MySQL INSTANT DDL breaks EXCHANGE PARTITION
Kedar
MySQL ERROR 1731 ‘Non matching attribute INSTANT COLUMN(s)’ breaks EXCHANGE PARTITION after ALGORITHM=INSTANT. This blog offers reasoning and fixtures.
Browsing Tag
MySQL
81 posts
How to setup and use Percona Binlog Server (PBS)
Earlier last week I was working with Percona Binlog Server, Percona’s tool for archiving the MySQL binary log (binlog) outside of a traditional replica and exploring what it can do.…
MySQL Major Version Upgrade Checklist – how to
This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task.
InnoDB Flushing is simple – explained
As a junior once I asked a seasoned MySQL DBA (Abuelo) “How do you stay so calm in critical situations?”Abuelo DBA then uttered golden words: “Son, I keep my dirty…
What MySQL configuration you hate the most?
Ever spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…
How to migrate PMM (Grafana) users
You’ve got a shiny new Percona Monitoring & Management instance standing by and want to move existing users over. This blog is a quick work around for migrating PMM users…