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 | 538103225088 | 660052 | 538103225088 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4516141872 | 0 | 0 | 0 | 5 | 38648016 | |
sakila | film | 291263440512 | 616554 | 291263440512 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1700487360 | 0 | 0 | 0 | 5 | 49595568 | |
sakila | film_actor | 109287140160 | 660800 | 109287140160 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1754074080 | 0 | 0 | 0 | 5 | 20805312 | |
sakila | payment | 99324915888 | 32088 | 99324915888 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 21879761904 | 0 | 0 | 0 | 5 | 50348496 | |
sakila | rental | 20662426224 | 41250 | 20662426224 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5898819696 | 0 | 0 | 0 | 5 | 53204448 | |
sakila | customer | 19731400656 | 28 | 19731400656 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 5118853344 | 0 | 0 | 0 | 5 | 38857104 | |
sakila | category | 10619916384 | 20590 | 10619916384 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1141176960 | 0 | 0 | 0 | 5 | 71453712 | |
TlapaleriaMalfoy | Registro | 4296263136 | 2 | 4296263136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4124742336 | 0 | 0 | 0 | 5 | 77669856 | |
sakila | inventory | 4095435696 | 9166 | 4095435696 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2819086512 | 0 | 0 | 0 | 5 | 53982720 | |
sakila | city | 4038230592 | 33 | 4038230592 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3344936496 | 0 | 0 | 0 | 5 | 390809760 | |
sakila | actor | 3072822720 | 802 | 3072822720 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2847280128 | 0 | 0 | 0 | 5 | 41143872 | |
sakila | language | 2309692704 | 466 | 2309692704 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 841539072 | 0 | 0 | 0 | 5 | 56099472 | |
sys | sys_config | 2283705600 | 2 | 2283705600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2483874096 | 0 | 0 | 0 | 5 | 48572832 | |
sakila | address | 2169357168 | 57 | 2169357168 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2425355328 | 0 | 0 | 0 | 5 | 58789104 | |
sakila | staff | 1722362928 | 4 | 1722362928 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1126398768 | 0 | 0 | 0 | 5 | 691817280 | |
sakila | country | 732074640 | 32 | 732074640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 796400880 | 0 | 0 | 0 | 5 | 61082208 | |
sakila | store | 720000864 | 6 | 720000864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 768338208 | 0 | 0 | 0 | 5 | 63215328 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|