SELECT * FROM `x$statement_analysis`
|
query | db | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | lock_latency | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | rows_affected | rows_affected_avg | tmp_tables | tmp_disk_tables | rows_sorted | sort_merge_passes | digest | first_seen | last_seen | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 25737 | 25382 | 0 | 5095215841000 | 2589589000 | 197972000 | 76879000000 | 0 | 0 | 1065 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2024-07-30 15:46:22.774360 | 2024-07-30 15:55:13.723091 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | * | 10949 | 10780 | 0 | 4623837221000 | 6051194000 | 422306000 | 78022000000 | 169 | 0 | 69290 | 6 | 0 | 0 | 169 | 0 | 169 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:22.780826 | 2024-07-30 15:55:13.719638 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 20479 | 19526 | 0 | 4245573354000 | 2368074000 | 207313000 | 208817000000 | 0 | 0 | 2859 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2024-07-30 15:46:22.797175 | 2024-07-30 15:55:13.117392 | ||
SHOW SESSION VARIABLES LIKE ? | performance_schema | * | 3989 | 0 | 0 | 3447295418000 | 7142740000 | 864200000 | 343430000000 | 3989 | 1 | 2289686 | 574 | 0 | 0 | 3989 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2024-07-30 15:46:22.767319 | 2024-07-30 15:55:13.716527 | |
SHOW SESSION VARIABLES LIKE ? | mysql | * | 3585 | 0 | 0 | 3113079616000 | 3277779000 | 868362000 | 306128000000 | 3585 | 1 | 2057790 | 574 | 0 | 0 | 3585 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2024-07-30 15:46:22.794602 | 2024-07-30 15:55:13.094784 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | * | 7031 | 6825 | 0 | 3066999202000 | 22004717000 | 436210000 | 96224000000 | 366 | 0 | 83998 | 12 | 0 | 0 | 201 | 0 | 366 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:22.928517 | 2024-07-30 15:55:13.116946 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | * | 8872 | 7974 | 5 | 2199874422000 | 4487931000 | 247956000 | 212009000000 | 7887 | 1 | 50795 | 6 | 0 | 0 | 2008 | 0 | 13830 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:23.042381 | 2024-07-30 15:55:13.105055 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | * | 7975 | 7303 | 0 | 1942546348000 | 43397788000 | 243579000 | 154558000000 | 5544 | 1 | 37128 | 5 | 0 | 0 | 1512 | 0 | 10080 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:22.856991 | 2024-07-30 15:55:12.947942 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 4111 | 3692 | 0 | 1813692438000 | 4153629000 | 441180000 | 167563000000 | 20879 | 5 | 106940 | 26 | 0 | 0 | 409 | 0 | 20859 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2024-07-30 15:46:22.798478 | 2024-07-30 15:55:13.050816 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 3988 | 3651 | 0 | 1663567221000 | 5450163000 | 417143000 | 135120000000 | 21848 | 5 | 110251 | 28 | 0 | 0 | 337 | 0 | 21848 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2024-07-30 15:46:22.784214 | 2024-07-30 15:55:13.721495 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 3381 | 3180 | 0 | 1233959756000 | 88295518000 | 364968000 | 78384000000 | 402 | 0 | 13264 | 4 | 0 | 0 | 201 | 0 | 402 | 0 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | 2024-07-30 15:46:22.887076 | 2024-07-30 15:55:13.040321 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 3821 | 3652 | 0 | 1224513864000 | 1706942000 | 320469000 | 59938000000 | 501 | 0 | 2849 | 1 | 0 | 0 | 169 | 0 | 501 | 0 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | 2024-07-30 15:46:22.785969 | 2024-07-30 15:55:13.723668 | ||
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | mysql | * | 2269 | 0 | 0 | 1129335233000 | 7830798000 | 497723000 | 391060000000 | 2269 | 1 | 6930 | 3 | 0 | 0 | 15883 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:23.080399 | 2024-07-30 15:55:13.118172 | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | performance_schema | * | 1994 | 0 | 0 | 973018490000 | 2966889000 | 487973000 | 332516000000 | 1994 | 1 | 6019 | 3 | 0 | 0 | 13958 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:22.892705 | 2024-07-30 15:55:12.964640 | |
SHOW TABLES FROM `phpmyadmin` | NULL | 5475 | 5475 | 0 | 908397287000 | 1721021000 | 165917000 | 365641000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... | 2024-07-30 15:46:22.742646 | 2024-07-30 15:55:13.709737 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | * | 1475 | 1339 | 0 | 860172873000 | 3270359000 | 583168000 | 77199000000 | 3400 | 2 | 34119 | 23 | 0 | 0 | 40 | 0 | 3400 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:23.490633 | 2024-07-30 15:55:13.018788 | |
SELECT ? FROM `mysql` . `user` LIMIT ? | NULL | 5077 | 0 | 0 | 697054187000 | 16921702000 | 137296000 | 339197000000 | 5077 | 1 | 5077 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... | 2024-07-30 15:46:22.759702 | 2024-07-30 15:55:13.729626 | ||
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | * | 2196 | 1854 | 0 | 632180790000 | 2120368000 | 287878000 | 83746000000 | 3358 | 2 | 22026 | 10 | 0 | 0 | 788 | 0 | 6240 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:22.955636 | 2024-07-30 15:55:13.002281 | |
SELECT COUNT ( * ) FROM `performance_schema` . `ta... | performance_schema | * | 1746 | 0 | 0 | 524729217000 | 9538470000 | 300532000 | 69419000000 | 1746 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... | 2024-07-30 15:46:22.781688 | 2024-07-30 15:55:13.720121 | |
SELECT * FROM `table_lock_waits_summary_by_table` ... | performance_schema | * | 1746 | 0 | 0 | 511230187000 | 4050134000 | 292800000 | 120805000000 | 43650 | 25 | 43650 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... | 2024-07-30 15:46:22.771102 | 2024-07-30 15:55:13.717309 | |
SELECT @@`version` , @@`version_comment` | NULL | 5475 | 0 | 0 | 464259293000 | 3450035000 | 84796000 | 0 | 5475 | 1 | 5475 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... | 2024-07-30 15:46:22.741459 | 2024-07-30 15:55:13.709193 | ||
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | NULL | * | 849 | 0 | 0 | 424688355000 | 2581576000 | 500221000 | 152256000000 | 849 | 1 | 2640 | 3 | 0 | 0 | 5943 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:23.010450 | 2024-07-30 15:55:13.016213 | |
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... | mysql | * | 2014 | 0 | 0 | 385862851000 | 1373461000 | 191590000 | 103893000000 | 2014 | 1 | 248998 | 124 | 0 | 0 | 2014 | 0 | 0 | 0 | cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... | 2024-07-30 15:46:23.085450 | 2024-07-30 15:55:13.118662 | |
SHOW CREATE TABLE `performance_schema` . `table_lo... | performance_schema | 1746 | 0 | 0 | 377602927000 | 1432369000 | 216267000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... | 2024-07-30 15:46:22.788494 | 2024-07-30 15:55:13.724606 | ||
SHOW CREATE TABLE `mysql` . `user` | mysql | 2014 | 0 | 0 | 371762554000 | 4357902000 | 184589000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... | 2024-07-30 15:46:22.889266 | 2024-07-30 15:55:13.040670 |
|
Warning in ./src/Table/Table.php#291
Backtrace
Warning in ./src/Table/Table.php#291
Backtrace