Welcome to Centmin Mod Community
Register Now

MariaDB Increasing Max Number of Indexes > 64

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

  1. Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    6:29 AM
    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 Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    6:29 AM
  3. eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    8:29 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
  4. Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    6:29 AM
    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

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    8:29 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    fix the table as there's no reason a single table needs 64+ keys !
     
  6. Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    6:29 AM
    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

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    8:29 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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
     
  8. Jimmy

    Jimmy Well-Known Member

    1,799
    391
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +999
    Local Time:
    6:29 AM
    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.