search

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
256 stars 27 forks source link

Increase open_files_limit on RDS instance #284

Closed drupaladmin closed 5 months ago

drupaladmin commented 6 months ago

I have this error to fix, but the guide suggest a solution for someone with dedicated server. I am on AWS RDS, and can't find a way to change these variable

image

doing this SHOW VARIABLES LIKE 'open_files_limit'; give me "1048576" and it is pretty close to the requested value

JonathanLefebvre commented 6 months ago

This happen with Mysql 8.0.33 - on AWS RDS instance type "db.m5.4xlarge" (pretty sure it doesn't change a thing) Parameter group in AWS related, show 5000 as default configuration, but as describe Mysql it self said otherwise.

CloudFormation image is : releem/releem-agent:1.14.0

JonathanLefebvre commented 6 months ago

Status: I had to change the Instance Type. Switching to a "db.r7g.2xlarge" but mostly "restarting the server" removes the error for now.

drupaladmin commented 6 months ago

Thank you for your patience @JonathanLefebvre

We've fixed the issue by changing table_open_cache limits.

It should work without changing the instance type.