4 results found
-
Ability to Terminate a MySQL Query
As a database admin or a developer,
I would like to be able to terminate running queries in my database as admin,
so that I would be able to unlock any long-running queries as part of my operations.2 votes -
Adjust temptable_max_ram according to the plan
As a database admin, using internaltmpmemstorageengine=TempTable (default), I would like the temptablemaxram size to be adjusted to the plan and not use the default value of 1G.
When using the new default TempTable engine for temporary tables the setting temptablemaxram=1G (default) controls the max. amount of memory for ALL temporary tables.
"The setting temptablemaxram controls how much is available to ALL temporary tables before converting to an on-disk table. Looking at our 50 queries example earlier, say each one needs 256MB of memory. With the default setting of 1GB, the…
1 vote -
Allow updating the table_definition_cache and table_open_cache MySQL parameters
Setting these variables allows the ability to configure the cache parameter to avoid workload issues with prepared statement issues
1 vote -
Update max_execution_time system variable
The ability to globally enforce the maxexecutiontime system variable would be great to have
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_execution_time
As it would help with limiting the long running queries happening that are left unchecked.
1 vote
- Don't see your idea?