Re: Bug #37411 - Threads staying in the "Sending Data" for long periods of time

Hi Ji=C5=99=C3=AD,

> i've got the same problem as described in bugreport of the Bug #374=
11 -
> Threads staying in the "Sending Data" for long periods of time (
> http://bugs.mysql.com/bug.php?id=3D37411) with MySQL 5.0.67 on Sola=
ris on Sun
> X4200 M2.
> I'm not able to bypass the problem by setting
> innodb_thread_concurrency=3D1
> because application running above the database has bigger frequency=
 of
> queries than server can supply. Im not able to set value higher tha=
n "1",
> because queries will be very slow  (as result of the bug). AFAIK th=
ere are
> only two options:
> 1) apply a patch
> 2) upgrade to MySQL

I do not know any specific patch, as the reason of that bug is still =
not=20
clear. Please, send the results of EXPLAIN for the queries that becom=
es=20
slow and send your my.cnf.

Please, upload also (to the bug #37411) the results of SHOW MUTEX STA=
TUS.

I think upgrade to 5.1.28 worth a try. I know cases when it helped.

> PS: MySQL configuration is quiet good, as its just innodb tables an=
d
> configuration equals (almost) to the one described in my-innodb-hea=
vy-4G.cnf
> (I have 8GB RAM).

This does not make your configuration automagically optimal for your=
=20
environment.

Best regards,
--=20
Valeriy Kravchuk, MySQL Principal Support Engineer
Sun Microsystems, Inc.
Kiev, Ukraine, www.sun.com/mysql


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]