thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
You obiously have wrong config of mysql especially becouse of innodb_buffer_pool_size (>= 468M) But you didnt post FULL result of mysqltuner, once you post complete result, I can help you a...
-
Post the rest of mysqltuner result
-
[!!] Temporary tables created on disk: 32% (198K on disk / 608K total) You got a lot of queries using temporary tables on disk, those should be optimized [!!] Table cache hit rate: 0% (3K open / 8...
-
there is very few queries (2,66k in 1,25 day) so there is not much to say and it would be inaccurate You had before few millions, do you have some bursts of traffic ? It would be good if you could...
-
Ohh, you should remove it first, then flush logs, to recreate the file :( Can you try again, remove old log, then flush logs
-
Yeah, you can post the review of pt-query-digest
-
You can post pt-query-digest result of analysis after the crash with high load After you generate that, you can remove mysql-slow.log and run mysql then flush logs; to start mysql-slow.log again...
-
Whm/Cpanel -> Manage Plugins There is munin
-
Ok, 1. Table lotusm_cs2, son888_CSU SELECT count FROM cscart_twigmo_ua_stat WHERE `section` = 'windows_version' AND `value` = '' AND `month` = '2013-11-1'\G Please check if you have indexes on th...
-
You should put that in brackets to make it easier to read # Overall: 2.78k total, 269 unique, 0.01 QPS, 0.00x concurrency __________ # Time range: 2013-11-10 18:49:02 to 2013-11-14 19:38:21 anyw...