[17:31:54] 3 things: enable slow querry log [17:31:55] innodb_buffer_pool_size = 512M [17:31:55] innodb_additional_mem_pool_size = 128M [17:34:48] AND Visagalis install mtop [17:35:42] then enable slow querry logs then start mtop once you see a slow querry use "e" button then number of process and you will see what it does [17:35:55] then copy the sql statement it says and use EXPLAIN statement; [17:36:07] in mysql and look if you can update idx stuff [19:30:07] query_cache_limit = 4M [19:30:08] query_cache_size = 32M [19:30:12] check those Visagalis [19:30:21] and see, you have to suit that for your mem [19:30:31] just a little example [19:30:40] also: [19:30:41] key_buffer = 32M [19:30:41] max_allowed_packet = 16M [19:30:41] thread_stack = 256K [19:30:57] also: [19:31:00] log_slow_queries = /var/log/mysql/mysql-slow.log [19:31:06] that's VERY useful to have there [19:31:38] next thing is: [19:31:40] #max_binlog_size = 100M [19:31:48] note the # [19:32:28] also make sure about this: [19:32:30] #skip-innodb [19:32:46] perhaps your inno-db is off and it shouldn't be