MariaDB [Warning] option 'innodb-sort-buffer-size': unsigned value..

rdan · Jul 10, 2014

On my.conf, I got this:

innodb_sort_buffer_size=256M
innodb_online_alter_log_max_size=128M
Click to expand...

On /var/log/mysqld.log
I got one warning:

[Warning] option 'innodb-sort-buffer-size': unsigned value 268435456 adjusted to 67108864
Click to expand...

How to correct this warning @eva2000 ?
Thank You!

eva2000 · Jul 10, 2014

set it back to Centmin Mod set size of 2M
Code:
innodb_sort_buffer_size=2M
that variable has a max value of 64M

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

innodb_sort_buffer_size

Introduced5.6.4
Command-Line Format--innodb_sort_buffer_size=#
Option-File Formatinnodb_sort_buffer_size
System Variable Nameinnodb_sort_buffer_size
Variable ScopeGlobal
Dynamic VariableNo
Permitted Values (>= 5.6.4)
Typenumeric
Default1048576
Range524288 .. 67108864
Permitted Values (>= 5.6.5)
Typenumeric
Default1048576
Range65536 .. 67108864
Specifies the size of sort buffers used for sorting data during creation of an InnoDB index. The size specified defines the amount of data filled in memory for an internal sort and written out to disk, which can be referred to as a “run”. During the merge phase, pairs of buffers of the specified size are “read in” and merged. The larger the setting, the fewer “runs” and merges there are, which is important to understand from a tuning perspective.

This sort area is only used for merge sorts during index creation, not during later index maintenance operations. Buffers are deallocated when index creation completes.

The value of this option also controls the amount by which the temporary log file is extended, to record concurrent DML during online DDL operations.

Before this setting was made configurable, the size was hardcoded to 1048576 bytes (1MB), and that value remains the default.

During an ALTER TABLE or CREATE TABLE statement that creates an index, 3 buffers are allocated, each with a size defined by this option. Additionally, auxiliary pointers are allocated to rows in the sort buffer so that the sort can run on pointers (as opposed to moving rows during the sort operation).
Click to expand...

rdan · Jul 10, 2014

Thanks a lot Eva!
Adjusted

Log in / Register

Forums

Learn about Centmin Mod LEMP Stack today

MariaDB [Warning] option 'innodb-sort-buffer-size': unsigned value..

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

.

Log in / Register

Useful Searches

Learn about Centmin Mod LEMP Stack today

MariaDB [Warning] option 'innodb-sort-buffer-size': unsigned value..

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

.