Want more timely Centmin Mod News Updates?
Become a Member

MariaDB Increasing Max Number of Indexes > 64

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Jimmy, Nov 28, 2017.

  1. Jimmy

    Jimmy Premium Member Premium Member

    1,365
    287
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +705
    Local Time:
    11:11 AM
    1.13.x
    MariaDB 10.1.x
    Does anyone know how to increase the max number of indexes per table from 64 to 256?

    Mariadb 10.1 all my tables are InnoDB.

    Is there a setting in my.cnf?

    I'm getting an error on one of my tables and I need to increase the amount.

    Code:
    IPS\Db\Exception: Too many keys specified; max 64 keys allowed (1069)
     
    Last edited: Nov 28, 2017
  2. Jimmy

    Jimmy Premium Member Premium Member

    1,365
    287
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +705
    Local Time:
    11:11 AM
    1.13.x
    MariaDB 10.1.x
  3. eva2000

    eva2000 Administrator Staff Member

    36,041
    7,907
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,189
    Local Time:
    1:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  4. Jimmy

    Jimmy Premium Member Premium Member

    1,365
    287
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +705
    Local Time:
    11:11 AM
    1.13.x
    MariaDB 10.1.x
    I wonder how I can get that increased. Haven't found anything that can be put into the my.cnf file.
     
  5. eva2000

    eva2000 Administrator Staff Member

    36,041
    7,907
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,189
    Local Time:
    1:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    fix the table as there's no reason a single table needs 64+ keys !
     
  6. Jimmy

    Jimmy Premium Member Premium Member

    1,365
    287
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +705
    Local Time:
    11:11 AM
    1.13.x
    MariaDB 10.1.x
    I wish it was that easy. It's a 3rd party app and I can't modify it. I guess I'll just have to work around the issue.
     
  7. eva2000

    eva2000 Administrator Staff Member

    36,041
    7,907
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,189
    Local Time:
    1:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    no out of box distro supplied MySQL server would be able to handle that app's mysql table as it would run up to any distro supplied MySQL server's default limits
     
    • Informative Informative x 1
  8. Jimmy

    Jimmy Premium Member Premium Member

    1,365
    287
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +705
    Local Time:
    11:11 AM
    1.13.x
    MariaDB 10.1.x
    I was just entering custom fields in the app, when I got to 60ish custom fields I got the error. Since there wasn't an easy solution, I'm reducing the amount of custom fields.
     
    • Agree Agree x 1
..