Hi Niket Kumar Singh •,
Welcome to Microsoft Q&A forum.
As I understand, you want to Modify innodb_dedicated_server variable in Azure Database for MySQL (Flexible Server) for optimization.
Could you please let us know the Pricing tier and other configuration details of your server?
Azure Database for MySQL flexible server supports tuning the values of server parameters. Some parameters' min and max values (ex. max_connections
, join_buffer_size
, query_cache_size
) are determined by the compute tier and before you compute the size of the server. Refer to server parameters for more information about these limits.
Azure Database for MySQL flexible server uses the InnoDB storage engine for all nontemporary tables. With InnoDB, data is stored within a clustered index using a B-Tree structure. The table is physically organized based on primary key values, which means that rows are stored in the primary key order.
Each secondary key entry in an InnoDB table contains a pointer to the primary key value in which the data is stored. In other words, a secondary index entry contains a copy of the primary key value to which the entry is pointing. Therefore, primary key choices have a direct effect on the amount of storage overhead in your tables.
Thanks