Brian "Krow" Aker (krow) wrote,
Brian "Krow" Aker
krow

Peter Z's comments on PBXT, My own thoughts

LJ ate part of the post, so I am updating it with the original content.

I've not been posting a lot about my studies on bottlenecks in the
server and my work on what I am seeing with different engines, but I
thought I would comment on Peter's benchmarks on PBXT:
http://www.mysqlperformanceblog.com/2007/04/08/pbxt-benchmarks/

This is a bit off what I have found so far:
Picture 2.png

Picture 3.png

Picture 4.png

Picture 5.png



In all tests but the final, the task was to split a load among many connections and see how the engine behaved. PBXT's write performance is quite good. Its update crashed on me before I got to see how well it would perform and the scan read was awful. On the other hand its performance with mixed IO is quite good. For an engine at this point in its integration, these are all promising numbers. I've got little doubt about PBXT being an engine that people will use in production.

All numbers were performed on 5.1, and I used PBXT as a loadable engine (aka it was not statically compiled in).

If you are curious about the script I used to generate these numbers you can grab it here:
http://hg.tangent.org/bbench?ca=tip;type=gz
Subscribe
  • Post a new comment

    Error

    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 8 comments