In the past, InnoDB has problem with SMP machine, is this problem
sovled yet? If yes, in what version?

THanks.

howa <howachen@gmail.com> wrote:

> In the past, InnoDB has problem with SMP machine, is this problem
> sovled yet? If yes, in what version?

I guess you're talking about bug #15815

(http://bugs.mysql.com/bug.php?id=15815)

This was fixed in 5.0.30.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

On 10 22 , 7 51 , Axel Schwenke <axel.schwe...@gmx.de> wrote:
> I guess you're talking about bug #15815
>
> (http://bugs.mysql.com/bug.php?id=15815)
>
> This was fixed in 5.0.30.
>
> XL
> --
> Axel Schwenke, Support Engineer, MySQL AB

Two questions:

1. How about MySQL 4? Which version is this bug fixed?
2. Is this fix a complete fix? I still see recent articles/post such
as http://mysqlha.blogspot.com/2007/08/...or-innodb.html
are still are still talking about this issue, so I am not sure if
SMP's problem are really resolved.

Thanks

howa <howachen@gmail.com> wrote:
> On 10 22 , 7 51 , Axel Schwenke <axel.schwe...@gmx.de> wrote:
>> I guess you're talking about bug #15815
>>
>> (http://bugs.mysql.com/bug.php?id=15815)
>>
>> This was fixed in 5.0.30.
>
> Two questions:
>
> 1. How about MySQL 4? Which version is this bug fixed?

Why don't you just click at the link above
and read? It's *all* there!

> 2. Is this fix a complete fix? I still see recent articles/post such
> as http://mysqlha.blogspot.com/2007/08/...or-innodb.html
> are still are still talking about this issue, so I am not sure if
> SMP's problem are really resolved.

Why don't you just click at the link above
and read? There is also discussion going on.

Why do you think the blog of some unknown guy
is a better place to discuss MySQL bugs than
the public MySQL bugtracker? And BTW I don't
see anything in this blog besides that InnoDB
*had* scalability issues in the past and the
(wrong) assumption InnoDB would try to solve
that by limiting the number of active threads
in the engine.

That limit was *always* there and for good
reason. It is *not* connected with bug 15815.


PS: it was always *safe* to run InnoDB on SMP
systems. The above bug is about scalability.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/