SELECT * FROM `x$schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INFS1200_RELEASE | Policy | 4741339152 | 112 | 4741339152 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2169088416 | 0 | 0 | 0 | 5 | 2152525056 | |
sakila | address | 3906004080 | 25 | 3906004080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1825748496 | 0 | 0 | 0 | 5 | 1820737248 | |
vedettfak | megye | 1515998352 | 6 | 1515998352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 438643920 | 0 | 0 | 0 | 5 | 992562912 | |
INFS1200_RELEASE | Vehicle | 1394164464 | 100 | 1394164464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 526285056 | 0 | 0 | 0 | 5 | 40336560 | |
INFS1200_RELEASE | Customer | 1293088896 | 100 | 1293088896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 526133520 | 0 | 0 | 0 | 5 | 48587616 | |
sakila | customer | 1016299152 | 26 | 1016299152 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1159530240 | 0 | 0 | 0 | 5 | 42804960 | |
sys | sys_config | 470002896 | 1 | 470002896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 384828576 | 0 | 0 | 0 | 5 | 43761168 | |
fy1 | users | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3719018688 | 0 | 0 | 0 | 5 | 38117376 | |
mysql | innodb_table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_stages_summary_by_thread_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
bddauditorias | Espacio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 468238848 | 0 | 0 | 0 | 5 | 217456272 | |
bddauditorias | Procesos | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 870819840 | 0 | 0 | 0 | 5 | 38495952 | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|