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 | 1275 | 288155618000 | 692764000 | 116394000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1275 | 142074094000 | 415660000 | 49031000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1274 | 8123510000 | 63084000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 28714 | 14942214582000 | 747304409000 | 3738562000000 | 116255 | 707911 | 0 | 11222 | |
root | show_keys | 1595 | 3176917597000 | 174000443000 | 589934000000 | 1825 | 22300 | 0 | 0 | |
root | show_variables | 1563 | 1749838637000 | 391104465000 | 138782000000 | 5042 | 895167 | 0 | 1563 | |
root | show_fields | 1662 | 1547575185000 | 5999050000 | 658246000000 | 55286 | 282634 | 0 | 0 | |
root | set_option | 3446 | 732590975000 | 455703582000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 24 | 568575428000 | 426271590000 | 23356000000 | 386 | 2331 | 0 | 0 | |
root | show_tables | 362 | 270874322000 | 8876725000 | 137800000000 | 7797 | 30056 | 0 | 0 | |
root | show_create_table | 832 | 165631489000 | 6268456000 | 275000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1122 | 88851263000 | 378468000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1248 | 70076757000 | 1966781000 | 2730000000 | 0 | 0 | 0 | 0 | |
root | set | 914 | 37707320000 | 2405759000 | 0 | 0 | 157 | 0 | 0 | |
root | show_warnings | 666 | 19532760000 | 106182000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 21478 | 17505988000 | 861671000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1388 | 9485778000 | 403489000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 3632 | 9197158000 | 3901918000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 57 | 8791343000 | 511569000 | 4237000000 | 513 | 513 | 0 | 57 | |
root | Execute | 34 | 5451277000 | 413051000 | 1708000000 | 0 | 68 | 0 | 34 | |
root | Prepare | 34 | 5418399000 | 672931000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 56 | 5067101000 | 1822873000 | 0 | 0 | 0 | 0 | 0 | |
root | stmt | 7 | 3014392000 | 2522285000 | 0 | 0 | 7 | 0 | 0 | |
root | show_status | 1 | 3000232000 | 3000232000 | 332000000 | 19 | 455 | 0 | 1 |
|