Get the most out of your Centmin Mod LEMP stack
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,165
    256
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +626
    Local Time:
    4:18 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,165
    256
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +626
    Local Time:
    4:18 AM
    1.13.x
    MariaDB 10.1.x
  3. eva2000

    eva2000 Administrator Staff Member

    30,960
    6,918
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,419
    Local Time:
    7:18 PM
    Nginx 1.13.x
    MariaDB 5.5
  4. Jimmy

    Jimmy Premium Member Premium Member

    1,165
    256
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +626
    Local Time:
    4:18 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

    30,960
    6,918
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,419
    Local Time:
    7:18 PM
    Nginx 1.13.x
    MariaDB 5.5
    fix the table as there's no reason a single table needs 64+ keys !
     
  6. Jimmy

    Jimmy Premium Member Premium Member

    1,165
    256
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +626
    Local Time:
    4:18 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

    30,960
    6,918
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,419
    Local Time:
    7:18 PM
    Nginx 1.13.x
    MariaDB 5.5
    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,165
    256
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +626
    Local Time:
    4:18 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