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 | 66413000 | 66413000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 616 | 164581999000 | 5803715000 | 65067000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 616 | 76456467000 | 390235000 | 25985000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 616 | 4978436000 | 31391000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 10265 | 9824097517000 | 519481664000 | 1421355000000 | 52502 | 563967 | 0 | 4538 | |
root | show_keys | 1206 | 1523811983000 | 108594568000 | 405271000000 | 398 | 9087 | 0 | 0 | |
root | show_fields | 932 | 781120564000 | 21130254000 | 375447000000 | 16751 | 87318 | 0 | 0 | |
root | show_tables | 472 | 327261275000 | 5289127000 | 163884000000 | 10331 | 42187 | 0 | 0 | |
root | show_variables | 353 | 316332593000 | 4291612000 | 33428000000 | 353 | 202517 | 0 | 353 | |
root | set_option | 1806 | 174667657000 | 5974010000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 501 | 51340183000 | 2006496000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 64640 | 49402117000 | 3826801000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 178 | 48000697000 | 3952422000 | 278000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 592 | 47345218000 | 533518000 | 5288000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 13 | 45171510000 | 29826893000 | 5757000000 | 344 | 1258 | 0 | 0 | |
root | freturn | 22467 | 29750041000 | 3524195000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 176 | 21106214000 | 2250583000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 743 | 6264190000 | 255275000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 132 | 4731129000 | 154042000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 15 | 3122342000 | 2153591000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 6 | 2457173000 | 2023208000 | 2179000000 | 54 | 54 | 0 | 6 | |
root | show_slave_status | 15 | 2339261000 | 630870000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 22 | 1465454000 | 315032000 | 0 | 0 | 0 | 0 | 0 | |
root | stmt | 3 | 753004000 | 543991000 | 0 | 0 | 3 | 0 | 0 | |
root | set | 6 | 665049000 | 512338000 | 0 | 0 | 3 | 0 | 0 |
|