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.13 ms | 1.13 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5050 | 1.03 s | 2.04 ms | 419.31 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5050 | 489.57 ms | 1.55 ms | 169.74 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5050 | 34.66 ms | 62.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 130830 | 54.70 s | 727.80 ms | 18.80 s | 420607 | 3142076 | 0 | 30872 | |
root | alter_table | 31 | 14.19 s | 653.67 ms | 48.75 ms | 0 | 0 | 120 | 0 | |
root | create_table | 73 | 8.49 s | 480.24 ms | 24.89 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 4134 | 3.95 s | 9.88 ms | 366.93 ms | 5237 | 2371866 | 0 | 4134 | |
root | show_keys | 3407 | 3.73 s | 92.20 ms | 1.32 s | 3376 | 39086 | 0 | 0 | |
root | show_fields | 3419 | 3.30 s | 7.10 ms | 1.34 s | 129455 | 659092 | 0 | 0 | |
root | insert | 34 | 1.04 s | 50.24 ms | 9.02 ms | 0 | 0 | 396 | 0 | |
root | set_option | 15471 | 966.10 ms | 5.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 27 | 956.82 ms | 90.73 ms | 5.52 ms | 0 | 0 | 19 | 0 | |
root | show_tables | 1392 | 891.01 ms | 7.93 ms | 553.93 ms | 9260 | 29399 | 0 | 0 | |
root | show_create_table | 1682 | 371.28 ms | 5.22 ms | 2.65 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 3266 | 199.74 ms | 681.74 us | 19.95 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2132 | 177.10 ms | 1.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 202 | 139.49 ms | 45.59 ms | 63.77 ms | 18 | 318 | 0 | 0 | |
root | show_warnings | 1615 | 54.22 ms | 1.13 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 45177 | 48.06 ms | 1.63 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 25768 | 47.02 ms | 3.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5361 | 38.72 ms | 311.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 648 | 28.09 ms | 972.10 us | 0 ps | 0 | 124 | 0 | 0 | |
root | show_binlogs | 107 | 16.90 ms | 5.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 151 | 15.44 ms | 2.03 ms | 0 ps | 0 | 0 | 0 | 0 |
|