#1  

09-01-2006, 01:13 AM

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?

  #2  

09-01-2006, 02:29 AM

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

  #3  

09-01-2006, 02:40 AM

my.cnf
[mysqlsafe]
open-files = 10000
!

  #4  

09-01-2006, 02:41 AM

some time show
MySQL Error : Can't open file: 'threadviews.MYI' (errno: 145)
errors not stable!

  #5  

09-01-2006, 05:21 AM

edit
/etc/login.conf
daemon:\
:openfiles-cur=2028:\

mysql:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=infinity:\
:openfiles-max=infinity:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:


and
sysctl -w kern.maxfiles=13666

restart server
now all thing is right.