13 results found
-
Allow Mysql Slow Query log on read-only replicas
As a mysql administrator, I would like to be able to enable the slow query log on a read-only replica.
Current state.
The slow query log can have one of two output destinations. Log file, and the mysql.slowlog table on the server itself. Docs for reference
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
Log Output:
This currently cannot be configured for Aiven managed Mysql services. This is because customers do not have access to the underlying filesystem for service nodes.
Table Output:
This is the output destination used by Aiven hosted Mysql services, for the same reasoning above.
This means that when an Aiven managed…9 votes -
See the end time or current status of a backup taking place
It would be great to be able to see the end time of when a backup is completed.
This way you can know how long the backup took. As well as monitor and see when the lock error will no longer occur.8 votes -
Access to MySQL Binary Logs
As a database administrator or developer,
I would like to be able to access and read binary logs of the database service by using third-party utilities,
so that I would be able to perform the tasks security auditing, replication monitoring and possibly data recovery on the database.5 votes -
Expose MySQL slow query logs in service logs
Currently, MySQL slow query logs are stored in the mysql.slow_log table. Adding an option to redirect those logs into service logs would allow log integrations, like OpenSearch, to pick those up and give customers greater value and flexibility.
It would implicitly solve the following:
https://ideas.aiven.io/forums/951280-operational-databases/suggestions/46266829-allow-mysql-slow-query-log-on-read-only-replicas4 votes -
innodb_buffer_pool_size
As a customer
I want to change the values ofinnodb_buffer_pool_size,innodb_buffer_pool_instances, andinnodb_buffer_pool_chunk_size
so that I can tune the DB config to better suit my workload
In addition, I understand that any changes should be within sensible limits, as taking too much memory away from the OS can cause OOM errors.3 votes -
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 -
Ability to adjust the lower_case_table_names setting for MySQL
As a database administrator, I want the option to be able to set the lowercasetablenames MySQL parameter in the event of migration requiring the lowercasetablenames is different than 0
2 votes -
Show all connections in the connections tab of the web console.
As database administrator or developer,
I want to see both the primary and read-only connections in the connections tab of the web console
so that I can observe all of the connections at the same time2 votes -
Ability to Change the MySQL Optimizer Behavior
As a database administrator or developer,
I would like to be able to change the behavior of the MySQL Optimizer at the global level by changing the variable of the optimizerswitch with values such as "indexmergeintersection=off" or "preferordering_index=off",
so that I would be able to optimize my query performance.2 votes -
Ability to change join_buffer_size
As a MySQL user
I want to tune my service parameters according to best practises (in this case parameter joinbuffersize)
so that I can make my application performance better as I cannot use indexes
In addition, it might be useful to be able some other parameters mentioned here (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size)2 votes -
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 -
MySQL Audit Logging Capability
As a database administrator or developer, I would like to have audit logging capability in the system so that I can track and monitor user activities, maintain data security, and ensure compliance with regulatory requirements.
1 vote -
Aiven Cli Integration with octopusdeploy CD
As the founder, we are interested in enabling multiple users to MySQL Database directly via the Aiven CLI, preferably utilizing Octopus Deploy. They have a community step template which can facilitate the creation of users if they don't already exist. In order to set up a connection to Aiven CLI within our CI/CD, the Aiven CLI needs to be installed within the octopusdeploy/worker-tools. Configuration instructions for this can be found on Github, specifically at https://github.com/OctopusDeploy/WorkerTools/tree/master/ubuntu.22.04 and https://github.com/OctopusDeploy/WorkerTools/blob/master/windows.ltsc2019/Dockerfile. Further information is available on Docker Hub at https://hub.docker.com/r/octopusdeploy/worker-tools.
1 vote
- Don't see your idea?