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.
Decoding Siebel Audit Trail with PLSQL
In this post we will understand how to decode Seibel Audit Trail using PLSQL. Siebel Audit Trail is feature in Siebel CRM which allows customer to track changes to important…
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