This is my first question. ^^
I have a question about the fragmentation (reorg) in mysql.
Q. If the statement(“delete/insert” ) is a frequent table, should be run periodically to “optimize table”?
Because “randomI/O” is bad (not table size). Is it right?
Q. Is there a way to query the table fragmentation like “innodb_scan_pages_contiguous, Innodb_scan_pages_jumpy”.
Thanks in advance for any help…