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 | 793025000 | 793025000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 812 | 180154070000 | 692764000 | 72221000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 812 | 87858698000 | 415660000 | 30246000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 811 | 5011903000 | 22692000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 15623 | 9117287074000 | 747304409000 | 2032302000000 | 71691 | 457633 | 0 | 7607 | |
root | show_keys | 945 | 2675007407000 | 174000443000 | 366031000000 | 1341 | 15147 | 0 | 0 | |
root | show_variables | 959 | 1258581188000 | 391104465000 | 87412000000 | 4451 | 549122 | 0 | 959 | |
root | show_fields | 1068 | 1039541607000 | 5999050000 | 439193000000 | 37405 | 191101 | 0 | 0 | |
root | set_option | 2210 | 641868129000 | 455703582000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 20 | 565967254000 | 426271590000 | 21804000000 | 380 | 2295 | 0 | 0 | |
root | show_tables | 284 | 223102405000 | 8876725000 | 111839000000 | 6185 | 25507 | 0 | 0 | |
root | show_create_table | 538 | 100261172000 | 2667922000 | 275000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 720 | 58793588000 | 378468000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 818 | 44445436000 | 360956000 | 2063000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 411 | 11800277000 | 106182000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 39 | 6586550000 | 511569000 | 3188000000 | 351 | 351 | 0 | 39 | |
root | freturn | 1239 | 6223854000 | 3901918000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 896 | 6124322000 | 403489000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 5251 | 5466039000 | 861671000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 21 | 4105514000 | 672931000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 37 | 4047848000 | 1822873000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 21 | 3810208000 | 413051000 | 1241000000 | 0 | 42 | 0 | 21 | |
root | stmt | 7 | 3014392000 | 2522285000 | 0 | 0 | 7 | 0 | 0 | |
root | show_status | 1 | 3000232000 | 3000232000 | 332000000 | 19 | 455 | 0 | 1 | |
root | set | 14 | 2766613000 | 2405759000 | 0 | 0 | 7 | 0 | 0 |
|