How to Fix Connection attributes of length xxx were truncated

July 25, 2023

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…

How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion

July 24, 2023

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…

How to meet Signal 11 bug in MariaDB

June 25, 2023

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…

How To Install specific version of MySQL 8 on Ubuntu

June 8, 2023

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…

How to MySQL Replication setup, Master GTID & SSL Encryption

June 4, 2023

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…

Install exact version of Percona Server for MySQL on CentOS

May 30, 2023

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…