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 | 536.28 us | 536.28 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5452 | 826.76 ms | 3.86 ms | 341.33 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5452 | 370.57 ms | 29.87 ms | 153.64 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5456 | 35.37 ms | 59.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 170643 | 1.62 m | 858.79 ms | 26.93 s | 683000 | 5593740 | 0 | 67683 | |
root | alter_table | 64 | 28.13 s | 665.16 ms | 12.92 ms | 0 | 0 | 5175 | 0 | |
root | show_fields | 8934 | 10.04 s | 71.54 ms | 4.15 s | 318367 | 1624838 | 0 | 0 | |
root | show_keys | 9562 | 9.01 s | 93.69 ms | 4.14 s | 8648 | 127629 | 0 | 0 | |
root | show_variables | 9156 | 8.99 s | 6.60 ms | 881.15 ms | 10800 | 5252289 | 0 | 9156 | |
root | create_table | 41 | 7.17 s | 303.18 ms | 14.03 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 4862 | 2.77 s | 4.08 ms | 1.48 s | 101786 | 287223 | 0 | 0 | |
root | insert | 33 | 1.34 s | 66.58 ms | 12.50 ms | 0 | 0 | 2972 | 0 | |
root | show_create_table | 4481 | 1.33 s | 110.99 ms | 1.13 ms | 0 | 0 | 0 | 0 | |
root | set_option | 22082 | 939.41 ms | 6.41 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 17 | 605.25 ms | 67.14 ms | 2.16 ms | 0 | 0 | 14 | 0 | |
root | show_table_status | 301 | 531.68 ms | 420.40 ms | 68.34 ms | 266 | 1662 | 0 | 0 | |
root | Init DB | 6874 | 350.71 ms | 2.00 ms | 19.75 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3603 | 318.57 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_view | 4 | 241.50 ms | 70.38 ms | 3.29 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 4030 | 137.81 ms | 906.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 95173 | 86.55 ms | 398.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | grant | 3 | 81.54 ms | 31.59 ms | 1.91 ms | 0 | 0 | 0 | 0 | |
root | drop_db | 2 | 74.90 ms | 54.58 ms | 2.22 ms | 0 | 0 | 0 | 0 | |
root | Quit | 9293 | 64.61 ms | 1.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 312 | 48.80 ms | 9.94 ms | 1.82 ms | 0 | 0 | 0 | 0 |
|