boost mysql
add in /etc/my.cnf:
----------------------------------------
key-buffer_size = 64M
sort_buffer_size = 32M
#
## thread buffers ##
#
sort_buffer_size = 5M
read_buffer_size = 5M
join_buffer_size = 32M
read_rnd_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method=O_DIRECT
innodb_additional_mem_pool_size = 8M
query_cache_size = 0
innodb_log_files_in_group = 2
innodb_log_file_size = 1900M
------
or
------
https://tools.percona.com/sign-in