MySQL Forums
Forum List  »  NDB clusters

Re: Example of Cluster SLOWER than InnoDB -- help?
Posted by: John Muehlhausen
Date: December 07, 2004 07:42PM

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?

Options: ReplyQuote

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.