SHOW PROCESSLIST in MySQL 5.6Thu, Oct 11, 2012 in Databases
Mark Leith writes that it’s time to say goodbye to SHOW PROCESSLIST in MySQL 5.6, and use the Performance Schema replacement for it instead, because the older tools cause some blocking, and the Performance Schema replacement is completely non-blocking.
On the face of it that’s a good thing, but I wonder whether we’ll want to keep some blocking functionality around anyway. Inspecting systems that are doing concurrent work can be hard unless you can see a variety of views on them. One such is looking at the state of all the concurrent work at an instant in time. This is sometimes indispensable for troubleshooting: you will see causes and effects you’ll never see in counters and metrics, no matter how many you capture or how sophisticated the analysis.
I haven’t seen MySQL 5.6 in production usage yet, but I wonder: when I do, will the view of SHOW PROCESSLIST and the new Performance Schema tables look a little different? Will the non-blocking nature of the Performance Schema table lose the ability to capture and express specific types of system state at a single instant in time?
I don’t know, but I’m eager to find out. I have a feeling we’ll all spend the next couple of years really learning how to use the new capabilities in MySQL 5.6.
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.