Implication in Increasing MySQL maximum keys allowed per table
0
votes
0
answers
980
views
We have a situation where we encounter a MySQL error
> **ERROR 1069:** Too many keys specified. Max 64 keys allowed
In our database (using Magento E-commerce) we need to add 76 indexed key columns but we are not allowed to add more than 64 keys, which is the maximum limit allowed.
So we have decided to increase the maximum limit to 80 by recompiling the MySQL / MariaDB, in that case what would be the implications ?
Kindly let me know if you need more server resource details.
Thank you !
Asked by Haijerome
(111 rep)
Sep 24, 2019, 09:00 AM