-
Notifications
You must be signed in to change notification settings - Fork 1.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Script freezes after first line of Storage Engine Statistics #55
Comments
As an update, I ran the script as root and the user used had full DB access. |
Hey @jlowe64. It's possible that MySQLTuner is asking MySQL to do something and it's taking a long time. When the script seems to hang, would you be able to log into MySQL and run |
Hi Major, The query it seems to hang on is: SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC I'm going to leave it running for a while and see what happens. Might just be a case of it taking a long time to run. |
Hmm, does this server run a bunch of databases/tables? I've seen this happen on servers that are storing large amounts of data. That query usually runs instantly so I'm curious to know why it's taking so long to return data on your server. |
We have 140 DBs each with about 200-220 tables and DBs ranging from 50mb to 750mb. So I guess we would be on the high end. |
It seems to have moved on to the rest of the script. Was just hanging for about 5-8 minutes on that part of the script. Sorry for the bother! I guess I was getting impatient. |
Ah yes, then this might take some time. ;) |
Thanks. :) |
I m on a box with 300 000 tables with 150GB in MYSQL. Is it even possible to use mysqltuner on this huge MYSQL? I m waiting for 3h on storage statistics and nothing happens. P.S. sorry to revoke old thread but it is related. |
I am also experiencing this same problem on a server which has lots of databases and lots of tables. It would be great if we had a command line switch forcing mysqltuner to skip this query completely. |
You can use --skipsize to skip this query |
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
The text was updated successfully, but these errors were encountered: