Server Parameters: table_open_cache
I would like to change the parameter of 'tableopencache' of MySQL.
Although I changed the SKU, this parameter would not be changed.
Do you have any plan to change the parameter conforming with SKU?
We now support changing the global server value of “table_open_cache”. If you need greater than 4500, I would recommend using a General Purpose 2 vCore server or greater. The Basic 1 vCore and 2 vCore values cap at about 2000.
Andrea Lam on behalf of the Azure DB for MySQL team
Dakota Clark commented
For a workload I'd like to deploy it requires that the table_open_cache parameter be set for 4500 so the 2000 limit will not work,
Hong Wang commented
Today, the default value is 2000. Do you want to change it to bigger or smaller?