thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
-
Ohh gossh, it's useless, the RAM you are reading is with cache and buffers Read something in google about memory management in linux
-
no no, its becouse you didn't run pt-query-digest again it should be run to update info about slow queries before sending it here Anyways, you don't have to send it, the results are good Your CPU ...
-
./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt did you run this ? you were supposed to copy slow.txt file, the result of pt-query-digest anyways, based on this file, slow queries are ...
-
It will generate data based on your current slow log, so you can do it now
-
long_query_time=0.1 means only to mark queries as slow when they take more than 0,1s so it doesn't make any difference, it's just for logging queries, so we know which ones are slower the best th...
-
if you have, you can post here please images for CPU, LOAD, RAM ? it would show us more the difference and current load
-
"Are there any way to periodically delete unwanted table cache? I think only way to reduce temporary tables is restart the SQL server. Am I correct? I can't restart SQL service regularly." You don...
-
you dont have to increase all the values recommended by this script, those are only pointers, you need to understand the impact of the change before making the actuall change Please review your sl...
-
this particular query should be immediate, probably query before that one took longer than wait_timeout allowed checkout slow query log