hugopereira84
5/4/2016 - 12:06 PM

boost mysql

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