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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | 21573359808 | 52 | 21573359808 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 21563516832 | 0 | 0 | 0 | 5 | 76861488 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 5538430128 | 2 | 5538430128 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film_actor | 4146551904 | 3 | 4146551904 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4238799840 | 0 | 0 | 0 | 5 | 39741504 | |
sakila | country | 3941926032 | 10 | 3941926032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4049964336 | 0 | 0 | 0 | 5 | 46986192 | |
sakila | film | 1437050208 | 307 | 1437050208 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1717547568 | 0 | 0 | 0 | 5 | 31838400 | |
sakila | language | 1408057728 | 98 | 1408057728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1125712368 | 0 | 0 | 0 | 5 | 73878816 | |
sakila | actor | 1376966448 | 200 | 1376966448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1551998448 | 0 | 0 | 0 | 5 | 46331472 | |
sakila | customer | 1179118512 | 26 | 1179118512 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1217967168 | 0 | 0 | 0 | 5 | 33529056 | |
sakila | address | 1138626720 | 53 | 1138626720 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1195595808 | 0 | 0 | 0 | 5 | 17462544 | |
sys | sys_config | 989090784 | 4 | 989090784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 928351776 | 0 | 0 | 0 | 5 | 51142608 | |
sakila | city | 912425184 | 35 | 912425184 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1053743328 | 0 | 0 | 0 | 5 | 26368320 | |
sakila | category | 797282640 | 67 | 797282640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 698144832 | 0 | 0 | 0 | 5 | 29114448 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_errors_summary_by_host_by_error | 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 | |
mysql | innodb_index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_statistics | 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 | events_statements_summary_by_host_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_summary_by_host_by_event_name | 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 | |
TlapaleriaMalfoy | Registro | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 65536 | 365565024 | 0 | 0 | 0 | 2 | 9077376 | |
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 | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|