Re: Example of Cluster SLOWER than InnoDB -- help?
I went and learned about mysql_set_server_option(MYSQL_OPTION_MULTI_STATEMENTS_ON) and mysql_next_result(). I think this saves a little back-and-forth latency.
I got rid of the dirty flag and restructured the transactions to get the same result from fewer statements.
I'm happy to report that I am now getting 96 messages sent and received (full contention-- that is, writer and reader looping as fast as possible) per second with Cluster vs. 147 with InnoDB. I was hoping that Cluster would do better than InnoDB and I think it will in a finished system with thousands of queue readers/writers and a multi-node cluster.
Does anyone have any thoughts on how this will scale? Will the inter-node locking negotiations slow it way down?
Subject
Views
Written By
Posted
6026
December 07, 2004 11:48AM
2905
December 07, 2004 02:41PM
Re: Example of Cluster SLOWER than InnoDB -- help?
3055
December 07, 2004 07:42PM
2783
December 08, 2004 11:14AM
2799
December 08, 2004 04:50PM
5349
December 09, 2004 02:45PM
2794
December 07, 2004 03:39PM
2780
December 07, 2004 08:13PM
2756
December 07, 2004 11:51PM
2793
December 08, 2004 12:36AM
2922
December 08, 2004 03:55PM
2914
December 08, 2004 06:14PM
2726
December 08, 2004 09:27PM
2802
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.