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 | 1298035000 | 1298035000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 2426 | 572410249000 | 2518379000 | 233684000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2426 | 276791482000 | 491962000 | 94774000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2434 | 20050389000 | 106078000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 36677 | 19146313154000 | 638055259000 | 5244533000000 | 313846 | 1855826 | 0 | 17755 | |
root | create_table | 18 | 2666726635000 | 290366981000 | 5930000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 1679 | 1623365141000 | 8501817000 | 155337000000 | 1677 | 962675 | 0 | 1679 | |
root | show_keys | 725 | 1622767608000 | 120619744000 | 272405000000 | 954 | 12960 | 0 | 0 | |
root | show_tables | 1907 | 1125390561000 | 6243454000 | 660014000000 | 12685 | 36336 | 0 | 0 | |
root | show_fields | 942 | 885564835000 | 2854985000 | 372964000000 | 31760 | 162520 | 0 | 0 | |
root | alter_table | 2 | 809439772000 | 489407185000 | 685000000 | 0 | 0 | 0 | 0 | |
root | set_option | 8080 | 627116544000 | 6181082000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 10 | 438573545000 | 66535180000 | 1944000000 | 0 | 0 | 9 | 0 | |
root | Init DB | 2186 | 187212004000 | 503726000 | 26214000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1636 | 156447768000 | 409045000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 4 | 87678280000 | 33569020000 | 403000000 | 0 | 0 | 4 | 0 | |
root | show_create_table | 487 | 86100879000 | 2553409000 | 527000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 163 | 67357614000 | 2474723000 | 44243000000 | 6 | 197 | 0 | 0 | |
root | show_binlogs | 404 | 27862759000 | 3719206000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 3051 | 23672374000 | 205585000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 145 | 18363797000 | 7336018000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 20203 | 17127093000 | 1107907000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 7445 | 16201702000 | 2615520000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 468 | 15596916000 | 185192000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 145 | 14183057000 | 810625000 | 0 | 0 | 0 | 0 | 0 |
|