Skip to content
← Aiven Ideas

Operational Databases

Join our forum to discuss your ideas with Aiven community or check out our public roadmap.

Operational Databases

Categories

JUMP TO ANOTHER FORUM

(thinking…)

I suggest you ...

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

15 results found

  1. 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
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  2. 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
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  3. 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
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  4. 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-replicas

    4 votes
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  5. 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.

    3 votes
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  6. 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

    3 votes
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  7. innodb_buffer_pool_size

    As a customer
    I want to change the values of innodb_buffer_pool_size, innodb_buffer_pool_instances, and innodb_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
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  8. 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…

    2 votes
    Pending Review  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  9. 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
    Pending Review  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  10. 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 time

    2 votes
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  11. 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
    Gathering Interest  ·  1 comment  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  12. 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
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  13. 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
    Pending Review  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  14. 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
    Pending Review  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?

  15. 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
    Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Admin →
    How important is this to you?
  • Don't see your idea?