Gabriel Torres Posted July 26, 2014 Share Posted July 26, 2014 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 More sharing options...
p4guru Posted July 26, 2014 Share Posted July 26, 2014 Percona XtraDB = InnoDB :) Link to comment Share on other sites More sharing options...
Makoto Posted July 26, 2014 Share Posted July 26, 2014 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 More sharing options...
Gabriel Torres Posted July 26, 2014 Author Share Posted July 26, 2014 Thanks for the confirmation, guys! Link to comment Share on other sites More sharing options...
xtech Posted July 27, 2014 Share Posted July 27, 2014 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 More sharing options...
Gabriel Torres Posted July 28, 2014 Author Share Posted July 28, 2014 xtech, too soon to say, as I made this move during the weekend, when our traffic is very low. I should have a better opinion by the end of the week. However, I've seen an improvement for DB-intensive tasks, such as searching for a specific item using the mysql console. Link to comment Share on other sites More sharing options...
xtech Posted July 29, 2014 Share Posted July 29, 2014 Nice! I am also considering move to percona in a near future. Link to comment Share on other sites More sharing options...
Makoto Posted July 31, 2014 Share Posted July 31, 2014 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.