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 | 105.43 us | 105.43 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1476 | 297.58 ms | 1.55 ms | 120.31 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1476 | 139.15 ms | 330.42 us | 47.76 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1473 | 9.48 ms | 228.17 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 64400 | 24.50 s | 479.79 ms | 8.76 s | 140000 | 981253 | 0 | 12011 | |
root | drop_db | 31 | 6.07 s | 1.16 s | 11.00 ms | 0 | 0 | 78 | 0 | |
root | create_table | 11 | 2.14 s | 275.96 ms | 10.13 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 1587 | 1.61 s | 101.52 ms | 556.98 ms | 1036 | 12832 | 0 | 0 | |
root | show_tables | 457 | 1.54 s | 1.04 s | 1.43 s | 6387 | 16347 | 0 | 0 | |
root | show_variables | 1543 | 1.44 s | 8.74 ms | 136.53 ms | 1543 | 885535 | 0 | 1543 | |
root | show_fields | 1287 | 1.19 s | 4.52 ms | 493.06 ms | 47345 | 240960 | 0 | 0 | |
root | create_db | 8 | 380.41 ms | 61.28 ms | 2.85 ms | 0 | 0 | 8 | 0 | |
root | insert | 11 | 322.53 ms | 63.12 ms | 5.23 ms | 0 | 0 | 47 | 0 | |
root | set_option | 4679 | 313.70 ms | 5.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 653 | 152.77 ms | 2.60 ms | 127.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 1101 | 69.70 ms | 751.41 us | 10.86 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 567 | 46.41 ms | 795.16 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 94 | 29.02 ms | 8.08 ms | 14.39 ms | 33 | 256 | 0 | 0 | |
root | jump_if_not | 23988 | 26.07 ms | 1.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 644 | 21.75 ms | 391.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 11563 | 17.04 ms | 2.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1681 | 10.84 ms | 236.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 58 | 10.80 ms | 4.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 16 | 8.38 ms | 3.72 ms | 0 ps | 0 | 16 | 0 | 0 | |
root | set | 32 | 4.76 ms | 3.67 ms | 0 ps | 0 | 16 | 0 | 0 |
|