Sorry for the late reply Well... To be quite frank it does not provide any features we need and is not worth the risk (real, perceived, or as dictated by a legal and accounting department with or without expensive technical research and trials). We support many thousands of servers (large, physical servers) and millions of databases. Switching engines is not something to take lightly. If we used fusion IO (oh how nice that would be) then perhaps. But even then the percona patched innodb is very close in performance. Remember, percona has a lot of features in there innodb that are not stock, fast and effective compression, asynchronous drops, better purge performance, etc, etc, etc. We just don't need to worry about the xtra layer. Which, depending on use case, can hinder performance by spinning additional cpu cycles without increasing throughput.
So I guess I have to ask. Why do you use xtradb? What is in xtra that compels you to use it? Also which innodb engine were you using before you switched? On Wed, Feb 15, 2012 at 2:28 PM, Eric Cope <eric.c...@gmail.com> wrote: > Why would you choose innodb over xtradb? > > Eric > > On Feb 15, 2012, at 2:06 PM, "Bryan O'Neal" > <bryan.on...@theonealandassociates.com> wrote: > >> I still use innodb but definitely recomend percona. The percona builds >> and patches of mysql are top notch. >> >> >> On 2/12/12, Lisa Kachold <lisakach...@obnosis.com> wrote: >>> Has anyone used Percona? >>> >>> http://www.percona.com/software/ >>> >>> >>> - Percona Server with >>> XtraDB<http://www.percona.com/software/percona-server/>is our database >>> server, with high performance and scalability >>> - Percona >>> XtraBackup<http://www.percona.com/software/percona-xtrabackup/>is >>> the world's only open-source hot backup solution for InnoDB and XtraDB >>> - Percona XtraDB <http://www.percona.com/software/percona-xtradb/> is >>> our high-performance storage engine for MySQL, based on InnoDB >>> - Percona XtraDB >>> Cluster<http://www.percona.com/software/percona-xtradb-cluster/>is a >>> new high availability and high scalability solution for MySQL users. >>> - Percona Data Recovery Tool for >>> InnoDB<http://www.percona.com/software/mysql-innodb-data-recovery-tools/>is >>> a set of tools for recovering data from InnoDB's data files >>> - The tcprstat tool <http://www.percona.com/docs/wiki/tcprstat:start> is >>> a TCP response-time analysis tool >>> - Percona LogJam >>> <http://www.percona.com/docs/wiki/percona-logjam:start>is a >>> high-performance workload reproduction tool >>> - Percona Tools <https://launchpad.net/perconatools> includes clones of >>> the standard TPC-C and TCP-E benchmarks designed for MySQL >>> - The benchworks tool >>> <http://www.percona.com/docs/wiki/benchworks:start>is a framework for >>> rapidly creating benchmarks and analyzing the results >>> - Percona Toolkit <http://www.percona.com/software/percona-toolkit/> is >>> a collection of advanced command-line tools used by Percona support staff >>> to perform a variety of MySQL and system tasks that are too difficult or >>> complex to perform manually >>> >>> It's pretty impressive. >>> >>> >>> >>> >>> >>> >>> -- >>> (503) 754-4452 Android >>> (623) 239-3392 Skype >>> (623) 688-3392 Google Voice >>> ** >>> it-clowns.com >>> >> >> -- >> Sent from my mobile device >> --------------------------------------------------- >> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us >> To subscribe, unsubscribe, or to change your mail settings: >> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss