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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
petshop | products | 4.87 ms | 0 | 0 ps | 1 | 4.87 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 9 | 240.00 KiB | 522.69 us | 8 | 74.70 ms | |
sakila | country | 4.06 ms | 26 | 4.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.17 ms | 0 | 0 bytes | 0 ps | 5 | 44.86 us | |
sakila | address | 4.01 ms | 5 | 4.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 4.17 ms | 0 | 0 bytes | 0 ps | 5 | 39.79 us | |
spoticfy | albumes | 3.01 ms | 449 | 3.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 611.61 us | 6 | 44.34 ms | |
spoticfy | artistas | 2.74 ms | 379 | 2.74 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 179.34 us | 6 | 51.59 ms | |
sakila | film | 2.29 ms | 159 | 2.29 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.72 ms | 0 | 0 bytes | 0 ps | 5 | 700.07 us | |
spoticfy | canciones | 2.01 ms | 388 | 2.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 622.24 us | 6 | 58.31 ms | |
sakila | language | 1.91 ms | 212 | 1.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 924.39 us | 0 | 0 bytes | 0 ps | 5 | 73.52 us | |
sakila | store | 1.58 ms | 3 | 1.58 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.69 ms | 0 | 0 bytes | 0 ps | 5 | 37.48 us | |
sakila | staff | 1.54 ms | 2 | 1.54 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.63 ms | 0 | 0 bytes | 0 ps | 5 | 65.40 us | |
sakila | city | 700.50 us | 202 | 700.50 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 731.07 us | 0 | 0 bytes | 0 ps | 5 | 107.19 us | |
vedettfak | megye | 557.71 us | 4 | 557.71 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 774.74 us | 0 | 0 bytes | 0 ps | 5 | 58.56 us | |
Stefano | vulcano | 508.34 us | 1 | 508.34 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 866.97 us | 0 | 0 bytes | 0 ps | 5 | 33.77 us | |
world | Country | 37.07 us | 1 | 37.07 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 462 bytes | 5.09 ms | 0 | 0 bytes | 0 ps | 4 | 24.24 us | |
performance_schema | table_lock_waits_summary_by_table | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | general_log | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 1 | 35 bytes | 416.51 us | 0 | 0 bytes | 0 ps | 4 | 66.79 us | |
аа | Поставщик | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | threads | 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_waits_summary_by_thread_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 | |
sku | Cinema | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.98 ms | 0 | 0 bytes | 0 ps | 5 | 41.48 us | |
pw | estudio | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.41 ms | 0 | 0 bytes | 0 ps | 5 | 37.66 us | |
mysql | dd_properties | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
StdMdDB | score | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 879.83 us | 0 | 0 bytes | 0 ps | 5 | 42.46 us | |
performance_schema | events_statements_current | 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 |
|