search

apavlo / h-store

H-Store Distributed Main Memory OLTP Database System
https://hstore.cs.brown.edu
GNU General Public License v3.0
567 stars 177 forks source link

Problem with auctionmark benchmark execution #138

Open saurabhagas opened 11 years ago

saurabhagas commented 11 years ago

The auctionmark benchmark seems to get stuck for hours at this point (see screenshot) at every run. Can you tell me possible reasons and solution? image

Also 'seats', 'wikipedia' and 'ycsb' have some erratic behavior. They run after repeated unsuccessful attempts. Are there any specific configuration settings for each benchmark? If not, what's the reason? The server I'm ssh-ing into had 32 GB of RAM, so memory is not a problem.

apavlo commented 11 years ago

What are you trying to do? Is there a specific project that you are working on? Or if you're just curious about running the system, then I recommend using the TPC-C, TM1, SmallBank, or Voter benchmarks. Those are the most stable.

saurabhagas commented 11 years ago

Thanks for the quick reply. I've noted what you said about auctionmark and wikipedia.

About seats and ycsb, their loading of tables fails most of the times. Sometimes the polling of localhost sites fails. ycsb was very slow, and it took around an hour to load all the tuples. Is it the expected behavior?

I'm was reading about OLTP one day and I came across h-store. The concept of purely in-memory databases seemed fascinating to me. I and a few of my friends took it as an exercise to test run it and see the memory access patterns. There is no idea of a project as such yet.

On 29 July 2013 20:12, Andy Pavlo notifications@github.com wrote:

-

The current version of AuctionMark in H-Store is a bit buggy. There is a newer/better/faster version in OLTP-Benchhttp://oltpbenchmark/oltpbenchthat I need to port back to H-Store.

SEATS and YCSB should be working. What are the problems that you are seeing?

Wikipedia has a lot of multi-partition transactions, which are going to be slow. It's not a good benchmark to use in this system.

What are you trying to do? Is there a specific project that you are working on? Or if you're just curious about running the system, then I recommend using the TPC-C, TM1, SmallBank, or Voter benchmarks. Those are the most stable.

— Reply to this email directly or view it on GitHubhttps://github.com/apavlo/h-store/issues/138#issuecomment-21724513 .