MySQL fragmentation and how to defragment
Kedar
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…
Browsing Tag
MySQL
77 posts
How to Fix Connection attributes of length xxx were truncated
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 MySQL Replication setup, Master GTID & SSL Encryption
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
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…
MySQL Slow query log export and download in RDS
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…
How to fix 1030 Unknown generic error from engine in MySQL
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…