Unable to change innodb_page_size to 32kb in Azure MySQL Flexible Server – clarification needed

Question

Unable to change innodb_page_size to 32kb in Azure MySQL Flexible Server – clarification needed

Sai Krishna Atmuri 0

Hello,

I'm currently using Azure Database for MySQL – Flexible Server and need clarification regarding the innodb_page_size configuration.

We have an application that requires innodb_page_size = 32KB for compatibility and performance reasons. However, in the Azure Portal under Server Parameters, this setting is not visible or editable.

I understand from MySQL documentation that innodb_page_size can only be set at initialization and not changed afterward. That’s acceptable — but I would like to confirm:

Is it possible to set innodb_page_size = 32KB during the initial provisioning of a Flexible Server (e.g., through CLI, ARM templates, or hidden parameters)?
If not supported, is it fixed to 16KB across all MySQL versions (5.7 / 8.0) in Flexible Server?
Are there any plans or roadmaps to allow customization of this parameter in future releases of Azure Database for MySQL?
Is self-hosting on Azure VM with a custom MySQL build the only way to achieve 32KB innodb_page_size on Azure?

Any clarification or official documentation reference would be appreciated.

Thanks in advance.

Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator

2025-05-14T18:04:11.2533333+00:00

Hi Sai Krishna Atmuri,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator

2025-05-14T18:04:11.2533333+00:00

Hi Sai Krishna Atmuri,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Azar 29,520 MVP Volunteer Moderator

Hi there Sai Krishna Atmuri

Thanks for using QandA platform

I guess you're correct innodb_page_size can only be set at MySQL server initialization and isn’t modifiable afterward. In Azure Database for MySQL – Flexible Server, this parameter is not exposed during provisioning via portal, CLI, or ARM templates. As of now, the default innodb_page_size is fixed at 16KB across both MySQL 5.7 and 8.0 in Flexible Server, and there's no support for customizing it during setup.

Currently, if your app requires a 32KB page size for compatibility or tuning, the only viable option is to self-host MySQL on an Azure VM using a custom build where you can define --innodb-page-size=32K at initialization.

If this helps kindly accept the answer thanks much.

Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator

2025-05-15T16:52:08.03+00:00

Hi Sai Krishna Atmuri,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Unable to change innodb_page_size to 32kb in Azure MySQL Flexible Server – clarification needed

1 answer

Your answer