Thank you very much.
Could you tell me what is IIRC?
On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel m...@kiewel-online.ch 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
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
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 m...@kiewel-online.ch wrote:
Moon's Father wrote:
Hi.
If the server has 16 cores, how to set
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
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
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
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);
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:
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`
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
...
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
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
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
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 shawn.gr...@sun.com wrote:
Hello Gary,
Gary Smith wrote:
Mike,
It's
14 matches
Mail list logo