SeaTea Posted February 6, 2016 Share Posted February 6, 2016 I am testing for a new installation of IPB4 and started with a fresh install. I am using Mariadb 10 on a 4GB,2-Xeon,SSD VPS. I wanted to use innodb so I tried to convert all tables of the fresh database from MYISAM to INNODB. For 2 of the tables (cms_databases and cms_page_widget_areas) this is not possible as I get an SQL Error 1071: "Specified key was too long; max key length is 767 bytes ". I am using utf8mb4. I found some info via google on this error. Maybe it can be solved by enabling innodb_large_prefix setting, but I do not want to change things too much to have a risk of incompatibility in the future. So I like to keep the IPBoard installation as simple as possible but with good performance. So like to know what others use, which tables do you have changed to innodb. This (now VB3.8) forum is not extremely busy, usually around 10K visitors a day and normally about 400 users online during peak hours and about 500K posts. What would be your advise: stick with MYISAM, change to Innodb and if so what tables. If all tables are advised, then how did you solve the 767 bytes error ? Link to comment Share on other sites More sharing options...
ASTRAPI Posted February 15, 2016 Share Posted February 15, 2016 You should convert all tables to Innodb and you will be fine with the innodb_large_prefix setting and you will get incompatibility only if you want later to downgrade but all we go forward Link to comment Share on other sites More sharing options...
SeaTea Posted February 15, 2016 Author Share Posted February 15, 2016 Thanks ! I have converted all tables with large_prefix setting now. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.