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 | 4227895000 | 4227895000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1627 | 384764004000 | 1409938000 | 154937000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1627 | 189929971000 | 631285000 | 63708000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1628 | 11835629000 | 48260000 | 0 | 0 | 0 | 0 | 0 | |
root | alter_table | 143 | 42294112276000 | 669929050000 | 33660000000 | 0 | 0 | 253 | 0 | |
root | create_table | 112 | 23043326721000 | 549223108000 | 42197000000 | 0 | 0 | 0 | 0 | |
root | select | 28256 | 15871956773000 | 2033225480000 | 4342240000000 | 120949 | 851166 | 0 | 11193 | |
root | insert | 153 | 5549491117000 | 76391048000 | 38624000000 | 0 | 0 | 676 | 0 | |
root | show_keys | 880 | 1211741805000 | 69501365000 | 297351000000 | 1056 | 15452 | 0 | 0 | |
root | show_variables | 1170 | 1031182787000 | 4344539000 | 104909000000 | 1170 | 671139 | 0 | 1170 | |
root | show_fields | 1100 | 989290679000 | 8495999000 | 388455000000 | 40771 | 208162 | 0 | 0 | |
root | set_option | 4833 | 403024891000 | 13559471000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 686 | 309758659000 | 10502987000 | 173081000000 | 5103 | 22484 | 0 | 0 | |
root | show_create_table | 583 | 283714825000 | 135985561000 | 5100000000 | 0 | 0 | 0 | 0 | |
root | create_db | 5 | 259324469000 | 76335895000 | 1013000000 | 0 | 0 | 5 | 0 | |
root | Init DB | 1245 | 109387475000 | 851210000 | 20055000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1073 | 94332167000 | 621377000 | 0 | 0 | 0 | 0 | 0 | |
root | create_view | 1 | 68699333000 | 68699333000 | 1429000000 | 0 | 0 | 0 | 0 | |
root | drop_db | 1 | 52873629000 | 52873629000 | 1185000000 | 0 | 0 | 0 | 0 | |
root | update | 1 | 38759114000 | 38759114000 | 844000000 | 0 | 1 | 1 | 0 | |
root | show_master_status | 41 | 28500917000 | 21356469000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 113 | 22183562000 | 2459508000 | 13302000000 | 0 | 20 | 0 | 0 | |
root | set | 450 | 17402025000 | 2280030000 | 0 | 0 | 75 | 0 | 0 | |
root | show_warnings | 475 | 14561373000 | 249586000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1650 | 12762277000 | 329784000 | 0 | 0 | 0 | 0 | 0 |
|