MySQL fragmentation(reorg)

MySQL & MariaDB Other MySQL® Questions
1

Hello
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…

2

I think that this is best solution.
Matt is also the best.