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.