Deep Dive Into InnoDB Page Merging and Page Splitting - Percona Tech Days - MySQL Tutorial
MySQL/InnoDB constantly performs merge and split operations, and you have very limited visibility of them. But they can bite you, and bite hard, especially if using a spindle storage VS SSD (which have different issues, by the way).
Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
This is an important point to keep in mind. In #InnoDB you cannot have fragmented records, but you can have a nightmare at the page-extent level.
The sad story is there is also very little we can do to optimize this on the server side using parameters or some other magic. But the good news is there is A LOT that can be done at design time.
This presentation will illustrate what really happen and how the use of a proper schema design may help you."
📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and MySQL Tutorials.
https://percona.tv/subscribe
In this talk, I will show how they did it, demonstrate situations when
asynchronous source-source replication is the best possible high
availability option and beats such solutions as #Galera or #InnoDB
#Clusters. I will also cover common mistakes, leading to disasters.
You can find more information about #MySQL #Databases and Percona Database Events in these links 👇🏻👇🏻👇🏻
https://per.co.na/mysql-support
https://per.co.na/mysql-info
https://per.co.na/lGkGc9
https://per.co.na/pl2020
Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: https://per.co.na/twitter
Follow Percona on Facebook: https://per.co.na/facebook
Follow Percona on Instagram: https://per.co.na/instagram
Follow Percona on LinkedIn: https://per.co.na/linkedin