SELECT * FROM `x$statements_with_temp_tables`
|
query | db | exec_count | total_latency | memory_tmp_tables | disk_tmp_tables | avg_tmp_tables_per_query | tmp_tables_to_disk_pct | first_seen | last_seen | digest | |
---|---|---|---|---|---|---|---|---|---|---|---|
SELECT `PLUGIN_NAME` , `PLUGIN_DESCRIPTION` FROM `... | mysql | 15 | 60493632000 | 15 | 15 | 1 | 100 | 2024-06-24 15:16:00.868394 | 2024-06-24 15:25:57.719568 | da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a... | |
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... | information_schema | 2 | 1188735381000 | 2 | 2 | 1 | 100 | 2024-06-24 15:21:20.354571 | 2024-06-24 15:22:36.210043 | 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c... | |
SELECT ? FROM `information_schema` . `INNODB_BUFFE... | information_schema | 2 | 20428005000 | 2 | 2 | 1 | 100 | 2024-06-24 15:21:20.488863 | 2024-06-24 15:22:36.331022 | 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | NULL | 551 | 310460519000 | 3857 | 0 | 7 | 0 | 2024-06-24 15:15:55.270568 | 2024-06-24 15:27:19.264063 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | 1335 | 942272773000 | 2683 | 0 | 2 | 0 | 2024-06-24 15:15:55.234627 | 2024-06-24 15:27:19.249723 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | performance_schema | 375 | 191658228000 | 2625 | 0 | 7 | 0 | 2024-06-24 15:15:55.247826 | 2024-06-24 15:27:23.848611 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | 1498 | 640917232000 | 2606 | 0 | 2 | 0 | 2024-06-24 15:15:55.222060 | 2024-06-24 15:27:23.835564 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | mysql | 338 | 180533719000 | 2366 | 0 | 7 | 0 | 2024-06-24 15:15:55.203851 | 2024-06-24 15:27:22.845925 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | 1370 | 620307363000 | 2229 | 0 | 2 | 0 | 2024-06-24 15:15:55.142388 | 2024-06-24 15:27:22.824404 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | klo | 139 | 64190769000 | 973 | 0 | 7 | 0 | 2024-06-24 15:18:28.126168 | 2024-06-24 15:27:18.846517 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | klo | 558 | 248144959000 | 947 | 0 | 2 | 0 | 2024-06-24 15:18:30.623328 | 2024-06-24 15:27:18.834238 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SHOW SESSION VARIABLES LIKE ? | performance_schema | 748 | 632717186000 | 748 | 0 | 1 | 0 | 2024-06-24 15:15:55.160895 | 2024-06-24 15:27:23.825652 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | NULL | 124 | 85990935000 | 744 | 0 | 6 | 0 | 2024-06-24 15:16:10.709966 | 2024-06-24 15:27:00.578854 | a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | information_schema | 103 | 52114958000 | 721 | 0 | 7 | 0 | 2024-06-24 15:15:55.710845 | 2024-06-24 15:27:14.698548 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | information_schema | 780 | 271341260000 | 714 | 0 | 1 | 0 | 2024-06-24 15:15:55.687053 | 2024-06-24 15:27:24.347796 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | dbcnp | 92 | 42582641000 | 644 | 0 | 7 | 0 | 2024-06-24 15:20:16.822140 | 2024-06-24 15:27:24.226452 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 750 | 652076581000 | 580 | 0 | 1 | 0 | 2024-06-24 15:15:55.169317 | 2024-06-24 15:27:23.712818 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | Estudiantes | 80 | 39359489000 | 560 | 0 | 7 | 0 | 2024-06-24 15:17:53.782579 | 2024-06-24 15:26:40.169220 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | dbcnp | 353 | 146672103000 | 548 | 0 | 2 | 0 | 2024-06-24 15:20:23.098689 | 2024-06-24 15:27:24.212390 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... | information_schema | 546 | 558609476000 | 507 | 0 | 1 | 0 | 2024-06-24 15:15:56.296228 | 2024-06-24 15:27:14.716607 | 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... | |
SHOW SESSION VARIABLES LIKE ? | mysql | 495 | 419995406000 | 495 | 0 | 1 | 0 | 2024-06-24 15:15:55.918663 | 2024-06-24 15:27:22.814588 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 533 | 442212450000 | 371 | 0 | 1 | 0 | 2024-06-24 15:15:55.395593 | 2024-06-24 15:27:22.774417 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | THOMAS_TESTE | 52 | 26171503000 | 364 | 0 | 7 | 0 | 2024-06-24 15:19:57.021548 | 2024-06-24 15:27:08.254981 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | |
SHOW SESSION VARIABLES LIKE ? | klo | 356 | 475317428000 | 356 | 0 | 1 | 0 | 2024-06-24 15:18:31.374339 | 2024-06-24 15:27:18.824174 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | |
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... | NULL | 333 | 77241514000 | 333 | 0 | 1 | 0 | 2024-06-24 15:15:55.271009 | 2024-06-24 15:27:19.264467 | cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... |
|
Warning in ./src/Table/Table.php#291
Backtrace
Warning in ./src/Table/Table.php#291
Backtrace