• 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 153 Times!

Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, 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

Get new posts by email:

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 (24.3K Followers)
  • Twitter (5.8k 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

  • The Importance of Voice and Style in Essay Writing April 1, 2023
  • What Online Casinos Have No Deposit Bonus in Australia March 30, 2023
  • Four Foolproof Tips To Never Run Out Of Blog Ideas For Your Website March 28, 2023
  • The Interactive Entertainment Serving as a Tech Proving Ground March 28, 2023
  • Is it Good to Run Apache Web server and MySQL Database on Separate Cloud Servers? March 27, 2023

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 2, 2023, https://thecustomizewindows.com/2017/10/innodb-vs-percona-xtradb-vs-tokudb-storage-engine-for-wordpress/.

Source:The Customize Windows, JiMA.in

PC users can consult Corrine Chorney for Security.

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

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

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

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT