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 | rental | 4.94 ms | 3 | 4.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 4.96 ms | 0 | 0 bytes | 0 ps | 5 | 43.91 us | |
sakila | customer | 4.59 ms | 226 | 4.59 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 5.53 ms | 0 | 0 bytes | 0 ps | 5 | 44.21 us | |
vedettfak | fa | 4.11 ms | 6 | 4.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 2.73 ms | 0 | 0 bytes | 0 ps | 5 | 1.47 ms | |
sakila | store | 4.07 ms | 3 | 4.07 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 4.13 ms | 0 | 0 bytes | 0 ps | 5 | 42.79 us | |
sakila | staff | 1.65 ms | 10 | 1.65 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.65 ms | 0 | 0 bytes | 0 ps | 5 | 35.77 us | |
sakila | address | 1.49 ms | 27 | 1.49 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.39 ms | 0 | 0 bytes | 0 ps | 5 | 54.01 us | |
sakila | city | 1.39 ms | 26 | 1.39 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.46 ms | 0 | 0 bytes | 0 ps | 5 | 42.59 us | |
sakila | inventory | 1.34 ms | 200 | 1.34 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.40 ms | 0 | 0 bytes | 0 ps | 5 | 54.66 us | |
sakila | language | 1.31 ms | 171 | 1.31 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 791.36 us | 0 | 0 bytes | 0 ps | 5 | 43.90 us | |
test19 | ecurie | 1.20 ms | 113 | 1.20 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.07 ms | 0 | 0 bytes | 0 ps | 5 | 36.54 us | |
sakila | film | 1.11 ms | 84 | 1.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 3.10 ms | 0 | 0 bytes | 0 ps | 5 | 36.09 us | |
sakila | country | 1.08 ms | 25 | 1.08 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 966.68 us | 0 | 0 bytes | 0 ps | 5 | 61.25 us | |
sakila | actor | 983.36 us | 6 | 983.36 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.12 ms | 0 | 0 bytes | 0 ps | 5 | 57.65 us | |
vedettfak | megye | 917.09 us | 152 | 917.09 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 850.76 us | 0 | 0 bytes | 0 ps | 5 | 46.53 us | |
sku | Attore | 742.24 us | 4 | 742.24 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 865.17 us | 0 | 0 bytes | 0 ps | 5 | 40.95 us | |
test19 | voiture | 384.60 us | 71 | 384.60 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 2.07 ms | 0 | 0 bytes | 0 ps | 5 | 22.50 us | |
test19 | pilote | 344.04 us | 117 | 344.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 789.68 us | 0 | 0 bytes | 0 ps | 5 | 26.20 us | |
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 | |
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 | |
performance_schema | events_stages_history | 0 ps | 0 | 0 ps | 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 | parameters | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 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_io_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 |
|