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