Tagged: enfold
Hi,
Enfold prefer a database with MyISAM or InnoDB?
Or Mixed? For example: “wp_options”, “wp_usermeta”, “wp_comments” InnoDB and all the rest MyISAM?
Thanks
Hello macrunner!
As far as I know WordPress is using MyISAM table engine by default. Let’s wait for Kriesi’s response.
Best regards,
Ismael
Hi Ismael, thanks for your interest.
At the time I chose to use a mixed engine, MyISAM + InnoDB.
To be precise, I converted InnoDB the following tables: “wp_options”, “wp_usermeta”, “wp_comments” and everything else MyISAM.
In this way I should not consume a lot of RAM resources.
I have relied on the following article: http://www.dev4press.com/2011/tutorials/wordpress/practical/choosing-mysql-database-engine-myisam-or-innodb/
I wait for Kriesi’s response.
Thanks
Hello!
Truth to be told, I have never made any tests regarding this issue. I figured 99.999% of all users will stay on the default wordpress generated settings and therefore never made any attempts to check whats better. If you want to keep server resources low make sure to use a caching plugin like wp supercahce or w3total cache. This will gain you much more than chaning the database type :)
Cheers!
Kriesi