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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
phpmyadmin | pma__userconfig | 6640832352 | 318 | 6180185088 | 0 | 0 | 8 | 460647264 | 0 | 0 | 0 | 0 | 0 | 15 | 344064 | 936083280 | 17 | 135796970496 | |
phpmyadmin | pma__column_info | 5253553008 | 19 | 5253553008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 15627711792 | 9 | 81682713024 | |
db_panyuan | student | 3924366336 | 43 | 1347384192 | 1 | 2562375024 | 1 | 14607120 | 0 | 0 | 65 | 2442 | 349597776 | 25 | 1230 | 2375136192 | 52 | 322584768 | |
phpmyadmin | pma__recent | 3319170624 | 108 | 795690720 | 53 | 1008684336 | 53 | 1514795568 | 0 | 0 | 0 | 0 | 0 | 31 | 606208 | 2837331024 | 32 | 193395416016 | |
sakila | film | 3107385072 | 2077 | 3107385072 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5375803488 | 0 | 0 | 0 | 5 | 35796288 | |
sakila | country | 1906025616 | 100 | 1906025616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1214745312 | 0 | 0 | 0 | 5 | 58081584 | |
sakila | city | 1193266272 | 104 | 1193266272 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1227856080 | 0 | 0 | 0 | 5 | 35986368 | |
CVD | PATIENTS | 1032641280 | 23 | 217896624 | 5 | 814744656 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 237880896 | 7 | 64777763952 | |
CVD | MEDICAL_PROCEDURES | 748417296 | 14 | 120843888 | 7 | 627573408 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 332434080 | 7 | 48886884816 | |
db_panyuan | grade | 624068016 | 39 | 149277216 | 10 | 75895248 | 1 | 398895552 | 0 | 0 | 64 | 1257 | 80938176 | 21 | 815 | 1151330400 | 55 | 258797088 | |
132 | SC | 587545728 | 0 | 0 | 5 | 587545728 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 1006966752 | 9 | 122757721680 | |
sakila | film_category | 440080080 | 1001 | 440080080 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1101272832 | 0 | 0 | 0 | 5 | 30772896 | |
132 | Course | 426659376 | 0 | 0 | 7 | 426659376 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 331356432 | 7 | 160078025184 | |
132 | Student | 391863648 | 20 | 145988304 | 4 | 245875344 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 686163984 | 7 | 50505702720 | |
phpmyadmin | pma__table_uiprefs | 391472928 | 55 | 391472928 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 373806576 | 6 | 72141661680 | |
phpmyadmin | pma__favorite | 332251920 | 55 | 332251920 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 5232582432 | 6 | 57017960208 | |
sakila | actor | 211213728 | 25 | 211213728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 800785392 | 0 | 0 | 0 | 5 | 38460048 | |
project_passport | tbl_member | 188972784 | 13 | 188972784 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 609990480 | 6 | 55827579984 | |
phpmyadmin | pma__table_info | 129125040 | 15 | 129125040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 393970896 | 6 | 74770359840 | |
sakila | language | 126703632 | 25 | 126703632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 746346480 | 0 | 0 | 0 | 5 | 36936240 | |
sakila | film_actor | 103021776 | 26 | 103021776 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2389557984 | 0 | 0 | 0 | 5 | 19324481616 | |
sakila | inventory | 99014256 | 26 | 99014256 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2087715696 | 0 | 0 | 0 | 5 | 31176288 | |
phpmyadmin | pma__tracking | 6273168 | 1 | 6273168 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 309501456 | 6 | 46574195184 | |
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 |
|