processlist information MySQL add more columns

80 Views Asked by At

The processlist provides very little information for certain thread states (such as sleep state), which makes it very difficult to debug problematic client code.

Adding tracking info in the form of an SQL comment / script name / linenumber etc, is useless if the INFO column is NULL (as it is in sleep state)

How to add "Last Query" to the processlist table?

I use MySQL 5.5.3

0

There are 0 best solutions below