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