What's the best database setup for WordPress for speed and lots of posts (hundred thousands of rows in posts and post_meta tables)?

While I can cache as much as I can and optimize my queries/PHP as far as can go, such as in the answer for How to Optimize WP site for millions of posts (am in a very similar situation with the OP of that question), that's only one part of optimizing querying loads of rows with speed.

Am thinking of trying to test/benchmark mySQL with tokudb (http://www.tokutek.com/tokudb-for-mysql/), MariaDB (https://mariadb.org/), and MariaDB with tokuDB. Am curious if anyone has tried/tested these or any other replacement DBs with WordPress, can share results, and recommend their fastest setup.

  • I would caution against considering anecdotal evidence for performance decisions. You need your own baseline benchmark for starters — what you have working already, how well does it perform, what are specific operations or functions that are bottlenecking. – Rarst Jan 18 '15 at 16:23
  • Yes. I plan to benchmark everything locally before even thinking of implementing anything. – forlogos Jan 19 '15 at 17:36

You may wish to post this same query in the TokuDB-users community here... https://groups.google.com/forum/#!forum/tokudb-user

Good luck with your research.

-dave

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.