MySQL Forums
Forum List  »  Memory Storage Engine

Not seeing expected performance increase in TPC-C
Posted by: Andy Pavlo
Date: January 10, 2008 10:38AM

I am trying to use an open-source implementation of the TPC-C benchmark against MySQL's Memory engine (http://osdldbt.sourceforge.net). It is a dual core Linux machine with 2GB of RAM. I am using the 'my-large.cnf' sample configuration file but I added 'max_heap_table_size = 1024M'. I run the exact same benchmark on the same configuration and data and compare the results between the InnoDB, MyISAM, and Memory engines. Unfortunately, I am not seeing the dramatic speed increase that one would expect with a memory only database.

The following numbers are with using 10 warehouses in the benchmark:

InnoDB on Disk: 126.68 TPM
MyISAM on Disk: 128.07 TPM
Memory - Hash Indexes: 76.40 TPM
Memory - BTree Indexes: 129.08 TPM

I think the problem must be with my configuration file, but I am not sure. I am going to try the SolidDB engine later today, but I wanted to first see if anybody had any thoughts about what I might be doing wrong.

Options: ReplyQuote


Subject
Views
Written By
Posted
Not seeing expected performance increase in TPC-C
6956
January 10, 2008 10:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.