Browsing Category

MySQL

98 posts

MySQL

Install exact version of Percona Server for MySQL on CentOS

Kedar
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…

View Post

MySQL Slow query log export and review in RDS

Kedar
May 30, 2023

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…

View Post

1030 Unknown generic error from engine in MySQL

Kedar
April 10, 2023

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…

View Post

MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp

Kedar
March 20, 2023

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…

View Post

Restore single MySQL table (ibd) from Xtrabackup (video demo)

Kedar
December 14, 2022

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…

View Post

MySQL Interview – ChatGPT is not your DBA

Kedar
December 14, 2022

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…

View Post