Jump to content

Recommended Posts

Hi guys,

I've just upgraded to Percona (thanks all for the suggestion), and I was just wondering how to upgrade to XtraDB. From what I understood, on Percona, InnoDB is automatically replaced with XtraDB, as we can check with SHOW ENGINES;, so no extra step is required to use XtraDB.

Can someone confirm this?

Thanks,

Gabriel.

Link to comment
Share on other sites

As long as you see XtraDB is loaded with SHOW ENGINES,

+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+

You're using XtraDB. It should be loaded by default.

Link to comment
Share on other sites

Hi guys,

I've just upgraded to Percona (thanks all for the suggestion), and I was just wondering how to upgrade to XtraDB. From what I understood, on Percona, InnoDB is automatically replaced with XtraDB, as we can check with SHOW ENGINES;, so no extra step is required to use XtraDB.

Can someone confirm this?

Thanks,

Gabriel.

Gabriel, do you confirm the performance improvement with percona?

Link to comment
Share on other sites

I've definitely seen a lot of performance benefits when migrating from MySQL to MariaDB (which was a very long time ago), and even more so when upgrading from MariaDB 5.5 to MariaDB 10.0.

I'd personally advocate migrating to MariaDB over Percona, but that's just my personal bias.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...