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 | country | 2105108016 | 80 | 1095018672 | 0 | 0 | 0 | 0 | 1 | 1010089344 | 6 | 147456 | 2708501664 | 1 | 16384 | 12855216 | 6 | 7766341440 | |
sakila | address | 2052071472 | 26 | 2052071472 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 229376 | 6228859296 | 0 | 0 | 0 | 5 | 40308576 | |
sku | Attore | 739336224 | 4 | 739336224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 829963200 | 0 | 0 | 0 | 5 | 46317744 | |
sakila | film | 436642272 | 28 | 436642272 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2052466944 | 0 | 0 | 0 | 5 | 65133552 | |
sakila | language | 151040208 | 25 | 151040208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 736864656 | 0 | 0 | 0 | 5 | 49774032 | |
sakila | city | 39127440 | 3 | 39127440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 210656688 | 9 | 85006525824 | |
test19 | cours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 895731408 | 0 | 0 | 0 | 5 | 40821792 | |
StdMdDB | student | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 772946064 | 0 | 0 | 0 | 5 | 25761120 | |
StdMdDB | score | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 954498336 | 0 | 0 | 0 | 5 | 47866896 | |
StdMdDB | course | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1798293552 | 0 | 0 | 0 | 5 | 34923504 | |
Stefano | vulcano | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1307584608 | 0 | 0 | 0 | 5 | 42576336 | |
test19 | voiture | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 877163760 | 0 | 0 | 0 | 5 | 22443696 | |
test19 | speciale | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 826347984 | 0 | 0 | 0 | 5 | 23621664 | |
test19 | RK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 917121216 | 0 | 0 | 0 | 5 | 28158240 | |
test19 | rallye | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 935720016 | 0 | 0 | 0 | 5 | 42898944 | |
test19 | pilote | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 862473744 | 0 | 0 | 0 | 5 | 34674816 | |
test19 | ecurie | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1103677344 | 0 | 0 | 0 | 5 | 60434880 | |
PRUEBA | MATERIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 813104688 | 0 | 0 | 0 | 5 | 10533547728 | |
wisedb | login | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1148325552 | 0 | 0 | 0 | 5 | 64749168 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
pw | usuario | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1064223600 | 0 | 0 | 0 | 5 | 34267200 | |
pw | idioma | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 943065024 | 0 | 0 | 0 | 5 | 33525360 | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
pw | estudio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 8601991728 | 0 | 0 | 0 | 5 | 87417792 | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|