Highest Rated Comments


Twirrim1 karma

Alongside what avleen mentions, there are a number of tools from Percona that are essential for anyone dealing with MySQL environments, which you can find in the "Percona Toolkit". For example pt-table-checksum which helps you confirm that data is consistent between servers, and pt-table-sync to help fix it when it isn't.

Twirrim1 karma

One of the fun things with HT is that the second 'core' shares the same L1 cache as the primary. For certain types of tasks that's ideal. For a sizeable number of the things we tend to use servers for, that's quite a negative. If the threads executing on each core aren't directly related and using the same data, it ends up flushing the L1 over and over again, far more quickly than in typical workload.