Diomedis Spinellis: How to monitor MySQL / MariaDB query progress

https://www.spinellis.gr/blog/20191103/ The progress indicator of MySQL or MariaDB long-running commands and queries is extremely extremely and frustratingly coarse. In an index update I’m running now it was stuck in the same state for more than three hours. Thankfully, the pmonitor <https://github.com/dspinellis/pmonitor> tool allows us to precisely monitor the progress of many commands. Here’s an example of its application on MariaDB. Adding an index on a GHTorrent <http://ghtorrent.org/> table with 6 billion records seemed to take forever, stuck in the “Enabling keys” state. ....