Brian "Krow" Aker's Idle Thoughts - 5.1 Feature: Process list table

I was asked about features in 5.1 this morning and one popped out that one of Elliot's new developers completed, which is the "PROCESSLIST" table.

As an example:

mysql> select * from PROCESSLIST WHERE command="query";
+----+------+------+--------------------+---------+------+----------- +-------------------------------------------------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+----+------+------+--------------------+---------+------+----------- +-------------------------------------------------+
| 2 | root | | information_schema | Query | 0 | preparing | select * from PROCESSLIST WHERE command="query" |
+----+------+------+--------------------+---------+------+----------- +-------------------------------------------------+
1 row in set (0.00 sec)

Adding show commands and turning them into information_schema table is pretty simple. I'll be leading some exercises at the MySQL User's Conference in the evening.