Change Is Inevitable
61 FOLLOWERS
Change Is Inevitable is Kedar Vaijanapurkar's Blog for MySQL, technology, and various subjects. Here he mian discusses topics covering MySQL, Database Administration and related technologies, software and movie reviews, and life.
Change Is Inevitable
1M ago
These days MySQL consultants around me are busy assisting with MySQL 8 upgrades for those who couldn’t board the train before EoL.I was recently involved in one of the MySQL…
The post MySQL 8 upgrade may fail using checkForServerUpgrade first appeared on Change Is Inevitable ..read more
Change Is Inevitable
2M ago
Primary keys are the backbone of efficient data access and maintaining data consistency in your MySQL databases. However, altering them requires careful planning and execution, as incorrect procedures can lead…
The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable ..read more
Change Is Inevitable
2M ago
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…
The post MySQL Benchmarking and error in my_thread_global_end() first appeared on Change Is Inevitable ..read more
Change Is Inevitable
2M ago
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…
The post How to save money in AWS RDS – Upgrade to MySQL 8 first appeared on Change Is Inevitable ..read more
Change Is Inevitable
3M ago
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…
The post How MySQL Binary Log Gets Its Number first appeared on Change Is Inevitable ..read more
Change Is Inevitable
3M ago
Recently I noted a strange MySQL replication error in a Percona XtraDB Cluster (PXC) node replicating from a standard MySQL instance. “Node has dropped from cluster”. This is a quick blog…
The post Node has dropped from cluster error in Galera Cluster first appeared on Change Is Inevitable ..read more
Change Is Inevitable
4M ago
The year 2023 surely was a successful year in MySQL blogging. I managed to publish 24 MySQL blogs in total both personal and Percona blog. This post is a reflection…
The post A year in MySQL Blogging – top blogs, summary and review first appeared on Change Is Inevitable ..read more
Change Is Inevitable
4M ago
The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable ..read more
Change Is Inevitable
5M ago
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…
The post What do you need to debug MySQL issues – a checklist first appeared on Change Is Inevitable ..read more
Change Is Inevitable
5M ago
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…
The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable ..read more