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 | 2743948000 | 2743948000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 585 | 129796422000 | 737643000 | 54192000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 585 | 82680058000 | 20916679000 | 42133000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 583 | 4405277000 | 35242000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 13341 | 6634060039000 | 471860951000 | 1688675000000 | 57633 | 374257 | 0 | 6495 | |
root | show_keys | 707 | 1225702269000 | 128683268000 | 270986000000 | 707 | 9958 | 0 | 0 | |
root | show_fields | 650 | 628927499000 | 3974336000 | 257188000000 | 23263 | 118705 | 0 | 0 | |
root | show_variables | 644 | 602970218000 | 5515581000 | 60442000000 | 644 | 369530 | 0 | 644 | |
root | set_option | 1894 | 172624078000 | 7169207000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 340 | 139839159000 | 3647828000 | 73391000000 | 3535 | 12750 | 0 | 0 | |
root | create_db | 3 | 99924483000 | 53510521000 | 2391000000 | 0 | 0 | 2 | 0 | |
root | show_create_table | 319 | 70815318000 | 4393931000 | 587000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 555 | 69996594000 | 22972678000 | 0 | 0 | 0 | 0 | 0 | |
root | grant | 1 | 51727991000 | 51727991000 | 492000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 616 | 45694489000 | 575519000 | 8955000000 | 0 | 0 | 0 | 0 | |
root | revoke_all | 1 | 45478653000 | 45478653000 | 3675000000 | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 26815831000 | 26815831000 | 1552000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 291 | 9327437000 | 138604000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 28 | 7186732000 | 2177285000 | 4520000000 | 0 | 4 | 0 | 0 | |
root | show_binlogs | 48 | 5914595000 | 3079278000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 711 | 5451372000 | 238625000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 3 | 2512575000 | 2133709000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 4 | 1748592000 | 1326048000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 130 | 1403925000 | 1122057000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 900 | 1176677000 | 16828000 | 0 | 0 | 0 | 0 | 0 |
|