MySQL Forums
Forum List  »  NDB clusters

is normal that a query simple in server node data send at 60Mb/s?
Posted by: David Garcia
Date: October 25, 2006 10:41AM

I finish of test, to executing a simple query:
table with: 512,077 register
query:
SELECT * FROM mensajes WHERE IDFORO =6 && mensajes.REF = mensajes.ID ORDER BY TIMETOPIC DESC LIMIT 0 , 5;

5 rows in set (40.53 sec)
and the server node data, send 60Mb/s contans during all 40 sg.
Total rates: 7196.9 kbytes/sec
7766.0 packets/sec
Incoming rates: 255.1 kbytes/sec
2749.8 packets/sec
Outgoing rates: 6942.5 kbytes/sec
5016.2 packets/sec


2 servers in cluster mysql work worse than 1 server only with mysql.I do not understand it.

I think a have some problem with configuration.

Thanks for your help.



Edited 5 time(s). Last edit at 10/25/2006 10:45AM by David Garcia.

Options: ReplyQuote


Subject
Views
Written By
Posted
is normal that a query simple in server node data send at 60Mb/s?
1582
October 25, 2006 10:41AM


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.