Learn about Centmin Mod LEMP Stack today
Become a Member

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

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by RoldanLT, Jul 10, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,975
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    6:44 AM
    1.11
    10.2
    On my.conf, I got this:
    On /var/log/mysqld.log
    I got one warning:
    How to correct this warning @eva2000 ?
    Thank You!
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,933
    6,911
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,407
    Local Time:
    8:44 AM
    Nginx 1.13.x
    MariaDB 5.5
    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

     
    • Like Like x 1
  3. RoldanLT

    RoldanLT Well-Known Member

    3,975
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    6:44 AM
    1.11
    10.2
    Thanks a lot Eva!
    Adjusted (y)