Debian Codegraph @

mysql-test/suite/sysschema/r/v_processlist.result

raw
1 DESC sys.processlist;
2 Field Type Null Key Default Extra
3 thd_id bigint(20) unsigned NO NULL
4 conn_id bigint(20) unsigned YES NULL
5 user varchar(384) YES NULL
6 db varchar(64) YES NULL
7 command varchar(16) YES NULL
8 state varchar(64) YES NULL
9 time bigint(20) YES NULL
10 current_statement longtext YES NULL
11 statement_latency varchar(12) YES NULL
12 progress decimal(26,2) YES NULL
13 lock_latency varchar(12) YES NULL
14 rows_examined bigint(20) unsigned YES NULL
15 rows_sent bigint(20) unsigned YES NULL
16 rows_affected bigint(20) unsigned YES NULL
17 tmp_tables bigint(20) unsigned YES NULL
18 tmp_disk_tables bigint(20) unsigned YES NULL
19 full_scan varchar(3) YES NULL
20 last_statement longtext YES NULL
21 last_statement_latency varchar(12) YES NULL
22 current_memory varchar(14) YES NULL
23 last_wait varchar(128) YES NULL
24 last_wait_latency varchar(13) YES NULL
25 source varchar(64) YES NULL
26 trx_latency varchar(12) YES NULL
27 trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL
28 trx_autocommit enum('YES','NO') YES NULL
29 pid varchar(1024) YES NULL
30 program_name varchar(1024) YES NULL
31 SELECT * FROM sys.processlist;
32 DESC sys.x$processlist;
33 Field Type Null Key Default Extra
34 thd_id bigint(20) unsigned NO NULL
35 conn_id bigint(20) unsigned YES NULL
36 user varchar(384) YES NULL
37 db varchar(64) YES NULL
38 command varchar(16) YES NULL
39 state varchar(64) YES NULL
40 time bigint(20) YES NULL
41 current_statement longtext YES NULL
42 statement_latency bigint(20) unsigned YES NULL
43 progress decimal(26,2) YES NULL
44 lock_latency bigint(20) unsigned YES NULL
45 rows_examined bigint(20) unsigned YES NULL
46 rows_sent bigint(20) unsigned YES NULL
47 rows_affected bigint(20) unsigned YES NULL
48 tmp_tables bigint(20) unsigned YES NULL
49 tmp_disk_tables bigint(20) unsigned YES NULL
50 full_scan varchar(3) YES NULL
51 last_statement longtext YES NULL
52 last_statement_latency bigint(20) unsigned YES NULL
53 current_memory decimal(41,0) YES NULL
54 last_wait varchar(128) YES NULL
55 last_wait_latency varchar(20) YES NULL
56 source varchar(64) YES NULL
57 trx_latency bigint(20) unsigned YES NULL
58 trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL
59 trx_autocommit enum('YES','NO') YES NULL
60 pid varchar(1024) YES NULL
61 program_name varchar(1024) YES NULL
62 SELECT * FROM sys.x$processlist;