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 | payment | 111.10 ms | 48132 | 111.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 65 | 1.06 MiB | 10.35 ms | 0 | 0 bytes | 0 ps | 5 | 15.84 us | |
sakila | rental | 23.26 ms | 61875 | 23.26 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 20 | 368.00 KiB | 4.13 ms | 0 | 0 bytes | 0 ps | 5 | 22.84 us | |
sakila | inventory | 7.58 ms | 16743 | 7.58 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.98 ms | 0 | 0 bytes | 0 ps | 5 | 40.25 us | |
sakila | film_category | 4.97 ms | 3074 | 4.97 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 4.59 ms | 0 | 0 bytes | 0 ps | 5 | 41.95 us | |
sakila | country | 3.96 ms | 52 | 3.96 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 3.97 ms | 0 | 0 bytes | 0 ps | 5 | 97.72 us | |
sakila | film | 3.63 ms | 3051 | 3.63 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.74 ms | 0 | 0 bytes | 0 ps | 5 | 165.96 us | |
sakila | actor | 2.08 ms | 25 | 2.08 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.35 ms | 0 | 0 bytes | 0 ps | 5 | 48.17 us | |
sakila | customer | 1.33 ms | 26 | 1.33 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 1.39 ms | 0 | 0 bytes | 0 ps | 5 | 56.62 us | |
vedettfak | megye | 1.17 ms | 2 | 1.17 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 993.95 us | 0 | 0 bytes | 0 ps | 5 | 388.49 us | |
sakila | category | 993.13 us | 76 | 993.13 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.02 ms | 0 | 0 bytes | 0 ps | 5 | 45.24 us | |
sakila | city | 894.36 us | 26 | 894.36 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 1.11 ms | 0 | 0 bytes | 0 ps | 5 | 28.98 us | |
sakila | address | 824.02 us | 26 | 824.02 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 979.33 us | 0 | 0 bytes | 0 ps | 5 | 28.57 us | |
sakila | language | 812.16 us | 25 | 812.16 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 795.36 us | 0 | 0 bytes | 0 ps | 5 | 53.60 us | |
sys | sys_config | 675.61 us | 1 | 675.61 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 767.25 us | 0 | 0 bytes | 0 ps | 5 | 212.27 us | |
sakila | film_text | 156.52 us | 1 | 156.52 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 442 bytes | 170.81 us | 0 | 0 bytes | 0 ps | 3 | 26.74 us | |
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 | |
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 | 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 | |
wisedb | login | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.72 ms | 0 | 0 bytes | 0 ps | 5 | 50.83 us | |
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 | |
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 | func | 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 |
|