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 | 1300475000 | 1300475000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1413 | 334096138000 | 797959000 | 135299000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1413 | 167454203000 | 333848000 | 56409000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1411 | 9533133000 | 47346000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 29144 | 15367242270000 | 476471925000 | 3884761000000 | 132290 | 1485256 | 0 | 10262 | |
root | show_keys | 1354 | 2228006466000 | 95679758000 | 505510000000 | 1488 | 17748 | 0 | 0 | |
root | create_table | 12 | 1288444849000 | 368159025000 | 4852000000 | 0 | 0 | 0 | 0 | |
root | show_fields | 1430 | 1272410991000 | 3907064000 | 567019000000 | 39273 | 201762 | 0 | 0 | |
root | show_variables | 1257 | 1098036782000 | 14187771000 | 113615000000 | 2923 | 719523 | 0 | 1257 | |
root | show_tables | 486 | 333568147000 | 2861909000 | 186683000000 | 8381 | 48311 | 0 | 0 | |
root | set_option | 3626 | 309122251000 | 8888161000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 95 | 302510195000 | 128880502000 | 46035000000 | 1256 | 8340 | 0 | 0 | |
root | create_db | 6 | 254689622000 | 64019231000 | 2254000000 | 0 | 0 | 5 | 0 | |
root | show_create_table | 676 | 167206210000 | 18202887000 | 670000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1130 | 90857879000 | 507696000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1243 | 75938874000 | 391459000 | 4419000000 | 0 | 0 | 0 | 0 | |
root | freturn | 14831 | 28241891000 | 782928000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 481 | 14232854000 | 180815000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1443 | 11221281000 | 265884000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 9182539000 | 9182539000 | 230000000 | 450 | 450 | 0 | 1 | |
root | show_storage_engines | 83 | 8302084000 | 351634000 | 3844000000 | 747 | 747 | 0 | 83 | |
root | Execute | 33 | 6657693000 | 400434000 | 2115000000 | 18 | 48 | 0 | 15 | |
root | Prepare | 33 | 5319432000 | 482964000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 59 | 3835474000 | 301279000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 23 | 1845212000 | 220755000 | 0 | 0 | 0 | 0 | 0 |
|