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 | 3182001000 | 3182001000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 3565 | 753855190000 | 795096000 | 304917000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 3565 | 356315680000 | 667981000 | 122690000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 3604 | 24773811000 | 43785000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 89459 | 32437134772000 | 706647406000 | 6019451000000 | 163529 | 1512063 | 0 | 17341 | |
root | alter_table | 32 | 9333927094000 | 745826138000 | 25932000000 | 0 | 0 | 1907 | 0 | |
root | create_table | 33 | 4136946017000 | 281169329000 | 13548000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 3846 | 3708706572000 | 1218477282000 | 1736854000000 | 1348 | 25321 | 0 | 0 | |
root | show_variables | 4293 | 3641332573000 | 5279970000 | 378844000000 | 5947 | 2463468 | 0 | 4293 | |
root | show_fields | 4720 | 2566683012000 | 4460779000 | 571329000000 | 52973 | 270400 | 0 | 0 | |
root | show_tables | 2202 | 1050098234000 | 5548043000 | 356792000000 | 15511 | 43586 | 0 | 0 | |
root | show_table_status | 3697 | 963652559000 | 2150781000 | 38465000000 | 4 | 135 | 0 | 0 | |
root | show_create_table | 2334 | 960705479000 | 131159647000 | 8682000000 | 0 | 0 | 0 | 0 | |
root | set_option | 13231 | 900356210000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 27 | 817053161000 | 100576525000 | 41277000000 | 0 | 0 | 1291 | 0 | |
root | create_db | 10 | 483571739000 | 80089968000 | 2925000000 | 0 | 0 | 10 | 0 | |
root | jump_if_not | 509980 | 296745248000 | 839952000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 2260 | 192002566000 | 830281000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 3574 | 190554442000 | 501516000 | 13312000000 | 0 | 0 | 0 | 0 | |
root | freturn | 126727 | 125023348000 | 632065000 | 0 | 0 | 0 | 0 | 0 | |
root | drop_user | 3 | 93631725000 | 32145947000 | 4048000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1877 | 57228791000 | 174144000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 5311 | 36669661000 | 730018000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 3 | 32259529000 | 19763839000 | 681000000 | 1350 | 1350 | 0 | 3 | |
root | show_binlogs | 181 | 19965142000 | 3018340000 | 0 | 0 | 0 | 0 | 0 |
|
Warning in ./src/Table/Table.php#291
Undefined array key "Create_time"Backtrace
Warning in ./src/Table/Table.php#291
Undefined array key "TABLE_COMMENT"Backtrace