MySQL Slow query log export and review 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…
MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
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…
Restore single MySQL table (ibd) from Xtrabackup (video demo)
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…
MySQL Interview – ChatGPT is not your DBA
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…
Securing MySQL: Data Encryption with Percona Server and Vault
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…