Comment 23 for bug 1113301

Revision history for this message
sheyda amini (sheyda-a) wrote :

Daniel,

I am going to use pt-online-schema-change to optimize a very large table which has lots of data deleted from. I did try it on a test server and seems to be working, but my worry is as in the past by inception of the triggers, the table got locked and in our environment which has high QPS , will generate an outage. Anything more to use this tool to avoid this scenario. I am running percona 5.5.34.

Thanks!