Re: Example of Cluster SLOWER than InnoDB -- help?
I split the <queueName>_state table into three: one for get seqnums, one for put seqnums and one for the dirty flag. (Breaking the dirty update that depends on seqnums in the process, but I'm just messing around at this point.)
That really helped, Cluster is now 50% the speed of InnoDB. My guess is that the locking in NDB is much more complicated (and time consuming) in NDB since it involves message passing.
Profiling shows that a couple ms is spent waiting in each mysql_query() call. I guess the only way to get rid of that cumulative time is to execute the whole transaction with one mysqlclient API call -- which requires stored procedures?
Subject
Views
Written By
Posted
6490
December 07, 2004 11:48AM
Re: Example of Cluster SLOWER than InnoDB -- help?
3160
December 07, 2004 02:41PM
3279
December 07, 2004 07:42PM
3016
December 08, 2004 11:14AM
3052
December 08, 2004 04:50PM
5591
December 09, 2004 02:45PM
3015
December 07, 2004 03:39PM
2996
December 07, 2004 08:13PM
2999
December 07, 2004 11:51PM
2997
December 08, 2004 12:36AM
3113
December 08, 2004 03:55PM
3156
December 08, 2004 06:14PM
2966
December 08, 2004 09:27PM
3022
December 08, 2004 05:05PM
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.