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 | country | 5419996560 | 101 | 5419996560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 761095632 | 0 | 0 | 0 | 5 | 40547232 | |
sakila | city | 4573234512 | 128 | 4573234512 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4162420416 | 0 | 0 | 0 | 5 | 41491824 | |
sakila | actor | 3974191584 | 28 | 3974191584 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4073719056 | 0 | 0 | 0 | 5 | 48262896 | |
sakila | category | 3324203520 | 2 | 3324203520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3410185152 | 0 | 0 | 0 | 5 | 40383552 | |
sakila | address | 3059890944 | 77 | 3059890944 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3681596160 | 0 | 0 | 0 | 5 | 38983824 | |
sakila | film | 2811819648 | 26 | 2811819648 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3605489712 | 0 | 0 | 0 | 5 | 34751904 | |
sakila | customer | 1026405600 | 26 | 1026405600 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1412200944 | 0 | 0 | 0 | 5 | 35469984 | |
sakila | language | 963090480 | 25 | 963090480 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 975758256 | 0 | 0 | 0 | 5 | 42344016 | |
TlapaleriaMalfoy | Registro | 603101664 | 2 | 603101664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 875145744 | 0 | 0 | 0 | 5 | 40497072 | |
Artist | PAINTER | 568236768 | 15 | 163084416 | 3 | 327111840 | 2 | 78040512 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 163506288 | 8 | 83075827824 | |
realestatephp | city | 442281312 | 32 | 232257168 | 5 | 210024144 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 237045072 | 7 | 70963364208 | |
realestatephp | admin | 171845520 | 10 | 145206336 | 1 | 26639184 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 267509616 | 7 | 54050291328 | |
Artist | PAINTING | 160529952 | 0 | 0 | 8 | 160529952 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 496628352 | 7 | 92509714176 | |
realestatephp | feedback | 54337008 | 0 | 0 | 2 | 54337008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 118128912 | 7 | 70729179312 | |
realestatephp | about | 42083184 | 0 | 0 | 1 | 42083184 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 4938829104 | 7 | 76187932656 | |
realestatephp | contact | 22763136 | 0 | 0 | 1 | 22763136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 5716460640 | 7 | 78077968320 | |
performance_schema | events_statements_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sku | Film | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2436592752 | 0 | 0 | 0 | 5 | 28161936 | |
performance_schema | global_variables | 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 | events_transactions_summary_by_account_by_event_na... | 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 | 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 | |
sku | Cinema | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4217772240 | 0 | 0 | 0 | 5 | 33756096 |
|