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 | 62499410160 | 16051 | 62499410160 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 6517664208 | 0 | 0 | 0 | 5 | 53049744 | |
sakila | customer | 56012199936 | 599 | 56012199936 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4348037760 | 0 | 0 | 0 | 5 | 81149376 | |
vedettfak | fa | 38479276176 | 1258 | 38479276176 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1959974544 | 0 | 0 | 0 | 5 | 35759856 | |
sakila | rental | 34012940016 | 16044 | 34012940016 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 9804166416 | 0 | 0 | 0 | 5 | 54269952 | |
sakila | film_category | 22331587344 | 1000 | 22331587344 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1751173776 | 0 | 0 | 0 | 5 | 43032000 | |
sakila | film_actor | 7287472368 | 5462 | 7287472368 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4053749568 | 0 | 0 | 0 | 5 | 56003904 | |
sakila | film | 4997584944 | 1234 | 4997584944 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1777835664 | 0 | 0 | 0 | 5 | 39706656 | |
sakila | inventory | 4731079584 | 4583 | 4731079584 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2044625616 | 0 | 0 | 0 | 5 | 41820768 | |
LibreriaOnline | Libros | 4046944176 | 1197 | 3847113600 | 20 | 199830576 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 216087168 | 8 | 84884421072 | |
sakila | city | 3848276256 | 1056 | 3848276256 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1292513904 | 0 | 0 | 0 | 5 | 67624656 | |
sakila | address | 3702203472 | 712 | 3702203472 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2962220976 | 0 | 0 | 0 | 5 | 48494160 | |
world | City | 3693526848 | 4079 | 3693526848 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 2042156160 | 0 | 0 | 0 | 4 | 19341696 | |
sakila | language | 2925201312 | 245 | 2925201312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 997566240 | 0 | 0 | 0 | 5 | 69671712 | |
LibreriaOnline | Clientes | 2889666912 | 869 | 2631145968 | 20 | 258520944 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 199448832 | 8 | 74703840288 | |
LibreriaOnline | Autores | 2223558480 | 511 | 1773921600 | 20 | 449636880 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 197472528 | 7 | 63266107344 | |
sakila | country | 2133434688 | 338 | 2133434688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 741472512 | 0 | 0 | 0 | 5 | 101280960 | |
sakila | film_text | 1860205776 | 1000 | 1860205776 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1871907312 | 0 | 0 | 0 | 1004 | 169763088 | |
LibreriaOnline | Categorías | 1704675984 | 384 | 1458288480 | 20 | 246387504 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | CountryLanguage | 1698331536 | 984 | 1698331536 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1436639952 | 0 | 0 | 0 | 4 | 18550752 | |
LibreriaOnline | Editoriales | 1697251248 | 402 | 1444989216 | 20 | 252262032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 302049264 | 6 | 51939299808 | |
sakila | staff | 1662545280 | 5 | 1662545280 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1524403584 | 0 | 0 | 0 | 5 | 41481264 | |
TlapaleriaMalfoy | Registro | 1637331696 | 2 | 1637331696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1792740576 | 0 | 0 | 0 | 5 | 64945584 | |
Table_insertion | ecurie | 1566232272 | 4 | 1566232272 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1850264064 | 0 | 0 | 0 | 5 | 47437632 | |
LibreriaOnline | Reseñas | 1256207040 | 151 | 943483728 | 20 | 312723312 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
LibreriaOnline | Pedidos | 1203316224 | 311 | 989302512 | 20 | 214013712 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 212213760 | 8 | 73321554768 |
|