SELECT * FROM `x$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 | 1364040000 | 1364040000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 112 | 29784969000 | 790319000 | 12228000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 112 | 14367414000 | 314776000 | 4783000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 111 | 772207000 | 37682000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 2954 | 2126446249000 | 316188839000 | 389433000000 | 17443 | 86596 | 0 | 1148 | |
root | show_keys | 189 | 714341794000 | 124674312000 | 71721000000 | 182 | 2848 | 0 | 0 | |
root | show_fields | 167 | 143439837000 | 3243502000 | 65085000000 | 4130 | 21344 | 0 | 0 | |
root | show_variables | 140 | 129648319000 | 4501120000 | 13064000000 | 140 | 80297 | 0 | 140 | |
root | show_tables | 101 | 66139195000 | 2749929000 | 34399000000 | 1797 | 6318 | 0 | 0 | |
root | set_option | 454 | 53341535000 | 5351868000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 46800792000 | 46800792000 | 45000000 | 0 | 0 | 1 | 0 | |
root | show_create_table | 82 | 16520290000 | 1830005000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 143 | 10168467000 | 439678000 | 1515000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 98 | 7467094000 | 261734000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 16 | 2751055000 | 1987632000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 2723070000 | 2423069000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 2058313000 | 1569478000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 59 | 1987488000 | 206033000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 191 | 1128883000 | 39527000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 6 | 997138000 | 345538000 | 493000000 | 54 | 54 | 0 | 6 | |
root | show_table_status | 2 | 782128000 | 671232000 | 592000000 | 0 | 2 | 0 | 0 | |
root | freturn | 51 | 589344000 | 527259000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 386 | 437124000 | 231642000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 3 | 309432000 | 248906000 | 0 | 0 | 0 | 0 | 0 |
|