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 | 65776000 | 65776000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 3083 | 604330438000 | 3510803000 | 249966000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 3083 | 285048049000 | 456902000 | 100167000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 3082 | 19899420000 | 627555000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 89191 | 32558335214000 | 661700833000 | 10140218000000 | 270207 | 1767332 | 0 | 45370 | |
root | show_fields | 6028 | 6063756351000 | 7105612000 | 2226401000000 | 301988 | 1529288 | 0 | 0 | |
root | show_variables | 6272 | 5282263260000 | 10756831000 | 549641000000 | 6272 | 3600086 | 0 | 6272 | |
root | show_keys | 5673 | 3869465380000 | 49679425000 | 1969673000000 | 6090 | 60784 | 0 | 0 | |
root | show_create_table | 3130 | 634585987000 | 8802293000 | 74000000 | 0 | 0 | 0 | 0 | |
root | insert | 20 | 626115999000 | 50107403000 | 2381000000 | 0 | 0 | 20 | 0 | |
root | set_option | 10031 | 591204167000 | 5887036000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 639 | 427570999000 | 12982668000 | 212719000000 | 13725 | 41250 | 0 | 0 | |
root | create_table | 2 | 387420641000 | 202205657000 | 1951000000 | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 161759088000 | 70922155000 | 6939000000 | 0 | 0 | 3 | 0 | |
root | Init DB | 3388 | 144802121000 | 305115000 | 2042000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1345 | 98377212000 | 368819000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 3085 | 89323576000 | 227854000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 3628 | 25108336000 | 587012000 | 0 | 0 | 0 | 0 | 0 | |
root | drop_db | 1 | 19555680000 | 19555680000 | 65000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 11 | 10087767000 | 3406939000 | 7467000000 | 0 | 18 | 0 | 0 | |
root | set | 150 | 7073637000 | 529802000 | 0 | 0 | 25 | 0 | 0 | |
root | show_binlogs | 67 | 6210352000 | 1899489000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 6804 | 5922443000 | 430807000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 990 | 2504609000 | 554056000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 18 | 1184968000 | 222562000 | 0 | 0 | 0 | 0 | 0 |
|