Use Alibaba Cloud Host The database often hangs up!

Little scum · Posted on 1/31/2016 10:06:37 AM

Alibaba Cloud killed the 32-bit centos some time ago, and many people switched to 64-bit systems.
The memory footprint of 64-bit systems is slightly higher. Some websites that use MySQL 5.5 databases often have the error that the database cannot be linked due to high memory usage.

Provide a workaround:

5,5 The default storage engine is innodb, which occupies more than 300 virtual memory when it moves together, and the storage engine we generally use is MyISAM.
Solution: Modify the /www/wdlinux/etc/my.cnf file.
Add it in [mysqld]

Login is visible.

Finally, restart mysql

Little scum · Posted on 8/17/2017 5:06:20 PM

AMH2.01 has InnoDB turned off by default.
-------------------------------------
For AMH2.0 version:
MySQL 5.5 enables the InnoDB engine by default.
If you don't use some advanced parts of the InnoDB transaction, you can close it. It is also enough to use MyISAM.
Small memory machines can save some memory.

Execution of the mandate now:
sed -i "/\[mysqld\]/a default-storage-engine = MyISAM\ninnodb=OFF\nskip-innodb " /etc/my.cnf && amh mysql stop && amh mysql start;

summer · Posted on 8/17/2017 9:13:29 PM

Xiao Zhazha Posted on 2017-8-17 17:06
AMH2.01 has InnoDB turned off by default.
-------------------------------------
For AMH2.0 version:

[Mutual Assistance] Use Alibaba Cloud Host The database often hangs up!

Related Posts

Sections viewed