tables with overhead

Question

I would like to know whether there is any query to find table names with overhead.

This query is particular to MySQL Database, and I believe that those who work on MySQL will be knowing what overhead to a table is.

"overhead" is a vague term, and doesn't register to me as a MySQL keyword. — OMG Ponies, Mar 22 '11 at 05:25
http://stackoverflow.com/questions/565997/in-mysql-what-does-overhead-mean-what-is-bad-about-it-and-how-to-fix-it — zerkms, Mar 22 '11 at 05:25
@OMG Ponies: indeed, but in some unknown reason some people call fragmented data files as "overheaded" :-S — zerkms, Mar 22 '11 at 05:26
@zerkms: thanks for the link, but I need to find those tables which have overhead or fragmented data file. How can I achieve this using a query? — I-M-JM, Mar 22 '11 at 05:53
@I-M-JM: the good practice is to schedule optimize command execution and optimize periodically all tables. — zerkms, Mar 22 '11 at 05:54
@zerkms: well that's what I have implemented, but still need this option. — I-M-JM, Mar 22 '11 at 06:04
@I-M-JM: you have done it in right way. I'm not sure it can even be an option. — zerkms, Mar 22 '11 at 06:12

score 1 · Answer 1 · edited Oct 19 '12 at 11:49

1

phpmyadmin - select database - go to bottom of screen - click "Check tables having overhead" It selects tables with overhead.

edited Oct 19 '12 at 11:49

Toon Krijthe

answered Oct 19 '12 at 11:46

user1265590

score 0 · Accepted Answer · answered Mar 22 '11 at 06:42

0

I think schedule optimization is only way available.

Thanks for all your help.

answered Mar 22 '11 at 06:42

I-M-JM

2 Answers2