header pictures for dedicated hosting services header image of world
Guests Visit the FreeBSD Forums  •  Login to the FreeBSD Forums  •  Register for FREE

Mysql notwork after 10min of start

09-01-2006, 01:13 AM
Majidnt vbmenu_register("postmenu_229333", true);
BSD n00b
Join Date: Aug 2005
Posts: 6
Mysql notwork after 10min of start

when start mysql althing is ok after 10min all php,mysql site show error!
(php cant query from mysql.)
error like this:
Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE FROM passwordhistory
MySQL Error : File './site_db/passwordhistory.MYD' not found (Errcode: 9)
Error Number : 1105

after shutdown mysql and start again site work correctly but after 10min all thing back like ago

OBSD 3.8
mysql 4.1.21
php 4.4.4
we test mysql 4.0 , 5 and php 4.3 ,
our mysql client 4.0

any idea?
09-01-2006, 02:29 AM
wilfried vbmenu_register("postmenu_229346", true);
Port Monkey
Join Date: Jun 2003
Location: Malmö, Sweden
Posts: 320
Errno 9 is EBADF (bad file descriptor)
It commonly happens in mysql when it runs out of file descriptors
Raise the limit of open files per process
eMac G4 1.0GHz, Sun Blade 150, Alpha PWS 433, Compaq ProLiant ML370/Smart Array 431
Commell EMB-564, AMD64 3000+, Dual P3-800, AMD XP 2400+, Dual Opteron 265/Adaptec 3200S
09-01-2006, 02:40 AM
Majidnt vbmenu_register("postmenu_229351", true);
BSD n00b
Join Date: Aug 2005
Posts: 6
open-files = 10000
09-01-2006, 02:41 AM
Majidnt vbmenu_register("postmenu_229352", true);
BSD n00b
Join Date: Aug 2005
Posts: 6
some time show
MySQL Error : Can't open file: 'threadviews.MYI' (errno: 145)
errors not stable!
09-01-2006, 05:21 AM
Majidnt vbmenu_register("postmenu_229362", true);
BSD n00b
Join Date: Aug 2005
Posts: 6


sysctl -w kern.maxfiles=13666

restart server
now all thing is right.



Looking for our FreeBSD Forums? We have moved them off our main page,just follow the link to our FreeBSD Forums page.


Privacy Policy

Please note:
(1) FreeBSD is a registered trademark of The FreeBSD Foundation.
(2) WEBSERVER CONSUMER GUIDE is in no way affiliated with The FreeBSD Foundation