Kedar Vaijanapurkar s Blog for MySQL, technology and various subjects
This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task. The post MySQL Major Version Upgrade Checklist – how to first appeared on Change Is Inevitable .
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 The post InnoDB Flushing is simple – explained first appeared on Change Is Inevitable .
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 The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable .
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 The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable .
MySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available The post MySQL 8.4 disables AHI – Why and What you need to know first appeared on Change Is Inevitable .
During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is The post How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4 first appeared on Change Is Inevitable .
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 The post What MySQL configuration you hate the most? first appeared on Change Is Inevitable .
I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally The post MySQL Podcast: InnoDB Cluster Group Replication first appeared on Change Is Inevitable .
I think we know that screen is officially old news and most modern Linux systems switched to tmux as the recommended multiplexer with RHEL 8. Recently I had a discussion The post How to use tmux, a cheat sheet first appeared on Change Is Inevitable .
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 The post How to migrate PMM (Grafana) users first appeared on Change Is Inevitable .
Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At The post A Unique Foreign Key issue in MySQL 8.4 first appeared on Change Is Inevitable .
Recently, I encountered a Percona Monitoring and Management (PMM) server that was rapidly approaching complete disk exhaustion. This post outlines the steps taken to identify the issue and reclaim disk The post How to Resolve Disk Space Issues in PMM: Case Study first appeared on Change Is Inevitable .
This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see The post MySQL Data Archiving basics – considerations, mistakes, best practices first appeared on Change Is Inevitable .
This is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find, The post Killer Blog for MySQL Administrators first appeared on Change Is Inevitable .
Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable .
AI tools like ChatGPT, GROK, Meta and Gemini are taking off, and as parents, it’s easy to feel the pressure to keep our kids up to speed. The message out The post AI tools – technology and kids first appeared on Change Is Inevitable .
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at The post Podcast: Duplicate Indexes in MySQL first appeared on Change Is Inevitable .
Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand The post MySQL Podcast – Practical Learning & Training first appeared on Change Is Inevitable .
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a The post MySQL Change Buffer – What When and FAQ first appeared on Change Is Inevitable .
Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how The post Understanding Return Codes of pt-upgrade: A quick guide first appeared on Change Is Inevitable .
If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server, The post Troubleshooting MySQL: Encryption can’t find Master Key first appeared on Change Is Inevitable .
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 .
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. The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable .
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 .
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 .
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 .
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 .
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 .
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 .
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 .
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 .
Do you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server The post Quick Look – MySQL Data Directory Files first appeared on Change Is Inevitable .
Are you planning an upgrade for your Percona XtraDB Cluster (PXC)? Upgrading to PXC 8.0 can be a smooth process, but sometimes challenges arise that require careful troubleshooting. In this The post How to fix Percona XtraDB Cluster 8.0 Upgrade issues first appeared on Change Is Inevitable .
In this blog post, I want to share my experience and learning after challenging myself on my MySQL blog writing spree in recent past. I invite you to comment on The post One MySQL blog a day challenge first appeared on Change Is Inevitable .
This blog is about a very odd case of a Federated table error causing unable reach the remote MySQL server and causing to error. I’ll share the approach I tool The post How to fix MySQL federated table error first appeared on Change Is Inevitable .
“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion. This blog post is a brain dump of the possible The post How to replicate without binary logs in MySQL first appeared on Change Is Inevitable .
In a MySQL database, fragmentation can occur over time as data is inserted, updated, and deleted. Fragmentation refers to the inefficient storage and organization of data within database objects, such The post MySQL fragmentation and how to defragment first appeared on Change Is Inevitable .
MySQL, a widely-used database management system, may show the warning “[Warning] Connection attributes of length 571 were truncated” in its error log. In this blog, we will explore the reasons The post How to Fix Connection attributes of length xxx were truncated first appeared on Change Is Inevitable .
I was attempting to download the MySQL slow query logs to perform a slow query review. In this blog we will explore the issue I faced while downloading the slow The post How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion first appeared on Change Is Inevitable .
Bugs in database management systems can be a nightmare for administrators and developers. In my recent experiments, I discovered a Signal 11 bug in multiple versions of MariaDB, resulting in The post How to meet Signal 11 bug in MariaDB first appeared on Change Is Inevitable .
This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on Ubuntu. The post includes instructions for installation using The post How To Install specific version of MySQL 8 on Ubuntu first appeared on Change Is Inevitable .
Setting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and The post How to MySQL Replication setup, Master GTID & SSL Encryption first appeared on Change Is Inevitable .
This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable .
A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for The post MySQL Slow query log export and download in RDS first appeared on Change Is Inevitable .
In this blog, I will share the steps I took to debug an error ‘ERROR 1030 (HY000): Got error 168 – ‘Unknown (generic) error from engine’ from storage engine’ while The post How to fix 1030 Unknown generic error from engine in MySQL first appeared on Change Is Inevitable .
A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values The post MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp first appeared on Change Is Inevitable .
In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a The post Restore single MySQL table (ibd) from Xtrabackup (video demo) first appeared on Change Is Inevitable .
Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant The post MySQL Interview – ChatGPT is not your DBA first appeared on Change Is Inevitable .
Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: PostgreSQL, MongoDB and MySQL. This talk for MySQL was related to MySQL Encryption with The post Securing MySQL: Data Encryption with Percona Server and Vault first appeared on Change Is Inevitable .
This ProxySQL post is sourced from an error I faced recently ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you The post Can not connect to ProxySQL: reasons and fixtures first appeared on Change Is Inevitable .