2

I am quite new in MariaDB and I use SQLyog Community Edition as the frontend GUI. Whenever I create a new table, on the Engine dropdown, there is no XtraDB option. Is there any additional steps I am missing? As I've read, XtraDB is the InnoDB improved. How can I set my table to have that engine?

enter image description here

Here is my SHOW ENGINES result:

MariaDB [(none)]> SHOW ENGINES;

    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
    | CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
    | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
    | MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |
    | MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |
    | ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         |
    | FEDERATED          | YES     | FederatedX pluggable storage engine                                        | YES          | NO   | YES        |
    | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                     | NO           | NO   | NO         |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
2
  • I need a favor. Please login to MariaDB and run SHOW ENGINES. In the row that has InnoDB, look at the comment section. What does it say ??? – RolandoMySQLDBA Aug 12 '15 at 16:28
  • I have edited my post for your question, thanks buddy. – Dan_The_Man Aug 12 '15 at 16:30
1

By default, XtraDB is used as the InnoDB replacement.

If you login to MariaDB and run SHOW ENGINES;, look for the InnoDB.

According to the Documentation for SHOW ENGINES;:

Note that both MySQL's InnoDB and Percona's XtraDB replacement are labeled as InnoDB. However, if XtraDB is in use, it will be specified in the COMMENT field. See XtraDB and InnoDB. The same applies to FederatedX.

Based on your SHOW ENGINES; output, you are using XtraDB now.

In case you need to revert back to the original InnoDB, see Using InnoDB Instead of XtraDB. It discusses flipping the plugins and restart MariaDB.

As for XtraDB, you can read the Documentation.

I can tell you one thing that I wish MySQL's InnoDB had: MORE INFORMATION_SCHEMA

Check out the 5.5 and 5.6 INFORMATION_SCHEMA extensions for Percona and see how they compare to those in MariaDB.

To see which parts of XtraDB can be tuned and monitored (which InnoDB cannot do), look at this Pictorial Representation of InnoDB (originated by Vadim Tkachenko).

2
  • That was quick man, thanks. Additionally, mind if you give me some quick insights of benefits of XtraDB to InnoDB? – Dan_The_Man Aug 12 '15 at 16:32
  • More information than you could ever want or need on that topic :-) – Vérace Aug 12 '15 at 17:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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