Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Setting the performance_schema_digests_size variable for Mariadb
There was a problem when setting the variable performance_schema_digests_size for Mariadb of any version, you can set values from -1 to 200, although according to the official documentation - from -1 to 1048576.
The default value for the variable is 10000. And this problem does not exist for mysql family instances.
How can I increase the variable performance_schema_digests_size for Mariadb ? Is the limit of 200 a reasonable restriction? Or is it a bug, how to report it to AWS/RDS ?
- Newest
- Most votes
- Most comments
The issue you're experiencing with the performance_schema_digests_size parameter for MariaDB on Amazon RDS is indeed unusual and appears to be a limitation or potential bug specific to the RDS implementation.
In standard MariaDB installations, as per the official documentation, this parameter should allow values from -1 to 1048576. However, the restriction you're encountering on RDS (allowing only values from -1 to 200) is not typical and could be considered overly restrictive.
To address this issue, you have a few options:
-
Work within the current limitations: If possible, adjust your workload to operate within the maximum allowed value of 200. This may not be ideal, but it's a temporary workaround.
-
Contact AWS Support: Since this appears to be a discrepancy between RDS behavior and standard MariaDB functionality, it's advisable to open a support case with AWS. They can investigate the issue, confirm if it's a bug, and potentially provide a fix or workaround.
-
Report the issue: You can report this potential bug to AWS through their official channels. The AWS Database Blog often encourages users to share feedback on RDS-related issues.
-
Check for updates: Keep an eye on RDS updates and release notes. If this is a known issue, it might be addressed in future updates.
The limit of 200 does seem unreasonably low compared to the standard MariaDB range, especially considering the default value is typically 10000. This restriction could potentially impact performance monitoring and optimization for larger or more complex database workloads.
In the meantime, if you absolutely need a higher value for performance_schema_digests_size, you might consider exploring alternative deployment options that allow full control over MariaDB configuration, such as running MariaDB on EC2. However, this would mean losing the managed benefits of RDS.
Remember to regularly check the Amazon RDS documentation and release notes for any updates or acknowledgments of this issue.
Sources
Troubleshoot Amazon RDS for MySQL and Amazon RDS for MariaDB Errors | AWS Database Blog
Turn on the Performance Schema for Amazon RDS for MariaDB or MySQL - Amazon Relational Database Service
Relevant content
- asked 2 months ago
