Not the answer you need?
Register and ask your own question!

MySQL fragmentation(reorg)

dbarexdbarex EntrantInactive User Role Beginner
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...

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.