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 | 1686459000 | 1686459000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 4011 | 875390975000 | 19578302000 | 353693000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 4011 | 405808290000 | 1322371000 | 141539000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 4012 | 27444960000 | 53604000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 113342 | 51616345743000 | 973484393000 | 15453643000000 | 336232 | 2841882 | 0 | 36013 | |
root | alter_table | 138 | 37472684555000 | 1405441863000 | 65145000000 | 0 | 0 | 174 | 0 | |
root | create_table | 99 | 11951144166000 | 462903760000 | 315300000000 | 0 | 0 | 0 | 0 | |
root | drop_db | 33 | 6655972778000 | 952582729000 | 25220000000 | 0 | 0 | 86 | 0 | |
root | show_fields | 5457 | 5219905091000 | 12791349000 | 2097889000000 | 209196 | 1067303 | 0 | 0 | |
root | show_variables | 5800 | 5007594968000 | 8692604000 | 517234000000 | 7444 | 3327814 | 0 | 5800 | |
root | show_keys | 5084 | 4857997474000 | 120330298000 | 1871323000000 | 5271 | 96237 | 0 | 0 | |
root | show_tables | 2700 | 2778905995000 | 866374678000 | 1898428000000 | 51092 | 152269 | 0 | 0 | |
root | insert | 44 | 1477764578000 | 113308643000 | 24253000000 | 0 | 0 | 505 | 0 | |
root | set_option | 14574 | 1008899798000 | 15928555000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 2744 | 807706194000 | 139866578000 | 3804000000 | 0 | 0 | 0 | 0 | |
root | create_db | 16 | 614335375000 | 66310888000 | 3541000000 | 0 | 0 | 16 | 0 | |
root | Init DB | 4206 | 478403029000 | 244174996000 | 263980000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 2381 | 191578251000 | 970728000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 289588 | 184847009000 | 891696000 | 0 | 0 | 0 | 0 | 0 | |
root | create_trigger | 2 | 118677617000 | 66773969000 | 2331000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 475 | 108739581000 | 2356269000 | 66428000000 | 66 | 718 | 0 | 0 | |
root | show_warnings | 2541 | 82876865000 | 781522000 | 0 | 0 | 0 | 0 | 0 | |
root | drop_table | 5 | 74608971000 | 72243038000 | 985000000 | 0 | 0 | 0 | 0 | |
root | freturn | 66966 | 68013785000 | 1999919000 | 0 | 0 | 0 | 0 | 0 | |
root | delete | 2 | 45365814000 | 25887875000 | 2378000000 | 0 | 6 | 2 | 0 |
|