Bug #67091 | MySQL service wont start with large buffer pool. | ||
---|---|---|---|
Submitted: | 4 Oct 2012 21:10 | Modified: | 10 Oct 2012 8:49 |
Reporter: | Abhijit Mori | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S5 (Performance) |
Version: | 5.0.80 | OS: | Windows (2008 server) |
Assigned to: | CPU Architecture: | Any | |
Tags: | InnoDb buffer pool. |
[4 Oct 2012 21:10]
Abhijit Mori
[5 Oct 2012 3:09]
Calvin Sun
The problem is fixed in MySQL 5.5.
[5 Oct 2012 18:34]
Abhijit Mori
Thanks Calvin. Do you know what is causing this? And what will be safe value of InnoDb buffer pool? Or does it even make a difference. I mean if the issue is not just related with buffer pool allocation and something else. Appreciate your Help!!
[6 Oct 2012 14:13]
MySQL Verification Team
Number of handles used in 5.0 is excessive, and likely hits 16.7 million threshold. Take a look at http://bugs.mysql.com/bug.php?id=52102
[9 Oct 2012 21:00]
Abhijit Mori
That definitely makes sense. I was able to see the issue happening and MySQL using almost all the possible handles, after which it crashed. I am going to try with 55 GB of buffer pool along with thought of upgrading to MySQL 5.5.8. Link was helpful Shane. Thanks.
[10 Oct 2012 8:49]
MySQL Verification Team
Hi, I'll close this bug then, as problem is solved in recent versions. Just a side note, please never consider 5.5.8 as a solution. Rather download 5.5.28 or whatever is the more recent version on dev.mysql.com.