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 Category
MySQL
128 posts
Articles related to MySQL, Percona Server, MariaDB
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…
MySQL Tools for Performance Tuning and Test Data Generation
As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…
How to fix write latency in MySQL 8.4 Upgrade
During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…
4 responses to “How to fix write latency in MySQL 8.4 Upgrade”
The default changes back to “all” on MySQL 9.7 – there were reported crashes with the change buffer in 8.4 so the default was changed but that stability is now back.
Thanks Justin, I updated the article to reflect the fact.
There is more to that story, I sent you some information about this in MySQL Community Slack.
Thanks JFG.