MySQL Forums
Forum List  »  Oracle

Re: transfering data
Posted by: Josh Chamas
Date: November 17, 2004 01:53AM

David Gornshtein wrote:
> 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.
>

I understand the point, but I believe the original poster meant actually 3000 transactions per second, not 3000 TPC-C style transactions which is not the common usage of "transaction". Its unlikely they meant 3000 TCP-C style transactions per your own analysis.

> 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

Of course, but I also suggested a possible near real time batching system that does not do parallel connections at the client or middle tier layers. I gave various scenarios that Jafni might apply from queue building, export/import, to real time replication frameworks outside the database, and each of these methods have their pros and cons, and may be applicable to Jafni's real requirements.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
4549
July 12, 2004 11:02PM
2746
July 24, 2004 07:57AM
2738
August 01, 2004 08:26AM
2819
August 05, 2004 10:15PM
2683
August 06, 2004 02:00AM
2665
August 09, 2004 04:15AM
2661
November 11, 2004 10:15PM
2750
November 17, 2004 12:42AM
2529
November 16, 2004 07:30PM
3171
November 17, 2004 12:27AM
2997
November 17, 2004 12:31AM
Re: transfering data
3138
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.