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 | 58393000 | 58393000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 612 | 113899619000 | 3718778000 | 42235000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 612 | 46079521000 | 349592000 | 16300000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 610 | 3783078000 | 32284000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 20463 | 9715762203000 | 269142551000 | 3044306000000 | 63028 | 558375 | 0 | 6796 | |
root | create_table | 13 | 2660547725000 | 451841214000 | 3463000000 | 0 | 0 | 0 | 0 | |
root | insert | 75 | 2128403023000 | 65040976000 | 7461000000 | 0 | 0 | 75 | 0 | |
root | show_fields | 1002 | 1023286714000 | 6764639000 | 408983000000 | 39377 | 200369 | 0 | 0 | |
root | show_variables | 977 | 924445691000 | 8465090000 | 94442000000 | 977 | 560756 | 0 | 977 | |
root | show_keys | 1067 | 784890857000 | 78256366000 | 410033000000 | 989 | 12938 | 0 | 0 | |
root | create_db | 3 | 228423003000 | 89248930000 | 739000000 | 0 | 0 | 3 | 0 | |
root | show_tables | 319 | 192651444000 | 4259031000 | 100149000000 | 6662 | 17863 | 0 | 0 | |
root | set_option | 2166 | 127872557000 | 9757369000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 508 | 118891596000 | 5976419000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 673 | 34533533000 | 1863315000 | 2440000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 436 | 33556963000 | 397381000 | 0 | 0 | 0 | 0 | 0 | |
root | set | 300 | 17483212000 | 1304303000 | 0 | 0 | 50 | 0 | 0 | |
root | show_warnings | 466 | 14044892000 | 80636000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 10454269000 | 3550637000 | 3830000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 36 | 8579585000 | 1064116000 | 5562000000 | 0 | 14 | 0 | 0 | |
root | show_binlogs | 14 | 7883847000 | 3019055000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 3264 | 6803328000 | 806660000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 17 | 5775023000 | 5019644000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 842 | 5535548000 | 180152000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 4034668000 | 589558000 | 957000000 | 0 | 0 | 0 | 0 |
|