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 | 3374 | 715624252000 | 795096000 | 289203000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 3374 | 338598944000 | 667981000 | 116505000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 3413 | 23455926000 | 43785000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 84524 | 31399761641000 | 706647406000 | 5921802000000 | 160026 | 1455943 | 0 | 16689 | |
root | alter_table | 32 | 9333927094000 | 745826138000 | 25932000000 | 0 | 0 | 1907 | 0 | |
root | create_table | 30 | 4134376765000 | 281169329000 | 12227000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 3612 | 3656854982000 | 1218477282000 | 1736854000000 | 1348 | 25321 | 0 | 0 | |
root | show_variables | 4012 | 3412823263000 | 5279970000 | 354273000000 | 5666 | 2302174 | 0 | 4012 | |
root | show_fields | 4376 | 2432183924000 | 4460779000 | 570766000000 | 52973 | 270400 | 0 | 0 | |
root | show_tables | 2070 | 1001797379000 | 5548043000 | 350731000000 | 15511 | 43586 | 0 | 0 | |
root | show_table_status | 3370 | 873568065000 | 2150781000 | 38465000000 | 4 | 135 | 0 | 0 | |
root | set_option | 12469 | 855531399000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 2161 | 846110599000 | 131159647000 | 8682000000 | 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 | 480988 | 281319219000 | 839952000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 3370 | 181153005000 | 501516000 | 13121000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 2117 | 181010199000 | 830281000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 119597 | 117968358000 | 632065000 | 0 | 0 | 0 | 0 | 0 | |
root | drop_user | 3 | 93631725000 | 32145947000 | 4048000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1757 | 53718185000 | 174144000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 4994 | 34990092000 | 730018000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 3 | 32259529000 | 19763839000 | 681000000 | 1350 | 1350 | 0 | 3 | |
root | show_binlogs | 178 | 19795765000 | 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