I made some tests on recreating Indexes. So, I'm running on PHP 7.3.24 + MariaDB 10.3.24
- Without adding index limit photos.app.goo.gl/rXEbkvR1EqVAYADj8
I have back a #1071 error
But, as far as I know, Maria 10.3.24 has been built on MySQL 5.7 and the prefix limitation should be 3072 and not 1000 (or 767)
Please, What am I missing ?
- If I add the index with the Key Block Size to 1000: photos.app.goo.gl/Y9axQb3HGsqMP42TA
I have back the same #1071 error
- If I add the Index with Sizes:
I have back the same #1089 error
- If I add just the URL limit in this way: 1000 - (55*4) / 4 = 195
The limit it has accepted, Is this the right way ?
All your suggestions are welcome! Many thanks!