thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
slow_query_log_file=mysql-slow.log long_query_time=0.1 ohh forgot this one slow_query_log=1 please add that and restart
-
Its very good, but please generate slow log again ./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt before your slow log didnt exist
-
Can you run du -sh /var/lib/mysql/mysql-slow.log
-
the generation of slow.txt can take a while, but during that you will receive percentage info of how much is finished just slow.txt file is not big, so it should not be a problem uploading it here
-
Much better, but since [!!] Temporary tables created on disk: 39% (297K on disk / 751K total) you should optimize your queries (especially the ones using temporary tables on disk) query can can b...
-
add key_buffer_size = 150M query_cache_limit = 1M query_cache_size = 30M query_cache_type = 1 table_open_cache = 1000 thread_cache_size = 16 tmp_table_size = 50M max_heap_table_size = 50M slow_qu...
-
you generated review of new slow queries, not the old one # Time range: 2014-01-18 21:13:22 to 21:14:17 old one is lost now, we need to wait several hours than regenerate review of slow queries again
-
OK much better, but since [!!] Joins performed without indexes: 4450 [!!] Temporary tables created on disk: 27% (50K on disk / 184K total) [!!] Table cache hit rate: 0% (1K open / 826K opened) yo...
-
here: [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-exte...
-
copy last 500 lines of error log here