Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By norio on
I run a large site (article directory with 80,000+ articles) using Drupal. What tables are recommended/safe to convert to InnoDB?
Comments
i'd like to know as well
*bump*
Im not running a site quite as large, but i have been looking into converting some of the tables to innoDBm but im not sure which ones i should or should not convert. I have read the I do not want to convert the node revisions table as it uses fulltext which innodb does not support. I have also hear you should only do it on heavy trafficked tables such as the node tables and tables dealing with comments. But I still havent read anything difinitive and am looking for some advice on what tables should and shouldnt be InnoDB
Moving from MyISAM to INNODB
I have a site that has around 70000 nodes and around 50000 visitors per day. The DBA suggested moving to innodb because of performance considerations. I see that innodb does not support full text searches. But at the same time I see that D7 has moved to innodb as the default database. Can anybody please confirm if it is OK to convert all the tables in my D6 db to innodb?
Thanks
Anoop
--
www.zyxware.com
from what i remember, there
from what i remember, there were some tables that you didnt want as innodb. but it escapes me on which ones they were.