2024-03-07 04:28
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…
Th… Read More
Blog Directory > Technology Blogs > Change Is Inevitable technology Blog >
Change Is Inevitable Blog
kedar.nitty-witty.com/blog
Tags:
mysql
mysql primary
upgrade
mysql benchmarking
cluster error
mysql issues
mysql primary key
mysql binary
mysql slow queries
mysql upgrade
Kedar Vaijanapurkar's blog for MySQL, Database Administration and related technologies, software and movie reviews and life.
2024-03-01 12:17
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… Read More
2024-02-20 08:12
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 ex… Read More
2024-02-08 05:51
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 sa… Read More
2024-01-28 11:37
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… Read More
2024-01-16 14:01
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 i… Read More
2024-01-04 11:38
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 i… Read More
2023-12-30 07:03
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 th… Read More
2023-12-11 14:20
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… Read More
2023-11-30 14:43
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 tab… Read More
2023-09-25 12:21
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 Qu… Read More
2023-09-05 10:08
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… Read More
2023-07-31 14:20
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 bl… Read More
2023-07-28 18:24
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… Read More
2023-07-27 14:47
“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… Read More
2023-07-26 15:31
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 obj… Read More
2023-07-25 07:40
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 explo… Read More
2023-07-24 06:28
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 overc… Read More
2023-06-25 12:36
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… Read More
2023-06-08 04:38
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… Read More
2023-06-04 12:01
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 H… Read More
2023-05-30 11:01
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… Read More
2023-05-30 09:05
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 Sl… Read More
2023-04-10 04:39
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’ wh… Read More
2023-04-10 04:39
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’ wh… Read More
2023-03-20 14:54
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… Read More
2022-12-14 17:39
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… Read More
2022-12-14 17:39
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 feedback on my p… Read More
2022-12-14 13:51
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 position. This blo… Read More
2022-12-10 00:00
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 Encryptio… Read More
2022-10-11 10:53
This ProxySQL post is sourced from an error I faced recently handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(): [ERROR] ProxySQL Error: Access denied for user ProxySQL has become… Read More
2022-09-24 11:50
In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe that it actua… Read More
2022-09-24 11:50
In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe…
The p… Read More
2022-07-13 09:43
MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of it.This will be a talk about the low ha… Read More
2021-08-19 13:12
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again, it will work. That’s it, that&rsquo&hell…Read More
2021-08-19 13:12
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again,…
The post Relay log read failure |… Read More
2021-03-23 05:27
This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with Holland backup fra… Read More
2020-04-10 15:49
Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In th… Read More
2019-10-08 17:55
This post covers Proxysql start up process, Layers and configuration file.
The post ProxySQL Configuration & Startup Process explained first appeared on Change Is Inevitable Read More
2019-10-03 17:55
When learning ProxySQL, we have seen some confusion around the configuration and especially around the usage of the configuration file. In this post, we will explain how ProxySQL treats its… Read More
2019-04-09 06:11
This post is for the backup script for MySQL database on Linux. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon succ… Read More
2019-04-09 06:11
This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The…
The… Read More
2018-10-01 05:00
दुर्गे दुर्घट भारी – श्री देवीच… Read More
2018-09-07 12:03
This blog post gives an introduction to resource groups in MySQL 8 and dynamical allocation to threads, as well as a related bug report Read More
2018-08-13 06:15
In this post we will see a case study of a Galera Cluster migration to AWS Aurora and quick solution to the replication issue. A friend received an error in a Master-Master replication as fo… Read More
2018-06-29 15:43
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump Read More
2018-01-29 18:18
Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL tables to CSV on forums. Si… Read More
2018-01-18 14:54
I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator dete… Read More
2018-01-09 13:12
In this post we will see how to pause and start a linux process using signals (SIGTSTP and SIGCONT) via kill command Read More
2018-01-09 13:12
In this post we will see how to pause (suspend) and start a linux process using signals (SIGTSTP and SIGCONT) via kill command.
The post Linux shell script: Pause (Suspend) a process with ki… Read More
2017-12-14 10:30
In this post we will understand how to decode Seibel Audit Trail using PLSQL. Siebel Audit Trail is feature in Siebel CRM which allows customer to track changes to important UI fields. Thoug… Read More
2017-04-11 07:41
Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB ) Read More
2017-03-02 12:34
This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>… Read More
2016-06-13 13:53
Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup Read More
2016-06-13 13:53
Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.
The post MySQL database restore issues using xtrabackup – facepalm moments first appeared on Change… Read More
2015-12-07 11:25
This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads Read More
2015-11-04 11:59
This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306 Read More
2015-10-19 19:51
This post discuss the pt-table-checksum & error "Waiting to check replicas for differences: 0% 00:00 remain" with a use-case and solution Read More
2015-08-17 11:47
We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though f… Read More
2015-07-20 14:57
MySQL ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it's fix for S… Read More
2015-07-20 14:57
MySQL ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it's fix for S… Read More
2015-07-01 06:45
It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We s… Read More
2015-07-01 06:45
It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We s… Read More
2015-06-30 12:47
Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log of Nagios and Per… Read More
2015-06-24 07:06
UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DI… Read More
2015-06-07 09:42
Often we come across requirement for Siebel to integrate with external applications. Siebel provides various ways to integrate through EAI (Enterprise Application Integration) like EIM, Preb… Read More
2015-06-02 07:10
Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools things can l… Read More
2015-05-20 10:32
FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up Read More
2015-05-20 10:32
FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up.
The post Cannot connect to MySQL server on 'localhost': Cacti Error first appeared… Read More
2015-04-28 10:28
This post will answer how to extract database, tables etc from mysqldumpsplitter utility Read More
2015-03-23 06:27
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER Read More
2015-03-23 06:27
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
The post How to fix definer does not exist erro… Read More
2015-03-10 08:38
10+ useful code snippets of Linux shell scripts for how-to color, sendmail, log, change dir, parse parameters, loop, configuration file, switch..case and more Read More
2015-02-23 12:42
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. This post is also a good example of how we can achieve…
The post Restore / point in tim… Read More
2015-02-23 12:42
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. Recently someone accidentally dropped an important MySQL database and the backup was not prese… Read More
2015-02-03 10:03
The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants Read More
2015-01-21 06:49
A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail. It could be a configuration item or purely setup requirement. In this article w… Read More
2014-12-31 12:06
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID Read More
2013-05-27 05:46
Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binarie… Read More
2012-09-13 07:49
This mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have following for you: mysql>… Read More
2012-07-05 07:51
At times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but… Read More
2012-07-05 07:51
At times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but… Read More
2012-05-26 06:51
“I just learned that Agent K has been assassinated by Boris from future, an alien criminal in 1969. I must travel through a time and stop him and save young Agent K. And I have only 24… Read More
2012-05-03 16:21
Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table looks something like this: Company1… Read More
2012-04-23 12:08
Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved. Below is a short example for altering tables ha… Read More
2012-03-17 16:20
This article will describe you about QTP vs Selenium point by point in a easy to understand way. In the field of Software Quality Assurance (QA) automation tools, Selenium and QuickTest Prof… Read More
2012-01-30 16:29
MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. Thi… Read More
2012-01-26 21:24
Agneepath… Agneepath… Agneepath… Vruksh ho bhale khade, ho ghane ho bade, Ek patra chhanh bhi, mang mat, mang mat, mang mat, Agnipath, Agnipath, Agnipath… Oh yes… Read More
2011-11-18 03:06
Introducing JaxtrSMS, The world’s first free and open texting app is a revolutionary product from co-founders Sabeer Bhatia & Yogesh Patel. Sending free text messages or free SMS i… Read More
2011-11-04 08:10
What is a software quality and what attributes are used to measure it? A very common question you might have faced during Testing or QA Interviews. Many of the Software Testers or Software Q… Read More
2011-10-09 18:41
In Software Testing, deciding how important the defect is and how soon the defect should be fixed is as important as finding a defect! This depends on how you actually place the defect into… Read More
2011-09-11 15:47
What music mean to you? Well, surealy this is one of those questions for which you know the answer but you just can’t describe satisfactorily. So, here is my try. I’m a music lov… Read More
2011-09-11 15:47
What music means to you? Well, surealy this is one of those questions for which you know the answer but you just can’t describe satisfactorily. So, here is my try. I’m a mu… Read More
2011-07-29 04:33
The MySQL binary log is a set of log files that contain information about data modifications made to a MySQL server instance. At times we need to understand the disk usage by binary logs to… Read More
2011-07-26 19:41
Dhing chika, Dhing chika, Dhing chika… This is what I got from singham, a ringtone… I hated Dabangg even more when it got National Award! Don’t want to continue it in a p… Read More
2011-07-21 14:41
It always feels good to have a capable camera and it feels even better to explore new capacities of my Sony DSC-HX1 After entering into manual mode and understanding a bit of photography bas… Read More
2011-05-01 13:42
“Auto mode is for kids and manual is for photographers” Well, One must take out time to learn & for those owning camera, this is definitly a must do thing. I’ve started… Read More
2011-04-26 15:43
And finally, Rohan Sippy’s “Dum Maaro Dum” ended the series of poor movies in 2011. The best parts of the movie are Direction & Music, alongwith the good mixture of new… Read More
2011-04-11 08:50
Are you in Ahmedabad, looking for a short visit to a natural place? Sundarvan can surely surprise you. A Nature Discovery Centre is like a small zoo located in the…
The post Place to… Read More
2011-04-11 08:50
Sundarvan – A Nature Discovery Centre is like a small zoo located in the heart of the city Ahmedabad. I heard about and decided to appear personally. How to reach Sundarvan: Located at… Read More
Subscribe to Change Is Inevitable
Get updates delivered right to your inbox!