How to avoid data loss in MySQL Primary Key change
Kedar
Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.
Browsing Category
MariaDB
25 posts
Articles related to MariaDB
MySQL Benchmarking and error in my_thread_global_end()
I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…
How to save money in AWS RDS – Upgrade to MySQL 8
MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…
How MySQL Binary Log Gets Its Number
In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…
What do you need to debug MySQL issues – a checklist
Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges. This checklist for MySQL debugging is as useful to a…
How to get MySQL Primary Keys in one minute
This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…