mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
44 lines
1.7 KiB
Text
44 lines
1.7 KiB
Text
DESC sys.schema_table_statistics;
|
|
Field Type Null Key Default Extra
|
|
table_schema varchar(64) YES NULL
|
|
table_name varchar(64) YES NULL
|
|
total_latency varchar(12) YES NULL
|
|
rows_fetched bigint(20) unsigned NO NULL
|
|
fetch_latency varchar(12) YES NULL
|
|
rows_inserted bigint(20) unsigned NO NULL
|
|
insert_latency varchar(12) YES NULL
|
|
rows_updated bigint(20) unsigned NO NULL
|
|
update_latency varchar(12) YES NULL
|
|
rows_deleted bigint(20) unsigned NO NULL
|
|
delete_latency varchar(12) YES NULL
|
|
io_read_requests decimal(42,0) YES NULL
|
|
io_read varchar(14) YES NULL
|
|
io_read_latency varchar(12) YES NULL
|
|
io_write_requests decimal(42,0) YES NULL
|
|
io_write varchar(14) YES NULL
|
|
io_write_latency varchar(12) YES NULL
|
|
io_misc_requests decimal(42,0) YES NULL
|
|
io_misc_latency varchar(12) YES NULL
|
|
SELECT * FROM sys.schema_table_statistics;
|
|
DESC sys.x$schema_table_statistics;
|
|
Field Type Null Key Default Extra
|
|
table_schema varchar(64) YES NULL
|
|
table_name varchar(64) YES NULL
|
|
total_latency bigint(20) unsigned NO NULL
|
|
rows_fetched bigint(20) unsigned NO NULL
|
|
fetch_latency bigint(20) unsigned NO NULL
|
|
rows_inserted bigint(20) unsigned NO NULL
|
|
insert_latency bigint(20) unsigned NO NULL
|
|
rows_updated bigint(20) unsigned NO NULL
|
|
update_latency bigint(20) unsigned NO NULL
|
|
rows_deleted bigint(20) unsigned NO NULL
|
|
delete_latency bigint(20) unsigned NO NULL
|
|
io_read_requests decimal(42,0) YES NULL
|
|
io_read decimal(41,0) YES NULL
|
|
io_read_latency decimal(42,0) YES NULL
|
|
io_write_requests decimal(42,0) YES NULL
|
|
io_write decimal(41,0) YES NULL
|
|
io_write_latency decimal(42,0) YES NULL
|
|
io_misc_requests decimal(42,0) YES NULL
|
|
io_misc_latency decimal(42,0) YES NULL
|
|
SELECT * FROM sys.x$schema_table_statistics;
|