Bug #29759 Many semaphore waits in SMP
| Submitted: | 12 Jul 2007 14:29 | Modified: | 27 Nov 2007 14:49 |
|---|---|---|---|
| Reporter: | Michail Epikhin | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
| Version: | 5.0.45 | OS: | Windows (2003 Ent R2 x64) |
| Assigned to: | Inaam Rana | CPU Architecture: | Any |
| Tags: | SMP, windows, x64, Xeon | ||
[12 Jul 2007 14:29]
Michail Epikhin
[12 Jul 2007 14:30]
Michail Epikhin
Innodb monitor
Attachment: im.txt (text/plain), 25.94 KiB.
[12 Jul 2007 14:30]
Michail Epikhin
MySQL configuration
Attachment: config.txt (text/plain), 14.31 KiB.
[29 Aug 2007 13:07]
Michail Epikhin
I have new result: If hyperthreading disabled, server work ok with innodb_thread_concurrency=3 on 4 phisical core.
[22 Nov 2007 18:58]
Inaam Rana
Michail, Can you upload the .err file please? Also have you only noticed long semaphore delays or have these delays caused a crash in some case as well? regards, inaam
[26 Nov 2007 11:18]
Michail Epikhin
Server work stable, only long semaphore wait. I cant upload .err - now I use 5.1.22RC and problem not repetable. But when I use 5.0.45 no addition info printed in err file (Only Start/Stop).
[27 Nov 2007 14:49]
Inaam Rana
Michail, This may be another instance of bug 29560. A fix for that is submitted to 5.0.54. This bug is not present in 5.1. For now I am setting this to Can't Repeat as you have moved to 5.1. If you have anything to report, please reopen this report. regards, inaam
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.