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