On Fri, Oct 29, 2010 at 1:25 PM, Josh Berkus
<josh@agliodbs.com> wrote:
Brian, My company is currently hitting a problem with mysql/innodb having
really slow insert performance (we're seeing ~1K rows/second).
My boss
wants to go and spend a bunch of money on the Tokutek backend.
<snip>
That seems like a really weak argument, unless Tokutek has come out with a stand-alone product I'm not aware of. At best you'll still need to deal with Oracle to get the MySQL bits, at worse Tokutek's technology is as good as it sounds and they are not an acquisition target for Oracle. (Assuming you don't want to deal with Oracle, which you're reasoning above implies. Many people won't care about that though).
> I've googled around for a while, but all the benchmarks I've found
commit one or more "fatal flaws", which render the benchmark pointless
at best:
Actually in this case, "real" benchmarks should be pretty easy. You already have a running application that you have numbers on. I'd say swap in a copy of xtradb, a copy of tokutek's tech, and a copy of Postgres (after all, it's only "5 minutes" to change the queries around), and benchmark all three. Realistically it would probably take a dedicated week to do it, but you're probably making a 3 year decision, so this bit of time up front seems like a good way to go. (And don't forget to publish your results afterwards).
Robert Treat
