Skip to content

Instantly share code, notes, and snippets.

@yang
Created February 2, 2010 17:33
Show Gist options
  • Save yang/292851 to your computer and use it in GitHub Desktop.
Save yang/292851 to your computer and use it in GitHub Desktop.
mysql> show full processlist;
+-----+------+-----------------+-------+------------+------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------------+-------+------------+------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 417 | root | localhost:57005 | tpcc2 | Field List | 1959 | Opening tables | |
| 419 | root | localhost:45650 | tpcc2 | Query | 2397 | creating table | create table warehouse (
w_id integer not null,
w_ytd decimal(12,2),
w_tax decimal(4,4),
w_name varchar(10),
w_street_1 varchar(20),
w_street_2 varchar(20),
w_city varchar(20),
w_state char(2),
w_zip char(9)
) |
| 420 | root | localhost:38036 | tpcc | Field List | 1080 | Opening tables | |
| 421 | root | localhost:38983 | tpcc2 | Sleep | 657 | | NULL |
| 422 | root | localhost:35890 | tpcc | Query | 0 | NULL | show full processlist |
+-----+------+-----------------+-------+------------+------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment