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 | 879851000 | 879851000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 670 | 148833034000 | 595705000 | 59672000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 668 | 70967395000 | 364000000 | 24362000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 668 | 5039766000 | 55992000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 10269 | 5110892031000 | 480484100000 | 1433242000000 | 55257 | 461039 | 0 | 4446 | |
root | show_keys | 407 | 1305915305000 | 112666356000 | 175959000000 | 464 | 7008 | 0 | 0 | |
root | create_table | 7 | 1142917710000 | 232505258000 | 4577000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 457 | 430764296000 | 7552221000 | 40572000000 | 453 | 261772 | 0 | 457 | |
root | show_fields | 393 | 367371433000 | 3494300000 | 172612000000 | 8321 | 43328 | 0 | 0 | |
root | show_tables | 447 | 329907800000 | 4671884000 | 194753000000 | 3658 | 13720 | 0 | 0 | |
root | create_db | 3 | 298528633000 | 193087036000 | 21265000000 | 0 | 0 | 3 | 0 | |
root | set_option | 2220 | 208338580000 | 15976127000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 4 | 140463023000 | 44937888000 | 2512000000 | 0 | 0 | 26 | 0 | |
root | show_grants | 479 | 41463636000 | 1091510000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 586 | 38031350000 | 336983000 | 3250000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 198 | 37607015000 | 2735223000 | 394000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 49 | 37219231000 | 6097987000 | 20852000000 | 56 | 391 | 0 | 0 | |
root | Quit | 808 | 6055770000 | 208115000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 136 | 5664055000 | 209129000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 30 | 4843179000 | 2528727000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 8 | 3191856000 | 2443411000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 24 | 2705377000 | 771290000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 15 | 1596955000 | 302972000 | 745000000 | 135 | 135 | 0 | 15 | |
root | show_master_status | 24 | 1298146000 | 145967000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 8 | 1129712000 | 408558000 | 245000000 | 0 | 16 | 0 | 8 |
|