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 | 2337753000 | 2337753000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 275 | 57767293000 | 562155000 | 23219000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 275 | 27464710000 | 305450000 | 9378000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 274 | 2396582000 | 38373000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 5249 | 2679601095000 | 305257359000 | 617976000000 | 25145 | 186970 | 0 | 2186 | |
root | show_keys | 220 | 880231452000 | 83656328000 | 85576000000 | 212 | 3193 | 0 | 0 | |
root | show_fields | 390 | 323126512000 | 4461645000 | 160695000000 | 6350 | 33656 | 0 | 0 | |
root | show_tables | 346 | 194483162000 | 6047906000 | 96831000000 | 7234 | 36927 | 0 | 0 | |
root | show_variables | 154 | 146748617000 | 4819736000 | 13903000000 | 154 | 88312 | 0 | 154 | |
root | set_option | 943 | 71991533000 | 4038440000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 286 | 25172212000 | 269489000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 326 | 19773667000 | 357496000 | 2182000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 80 | 18125150000 | 1952595000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 166 | 12356750000 | 140760000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 17 | 2612685000 | 588705000 | 1582000000 | 0 | 67 | 0 | 0 | |
root | error | 16 | 2417860000 | 1900363000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 354 | 2191628000 | 165255000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 56 | 2059274000 | 217857000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 7 | 575878000 | 110621000 | 284000000 | 63 | 63 | 0 | 7 |
|