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 | 90.56 us | 90.56 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5256 | 1.05 s | 1.38 ms | 425.28 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5256 | 494.67 ms | 659.35 us | 172.09 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5255 | 35.60 ms | 183.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 207332 | 1.34 m | 879.31 ms | 29.13 s | 432755 | 3002773 | 0 | 44284 | |
root | drop_db | 39 | 7.52 s | 1.16 s | 20.25 ms | 0 | 0 | 87 | 0 | |
root | create_table | 39 | 6.64 s | 387.83 ms | 17.24 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 6471 | 5.76 s | 5.70 ms | 561.85 ms | 8679 | 3713367 | 0 | 6471 | |
root | show_fields | 5658 | 5.53 s | 7.91 ms | 2.22 s | 217931 | 1108401 | 0 | 0 | |
root | show_keys | 6566 | 5.23 s | 80.68 ms | 2.42 s | 4908 | 58266 | 0 | 0 | |
root | create_db | 29 | 1.27 s | 73.70 ms | 6.24 ms | 0 | 0 | 26 | 0 | |
root | insert | 36 | 1.16 s | 149.34 ms | 8.93 ms | 0 | 0 | 162 | 0 | |
root | show_tables | 1953 | 1.12 s | 14.01 ms | 636.55 ms | 23815 | 66364 | 0 | 0 | |
root | set_option | 16887 | 1.01 s | 6.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2894 | 634.24 ms | 1.89 ms | 1.86 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 4544 | 261.22 ms | 470.34 us | 27.26 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2539 | 204.59 ms | 349.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 280 | 157.18 ms | 39.96 ms | 73.72 ms | 73 | 705 | 0 | 0 | |
root | show_warnings | 2818 | 89.47 ms | 915.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 70552 | 58.61 ms | 1.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6092 | 40.80 ms | 252.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 128 | 33.74 ms | 16.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 4 | 32.98 ms | 16.39 ms | 583.00 us | 1800 | 1800 | 0 | 4 | |
root | freturn | 24028 | 25.06 ms | 1.71 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 512 | 24.85 ms | 2.09 ms | 0 ps | 0 | 106 | 0 | 0 |
|