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 | 291612026112 | 336097 | 291612026112 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2732900016 | 0 | 0 | 0 | 5 | 20787888 | |
sakila | payment | 251281693872 | 128465 | 251281693872 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12379209744 | 0 | 0 | 0 | 5 | 36769920 | |
sakila | film | 152499421536 | 314514 | 152499421536 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2334092112 | 0 | 0 | 0 | 5 | 29991984 | |
sakila | rental | 59098776528 | 144401 | 59098776528 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 18036195936 | 0 | 0 | 0 | 5 | 37109952 | |
sakila | film_actor | 56033297760 | 330400 | 56033297760 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1574604768 | 0 | 0 | 0 | 5 | 24083136 | |
sakila | inventory | 19638053952 | 38098 | 19638053952 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 475136 | 7616603280 | 0 | 0 | 0 | 5 | 41570496 | |
sakila | staff | 8384044944 | 105 | 8384044944 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 7636935504 | 0 | 0 | 0 | 5 | 41206704 | |
TlapaleriaMalfoy | Registro | 6530408544 | 5 | 6530408544 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1763921280 | 0 | 0 | 0 | 5 | 4740529728 | |
sakila | category | 5468221968 | 10372 | 5468221968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 718496064 | 0 | 0 | 0 | 5 | 20039712 | |
Table_insertion | voiture | 5037790032 | 2 | 5037790032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5043721584 | 0 | 0 | 0 | 5 | 162464544 | |
sakila | customer | 4172767632 | 155 | 4172767632 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3458644992 | 0 | 0 | 0 | 5 | 36684384 | |
sakila | country | 3455759472 | 156 | 3455759472 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2579586240 | 0 | 0 | 0 | 5 | 52795248 | |
sakila | language | 2724605136 | 132 | 2724605136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1239728688 | 0 | 0 | 0 | 5 | 302524992 | |
sakila | store | 2248407216 | 14 | 2248407216 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1981300464 | 0 | 0 | 0 | 5 | 115863264 | |
sakila | city | 2188813440 | 186 | 2188813440 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1131083184 | 0 | 0 | 0 | 5 | 36834336 | |
sakila | address | 2001541872 | 109 | 2001541872 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1458159120 | 0 | 0 | 0 | 5 | 605391600 | |
sys | sys_config | 1739176032 | 1 | 1739176032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1760025168 | 0 | 0 | 0 | 5 | 110953920 | |
sakila | actor | 1348288656 | 401 | 1348288656 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1281969216 | 0 | 0 | 0 | 5 | 54090960 | |
world | CountryLanguage | 322455408 | 1 | 322455408 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 2008514112 | 0 | 0 | 0 | 4 | 22381392 | |
vedettfak | fa | 51413472 | 1 | 51413472 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4972249920 | 0 | 0 | 0 | 5 | 1959393216 | |
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 |
|