SELECT * FROM `x$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 | 4988940528 | 129 | 4988940528 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5536717296 | 0 | 0 | 0 | 5 | 39943728 | |
sakila | actor | 4440604608 | 137 | 4440604608 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4282721520 | 0 | 0 | 0 | 5 | 54141120 | |
sakila | country | 2005058880 | 358 | 2005058880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 892249248 | 0 | 0 | 0 | 5 | 39691344 | |
sakila | city | 1396556832 | 183 | 1396556832 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1045807488 | 0 | 0 | 0 | 5 | 50058624 | |
sakila | language | 1214312352 | 100 | 1214312352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 756761808 | 0 | 0 | 0 | 5 | 32826288 | |
sakila | film_text | 671675664 | 26 | 671675664 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 1047732576 | 0 | 0 | 0 | 32 | 34346400 | |
sakila | customer | 505338768 | 83 | 505338768 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1552577136 | 0 | 0 | 0 | 5 | 39627456 | |
sakila | address | 478977312 | 76 | 478977312 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1731891216 | 0 | 0 | 0 | 5 | 54958464 | |
sakila | rental | 460827840 | 26 | 460827840 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 6612680448 | 0 | 0 | 0 | 5 | 33270864 | |
sakila | staff | 214814160 | 25 | 214814160 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1097310192 | 0 | 0 | 0 | 5 | 35381280 | |
sakila | inventory | 91662912 | 26 | 91662912 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2186644416 | 0 | 0 | 0 | 5 | 27016176 | |
My Feminim | Myfeminim | 67836384 | 1 | 67836384 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | accounts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_statistics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | memory_summary_by_host_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_summary_by_host_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_host_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|