Thanks for you reply.
I read the official document and found the variable called
"thread_concurrency" could only affect on solaris.
On Sat, Apr 11, 2009 at 5:04 AM, mos wrote:
> At 06:00 AM 4/10/2009, you wrote:
>
>> Hi.
>> If the server has 16 cores, how to set parameters to make MySQL runs
il 10, 2009 8:00 PM
To: MySql
Subject: MySQL runs on 16-cores server
Hi.
If the server has 16 cores, how to set parameters to make MySQL runs
well.
Any reply is appreciated.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
--
MySQL General Ma
-Original Message-
From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf
Of Baron Schwartz
Sent: dinsdag 14 april 2009 15:18
To: mos
Cc: Jerry Schwartz; Andy Smith; mysql@lists.mysql.com
Subject: Re: MySQL runs on 16-cores server
Mike,
> Now the SSD that I would l
Mike,
> Now the SSD that I would like to have is the Hyperdrive 5 from
> http://www.hyperossystems.co.uk/. It is a DDR SSD and each drive has slots
> for 8 DIMM's which means it can hold up to 32GB (64GB if you can find 8GB
> DDR2's) per drive. They can be striped to give you a heck of a lot of dr
At 02:21 PM 4/13/2009, Baron Schwartz wrote:
Mike,
> MySQL does not scale well beyond 4 processors, at least not like PostgreSql
> does. MySQL seems to hit a plateau rather quickly. If XtraDb's modified
> Innodb plugin scales better, then fine. But I haven't seen any benchmarks
> showing the sp
On Mon, Apr 13, 2009 at 8:34 PM, David Sparks wrote:
>> Right now if you want a more scalable *current* version of
>> MySQL, you need to look to the Google patches, the Percona builds (and
>> Percona XtraDB, a fork of InnoDB), or OurDelta builds.
>
> Is there a webpage somewhere that compares and
> Right now if you want a more scalable *current* version of
> MySQL, you need to look to the Google patches, the Percona builds (and
> Percona XtraDB, a fork of InnoDB), or OurDelta builds.
Is there a webpage somewhere that compares and contrasts the above patchsets?
I thought the Google patches
On Mon, April 13, 2009 11:55, mos wrote:
> Jerry,
>
> At 09:53 AM 4/13/2009, Jerry Schwartz wrote:
>>Sorry for top-posting, but this is getting unwieldy.
>>
>>The problems with hardware in multiprocessor systems have been dealt with
>>long since, assuming that Intel, AMD, et al have implemented the
Mike,
> MySQL does not scale well beyond 4 processors, at least not like PostgreSql
> does. MySQL seems to hit a plateau rather quickly. If XtraDb's modified
> Innodb plugin scales better, then fine. But I haven't seen any benchmarks
> showing the speed improvements relative to the number of proc
ent: Saturday, April 11, 2009 5:07 PM
>To: Andy Smith
>Cc: mysql@lists.mysql.com
>Subject: Re: MySQL runs on 16-cores server
>
>At 08:27 AM 4/11/2009, Andy Smith wrote:
>>Hi,
>>
>> In what way can having more cores slow down MySQL (or any other app
>>for that
FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Original Message-
>From: mos [mailto:mo...@fastmail.fm]
>Sent: Saturday, April 11, 2009 5:07 PM
>To: Andy Smith
>Cc: mysql@lists.mysql.com
>Subject: Re: MySQL runs on 16-cores server
>
At 08:27 AM 4/11/2009, Andy Smith wrote:
Hi,
In what way can having more cores slow down MySQL (or any other app
for that matter)? Are you simlpy referring to the fact that some
mutlicore servers might be slower in single threaded preformance than
a higher clocked single core system? If I have
Andy, one reason (in addition to slower clock speeds per core) that a
system with more cores might be slower than an equivalently fast single
processor is memory bandwidth and communications bottlenecks between
cores. Synchronization of multiple database processes and accesses to
shared data a
MySQL isn't multi-process, it's single-process and multi-threaded.
A lot of work is going into making it scale better on SMP machines.
Much of this is to be released in future versions of MySQL. The
Drizzle developers are also doing a lot of good work, but that's in
Drizzle. Right now if you wan
Hi,
In what way can having more cores slow down MySQL (or any other app
for that matter)? Are you simlpy referring to the fact that some
mutlicore servers might be slower in single threaded preformance than
a higher clocked single core system? If I have a mutlicore system with
fast sing
Moon's Father wrote:
> Thank you very much.
> Could you tell me what is IIRC?
If I remember correctly.
HTH,
Uwe
>
>
>
> On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel wrote:
>
> Moon's Father wrote:
> > Hi.
> >If the server has 16 cores, how to set parameters to make
At 02:03 AM 4/11/2009, you wrote:
Thank you very much.
Could you tell me what is IIRC?
IIRC = "If I Recall Correctly". I don't know why he didn't write it out in
full, it would have caused less confusion. For a second there I thought he
was talking about MS's predecessor to IIS. :-)
Mike
Thank you very much.
Could you tell me what is IIRC?
On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel wrote:
> Moon's Father wrote:
> > Hi.
> >If the server has 16 cores, how to set parameters to make MySQL runs
> > well.
>
> IIRC is mysqld multi threaded - so if you have parallel queries, mys
At 06:00 AM 4/10/2009, you wrote:
Hi.
If the server has 16 cores, how to set parameters to make MySQL runs
well.
Any reply is appreciated.
Using more cores with MySQL doesn't mean it will run faster. In fact, it
could slow it down. Make sure you have done benchmarking with your current
com
On Fri, Apr 10, 2009 at 10:40 AM, Wm Mussatto wrote:
> On Fri, April 10, 2009 05:24, Uwe Kiewel wrote:
>> Moon's Father wrote:
>>> Hi.
>>> If the server has 16 cores, how to set parameters to make MySQL runs
>>> well.
>>
>> IIRC is mysqld multi threaded - so if you have parallel queries, mysqld
On Fri, April 10, 2009 05:24, Uwe Kiewel wrote:
> Moon's Father wrote:
>> Hi.
>>If the server has 16 cores, how to set parameters to make MySQL runs
>> well.
>
> IIRC is mysqld multi threaded - so if you have parallel queries, mysqld
> will spam multiple threads across multiple cores.
---^^
Moon's Father wrote:
> Hi.
>If the server has 16 cores, how to set parameters to make MySQL runs
> well.
IIRC is mysqld multi threaded - so if you have parallel queries, mysqld
will spam multiple threads across multiple cores.
HTH,
Uwe
--
MySQL General Mailing List
For list archive
22 matches
Mail list logo
