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 | 2.05 ms | 2.05 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1381 | 237.26 ms | 749.18 us | 95.86 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1381 | 108.22 ms | 560.05 us | 38.13 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1380 | 8.32 ms | 43.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 62715 | 31.34 s | 1.02 s | 8.73 s | 170736 | 1156530 | 0 | 15876 | |
root | show_keys | 2466 | 2.70 s | 109.61 ms | 943.41 ms | 2622 | 42045 | 0 | 0 | |
root | show_fields | 2662 | 2.70 s | 5.55 ms | 1.06 s | 105417 | 537028 | 0 | 0 | |
root | show_variables | 2379 | 2.10 s | 7.28 ms | 207.17 ms | 2379 | 1365399 | 0 | 2379 | |
root | show_tables | 1166 | 710.23 ms | 4.81 ms | 358.92 ms | 27026 | 81580 | 0 | 0 | |
root | set_option | 5605 | 332.11 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1326 | 271.14 ms | 3.98 ms | 537.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 195.69 ms | 195.69 ms | 4.71 ms | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 142.01 ms | 63.56 ms | 200.00 us | 0 | 0 | 3 | 0 | |
root | Init DB | 1756 | 87.29 ms | 533.68 us | 5.62 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 993 | 79.51 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1143 | 35.14 ms | 681.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2397 | 14.63 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 17 | 12.21 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 60 | 11.51 ms | 1.49 ms | 6.30 ms | 33 | 236 | 0 | 0 | |
root | show_create_proc | 27 | 7.28 ms | 1.41 ms | 1.70 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 53 | 5.71 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 34 | 5.46 ms | 699.85 us | 2.00 ms | 28 | 42 | 0 | 7 | |
root | Prepare | 34 | 4.58 ms | 923.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 24 | 4.48 ms | 2.13 ms | 3.25 ms | 216 | 216 | 0 | 24 | |
root | show_slave_status | 17 | 4.05 ms | 2.46 ms | 0 ps | 0 | 0 | 0 | 0 |
|