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 | 871278667248 | 990000 | 871278667248 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1104416544 | 0 | 0 | 0 | 5 | 33887040 | |
sakila | film | 473167114992 | 924544 | 473167114992 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2093505744 | 0 | 0 | 0 | 5 | 35462064 | |
sakila | film_actor | 175292764416 | 991200 | 175292764416 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1866459936 | 0 | 0 | 0 | 5 | 51625200 | |
klo | ChangeLogs | 26748251376 | 1918 | 4618744944 | 58 | 21844654656 | 0 | 0 | 11 | 284851776 | 0 | 0 | 0 | 27 | 540672 | 571039920 | 26 | 130138251936 | |
sakila | category | 15644082960 | 30810 | 15644082960 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 927070320 | 0 | 0 | 0 | 5 | 41552544 | |
klo | Rentals | 13534536048 | 202 | 1759071600 | 5 | 287824944 | 4 | 85610976 | 4 | 11402028528 | 0 | 0 | 0 | 20 | 425984 | 4974730992 | 16 | 103990018176 | |
klo | Vehicles | 7027744416 | 753 | 3613812576 | 5 | 334687056 | 5 | 204100512 | 7 | 2875144272 | 0 | 0 | 0 | 20 | 425984 | 1030449552 | 16 | 109145780832 | |
klo | RentalPoints | 6583230720 | 467 | 5264675328 | 5 | 256698816 | 5 | 243768096 | 5 | 818088480 | 0 | 0 | 0 | 20 | 425984 | 613994832 | 16 | 111084591024 | |
klo | Parks | 4447804416 | 461 | 3185634144 | 5 | 254188704 | 5 | 304715136 | 5 | 703266432 | 0 | 0 | 0 | 12 | 294912 | 5308496160 | 11 | 96794438928 | |
sakila | customer | 1727743248 | 30 | 1727743248 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2114391840 | 0 | 0 | 0 | 5 | 21541344 | |
sakila | address | 1556120016 | 630 | 1556120016 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1979887008 | 0 | 0 | 0 | 5 | 18515376 | |
sys | sys_config | 985914864 | 17 | 985914864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 598992768 | 0 | 0 | 0 | 5 | 263249184 | |
sakila | actor | 933211488 | 1335 | 933211488 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1724980224 | 0 | 0 | 0 | 5 | 50162640 | |
sakila | city | 674872176 | 7 | 674872176 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1448011488 | 0 | 0 | 0 | 5 | 19745616 | |
sakila | country | 661459392 | 2 | 661459392 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 822335184 | 0 | 0 | 0 | 5 | 38174400 | |
sakila | language | 538680384 | 123 | 538680384 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 674051664 | 0 | 0 | 0 | 5 | 30807744 | |
Estudiantes | alumno | 218830128 | 8 | 138987024 | 2 | 79843104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 190112736 | 8 | 64279137120 | |
Table_insertion | pilote | 47456640 | 3 | 47456640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 691828368 | 0 | 0 | 0 | 5 | 37730880 | |
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 |
|