Set values for parameters not available under Server Parameters

Question

Set values for parameters not available under Server Parameters

Sandeep Ramnani 26

I need to set the values for below two parameters:

innodb_log_buffer_size = 32M
innodb_log_file_size = 256M

However, I don't see them under Server Parameters. How can I set values for these two parameters?

Answer 1

Navtej Singh Saini 4,171

@Sandeep Ramnani

Please go through the document which lists all the server parameter you can change. It also mentions that some of the parameters cannot be changed directly.

But there is an alternate method as below:

Please check and let us know if any issues or question.

Thanks
Navtej S

Sandeep Ramnani 26 Reputation points

2020-12-22T22:48:58.413+00:00

Thanks Navtej.

It isn't letting me set the value for "innodb_log_buffer_size" using init_connect. Seems like it is a Read Only Parameter.

As per MySQL Documentation (https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_log_buffer_size), it is used for performance optimization and Maximum possible value is 4294967295.

Is there any reason why Azure doesn't support to increase value for this parameter?
Navtej Singh Saini 4,171 Reputation points

2020-12-23T16:56:05.79+00:00

@Sandeep Ramnani

Let me check further regarding this and get back to you.

Thanks
Navtej S
Navtej Singh Saini 4,171 Reputation points

2020-12-30T17:55:27.887+00:00

@Sandeep Ramnani

Is there a error message you get while setting the parameter. We are still checking this with our internal team.

Thanks
Navtej S
Sandeep Ramnani 26 Reputation points

2020-12-30T22:11:21.407+00:00

@Navtej Singh Saini - When I try to run this query, set SESSION innodb_log_buffer_size=33554432;, it gives below error message:

SQL Error (1238): Variable "innodb_log_buffer_size" is a read only variable
Navtej Singh Saini 4,171 Reputation points

2021-01-05T04:29:09.417+00:00

@Sandeep Ramnani

We have received reply from our team and they have asked you to the raise issue with support to change these server parameters where our internal team will do the needful. Here is the response from the team

"The parameters you mentioned cannot be set at session level using init_connect and are server level parameters. Could you ask the customer to open support ticket for this and our team will help them."

Please let me know if you have any other questions.

Thanks
Navtej S
Navtej Singh Saini 4,171 Reputation points

2021-01-05T22:12:07.28+00:00

@Sandeep Ramnani

Please let us know if you have any further questions regarding this issue.

Thanks
Navtej S
Sandeep Ramnani 26 Reputation points

2021-01-06T01:44:32.147+00:00

Thanks Navtej. This issue is resolved.

Set values for parameters not available under Server Parameters

0 additional answers

Activity