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 | 2965953000 | 2965953000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 198 | 34732043000 | 929397000 | 13958000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 198 | 14973186000 | 279248000 | 5271000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 195 | 1117684000 | 33540000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 5780 | 3373752222000 | 240549276000 | 821401000000 | 34169 | 157922 | 0 | 2368 | |
root | show_keys | 299 | 605246938000 | 100665675000 | 116702000000 | 318 | 6728 | 0 | 0 | |
root | show_fields | 403 | 372242794000 | 6136074000 | 144230000000 | 13419 | 68422 | 0 | 0 | |
root | show_variables | 306 | 331492913000 | 24037174000 | 31019000000 | 306 | 175644 | 0 | 306 | |
root | show_tables | 152 | 88290589000 | 3534662000 | 45290000000 | 3371 | 10748 | 0 | 0 | |
root | show_create_table | 202 | 63931798000 | 25807533000 | 1678000000 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 54458570000 | 54458570000 | 1109000000 | 0 | 0 | 1 | 0 | |
root | set_option | 777 | 52617562000 | 4153443000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 195 | 16436587000 | 546230000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 219 | 10847404000 | 179811000 | 701000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 54 | 6015365000 | 160474000 | 3217000000 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 40 | 5089006000 | 393516000 | 2623000000 | 360 | 360 | 0 | 40 | |
root | show_warnings | 148 | 4767911000 | 226178000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 1 | 1968859000 | 1968859000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 326 | 1942710000 | 214347000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 10 | 1744419000 | 771386000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 100 | 1149064000 | 946932000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 9 | 1012264000 | 518489000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 510 | 993854000 | 253621000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 9 | 338996000 | 94458000 | 0 | 0 | 0 | 0 | 0 |
|