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 | 136172751264 | 32088 | 136172751264 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 11561327184 | 0 | 0 | 0 | 5 | 25290144 | |
sakila | rental | 28945824864 | 41250 | 28945824864 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5249056560 | 0 | 0 | 0 | 5 | 256325520 | |
sakila | inventory | 7939671696 | 11162 | 7939671696 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1250845728 | 0 | 0 | 0 | 5 | 188174976 | |
sakila | customer | 6102657264 | 2 | 6102657264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5365570848 | 0 | 0 | 0 | 5 | 656318256 | |
sakila | film | 6062022912 | 2245 | 6062022912 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 893139456 | 0 | 0 | 0 | 5 | 1414561104 | |
Titanic | ticket | 2791343808 | 0 | 0 | 1000 | 2791343808 | 0 | 0 | 0 | 0 | 2 | 392 | 13606032 | 1012 | 40503 | 1460267952 | 8 | 99806784 | |
Titanic | pasajeros | 2787063312 | 0 | 0 | 1000 | 2787063312 | 0 | 0 | 0 | 0 | 2 | 385 | 7823376 | 1011 | 34048 | 1414920144 | 8 | 62466096 | |
sakila | language | 2553380016 | 365 | 2553380016 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 481415088 | 0 | 0 | 0 | 5 | 54014928 | |
Titanic | status | 2280856512 | 0 | 0 | 1000 | 2280856512 | 0 | 0 | 0 | 0 | 2 | 378 | 14968272 | 1010 | 13497 | 1275528144 | 8 | 1386080784 | |
Titanic | family | 1844761248 | 0 | 0 | 1000 | 1844761248 | 0 | 0 | 0 | 0 | 2 | 385 | 12111792 | 1011 | 17504 | 841859568 | 8 | 75447504 | |
sakila | city | 1606516032 | 57 | 1606516032 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1149496656 | 0 | 0 | 0 | 5 | 218427264 | |
sakila | address | 1309922592 | 102 | 1309922592 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 845229264 | 0 | 0 | 0 | 5 | 352195536 | |
sys | sys_config | 1188379632 | 1 | 1188379632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 507223200 | 0 | 0 | 0 | 5 | 644841120 | |
sakila | country | 1168955040 | 252 | 1168955040 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 371985504 | 0 | 0 | 0 | 5 | 26263248 | |
sakila | film_category | 1075147392 | 2034 | 1075147392 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 422935392 | 0 | 0 | 0 | 5 | 29012016 | |
INFS1200_RELEASE | Customer | 982092672 | 3 | 982092672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 529277760 | 0 | 0 | 0 | 5 | 377529504 | |
sakila | staff | 870914880 | 2 | 870914880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 628887600 | 0 | 0 | 0 | 5 | 192529920 | |
sakila | store | 761393424 | 6 | 761393424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 582127920 | 0 | 0 | 0 | 5 | 105494928 | |
sakila | category | 608607648 | 66 | 608607648 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 452670768 | 0 | 0 | 0 | 5 | 46638768 | |
Titanic | puertos | 33785664 | 0 | 0 | 3 | 33785664 | 0 | 0 | 0 | 0 | 2 | 364 | 10365168 | 11 | 543 | 77519904 | 8 | 17855342208 | |
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 |
|