• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » InnoDB vs Percona XtraDB vs TokuDB Storage Engine For WordPress

By Abhishek Ghosh October 7, 2017 10:17 am Updated on October 7, 2017

InnoDB vs Percona XtraDB vs TokuDB Storage Engine For WordPress

Advertisement

This is not an article with lot of bar charts. I am no database expert but I can talk something about database which so called some “WordPress Experts” in their “professional services” possibly has no such options to the clients. Slow WordPress is quite common and blindly increasing RAM like work is not a solution. Talking about InnoDB vs Percona XtraDB vs TokuDB Storage Engine for WordPress is a Need. Our guides makes Percona XtraDB enabled by default, we are talking about guides like installing WordPress Nginx on Ubuntu 16.04LTS (which is officially suggested guide on WordPress documentation for Nginx PHP7-FPM). In older publications on this website we discussed about why to shift towards InnoDB from MyISAM, how to optimise InnoDB, how to utilise caching on InnoDB etc. If you know nothing, a complete n00b – InnoDB, Percona XtraDB, TokuDB are storage engine of MySQL servers. Original MySQL has various forks and most known are Original MySQL, MariaDB and Percona. We use Percona as Percona has hundreds of advantages like official paid support with same software. Percona XtraDB storage engine is patched version of InnoDB. We say “InnoDB” instead of saying “Percona XtraDB” as later is more practical, when we are not talking about one website, one database server on same web server. Running database server on hardware without much calculation itself a bottleneck. If you are :

  1. using our any guide published after 2015, then all are Percona XtraDB enabled
  2. using our any guide published after 2015, then all are InnoDB enabled (just a matter of name to a n00b)
  3. using Percona MySQL server with innodb directives from guides other than us then then all are Percona XtraDB hence InnoDB enabled
  4. trying to optimise or experiment then take backup

We have not talked about TokuDB so far before.

InnoDB vs Percona XtraDB vs TokuDB Storage Engine For WordPress

 

InnoDB vs Percona XtraDB vs TokuDB Storage Engine For WordPress

 

Under normal circumstances, tuning Percona Server’s InnoDB aka XtraDB should be enough to deliver good performance. TokuDB is not exactly “mainstream”. After login to MySQL Server, if we run :

Advertisement

---

Vim
1
show engines;

that returns some read only information around the engine under use.

Vim
1
show plugins;

will return some read only information around the installed plugins. Now, at this point one must take backup of database, test that backup and then proceed. We think to migrate from InnoDB to TokuDB only on cluster, not single server.

These are helpful guides to install TokuDB for Percona:

Vim
1
2
https://www.percona.com/doc/percona-server/LATEST/tokudb/tokudb_installation.html
https://www.percona.com/blog/2014/06/26/percona-server-with-tokudb-beta-installation-configuration/

Likewise, for MariaDB the command to install TokuDB is like :

Vim
1
INSTALL SONAME 'ha_tokudb';

The file /etc/mysql/conf.d/tokudb.cnf will need to have settings like :

Vim
1
2
3
4
5
6
7
8
9
10
11
12
[mariadb]
 
#plugin-load=ha_tokudb.so
 
tokudb_cache_size=300GB
tokudb_commit_sync=off
tokudb_fsync_log_period=1000
tokudb_directio=ON
tokudb_disable_slow_alter=ON
tokudb_disable_hot_alter=OFF
tokudb_load_save_space=ON
tokudb_row_format=tokudb_fast

Then restart MariaDB.

Vim
1
2
3
MariaDB [(none)]> use target_database-name;
Database changed
MariaDB [target_database-name]> alter table user_data engine=tokudb;

InnoDB is easy name for MariaDB or whatever’s Percona XtraDB and TokuDB is definitely not for the n00b. That is difference. Obviously TokuDB has some positive points as from point of performance otherwise would not be developed as new thing.

But for who do not need cluster, Percona with optimised InnoDB/XtraDB is enough for WordPress. That is what we written as guides where question of “official” arises.

Tagged With paperuri:(d132a67b3bdeb3dc8e2be1ffda323bcf) , percona tokudb tutorial , tokudb extradb innodb , tokudb vs xtradb , XtraDB and InnoDB

This Article Has Been Shared 477 Times!

Facebook Twitter Pinterest
Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Orthopaedic Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to InnoDB vs Percona XtraDB vs TokuDB Storage Engine For WordPress

  • Adding Schema.org Structured Data in Genesis Theme

    Adding Schema.org Structured Data in Genesis Theme without using any plugin is quite easy as Genesis has great documentation and has excellent existing markups.

  • How to Use Google Data Highlighter and Other Points

    How to Use Google Data Highlighter has been shown as a detailed guide video to tag a set of webpages who can not relate them by HTML tagging. But it has flaws.

  • HTML5, WordPress and Cloud : What We Learnt From Redesign

    HTML5, WordPress and Cloud – with new redesign,not complete yet at the time of publishing this post we learnt important points with this old blog with 5K posts.

  • WordPress Lost Post Recovery Options on Cloud

    WordPress Lost Post Recovery Options Are Not Less in Number on Cloud, Even Without Backup Failure. If Your FTP Server is Running, Data Can Be Recovered.

  • Disabling XMLRPC, SMTP on WordPress For Security

    WordPress is NOT a secured Web Software by Default. On Cloud Computing Platforms Disabling XMLRPC, SMTP on WordPress For Security is Important.

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

You can subscribe to our Free Once a Day, Regular Newsletter by clicking the subscribe button below.

Click To Subscribe

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (21K Followers)
  • Twitter (5.3k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • Best Powerpoint Templates for Communicating IoT Concepts April 17, 2021
  • How to Build a DIY Water Level Indicator? April 16, 2021
  • How Startups Can Convince the Investors April 14, 2021
  • What to Know About the Cloud Storage Services for Smartphones April 13, 2021
  • WonderFox HD Video Converter Factory Pro Review April 10, 2021

 

About This Article

Cite this article as: Abhishek Ghosh, "InnoDB vs Percona XtraDB vs TokuDB Storage Engine For WordPress," in The Customize Windows, October 7, 2017, April 19, 2021, https://thecustomizewindows.com/2017/10/innodb-vs-percona-xtradb-vs-tokudb-storage-engine-for-wordpress/.

Source:The Customize Windows, JiMA.in

 

This website uses cookies. If you do not want to allow us to use cookies and/or non-personalized Ads, kindly clear browser cookies after closing this webpage.

Read Cookie Policy.

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2021 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy