SELECT * FROM `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_actor | 4.94 ms | 6 | 4.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 4.91 ms | 0 | 0 bytes | 0 ps | 5 | 45.09 us | |
sakila | staff | 4.45 ms | 50 | 4.45 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.27 ms | 0 | 0 bytes | 0 ps | 5 | 32.82 us | |
sakila | address | 4.26 ms | 26 | 4.26 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 4.73 ms | 0 | 0 bytes | 0 ps | 5 | 38.05 us | |
sakila | actor | 2.86 ms | 412 | 2.86 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 2.76 ms | 0 | 0 bytes | 0 ps | 5 | 32.35 us | |
sakila | customer | 2.38 ms | 50 | 2.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 2.17 ms | 0 | 0 bytes | 0 ps | 5 | 45.90 us | |
sakila | rental | 2.35 ms | 52 | 2.35 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 53 | 896.00 KiB | 13.50 ms | 0 | 0 bytes | 0 ps | 5 | 359.31 us | |
sakila | city | 1.64 ms | 25 | 1.64 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 1.46 ms | 0 | 0 bytes | 0 ps | 5 | 79.04 us | |
sakila | language | 1.43 ms | 146 | 1.43 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 841.32 us | 0 | 0 bytes | 0 ps | 5 | 52.75 us | |
sakila | film | 1.43 ms | 458 | 1.43 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.52 ms | 0 | 0 bytes | 0 ps | 5 | 34.28 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 822.03 us | 2 | 822.03 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
pw | usuario | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 25.50 ms | 0 | 0 bytes | 0 ps | 5 | 99.40 us | |
mysql | help_keyword | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | innodb_index_stats | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_topic | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_user_by_event_name | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_statistics | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | events | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_worker_info | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_relay_log_info | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|