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 | 275900586192 | 160443 | 275900586192 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12216936864 | 0 | 0 | 0 | 5 | 19417728 | |
sys | sys_config | 180558101856 | 1 | 180558101856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2175223776 | 0 | 0 | 0 | 5 | 2499154944 | |
sakila | rental | 74014100160 | 206252 | 74014100160 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 9923095248 | 0 | 0 | 0 | 5 | 21990144 | |
sakila | language | 31820735232 | 52 | 31820735232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1219901760 | 0 | 0 | 0 | 5 | 103230864 | |
vedettfak | megye | 22808735664 | 4 | 22808735664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2041184640 | 0 | 0 | 0 | 5 | 486842400 | |
sakila | city | 18018041184 | 97 | 18018041184 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 17310657936 | 0 | 0 | 0 | 5 | 475470336 | |
sakila | store | 9788883984 | 32 | 9788883984 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 729696000 | 0 | 0 | 0 | 5 | 45553728 | |
sakila | inventory | 9371809920 | 45830 | 9371809920 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3183437136 | 0 | 0 | 0 | 5 | 14503104 | |
test19 | pilote | 5358258048 | 2 | 5358258048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5502205104 | 0 | 0 | 0 | 5 | 46008864 | |
vedettfak | fa | 4599433344 | 2 | 4599433344 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4749933936 | 0 | 0 | 0 | 5 | 48869568 | |
sakila | actor | 3917138544 | 2 | 3917138544 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4168723680 | 0 | 0 | 0 | 5 | 43708368 | |
sakila | staff | 1734371232 | 22 | 1734371232 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1742538336 | 0 | 0 | 0 | 5 | 19825344 | |
Stefano | vulcano | 1302345264 | 4 | 1302345264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 919091712 | 0 | 0 | 0 | 5 | 688849392 | |
test19 | voiture | 1251772896 | 3 | 1251772896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1362771696 | 0 | 0 | 0 | 5 | 54443664 | |
sakila | country | 1104099216 | 73 | 1104099216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 758366928 | 0 | 0 | 0 | 5 | 44618640 | |
test19 | ecurie | 972737040 | 2 | 972737040 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1208105184 | 0 | 0 | 0 | 5 | 67186416 | |
sakila | film | 918141312 | 3 | 918141312 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 988352112 | 0 | 0 | 0 | 5 | 38638512 | |
sakila | address | 757404384 | 49 | 757404384 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1623786912 | 0 | 0 | 0 | 5 | 15890160 | |
sakila | category | 747569856 | 4 | 747569856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904361568 | 0 | 0 | 0 | 5 | 52525968 | |
sakila | customer | 727586640 | 4 | 727586640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 836491920 | 0 | 0 | 0 | 5 | 51280944 | |
world | CountryLanguage | 651883584 | 38 | 651883584 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 711859632 | 0 | 0 | 0 | 10 | 70845456 | |
world | Country | 27167184 | 2 | 27167184 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 134454672 | 0 | 0 | 0 | 5 | 21100992 | |
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 |
|