mysql-my.cnf

innodb_buffer_pool_size=46G
innodb_log_file_size=11G
innodb_buffer_pool_instances=1
table_open_cache=4096


setting asal
innodb_buffer_pool_size             | 1073741824
innodb_log_buffer_size                   | 16777216
innodb_log_buffer_size                   | 16777216
innodb_buffer_pool_instances | 64
table_open_cache                | 495





<ifModule mod_deflate.c>
  AddOutputFilterByType DEFLATE text/html text/plain text/xml text/x-js text/javascript text/css application/javascript
</ifmodule>