diff options
Diffstat (limited to 'mysql-test/suite/sysschema/r/v_session.result')
| -rw-r--r-- | mysql-test/suite/sysschema/r/v_session.result | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/r/v_session.result b/mysql-test/suite/sysschema/r/v_session.result new file mode 100644 index 00000000..fd88b8f1 --- /dev/null +++ b/mysql-test/suite/sysschema/r/v_session.result @@ -0,0 +1,62 @@ +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; |