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 | 2164 | 441640680000 | 774106000 | 178152000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2164 | 207857285000 | 511338000 | 71016000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2198 | 15292873000 | 43785000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 56069 | 25323193297000 | 706647406000 | 5339865000000 | 140581 | 1157217 | 0 | 13011 | |
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 | 2306 | 3369193250000 | 1218477282000 | 1736854000000 | 1348 | 25321 | 0 | 0 | |
root | show_variables | 2464 | 2142805152000 | 5279970000 | 218579000000 | 3566 | 1413664 | 0 | 2464 | |
root | show_fields | 2535 | 1782775250000 | 4460779000 | 549933000000 | 52973 | 270400 | 0 | 0 | |
root | insert | 27 | 817053161000 | 100576525000 | 41277000000 | 0 | 0 | 1291 | 0 | |
root | show_tables | 1372 | 744904560000 | 5548043000 | 317062000000 | 15511 | 43586 | 0 | 0 | |
root | show_create_table | 1248 | 565479964000 | 131159647000 | 830000000 | 0 | 0 | 0 | 0 | |
root | set_option | 7948 | 535506282000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 1526 | 401668208000 | 2150781000 | 27359000000 | 4 | 135 | 0 | 0 | |
root | create_db | 8 | 397594689000 | 80089968000 | 2807000000 | 0 | 0 | 8 | 0 | |
root | jump_if_not | 287785 | 168885828000 | 839952000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 2137 | 119957942000 | 501516000 | 10911000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1254 | 104467909000 | 830281000 | 0 | 0 | 0 | 0 | 0 | |
root | drop_user | 3 | 93631725000 | 32145947000 | 4048000000 | 0 | 0 | 0 | 0 | |
root | freturn | 70547 | 68810264000 | 632065000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1092 | 34058692000 | 165187000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 3153 | 21912149000 | 221817000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 20570676000 | 19763839000 | 573000000 | 900 | 900 | 0 | 2 | |
root | show_master_status | 103 | 17885032000 | 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