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 | 2835069000 | 2835069000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 707 | 160999400000 | 928105000 | 65622000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 697 | 77148620000 | 352549000 | 26534000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 703 | 5045843000 | 50101000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 20801 | 8961811818000 | 347315153000 | 2540307000000 | 99099 | 616485 | 0 | 5658 | |
root | show_keys | 796 | 1762524074000 | 96530647000 | 278989000000 | 783 | 12393 | 0 | 0 | |
root | create_table | 3 | 676648274000 | 264106201000 | 8257000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 723 | 605107380000 | 3836508000 | 62412000000 | 723 | 414981 | 0 | 723 | |
root | show_fields | 673 | 561101701000 | 3694837000 | 243579000000 | 18779 | 96606 | 0 | 0 | |
root | show_table_status | 20 | 391918432000 | 368009641000 | 12851000000 | 132 | 1080 | 0 | 0 | |
root | drop_table | 3 | 390518518000 | 144081282000 | 2356000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 533 | 376971349000 | 4469150000 | 193640000000 | 9551 | 35783 | 0 | 0 | |
root | set_option | 2564 | 234846521000 | 9556827000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 146337287000 | 53480435000 | 2347000000 | 0 | 0 | 3 | 0 | |
root | drop_db | 2 | 113636332000 | 65405370000 | 595000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 339 | 66049359000 | 2107104000 | 104000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 709 | 46920348000 | 463127000 | 5568000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 456 | 36813266000 | 342924000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 48486 | 29548530000 | 93607000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 13281 | 13960064000 | 641520000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 266 | 9143246000 | 185250000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1004 | 7850283000 | 193103000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 108 | 5884505000 | 170025000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 4 | 2210376000 | 2125499000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 25 | 1905872000 | 190253000 | 0 | 0 | 0 | 0 | 0 |
|