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 | 31203 | 30848 | 0 | 6117592558000 | 4225598000 | 196057000 | 76879000000 | 0 | 0 | 1065 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2024-07-30 15:46:22.774360 | 2024-07-30 15:57:52.112319 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | * | 13267 | 13098 | 0 | 5534051189000 | 6051194000 | 417129000 | 78022000000 | 169 | 0 | 69290 | 5 | 0 | 0 | 169 | 0 | 169 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:22.780826 | 2024-07-30 15:57:52.110245 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 24816 | 23863 | 0 | 5063087140000 | 2368074000 | 204025000 | 208817000000 | 0 | 0 | 2859 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2024-07-30 15:46:22.797175 | 2024-07-30 15:57:51.274197 | ||
SHOW SESSION VARIABLES LIKE ? | performance_schema | * | 4775 | 0 | 0 | 4096665043000 | 7142740000 | 857940000 | 410570000000 | 4775 | 1 | 2740850 | 574 | 0 | 0 | 4775 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2024-07-30 15:46:22.767319 | 2024-07-30 15:57:52.092171 | |
SHOW SESSION VARIABLES LIKE ? | mysql | * | 4292 | 0 | 0 | 3695968625000 | 3277779000 | 861129000 | 364972000000 | 4292 | 1 | 2463608 | 574 | 0 | 0 | 4292 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2024-07-30 15:46:22.794602 | 2024-07-30 15:57:51.229711 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | * | 8554 | 8348 | 0 | 3646192885000 | 22004717000 | 426255000 | 96224000000 | 366 | 0 | 83998 | 10 | 0 | 0 | 201 | 0 | 366 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:22.928517 | 2024-07-30 15:57:51.273871 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | * | 10639 | 9741 | 5 | 2536454049000 | 4487931000 | 238410000 | 212009000000 | 7887 | 1 | 50795 | 5 | 0 | 0 | 2008 | 0 | 13830 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:23.042381 | 2024-07-30 15:57:51.246655 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | * | 9547 | 8875 | 0 | 2235868643000 | 43397788000 | 234195000 | 154558000000 | 5544 | 1 | 37128 | 4 | 0 | 0 | 1512 | 0 | 10080 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:22.856991 | 2024-07-30 15:57:51.800006 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 4964 | 4545 | 0 | 2118914963000 | 4153629000 | 426856000 | 167563000000 | 20879 | 4 | 106940 | 22 | 0 | 0 | 409 | 0 | 20859 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2024-07-30 15:46:22.798478 | 2024-07-30 15:57:51.162861 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 4775 | 4438 | 0 | 1927816220000 | 5450163000 | 403731000 | 135120000000 | 21848 | 5 | 110251 | 23 | 0 | 0 | 337 | 0 | 21848 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2024-07-30 15:46:22.784214 | 2024-07-30 15:57:52.111539 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 4607 | 4438 | 0 | 1458464307000 | 1706942000 | 316575000 | 59938000000 | 501 | 0 | 2849 | 1 | 0 | 0 | 169 | 0 | 501 | 0 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | 2024-07-30 15:46:22.785969 | 2024-07-30 15:57:52.102051 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 4089 | 3888 | 0 | 1445891387000 | 88295518000 | 353605000 | 78384000000 | 402 | 0 | 13264 | 3 | 0 | 0 | 201 | 0 | 402 | 0 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | 2024-07-30 15:46:22.887076 | 2024-07-30 15:57:51.147010 | ||
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | mysql | * | 2722 | 0 | 0 | 1334994393000 | 7830798000 | 490446000 | 461466000000 | 2722 | 1 | 8289 | 3 | 0 | 0 | 19054 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:23.080399 | 2024-07-30 15:57:51.274790 | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | performance_schema | * | 2387 | 0 | 0 | 1151407776000 | 2966889000 | 482366000 | 393548000000 | 2387 | 1 | 7198 | 3 | 0 | 0 | 16709 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:22.892705 | 2024-07-30 15:57:51.813065 | |
SHOW TABLES FROM `phpmyadmin` | NULL | 6499 | 6499 | 0 | 1115248757000 | 1721021000 | 171603000 | 449503000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... | 2024-07-30 15:46:22.742646 | 2024-07-30 15:57:52.103056 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | * | 1772 | 1636 | 0 | 1046527950000 | 3270359000 | 590591000 | 77199000000 | 3400 | 2 | 34119 | 19 | 0 | 0 | 40 | 0 | 3400 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:23.490633 | 2024-07-30 15:57:51.103324 | |
SELECT ? FROM `mysql` . `user` LIMIT ? | NULL | 6039 | 0 | 0 | 829718565000 | 16921702000 | 137393000 | 402095000000 | 6039 | 1 | 6039 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... | 2024-07-30 15:46:22.759702 | 2024-07-30 15:57:52.117637 | ||
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | * | 2528 | 2186 | 0 | 700503523000 | 2120368000 | 277097000 | 83746000000 | 3358 | 1 | 22026 | 9 | 0 | 0 | 788 | 0 | 6240 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:22.955636 | 2024-07-30 15:57:52.044235 | |
SELECT COUNT ( * ) FROM `performance_schema` . `ta... | performance_schema | * | 2087 | 0 | 0 | 624008280000 | 9538470000 | 298997000 | 80848000000 | 2087 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... | 2024-07-30 15:46:22.781688 | 2024-07-30 15:57:52.095932 | |
SELECT * FROM `table_lock_waits_summary_by_table` ... | performance_schema | * | 2087 | 0 | 0 | 608431198000 | 4050134000 | 291533000 | 143302000000 | 52175 | 25 | 52175 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... | 2024-07-30 15:46:22.771102 | 2024-07-30 15:57:52.092970 | |
SELECT @@`version` , @@`version_comment` | NULL | 6499 | 0 | 0 | 571845272000 | 3450035000 | 87989000 | 0 | 6499 | 1 | 6499 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... | 2024-07-30 15:46:22.741459 | 2024-07-30 15:57:52.102645 | ||
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | NULL | * | 972 | 0 | 0 | 484134217000 | 2581576000 | 498080000 | 173748000000 | 972 | 1 | 3009 | 3 | 0 | 0 | 6804 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:23.010450 | 2024-07-30 15:57:52.056398 | |
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... | mysql | * | 2417 | 0 | 0 | 456088852000 | 1373461000 | 188700000 | 121788000000 | 2417 | 1 | 297761 | 123 | 0 | 0 | 2417 | 0 | 0 | 0 | cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... | 2024-07-30 15:46:23.085450 | 2024-07-30 15:57:51.275084 | |
SHOW CREATE TABLE `performance_schema` . `table_lo... | performance_schema | 2087 | 0 | 0 | 449520970000 | 1432369000 | 215390000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... | 2024-07-30 15:46:22.788494 | 2024-07-30 15:57:52.103051 | ||
SHOW CREATE TABLE `mysql` . `user` | mysql | 2416 | 0 | 0 | 444244538000 | 4357902000 | 183876000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... | 2024-07-30 15:46:22.889266 | 2024-07-30 15:57:51.147379 |
|
Warning in ./src/Table/Table.php#291
Backtrace
Warning in ./src/Table/Table.php#291
Backtrace