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 | payment | 5422260096 | 2 | 5422260096 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 11326977024 | 0 | 0 | 0 | 5 | 66783552 | |
sakila | staff | 4927509840 | 30 | 4927509840 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4689682800 | 0 | 0 | 0 | 5 | 67170576 | |
sakila | city | 4694694576 | 308 | 4694694576 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4138090704 | 0 | 0 | 0 | 5 | 48286128 | |
sakila | address | 4310765712 | 5530 | 4310765712 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2105836656 | 0 | 0 | 0 | 5 | 38377680 | |
TlapaleriaMalfoy | Registro | 3777263424 | 1 | 3777263424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3986679840 | 0 | 0 | 0 | 5 | 38842320 | |
sakila | film | 3537072528 | 336 | 3537072528 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2724036480 | 0 | 0 | 0 | 5 | 42035136 | |
sakila | language | 2757134688 | 275 | 2757134688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 766122720 | 0 | 0 | 0 | 5 | 54372912 | |
sakila | customer | 1609137024 | 51 | 1609137024 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1762585968 | 0 | 0 | 0 | 5 | 47625072 | |
world | CountryLanguage | 1438302624 | 31 | 1438302624 | 0 | 0 | 0 | 0 | 0 | 0 | 28 | 1421 | 1106777232 | 0 | 0 | 0 | 9 | 90454848 | |
sakila | actor | 1420377024 | 526 | 1420377024 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 874646256 | 0 | 0 | 0 | 5 | 30518928 | |
world | City | 1374118416 | 3 | 1374118416 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 300178032 | 0 | 0 | 0 | 6 | 36085632 | |
sakila | country | 1257637392 | 133 | 1257637392 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 877625760 | 0 | 0 | 0 | 5 | 94053696 | |
sakila | category | 853373136 | 7 | 853373136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 887106528 | 0 | 0 | 0 | 5 | 37977456 | |
sys | sys_config | 621666144 | 1 | 621666144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 849489168 | 0 | 0 | 0 | 5 | 48510528 | |
sakila | rental | 471068928 | 26 | 471068928 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 6260157024 | 0 | 0 | 0 | 5 | 35228688 | |
sakila | store | 418081488 | 3 | 418081488 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1187503152 | 0 | 0 | 0 | 5 | 33364848 | |
sakila | inventory | 156519264 | 52 | 156519264 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5378379072 | 0 | 0 | 0 | 5 | 25207776 | |
Table_insertion | pilote | 38678640 | 3 | 38678640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 744446736 | 0 | 0 | 0 | 5 | 41730480 | |
Table_insertion | ecurie | 37828032 | 2 | 37828032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 974005824 | 0 | 0 | 0 | 5 | 39274224 | |
world | Country | 36533376 | 1 | 36533376 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 1583015808 | 0 | 0 | 0 | 4 | 37439424 | |
Stefano | vulcano | 18403968 | 1 | 18403968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1784535456 | 0 | 0 | 0 | 5 | 57686640 | |
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 |
|