mirror of
https://github.com/MariaDB/server.git
synced 2025-10-26 16:38:11 +01:00
a3099a3b4a
Also increase user name up to 128. The work was started by Rucha Deodhar <rucha.deodhar@mariadb.com>, contains audit plugin fixes by Alexey Botchkov <holyfoot@askmonty.org>.
62 lines
2.2 KiB
Text
62 lines
2.2 KiB
Text
DESC sys.session;
|
|
Field Type Null Key Default Extra
|
|
thd_id bigint(20) unsigned NO NULL
|
|
conn_id bigint(20) unsigned YES NULL
|
|
user varchar(384) YES NULL
|
|
db varchar(64) YES NULL
|
|
command varchar(16) YES NULL
|
|
state varchar(64) YES NULL
|
|
time bigint(20) YES NULL
|
|
current_statement longtext YES NULL
|
|
statement_latency mediumtext YES NULL
|
|
progress decimal(26,2) YES NULL
|
|
lock_latency text YES NULL
|
|
rows_examined bigint(20) unsigned YES NULL
|
|
rows_sent bigint(20) unsigned YES NULL
|
|
rows_affected bigint(20) unsigned YES NULL
|
|
tmp_tables bigint(20) unsigned YES NULL
|
|
tmp_disk_tables bigint(20) unsigned YES NULL
|
|
full_scan varchar(3) YES NULL
|
|
last_statement longtext YES NULL
|
|
last_statement_latency mediumtext YES NULL
|
|
current_memory text YES NULL
|
|
last_wait varchar(128) YES NULL
|
|
last_wait_latency mediumtext YES NULL
|
|
source varchar(64) YES NULL
|
|
trx_latency text 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.session;
|
|
DESC sys.x$session;
|
|
Field Type Null Key Default Extra
|
|
thd_id bigint(20) unsigned NO NULL
|
|
conn_id bigint(20) unsigned YES NULL
|
|
user varchar(384) YES NULL
|
|
db varchar(64) YES NULL
|
|
command varchar(16) YES NULL
|
|
state varchar(64) YES NULL
|
|
time bigint(20) YES NULL
|
|
current_statement longtext YES NULL
|
|
statement_latency bigint(20) unsigned YES NULL
|
|
progress decimal(26,2) YES NULL
|
|
lock_latency bigint(20) unsigned YES NULL
|
|
rows_examined bigint(20) unsigned YES NULL
|
|
rows_sent bigint(20) unsigned YES NULL
|
|
rows_affected bigint(20) unsigned YES NULL
|
|
tmp_tables bigint(20) unsigned YES NULL
|
|
tmp_disk_tables bigint(20) unsigned YES NULL
|
|
full_scan varchar(3) YES NULL
|
|
last_statement longtext YES NULL
|
|
last_statement_latency bigint(20) 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(20) 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$session;
|