MySQL Bugs: #69537: Documentation of 'innodb_sort_buffer

Bug #69537	Documentation of 'innodb_sort_buffer_size' is wrong.
Submitted:	21 Jun 2013 5:47	Modified:	25 Jun 2013 12:13
Reporter:	宏樹植松	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.6.12	OS:	Any
Assigned to:	Bugs System	CPU Architecture:	Any
Tags:	documentation, innodb

Description:
"innodb_sort_buffer_size" is documented as "dynamic=yes". But as far as I tried this parameter is read only.

I have also noticed that this variable defined as read-only parameter in the source code(/storage/innobase/handler/ha_innodb.cc). 

So I think this psrameter should documented as "dynamic=no".

The document URL is follows.

http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_sort_buffer_si...

How to repeat:
Try to change variable at runtime.

mysql> SET GLOBAL innodb_sort_buffer_size=1024*1024*5;
ERROR 1238 (HY000): Variable 'innodb_sort_buffer_size' is a read only variable.

Suggested fix:
I think it should modify documentation of this parameter as "dynamic=no".

Hello,

Thank you for the report.
Verified as described.

Manual - http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_sort_buffer_si...

//
Server version: 5.6.12-debug-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show global variables like 'innodb_sort_buffer_size';
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| innodb_sort_buffer_size | 1048576 |
+-------------------------+---------+
1 row in set (0.02 sec)

mysql> set global innodb_sort_buffer_size=2*1024*1024;
ERROR 1238 (HY000): Variable 'innodb_sort_buffer_size' is a read only variable
mysql> 
mysql> 

Thanks,
Umesh

The documentation for innodb_sort_buffer_size has been updated. The change will appear soon, in the next published doc build. 

Thank you for the bug report.