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 | 1.18 ms | 1.18 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5946 | 1.28 s | 1.35 ms | 528.72 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5946 | 611.19 ms | 1.47 ms | 217.69 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5966 | 47.38 ms | 845.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 64443 | 27.36 s | 644.69 ms | 8.94 s | 558196 | 2509469 | 0 | 34643 | |
root | alter_table | 18 | 8.62 s | 612.64 ms | 2.65 ms | 0 | 0 | 80 | 0 | |
root | drop_db | 53 | 8.32 s | 1.35 s | 39.67 ms | 0 | 0 | 96 | 0 | |
root | create_table | 42 | 7.08 s | 323.77 ms | 12.28 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 3334 | 3.19 s | 4.09 ms | 301.63 ms | 40262 | 1910545 | 0 | 3334 | |
root | create_db | 43 | 1.79 s | 65.70 ms | 4.94 ms | 0 | 0 | 38 | 0 | |
root | show_keys | 930 | 1.77 s | 65.84 ms | 342.10 ms | 1429 | 19328 | 0 | 0 | |
root | show_tables | 4262 | 1.64 s | 4.94 ms | 956.91 ms | 8009 | 29911 | 0 | 0 | |
root | set_option | 20415 | 1.36 s | 6.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_fields | 1386 | 1.31 s | 4.02 ms | 521.21 ms | 53130 | 270815 | 0 | 0 | |
root | insert | 23 | 934.25 ms | 161.08 ms | 10.00 ms | 0 | 0 | 151 | 0 | |
root | Init DB | 4370 | 371.77 ms | 551.47 us | 62.31 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2876 | 267.09 ms | 1.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 426 | 192.29 ms | 4.26 ms | 126.10 ms | 15 | 589 | 0 | 0 | |
root | show_binlogs | 1121 | 139.38 ms | 36.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 675 | 136.86 ms | 4.42 ms | 6.03 ms | 0 | 0 | 0 | 0 | |
root | flush | 4 | 105.54 ms | 54.86 ms | 2.01 ms | 0 | 0 | 0 | 0 | |
root | Quit | 8306 | 61.45 ms | 329.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 300 | 56.97 ms | 21.58 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 32 | 37.09 ms | 3.87 ms | 3.82 ms | 14400 | 14400 | 0 | 32 | |
root | show_warnings | 714 | 27.08 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 |
|