A tale of Corrupt InnoDB table, MySQL crash & recovery
Kedar
I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator…
How to Pause (Suspend) a process in Linux with kill signals
In this post we will see how to pause (suspend) and start a linux process using signals (SIGTSTP and SIGCONT) via kill command.
Reset root password on Galera Cluster (Percona or MariaDB)
Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )
MySQL to Galera Cluster Migration, Deadlock, Back to basics
This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into…
MySQL database restore issues using xtrabackup – facepalm moments
Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.
corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”
This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads