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 | 1227448455024 | 1321000 | 1227448455024 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1333211088 | 0 | 0 | 0 | 5 | 51538080 | |
sakila | film | 688246136160 | 1233816 | 688246136160 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1672021824 | 0 | 0 | 0 | 5 | 278950320 | |
sakila | film_actor | 249012464448 | 1327062 | 249012464448 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 2112959904 | 0 | 0 | 0 | 5 | 41620128 | |
sakila | category | 23887245888 | 41115 | 23887245888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 754231632 | 0 | 0 | 0 | 5 | 35520144 | |
sakila | payment | 22113155328 | 16049 | 22113155328 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 6165419040 | 0 | 0 | 0 | 5 | 30751776 | |
sakila | rental | 16684124688 | 16044 | 16684124688 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 5679993792 | 0 | 0 | 0 | 5 | 34222320 | |
sakila | film_text | 3441403152 | 1026 | 3441403152 | 0 | 0 | 0 | 0 | 0 | 0 | 2052 | 122263 | 3232306704 | 0 | 0 | 0 | 1034 | 169763616 | |
sakila | country | 3403664352 | 212 | 3403664352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3033604992 | 0 | 0 | 0 | 5 | 137880864 | |
sakila | address | 3328091184 | 1979 | 3328091184 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3625265424 | 0 | 0 | 0 | 5 | 51984768 | |
sakila | city | 3079256928 | 680 | 3079256928 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2689729680 | 0 | 0 | 0 | 5 | 51578208 | |
sakila | actor | 2966804544 | 4180 | 2966804544 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1128564096 | 0 | 0 | 0 | 5 | 41551488 | |
sakila | language | 2524226496 | 206 | 2524226496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 887967168 | 0 | 0 | 0 | 5 | 72858192 | |
sakila | inventory | 2303526192 | 4581 | 2303526192 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2188141824 | 0 | 0 | 0 | 5 | 24234672 | |
sakila | staff | 1986498096 | 2 | 1986498096 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3093796464 | 0 | 0 | 0 | 5 | 31739664 | |
TlapaleriaMalfoy | Registro | 1831007904 | 2 | 1831007904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 971925504 | 0 | 0 | 0 | 5 | 305696160 | |
sys | sys_config | 741422352 | 2 | 741422352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1019582784 | 0 | 0 | 0 | 5 | 59468112 | |
sakila | customer | 452425776 | 599 | 452425776 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1440127920 | 0 | 0 | 0 | 5 | 36367584 | |
kuliah | dokter | 221816496 | 0 | 0 | 18 | 221816496 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 81308832 | 4 | 48608469888 | |
cadastro | pessoas | 117096144 | 7 | 32588160 | 6 | 84507984 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 217327440 | 6 | 55829700432 | |
cadastro | cursos | 109878912 | 0 | 0 | 7 | 109878912 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 248072880 | 9 | 125043882480 | |
kuliah | pasien | 100291488 | 0 | 0 | 3 | 100291488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 89530320 | 4 | 28632655392 | |
cadastro | priscila | 31337328 | 0 | 0 | 1 | 31337328 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 234944688 | 6 | 50998080144 | |
kuliah | login | 27467616 | 0 | 0 | 1 | 27467616 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 131072 | 126291264 | 4 | 33873654672 | |
sakila | store | 12278112 | 2 | 12278112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 845544480 | 0 | 0 | 0 | 5 | 19250352 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|