SELECT * FROM `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 | inventory | 2.94 ms | 7 | 2.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 2.92 ms | 0 | 0 bytes | 0 ps | 5 | 47.10 us | |
sakila | film | 1.41 ms | 452 | 1.41 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.81 ms | 0 | 0 bytes | 0 ps | 5 | 31.19 us | |
sakila | language | 1.01 ms | 50 | 1.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 759.76 us | 0 | 0 bytes | 0 ps | 5 | 50.17 us | |
sakila | country | 834.38 us | 7 | 834.38 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 935.35 us | 0 | 0 bytes | 0 ps | 5 | 55.60 us | |
sakila | customer | 806.37 us | 7 | 806.37 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 880.79 us | 0 | 0 bytes | 0 ps | 5 | 21.28 us | |
sakila | store | 779.13 us | 16 | 779.13 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 783.13 us | 0 | 0 bytes | 0 ps | 5 | 71.77 us | |
sys | sys_config | 630.28 us | 1 | 630.28 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 811.18 us | 0 | 0 bytes | 0 ps | 5 | 44.32 us | |
sakila | city | 598.19 us | 7 | 598.19 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 701.38 us | 0 | 0 bytes | 0 ps | 5 | 22.73 us | |
sakila | address | 549.44 us | 7 | 549.44 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 716.96 us | 0 | 0 bytes | 0 ps | 5 | 36.85 us | |
sklepSerohenko | towar | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 958.78 us | 0 | 0 bytes | 0 ps | 5 | 40.82 us | |
performance_schema | global_status | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | speciale | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 920.33 us | 0 | 0 bytes | 0 ps | 5 | 30.53 us | |
performance_schema | events_statements_current | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | memory_summary_global_by_event_name | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | setup_instruments | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | voiture | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.78 ms | 0 | 0 bytes | 0 ps | 5 | 31.27 us | |
performance_schema | events_transactions_current | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | RK | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 875.59 us | 0 | 0 bytes | 0 ps | 5 | 20.68 us | |
Table_insertion | rallye | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.04 ms | 0 | 0 bytes | 0 ps | 5 | 27.88 us | |
Table_insertion | pilote | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 681.32 us | 0 | 0 bytes | 0 ps | 5 | 26.30 us | |
Table_insertion | ecurie | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.29 ms | 0 | 0 bytes | 0 ps | 5 | 30.44 us |
|