You can set max_connect_errors=9 to "disable" the host
blocking. It's common to do this with load balancers because tcp/ip
health checks count as connection errors.
-Eric
On Sat, Apr 11, 2009 at 1:01 PM, Shawn Green wrote:
>
> Hello Gary,
>
> Gary Smith wrote:
>>
>> Mike,
>> It's not a c
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
Hello Gary,
Gary Smith wrote:
Mike,
It's not a connection pooling issue per say. We have several boxes running
spam assassin, sqlgrey and postfix (via mysql). Normally these components work
great. SA and sqlgrey both have a fixed number of connections, around 16, that
they are generally
Craig Dunn wrote:
Hi,
I'm trying to migrate an application from 4.1 to 5.1, theres a bunch of
queries that seem to be failing and it looks like the order of INNER
JOIN's... for example...
SELECTetc
INNER JOIN tablex AS x ON y.foo = a.bar
INNER JOIN tablea AS a ON y.foo = b.bar
... w
Jerry Schwartz wrote:
This is a question that I run into frequently; I might even have posted it
before.
If I have three tables:
A: pub_product_id
B: product_id, publisher_id, pub_product_id
C: publisher_id, publisher_code
D: product_id, product_price
and I want to find those `pub_products` th
PJ wrote:
I am trying to select names from a list which depends on another table
for their ranking.
I want to retrieve all names that start with a Capital letter in
last_name and ranking of 1 and any other names that have a ranking of 2
but are both related to a third table.
tables: book(id,...et
syed basha wrote:
delimiter //
create procedure sample1(in p_item varchar(30),
in p_size varchar(6),
in p_quantity decimal(10,3),
in p_unit varchar(3),
in p_autoincrement varchar(30),
out v_mess varchar(50)
)
begin
declare done int default 0;
declare v_bhqty decimal(10,3);
decl
Hello Bob,
BobSharp wrote:
Picture does not seem to have been carried in the message, posts with
attachment did not seem to get through either.
So hope the link works.
Below is the ER diagram in an exercise I am trying to do.
http://www.probowluk.co.uk/images/er_ECA_001.jpg
It's been going
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
14 matches
Mail list logo
