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
4541
July 12, 2004 11:02PM
2741
July 24, 2004 07:57AM
2729
August 01, 2004 08:26AM
2813
August 05, 2004 10:15PM
2676
August 06, 2004 02:00AM
2658
August 09, 2004 04:15AM
2655
November 11, 2004 10:15PM
2741
November 17, 2004 12:42AM
2525
November 16, 2004 07:30PM
Re: transfering data
3165
November 17, 2004 12:27AM
2992
November 17, 2004 12:31AM
3133
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.