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_category | 591.15 ms | 660000 | 591.15 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 922.11 us | 0 | 0 bytes | 0 ps | 5 | 22.94 us | |
sakila | film | 318.28 ms | 616330 | 318.28 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.93 ms | 0 | 0 bytes | 0 ps | 5 | 15.96 us | |
sakila | film_actor | 118.28 ms | 660800 | 118.28 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 15 | 288.00 KiB | 1.67 ms | 0 | 0 bytes | 0 ps | 5 | 22.49 us | |
sakila | category | 11.02 ms | 20540 | 11.02 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 747.23 us | 0 | 0 bytes | 0 ps | 5 | 22.39 us | |
sakila | address | 5.00 ms | 103 | 5.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 5.00 ms | 0 | 0 bytes | 0 ps | 5 | 50.31 us | |
sakila | customer | 4.54 ms | 26 | 4.54 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 5.46 ms | 0 | 0 bytes | 0 ps | 5 | 45.55 us | |
vedettfak | megye | 2.62 ms | 3 | 2.62 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 962.09 us | 0 | 0 bytes | 0 ps | 5 | 1.87 ms | |
sakila | city | 2.33 ms | 153 | 2.33 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.63 ms | 0 | 0 bytes | 0 ps | 5 | 52.04 us | |
sakila | country | 1.77 ms | 75 | 1.77 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 551.14 us | 0 | 0 bytes | 0 ps | 5 | 393.41 us | |
sakila | rental | 1.26 ms | 2 | 1.26 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.75 ms | 0 | 0 bytes | 0 ps | 5 | 37.66 us | |
sakila | actor | 1.17 ms | 800 | 1.17 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.06 ms | 0 | 0 bytes | 0 ps | 5 | 37.15 us | |
sakila | language | 976.72 us | 25 | 976.72 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 920.25 us | 0 | 0 bytes | 0 ps | 5 | 41.92 us | |
sys | sys_config | 652.31 us | 1 | 652.31 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 831.95 us | 0 | 0 bytes | 0 ps | 5 | 46.15 us | |
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 | 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 | file_summary_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 | 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 | |
performance_schema | events_transactions_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 | events_stages_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 | |
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 | routines | 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 | events_statements_summary_by_digest | 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 |
|