MySQL key efficiency 100%
This is to remember the conf for this:
for 1GB RAM dedicated server:
query_cache_limit = 4MB query_cache_size = 128MB key_buffer_size = 128M max_connections = 300 wait_timeout = 7200 tmp_table_size = 64MB max_connect_errors = 1000 connect_timeout = 20 max_allowed_packet = 16M
from here: thanks man!
+1 Gb RAM = 2 Gb new config:
log-slow-admin-statements query_cache_limit = 4MB query_cache_size = 64M key_buffer_size = 64M max_connections = 300 wait_timeout = 7200 tmp_table_size = 12MB max_connect_errors = 500 connect_timeout = 60 max_allowed_packet = 8M innodb_buffer_pool_size = 128M performance_schema plugin_dir = /usr/lib/plugin default-storage-engine = InnoDB innodb = ON
