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 !