So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
I'm loading data into a fresh instance which takes ~48s to load a single file (1G; 2.5m rows). To decrease load time, I tried chunking it into 100k rows using Percona's pt-fifo-split. Unfortunately, ...
Problem while replaying logs I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior: As described here i: Created a dump (innobackupex ftw) ...
As you might know, in order to assure a consistent replication state, the slave should be backup only when there are no open temporary tables: ...
I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that. Certain tables in the mix have composite ...