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 | 1183240000 | 1183240000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 5341 | 1154969621000 | 1351694000 | 477607000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 5341 | 551258841000 | 1474695000 | 196088000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 5350 | 42308688000 | 845175000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 55606 | 23717605164000 | 644694023000 | 7637885000000 | 481589 | 2170979 | 0 | 30426 | |
root | alter_table | 18 | 8617702449000 | 612641925000 | 2651000000 | 0 | 0 | 80 | 0 | |
root | drop_db | 53 | 8316095725000 | 1352101075000 | 39671000000 | 0 | 0 | 96 | 0 | |
root | create_table | 41 | 6949241216000 | 323765054000 | 12116000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 2979 | 2868701471000 | 4091135000 | 271324000000 | 38803 | 1707132 | 0 | 2979 | |
root | create_db | 40 | 1640877376000 | 65551589000 | 4699000000 | 0 | 0 | 35 | 0 | |
root | show_keys | 827 | 1608342257000 | 65840126000 | 302318000000 | 1289 | 17523 | 0 | 0 | |
root | show_tables | 3873 | 1475766029000 | 4941383000 | 858743000000 | 5927 | 23848 | 0 | 0 | |
root | set_option | 18440 | 1236425107000 | 6046022000 | 0 | 0 | 0 | 0 | 0 | |
root | show_fields | 1235 | 1161261358000 | 4017045000 | 460624000000 | 47984 | 244519 | 0 | 0 | |
root | insert | 22 | 908672533000 | 161080199000 | 9819000000 | 0 | 0 | 149 | 0 | |
root | Init DB | 3847 | 327785533000 | 551474000 | 54733000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 2517 | 235903767000 | 1497623000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 311 | 162207543000 | 4264150000 | 107985000000 | 14 | 485 | 0 | 0 | |
root | show_binlogs | 953 | 129927359000 | 36172390000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 610 | 124653029000 | 4420118000 | 5845000000 | 0 | 0 | 0 | 0 | |
root | flush | 4 | 105538479000 | 54858584000 | 2009000000 | 0 | 0 | 0 | 0 | |
root | Quit | 7515 | 55985920000 | 329829000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 277 | 55612043000 | 21580924000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 31 | 35093193000 | 3873611000 | 3610000000 | 13950 | 13950 | 0 | 31 | |
root | show_warnings | 650 | 25087515000 | 1974413000 | 0 | 0 | 0 | 0 | 0 |
|