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_category | 332654402784 | 330000 | 332654402784 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 878110464 | 0 | 0 | 0 | 5 | 17557584 | |
sakila | film | 172745441616 | 308177 | 172745441616 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1670360736 | 0 | 0 | 0 | 5 | 55426800 | |
sakila | film_actor | 63753206880 | 330400 | 63753206880 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1646135568 | 0 | 0 | 0 | 5 | 21175440 | |
sakila | category | 5960151648 | 10270 | 5960151648 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 649911504 | 0 | 0 | 0 | 5 | 16973616 | |
sakila | customer | 5051810544 | 103 | 5051810544 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4655105136 | 0 | 0 | 0 | 5 | 91841904 | |
sakila | payment | 4417227408 | 26 | 4417227408 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 17085048288 | 0 | 0 | 0 | 5 | 39433152 | |
sakila | store | 3979522800 | 6 | 3979522800 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4013161680 | 0 | 0 | 0 | 5 | 69831696 | |
sakila | address | 3567452592 | 80 | 3567452592 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3957816720 | 0 | 0 | 0 | 5 | 38151168 | |
sakila | staff | 2867433360 | 54 | 2867433360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1739686080 | 0 | 0 | 0 | 5 | 1003609200 | |
sakila | city | 1340225568 | 51 | 1340225568 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1005166800 | 0 | 0 | 0 | 5 | 265674816 | |
sakila | rental | 1278349776 | 26 | 1278349776 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 6292822800 | 0 | 0 | 0 | 5 | 38378208 | |
sakila | inventory | 1209584112 | 26 | 1209584112 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1992061632 | 0 | 0 | 0 | 5 | 41976000 | |
sakila | country | 1013364000 | 51 | 1013364000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 968577456 | 0 | 0 | 0 | 5 | 55828608 | |
TlapaleriaMalfoy | Registro | 909595104 | 3 | 909595104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 823229616 | 0 | 0 | 0 | 5 | 327019440 | |
sakila | actor | 852993504 | 400 | 852993504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904188912 | 0 | 0 | 0 | 5 | 34771440 | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_history_long | 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 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
table | ameerah | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 882274272 | 0 | 0 | 0 | 5 | 346032192 | |
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 | |
PRUEBA | MATERIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 619435344 | 0 | 0 | 0 | 5 | 156336048 | |
performance_schema | events_statements_current | 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 |
|