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 | 916.50 us | 916.50 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 758 | 174.97 ms | 1.86 ms | 70.26 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 758 | 83.92 ms | 385.12 us | 28.83 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 757 | 5.20 ms | 39.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 35364 | 15.38 s | 981.75 ms | 4.74 s | 79354 | 1267378 | 0 | 6088 | |
root | show_keys | 870 | 1.35 s | 97.93 ms | 329.36 ms | 974 | 15207 | 0 | 0 | |
root | alter_table | 5 | 987.90 ms | 349.40 ms | 5.48 ms | 0 | 0 | 0 | 0 | |
root | show_fields | 956 | 948.55 ms | 5.72 ms | 377.39 ms | 37378 | 190500 | 0 | 0 | |
root | show_variables | 962 | 930.21 ms | 5.09 ms | 92.67 ms | 961 | 551957 | 0 | 962 | |
root | create_table | 3 | 610.13 ms | 217.35 ms | 4.03 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 352 | 275.43 ms | 3.65 ms | 148.64 ms | 6721 | 20267 | 0 | 0 | |
root | set_option | 2678 | 223.52 ms | 10.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 184.77 ms | 72.34 ms | 2.71 ms | 0 | 0 | 3 | 0 | |
root | show_create_table | 469 | 93.99 ms | 2.00 ms | 384.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 513 | 40.95 ms | 393.85 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 682 | 35.63 ms | 505.49 us | 1.03 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 431 | 15.30 ms | 269.32 us | 0 ps | 0 | 0 | 0 | 0 | |
root | flush | 1 | 14.64 ms | 14.64 ms | 1.11 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 21 | 8.64 ms | 1.60 ms | 5.75 ms | 0 | 20 | 0 | 0 | |
root | Quit | 1021 | 7.36 ms | 516.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 126 | 5.29 ms | 4.58 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 7 | 4.77 ms | 4.25 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 27 | 4.30 ms | 2.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 14 | 2.35 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | change_db | 3 | 2.14 ms | 1.94 ms | 0 ps | 0 | 0 | 0 | 0 |
|