Thread: High load - queries take long time

>>>>> CONTINUATION >>>>> mysql> show processlist; +----------+-----------------+---------------------------+----------------------+---------+------+-----------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info |...

This is possibly excessive: innodb_log_file_size = 1500M and may cause hiccups when it is flushing it. To assist in analyzing slow SELECTs, please provide * SHOW CREATE TABLE tbl\G -- engine, indexes -- works better than DESC * SHOW TABLE STATUS LIKE 'tbl'\G -- sizes * EXPLAIN SELECT ...\G -- clues of inefficiencies * SHOW VARIABLES LIKE '%buffer%'; -- cache size * SHOW VARIABLES LIKE 'innodb%'; -- various...