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 | 2722280000 | 2722280000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 856 | 193336997000 | 686920000 | 77732000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 856 | 94189571000 | 1028532000 | 32073000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 854 | 5609428000 | 34394000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 15919 | 14761461567000 | 833080642000 | 2357836000000 | 92526 | 964177 | 0 | 8067 | |
root | show_keys | 1215 | 1488587784000 | 104662548000 | 486121000000 | 1133 | 14252 | 0 | 0 | |
root | show_fields | 1294 | 1275786733000 | 8956628000 | 516859000000 | 44306 | 225875 | 0 | 0 | |
root | show_variables | 991 | 893499187000 | 24786921000 | 88120000000 | 990 | 567322 | 0 | 991 | |
root | set_option | 2274 | 188868271000 | 6057592000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 566 | 120699176000 | 5622293000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 188 | 117185969000 | 3927624000 | 69576000000 | 1277 | 5475 | 0 | 0 | |
root | jump_if_not | 137936 | 87442185000 | 2088832000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 788 | 60221922000 | 289666000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 944 | 53561323000 | 396880000 | 2188000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 12 | 49934212000 | 39074275000 | 7694000000 | 18 | 98 | 0 | 0 | |
root | freturn | 36349 | 49741166000 | 3416278000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 424 | 12569975000 | 95651000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 35 | 10848279000 | 4150428000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 72 | 10509137000 | 3733092000 | 4500000000 | 648 | 648 | 0 | 72 | |
root | Quit | 928 | 7479607000 | 219927000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 44 | 6904755000 | 1144233000 | 0 | 0 | 0 | 0 | 0 | |
root | set | 158 | 6418997000 | 704839000 | 0 | 0 | 29 | 0 | 0 | |
root | show_master_status | 44 | 6053696000 | 1344987000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 2 | 4285700000 | 2182721000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 54 | 4264015000 | 1956603000 | 0 | 0 | 0 | 0 | 0 |
|