'Load testing a specific MySQL table whilst running pt-online-schema-change
I am running the pt-online-schema-change tool to make schema changes to a large table containing around 100 million rows. These changes worked fine but I only performed them on a copy of the table where the table itself was not experiencing any sort of load. The original table on the other hand is subject to around 100 MySQL queries per second. I now want to simulate this type of load on the table and then run the schema tool change alongside it to see how it will behave when running it on the production database. Are there any tools available that can do e.g. an indefinite amount of SQL insertion queries on a specific table or something similar along those lines?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|