Надо чтоб mysqltuner поработал после оптимизации базы под innodb. Главное чтоб карта сети открывалась нормально. Она то и тормозит, так как запрос идет сразу к многим объектам.
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_limit (> 32M, or use smaller result sets)
table_cache (> 64)
innodb_buffer_pool_size (>= 4G)
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_limit (> 32M, or use smaller result sets)
table_cache (> 64)
innodb_buffer_pool_size (>= 4G)
Comment