Change Is Inevitable
  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
Change Is Inevitable

Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects

  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright

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

Securing MySQL: Data Encryption with Percona Server and Vault

  • Kedar
  • December 10, 2022
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…
View Post

Can not connect to ProxySQL: reasons and fixtures

  • Kedar
  • October 11, 2022
This ProxySQL post is sourced from an error I faced recently ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you…
View Post

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines

  • Kedar
  • September 24, 2022
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…
View Post

The Low Hanging Fruits of MySQL – Percona Live Community 2022

  • Kedar
  • July 13, 2022
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…
View Post

Posts navigation

1 2 … 17 Next
Search:
... ...

Latest Posts

  • Install exact version of Percona Server for MySQL on CentOS
  • MySQL Slow query log export and review in RDS
  • 1030 Unknown generic error from engine in MySQL
  • MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
  • Restore single MySQL table (ibd) from Xtrabackup (video demo)
Recent Posts
  • Install exact version of Percona Server for MySQL on CentOS
  • MySQL Slow query log export and review in RDS
  • 1030 Unknown generic error from engine in MySQL
  • MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
  • Restore single MySQL table (ibd) from Xtrabackup (video demo)
Recent Comments
  • Shubham Sahu on MySQL database restore issues using xtrabackup – facepalm moments
  • Kedar on Download MySQL’s Automatic Random Test Data Generator
  • Kedar on MySQL to Galera Cluster Migration, Deadlock, Back to basics
  • offpageanil@gmail.com on MySQL to Galera Cluster Migration, Deadlock, Back to basics
  • Sarthak on Computer usage and maintenance-my 10 practices
Change Is Inevitable
Designed & Developed by Code Supply Co.