MySQL Forums
Forum List  »  Stored Procedures

Re: How many record insertions per second are typical?
Posted by: Jay Pipes
Date: November 07, 2005 09:18AM

peter.hamilton-scott wrote:
> 1. Is what I got fairly typical, within the curve,
> for InnoDB?

No way to answer this question without benchmarking on your platform, viewing the exact code, setting up a test environment and running benchmarks against same code, etc... So many different variables, it's impossible to make a guess.

> 2. Would it have been any faster using MyIsam?

Probably, since there is no need for the transactional container. But again, you'd have to test it. come to think of it, it would be good to test it without using a stored procedure as well. Currently, stored procedures produce a small performance penalty because of some overhead.

> 3. Is there a kind of unofficial world record for
> inserting records per second?

The TPC (Transaction Processing Performance Council) benchmarks are generally considered to be the gold standard for the who's who in the database world. But remember, the machines used to generate these benchamrks are *highly* tuned and *very* expensive in general. (http:tpc.org) The measurements are always in tpm/c which are complete business transactions per *minute*. The current record holder is 3,210,540 transactions per minute (IBM DB2 on eServer platform)

so, sad to say, your results are slightly below the world record :) But, hey, don't give up :)

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How many record insertions per second are typical?
2341
November 07, 2005 09:18AM


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.