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 | 1751 | 349828655000 | 774106000 | 141122000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1751 | 163530791000 | 511338000 | 55805000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1783 | 12452690000 | 43785000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 47857 | 23141014657000 | 706647406000 | 5162968000000 | 134858 | 1055704 | 0 | 11884 | |
root | alter_table | 32 | 9333927094000 | 745826138000 | 25932000000 | 0 | 0 | 1907 | 0 | |
root | create_table | 28 | 3852751948000 | 269087361000 | 12069000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 1924 | 3283428310000 | 1218477282000 | 1736854000000 | 1348 | 25321 | 0 | 0 | |
root | show_variables | 2008 | 1748568322000 | 5279970000 | 178904000000 | 3110 | 1151941 | 0 | 2008 | |
root | show_fields | 2069 | 1620159735000 | 4460779000 | 548576000000 | 52973 | 270400 | 0 | 0 | |
root | insert | 27 | 817053161000 | 100576525000 | 41277000000 | 0 | 0 | 1291 | 0 | |
root | show_tables | 1146 | 666571116000 | 5548043000 | 305603000000 | 15511 | 43586 | 0 | 0 | |
root | show_create_table | 1017 | 523971287000 | 131159647000 | 482000000 | 0 | 0 | 0 | 0 | |
root | set_option | 6467 | 434623242000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 8 | 397594689000 | 80089968000 | 2807000000 | 0 | 0 | 8 | 0 | |
root | show_table_status | 1019 | 268136260000 | 2150781000 | 25054000000 | 4 | 135 | 0 | 0 | |
root | Init DB | 1747 | 97021993000 | 501516000 | 8855000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 158213 | 95920149000 | 839952000 | 0 | 0 | 0 | 0 | 0 | |
root | drop_user | 3 | 93631725000 | 32145947000 | 4048000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1020 | 84048950000 | 830281000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 39737 | 41940817000 | 632065000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 896 | 28166268000 | 165187000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 20570676000 | 19763839000 | 573000000 | 900 | 900 | 0 | 2 | |
root | Quit | 2564 | 17740538000 | 221817000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 92 | 17427367000 | 13157425000 | 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