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 | customer | 4483670928 | 26 | 4483670928 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4972029216 | 0 | 0 | 0 | 5 | 34345344 | |
sakila | category | 3727867968 | 17 | 3727867968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3906337248 | 0 | 0 | 0 | 5 | 47267616 | |
sakila | language | 1926341472 | 182 | 1926341472 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 802592736 | 0 | 0 | 0 | 5 | 59091120 | |
TlapaleriaMalfoy | Registro | 1911634560 | 3 | 1911634560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1116751152 | 0 | 0 | 0 | 5 | 504805488 | |
sakila | staff | 1473589392 | 3 | 1473589392 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1246272192 | 0 | 0 | 0 | 5 | 35198064 | |
sakila | film | 1435436640 | 182 | 1435436640 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1291253568 | 0 | 0 | 0 | 5 | 211499904 | |
sakila | address | 1251578064 | 53 | 1251578064 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2068838112 | 0 | 0 | 0 | 5 | 53953152 | |
sakila | rental | 1224195984 | 2 | 1224195984 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1294544064 | 0 | 0 | 0 | 5 | 37247232 | |
sakila | city | 1193582016 | 25 | 1193582016 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1186063824 | 0 | 0 | 0 | 5 | 38514960 | |
sakila | country | 765519744 | 28 | 765519744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 869720544 | 0 | 0 | 0 | 5 | 56186064 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_history | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | ALUNO_CURSO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 143429616 | 7 | 79289172864 | |
performance_schema | events_transactions_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_errors_summary_by_thread_by_error | 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 | |
world | CountryLanguage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 303732528 | 0 | 0 | 0 | 4 | 38778432 | |
world | Country | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 3131168832 | 0 | 0 | 0 | 4 | 21586752 | |
world | City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 156290112 | 0 | 0 | 0 | 4 | 24398352 | |
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 | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|