First Industry-Standard Benchmark On 64-bit Linux

Haider writes "IBM has published two TPC-H benchmarks at the 100GB and 300GB scale factors (meaning the raw data in the database). The results are published at www.tpc.org/tpch/results/tpch_perf_results. The two results were published with exactly the same hardware and show scalability of the solution as more data is put on it. The system was a cluster of 8 2-way nodes running 2GHz AMD Opteron cpus with 6 GB of memory on each node. The OS was SLES 8 for AMD, and the database was 64-bit DB2 for Linux. The details of this solution are described in an article at infoworld.com."

Comments

Sun are cheap?

[stu_coates]

What stands out for me is that the cheapest platform from these results, across 100GB, 300GB, and 1000GB, is actually from Sun - look at the Price/QphH figures. So much for all the hype about Linux solutions being cheaper... although it does show that Linux solutions can be scaled very high when used in clusters.

Re:Cost? Can I do it cheaper?

[rtaylor]

You tell me how well MySQL handles the below in comparison to other DBs.

TPC-H is also about 25% writes / 75% reads on tables with billions of rows. I do hope you're not using a table lock for readers / writers. Frankly, I hope you're using some form of MVCC so writers do NOT block readers.

It also uses large parts of advanced SQL92 and SQL99 features (Subselects in the from clause being very common).

Common tricks to speed things up is to use prepared statements, compiled procedures, can be much faster than without (less network overhead, parsing, or plan generation).

Queries use for TPC-H like benchmark by OSDL. It is a pre-beta, but shows the types of queries you are dealing with.