Aliyun 512 in-memory MySQL and PHP optimization settings

1, find the MySQL configuration file

/etc/my.cnf

I use the LNMP one-button installation package, MySQL configuration file may not be the same as yours, please find your own.

2, modify the following parameters:

Key_buffer = 16K
Max_allowed_packet = 1M
Thread_stack = 64K
Table_cache = 4
Sort_buffer = 64K
Net_buffer_length = 2K
If not, add it yourself.

3, if you do not use the InnoDB table, on the bottom of the file to disable InnoDB:

Skip-innodb

OK, then optimize the PHP settings.

After you install PHP, you need to turn on the log and adjust the settings to ensure better performance. Here, you need to focus on memory_limit this parameter, which controls how much memory is allocated to PHP. Here's how to enable logging and optimize PHP performance:

1, the first natural is to find the PHP configuration file:

/usr/local/php/etc/php.ini

2, to ensure that the following parameters have been set up, mainly to remove the previous annotation symbol ";"

Max_execution_time = 30
Memory_limit = 64M
error_reporting = e_compile_error| e_recoverable_error| e_error| E_core_error
Display_errors = Off
Log_errors = On
Error_log =/var/log/php.log
Register_globals = Off
Note: Here the 64M settings for most sites are applicable, if it is a larger site, you need to change to 128M or greater.

After saving the configuration file, restart the appropriate service