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 | 110.11 us | 110.11 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4225 | 939.17 ms | 5.71 ms | 380.98 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4225 | 449.33 ms | 470.50 us | 156.09 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4231 | 32.83 ms | 174.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 93740 | 46.83 s | 688.27 ms | 15.16 s | 420690 | 3038000 | 0 | 28703 | |
root | alter_table | 44 | 18.17 s | 633.22 ms | 11.32 ms | 0 | 0 | 38 | 0 | |
root | create_table | 54 | 10.14 s | 476.80 ms | 18.77 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 2571 | 4.59 s | 485.11 ms | 968.36 ms | 2545 | 36774 | 0 | 0 | |
root | show_variables | 3209 | 2.92 s | 8.41 ms | 282.11 ms | 4312 | 1839971 | 0 | 3209 | |
root | show_fields | 2712 | 2.61 s | 18.41 ms | 1.06 s | 97252 | 496133 | 0 | 0 | |
root | show_tables | 1793 | 1.71 s | 638.96 ms | 671.54 ms | 8754 | 25559 | 0 | 0 | |
root | create_db | 29 | 1.44 s | 99.69 ms | 9.91 ms | 0 | 0 | 27 | 0 | |
root | set_option | 13147 | 996.73 ms | 87.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 29 | 934.25 ms | 79.44 ms | 4.74 ms | 0 | 0 | 59 | 0 | |
root | show_create_table | 1229 | 261.45 ms | 9.80 ms | 5.01 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 3153 | 227.30 ms | 2.62 ms | 25.73 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 297 | 182.83 ms | 3.57 ms | 123.13 ms | 3 | 332 | 0 | 0 | |
root | show_grants | 1955 | 180.03 ms | 379.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | drop_table | 1 | 126.84 ms | 126.84 ms | 468.00 us | 0 | 0 | 0 | 0 | |
root | grant | 3 | 102.74 ms | 46.69 ms | 1.63 ms | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 73.92 ms | 46.78 ms | 3.75 ms | 0 | 0 | 0 | 0 | |
root | alter_user | 2 | 59.43 ms | 34.75 ms | 770.00 us | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 40.86 ms | 40.86 ms | 3.71 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1227 | 40.32 ms | 252.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4566 | 35.68 ms | 689.79 us | 0 ps | 0 | 0 | 0 | 0 |
|