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 | 2604161000 | 2604161000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1378 | 323226653000 | 1325919000 | 131393000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1378 | 189624590000 | 28644664000 | 83300000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1377 | 10603843000 | 50450000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 44795 | 17388401573000 | 815548989000 | 6023261000000 | 147966 | 915679 | 0 | 9692 | |
root | show_keys | 842 | 1391727563000 | 94838578000 | 297616000000 | 1068 | 13068 | 0 | 0 | |
root | create_table | 4 | 1057105302000 | 350272483000 | 3324000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 1057 | 973229303000 | 6889023000 | 95643000000 | 1054 | 605878 | 0 | 1057 | |
root | show_fields | 924 | 850104463000 | 3797688000 | 344575000000 | 34311 | 174949 | 0 | 0 | |
root | set_option | 4359 | 769416772000 | 435484389000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 800 | 569014702000 | 4648127000 | 354020000000 | 4616 | 15093 | 0 | 0 | |
root | create_db | 12 | 321706953000 | 64943844000 | 626000000 | 0 | 0 | 7 | 0 | |
root | show_table_status | 115 | 83400981000 | 3225308000 | 56549000000 | 1 | 139 | 0 | 0 | |
root | Init DB | 1160 | 80152143000 | 2264915000 | 6216000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 921 | 77533363000 | 309401000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 447 | 75753787000 | 758503000 | 363000000 | 0 | 0 | 0 | 0 | |
root | grant | 2 | 66731461000 | 38713522000 | 1377000000 | 0 | 0 | 0 | 0 | |
root | insert | 2 | 66172276000 | 34777785000 | 929000000 | 0 | 0 | 2 | 0 | |
root | alter_user | 2 | 45045356000 | 30257987000 | 843000000 | 0 | 0 | 0 | 0 | |
root | revoke_all | 1 | 44350590000 | 44350590000 | 289000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 47409 | 32131413000 | 379943000 | 0 | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 31234735000 | 31234735000 | 1301000000 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 82 | 17349306000 | 11148674000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 13856 | 16975081000 | 1057317000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 405 | 12065871000 | 158643000 | 0 | 0 | 0 | 0 | 0 |
|