MySQL Forums
Forum List  »  Oracle

Re: transfering data
Posted by: David Gornshtein
Date: November 17, 2004 12:27AM

Josh,

I think this issue is slightly more complicated.
3000 transactions per second = 180000 tpmC.
MySQL has no even single TPCC 4/5/5.1 and so on
certified benchmark dealing with such throughput.

Moreover, several months before we performed some tests to check
scalability of MySQL on n-way high end Sparc III SMP machines
Sorry to say that, but MySQL 4.0.xx scales up to 4-way SMP
and after 8 CPUs it's not scalable at all.

So, first I would like to be sure, that MySQL can handle this throughput.

In addition, You consider using client side TP monitor compatible software
to perform DML via two RDBMS instances in parallel - it's nice
but remember, that You will need to increase Your client CPU capabilities
and Your main Oracle server CPU capabilities too. Distributed XA
and two phase commit based transaction considerable increases load on
RDBMS server and requires much more work on client side too.

Let's assume that you are working with InnoDB which is only high performance
reliable storage engine You have in MySQL 4.0.xx.

If you are setting innodb_flush_log_at_trx_commit = 1, this means that
for 180000 tpmC, You might have up to 3000 IO sync/sec.

In addition, I would not seriously consider using Perl DBI as a client for 180000 tpmC
throughput.

Regards,
David.

Options: ReplyQuote


Subject
Views
Written By
Posted
4632
July 12, 2004 11:02PM
2786
July 24, 2004 07:57AM
2791
August 01, 2004 08:26AM
2865
August 05, 2004 10:15PM
2723
August 06, 2004 02:00AM
2722
August 09, 2004 04:15AM
2708
November 11, 2004 10:15PM
2791
November 17, 2004 12:42AM
2572
November 16, 2004 07:30PM
Re: transfering data
3224
November 17, 2004 12:27AM
3037
November 17, 2004 12:31AM
3184
November 17, 2004 01:53AM


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.