From: Andrew Morgan
Date: September 23 2010 11:26pm
Subject: RE: Performance and Scalability and cluster
List-Archive: http://lists.mysql.com/cluster/7778
Message-Id: <0608121c-a59d-4a17-9fb9-cc19d1fa4f0c@default>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Jeff,

 To get a feel for what is possible, Cluster benchmarks are published at ht=
tp://www.mysql.com/why-mysql/benchmarks/mysql-cluster/

Regards, Andrew.



Andrew Morgan | MySQL Senior Product Manager
Mobile: +447833483595=20
Web: www.clusterdb.com
United Kingdom

ORACLE Corporation UK Ltd is a company incorporated in England & Wales | Co=
mpany Reg. No. 1782505 | Reg. office: Oracle Parkway, Thames Valley Park, R=
eading RG6 1RA=20

Oracle is committed to developing practices and products that help protect =
the environment




> -----Original Message-----
> From: Adam Dixon [mailto:adamtdixon@stripped]
> Sent: 23 September 2010 14:59
> To: Schweiger, Jeff - ES
> Cc: cluster@stripped
> Subject: Re: Performance and Scalability and cluster
>=20
> Hello Jeff,
>=20
> On Fri, Sep 24, 2010 at 7:12 AM, Schweiger, Jeff - ES
> <Jeff.Schweiger@stripped> wrote:
> > Thanks for the response... One follow up question:
> >
> >>You know, 60k queries/min is not that large for cluster although it
> >>depends on the queries. =A0How is the load of your servers at 60k/s?
> =A0Can
> >>you estimate what will be the first bottleneck?
> >
> > I guess that is part of my problem... =A0I would like to get an idea
> how many queries cluster *can* handle. =A0At my current query rate, the
> load on my servers is very low. =A0I know performance is highly variable
> and is app dependant, hardware dependant and query type dependant. =A0For
> example, currently I am running on old Sun 2000's, and know I will get
> a boost if I go to a newer Intel multi core platform. =A0But I think I
> have tuned by app and cluster to perform well.
> >
> > So given a 4 data node 2 mysqld cluster, can I expect 500,000 queries
> per second, can I expect more? =A0I would love to know what type of
> performance people have seen.
>=20
> Due to all the specifics of any particular deployment, the only way to
> answer such a thing is to obtain more information about how your
> cluster is performing.
>=20
> Measure your loads (cpu/diskio), key query response times at
> 60,000/min. Then double your test load to 120,000 and measure the same
> data, and repeat until you either find a performance problem or a
> configuration limitation. This way you should get some profiling
> information and specific details about how your system will perform,
> with your app. Its simply not possible to compare generic benchmarks
> to your application.
>=20
> Some benchmark tools allow custom sets of queries to be run if you are
> unable to easily simulate your application loads.
>=20
> Adam
>=20
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=3Dandrew.morgan@stripped
>=20