59 messages in com.mysql.lists.clusterRe: Absurd results! ........ ! Why?
FromSent OnAttachments
Gurgen Petrosyan24 Aug 2004 06:32 
Crouch, Luke H.24 Aug 2004 06:56 
Crouch, Luke H.24 Aug 2004 21:49 
Magnus Svensson25 Aug 2004 01:58 
Lars Thalmann25 Aug 2004 04:21 
Gurgen Petrosyan25 Aug 2004 06:02 
Lars Thalmann25 Aug 2004 07:39 
Gurgen Petrosyan25 Aug 2004 13:29 
Tomas Ulin14 Sep 2004 02:37 
Tomas Ulin14 Sep 2004 05:20 
Gurgen Petrosyan14 Sep 2004 08:34 
Gurgen Petrosyan14 Sep 2004 10:32 
Gurgen Petrosyan14 Sep 2004 11:02 
Tomas Ulin16 Sep 2004 06:35 
Gurgen Petrosyan16 Sep 2004 12:38 
Gurgen Petrosyan16 Sep 2004 13:10 
Gurgen Petrosyan17 Sep 2004 12:56 
Gurgen Petrosyan17 Sep 2004 14:41 
Sharad Maloo20 Sep 2004 07:12 
Gurgen Petrosyan20 Sep 2004 13:39 
Magnus Svensson22 Sep 2004 05:28 
Bruce Robertson22 Sep 2004 10:00 
Gurgen Petrosyan22 Sep 2004 13:59 
Gurgen Petrosyan22 Sep 2004 14:21 
Gurgen Petrosyan22 Sep 2004 14:35 
Gurgen Petrosyan22 Sep 2004 14:39 
Gurgen Petrosyan22 Sep 2004 15:49 
Mikael Ronström23 Sep 2004 00:20 
Mikael Ronström23 Sep 2004 00:29 
Gurgen Petrosyan03 Oct 2004 11:32 
Crouch, Luke H.04 Oct 2004 06:12 
Gurgen Petrosyan04 Oct 2004 13:58 
pek...@mysql.com08 Nov 2004 05:16 
Gurgen Petrosyan08 Nov 2004 12:51 
Joseph E. Sacco, Ph.D.11 Nov 2004 05:18 
Gurgen Petrosyan11 Nov 2004 05:25 
Gurgen Petrosyan28 Nov 2004 08:47 
Jonas Oreland29 Nov 2004 00:15 
Klaus Byskov Pedersen18 Jan 2005 00:27 
Mikael Ronström18 Jan 2005 02:14 
Gurgen Petrosyan18 Jan 2005 07:21 
Gurgen Petrosyan18 Jan 2005 08:47 
Gurgen Petrosyan18 Jan 2005 09:00 
Gurgen Petrosyan18 Jan 2005 09:17 
Jon Stephens02 Feb 2005 09:03 
Mikael Ronström02 Feb 2005 11:21 
Gurgen Petrosyan02 Feb 2005 16:28 
Jon Stephens02 Feb 2005 18:16 
Jon Stephens07 Feb 2005 09:16 
Gurgen Petrosyan07 Feb 2005 10:18 
Gurgen Petrosyan09 Feb 2005 11:51 
Stefan Hinz23 Feb 2005 06:12 
Eric Bergen05 Mar 2005 11:36 
Gurgen Petrosyan05 Mar 2005 12:56 
Gurgen Petrosyan05 Mar 2005 14:00 
Gurgen Petrosyan05 Mar 2005 14:15 
Jon Stephens05 Mar 2005 18:20 
Jon Stephens07 Mar 2005 07:35 
Gurgen Petrosyan07 Mar 2005 11:39 
Subject:Re: Absurd results! ........ ! Why?
From:Jon Stephens (jo@mysql.com)
Date:03/05/2005 06:20:19 PM
List:com.mysql.lists.cluster

Cluster is going to be only as fast as your network between cluster hosts.

You can speed things up by making sure that all your networking hardware is using 100 and not 10 megabit mode. I got caught out by this recently in a non-Cluster setting - it's amazing how many Ethernet cards there are that still switch between 10 and 100 Mbit modes.

You can speed things up even more by using the SCI protocol rather than TCP/IP, but this involves obtaining special hardware. See http://dev.mysql.com/doc/mysql/en/sci-sockets.html for some info about this.

cheers

jon.

Eric Bergen wrote:

MySQL Cluster wasn't designed to be faster than a single machine. It was designed to be more reliable. If you read the main page for MySQL cluster you will see that the strengths listed are centered around high availability not raw speed (although it's still very fast).

http://www.mysql.com/products/cluster/

On Sat, 5 Mar 2005 18:00:52 -0400 (GMT+4), Gurgen Petrosyan <gur@ipia.sci.am> wrote:

Why we cannot will make sure in productivity MySQL Cluster in comparison with a local computer?

We have done many experiences on MySQL Cluster with 4 nodes And the same experiences by the local machine Have received absurd results!

By the local machine the base in 2Gb is processed in 2 times faster, than the same base on MySQL Cluster with 4 nodes

Why so have turned out? In what then advantage MySQL Cluster? If a database answers different inquiries much more slowly than by the local machine!

Please answer!

--------- Gurgen

-- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=eric@gmail.com

-- Jon Stephens Technical Writer, MySQL Documentation Team Brisbane, Australia Voice: +61 (7) 3388-2228 Email: jo@mysql.com MySQL AB www.mysql.com

Jumpstart your cluster! http://www.mysql.com/consulting/packaged/cluster.html