| 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; |