O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Monitoring connections

The SHOW PROCESSLIST statement returns information about the active connections. The PROCESSLIST table in the information_schema database contains additional complete information; we will discuss this. Also, the threads table in the performance_schema database includes the same information returned by SHOW PROCESSLIST, plus some extra columns. Normally, SHOW PROCESSLIST returns sufficient information and is less verbose. The PROCESSLIST table has the advantage that its contents can be used in a stored program.

The following example shows the contents of the PROCESSLIST table and the output of SHOW PROCESSLIST:

MariaDB [(none)]> SELECT * FROM information_schema.PROCESSLIST \G

*************************** 1. row *************************** ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required