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

What status variables to monitor when running a large ALTER TABLE

JoeSmartJoeSmart EntrantInactive User Role Beginner
Hi,

First post so apologies for any failure to adhere to community standards.

I am not a MySQL (or any kind of DB) expert and have just recently discovered the pt-online-schema-change tool which is right now looking like a life saver. My problem is just that I am unsure how I can effectively use the --max-load option to ensure the DB is not overloaded during the change. The DB is written to by a single thread and so the default behaviour to monitor active threads is not a great way for me to measure the load. I would prefer something CPU based, as CPU is generally the constraining resource on our server. Is there anything which would offer this kind of functionality here? Alternatively if it is possible to tell how long queries are taking to execute that might work. Open to other suggestions but CPU is the obvious best choice to me.

Thanks
Joe

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.