Bug #3879 | Automatic Lock is rising when using SELECT | ||
---|---|---|---|
Submitted: | 25 May 2004 7:36 | Modified: | 29 May 2004 16:56 |
Reporter: | Sivan Narayana | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 3.23..42 | OS: | Linux (Linux 7.0) |
Assigned to: | CPU Architecture: | Any |
[25 May 2004 7:36]
Sivan Narayana
[25 May 2004 7:56]
Roberto Spadim
Bug 3720 Showed the same problem!
[25 May 2004 8:12]
Roberto Spadim
INNODB don't show this problem! Just Heap AND MyIsam!!!!
[29 May 2004 16:56]
MySQL Verification Team
Thank you for writting to us. What you describe is not a bug. MyISAM uses implicit table locks on all SELECT's in 3.23.*. Workaround is to use 4.1 or to move to InnoDB.