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 | actor | 4574056080 | 1117 | 4574056080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3959882256 | 0 | 0 | 0 | 5 | 45711600 | |
TlapaleriaMalfoy | Registro | 4455953040 | 2 | 4455953040 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2553787104 | 0 | 0 | 0 | 5 | 1942470816 | |
vedettfak | megye | 4188525264 | 35 | 4188525264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3968650752 | 0 | 0 | 0 | 5 | 383685456 | |
sakila | language | 3711942432 | 701 | 3711942432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1047266352 | 0 | 0 | 0 | 5 | 581022288 | |
sakila | film_actor | 2666853024 | 16 | 2666853024 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3998457408 | 0 | 0 | 0 | 5 | 31273968 | |
sakila | film | 2586386352 | 1163 | 2586386352 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1567313616 | 0 | 0 | 0 | 5 | 36124176 | |
srms | admin | 702348240 | 47 | 702348240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 247866432 | 6 | 56752802832 | |
sakila | inventory | 672360480 | 26 | 672360480 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2246751408 | 0 | 0 | 0 | 5 | 34645776 | |
sakila | country | 635217792 | 101 | 635217792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 780735648 | 0 | 0 | 0 | 5 | 30147216 | |
sakila | city | 608712192 | 128 | 608712192 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1276960080 | 0 | 0 | 0 | 5 | 27966576 | |
srms | tblresult | 533945280 | 106 | 533945280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 174095328 | 6 | 95205136752 | |
srms | tblnotice | 508899600 | 34 | 508899600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 199001616 | 6 | 47086627104 | |
sakila | address | 494140416 | 52 | 494140416 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1629244848 | 0 | 0 | 0 | 5 | 39850800 | |
BIMBO | EMPLEADO | 474351504 | 14 | 102409296 | 5 | 371942208 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 187810656 | 7 | 68741113056 | |
srms | tblclasses | 438244224 | 54 | 438244224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 6634712832 | 7 | 92719198176 | |
srms | tblsubjects | 393332016 | 47 | 393332016 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 266528592 | 6 | 60994655040 | |
srms | tblstudents | 390615456 | 43 | 390615456 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 158106432 | 6 | 67060703424 | |
Veterinaria_ColitaFeliz | Servicio_TipoDeConsulta | 109042032 | 2 | 73423680 | 1 | 35618352 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 217610976 | 7 | 56613527520 | |
Table_insertion | ecurie | 29032080 | 2 | 29032080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 891976800 | 0 | 0 | 0 | 5 | 40988112 | |
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 | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|