11 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…8 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.7 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.4 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-replicas3 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 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 -
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 -
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
1 vote -
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 time1 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?