Bug #17646 | open_files_limit variable cannot be set | ||
---|---|---|---|
Submitted: | 22 Feb 2006 13:20 | Modified: | 27 Sep 2008 18:42 |
Reporter: | d di (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.18 | OS: | Windows (Windows) |
Assigned to: | CPU Architecture: | Any |
[22 Feb 2006 13:20]
d di
[22 Feb 2006 13:34]
MySQL Verification Team
Yes the file descriptors are limited to 2048 on Windows. What I suggest you is for to reduce at minimum possible the value of table_cache variable (every table uses 2 files descriptor).
[4 Apr 2008 21:04]
Abraham Chaffin
I'm getting the same error on a Gentoo linux machine - trying to do a mysqldump # mysqldump -u root -p --opt databasename > datafile.sql Enter password: mysqldump: Got error: 29: File './databasename/tablename.MYD' not found (Errcode: 24) when using LOCK TABLES Is there a work around for this on linux - I'd prefer not to delete tables to be able to dump the database: mysql Ver 14.12 Distrib 5.0.44, for pc-linux-gnu (x86_64)
[27 Sep 2008 18:42]
Vladislav Vaintroub
Fixed with Bug#24509 (in 6.0)