SELECT * FROM `user_summary_by_statement_type`
|
user | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
background | select | 1 | 973.30 us | 973.30 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2345 | 573.98 ms | 12.00 ms | 238.26 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2345 | 275.34 ms | 395.77 us | 94.86 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2345 | 16.97 ms | 149.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 29807 | 14.28 s | 433.93 ms | 4.00 s | 190738 | 1927768 | 0 | 14201 | |
root | alter_table | 22 | 12.15 s | 1.17 s | 6.57 ms | 0 | 0 | 213 | 0 | |
root | create_table | 26 | 5.65 s | 301.78 ms | 471.71 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 928 | 2.33 s | 200.77 ms | 425.86 ms | 1453 | 17393 | 0 | 0 | |
root | create_procedure | 40 | 1.97 s | 101.00 ms | 12.05 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 1721 | 1.57 s | 5.22 ms | 156.19 ms | 2273 | 986888 | 0 | 1721 | |
root | show_fields | 1239 | 1.16 s | 5.00 ms | 472.76 ms | 45474 | 232038 | 0 | 0 | |
root | create_db | 25 | 722.23 ms | 85.23 ms | 1.14 ms | 0 | 0 | 14 | 0 | |
root | drop_table | 5 | 621.64 ms | 136.20 ms | 1.71 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 922 | 593.79 ms | 4.21 ms | 376.44 ms | 3392 | 13994 | 0 | 0 | |
root | set_option | 7181 | 541.47 ms | 5.60 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_view | 5 | 241.99 ms | 53.53 ms | 3.02 ms | 0 | 0 | 0 | 0 | |
root | insert | 16 | 226.57 ms | 51.34 ms | 9.48 ms | 0 | 0 | 268 | 0 | |
root | Init DB | 1723 | 132.26 ms | 707.30 us | 16.33 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1265 | 107.41 ms | 616.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 208 | 101.86 ms | 7.56 ms | 63.54 ms | 48 | 502 | 0 | 0 | |
root | show_create_table | 608 | 100.00 ms | 1.53 ms | 511.00 us | 0 | 0 | 0 | 0 | |
root | show_create_proc | 40 | 79.44 ms | 68.77 ms | 72.41 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 121 | 20.36 ms | 13.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 591 | 19.62 ms | 325.80 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2443 | 18.25 ms | 247.63 us | 0 ps | 0 | 0 | 0 | 0 |
|