** Increase Key Buffer ( yours is currently 64MB, but total indexes are 116M, so put at least 128MB). Should help immediately.
** Run mysqloptimize and mysqlrepair on your tables
** Increase table cache/ decrease total number of tables to increase the table cache hit rate. Maybe you've got some unused or old tables which could be deleted.
Other recommended confugration options:
** log_slow_queries = /var/log/mysql/mysql-slow.log
** long_query_time = 4
** log-queries-not-using-indexes
Check log file after some time.
-------------------------------------------------------
SET global max_connections = 1000000
show variables like 'max_connections'
mysql> show status like '%onn%';
mysql> show processlist;
** Run mysqloptimize and mysqlrepair on your tables
** Increase table cache/ decrease total number of tables to increase the table cache hit rate. Maybe you've got some unused or old tables which could be deleted.
Other recommended confugration options:
** log_slow_queries = /var/log/mysql/mysql-slow.log
** long_query_time = 4
** log-queries-not-using-indexes
Check log file after some time.
-------------------------------------------------------
SET global max_connections = 1000000
show variables like 'max_connections'
mysql> show status like '%onn%';
mysql> show processlist;
No comments:
Post a Comment