Database Tests

MySQL 4.0.20d has been a staple of our Linux tests since its inception. Even though it does not carry high relevance for a workstation test, we still regard it as the de facto free, open sourced benchmark for Linux. Below, you can see our results for sql-bench on both the 64-bit and 32-bit kernels for SuSE 9.1.

Hold your mouse over for the 64-bit graph.

Hold your mouse over for the 64-bit graph.

We already see some exciting trends with this benchmark. For one, the 64-bit MySQLd appears to be much faster than the 32-bit one (mouse over the graphs to see the difference). Since the above benchmarks were done without HyperThreading, we enabled it in the graph below.

HyperThreading: 32-bit MySQL 4.0.20d - Test-Select

HyperThreading: 32-bit MySQL 4.0.20d - Test-Insert

We expect to see a performance increase with HyperThreading - SQL servers must thread well. Unfortunately, the sql-bench benchmark is more to blame than anything else, and it does not thread realistically. As we validate a new benchmark for this portion of our Linux benchmark suite, sql-bench will do, but keep in mind that its extremely synthetic behavior.

Index Rendering Benchmarks
Comments Locked


View All Comments

  • ravedave - Monday, September 20, 2004 - link

    What klah is trying to say in too many and too big of words : Make the scale the same for the mouseover pics.

    Also make the picture height the same as well if possible.

    Otherwise a very good article.

    Has anyone thought of making an open office benchmark for linux?

  • klah - Monday, September 20, 2004 - link

    Good article, but I have a comment on the mouse-over graphs. They work well in other articles such as the recent DVR-108D article where the scale and axes remain constant. In this case however the layout and in some cases even the scale are different between the two graphs. It would be easier to compare the two if the scale was the same and processors were in the same layout(spacing/location), with the inapplicable processors still listed to maintain the same appearance between the two.

    If that explanation is nonsensical I can create a few images to try to elucidate my point.

  • Decoder - Monday, September 20, 2004 - link

    "Hold your mouse over for the 64-bit graph."

    I like to see the 32 and 64 bits on the same graph. Why not use Athlon FX-53 (32) and Athlon FX-53 (64) for labels?

Log in

Don't have an account? Sign up now