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.cope@gmail.com> wrote:
> Why would you choose innodb over xtradb?
>
> Eric
>
> On Feb 15, 2012, at 2:06 PM, "Bryan O'Neal" <Bryan.ONeal@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 <lisakachold@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
(text/plain)