Re: spontanious performance problem :(

2001-10-23 Thread Michal Žejdl
Wouter de Jong wrote: > > /proc/sys/fs/file-max: > 32768 And what about file-nr and others (*-nr)? sql -- Ing. Michal Žejdl e-mail: [EMAIL PROTECTED] Sokolovská uhelná, a.s. tel.: +420 168 46-5418 ---

Re: spontanious performance problem :(

2001-10-22 Thread Wouter de Jong
On Tue, Oct 23, 2001 at 08:08:08AM +0200, Michal Zejdl wrote: > > Blank shot - have you enough FD? > sql I really think so... ulimit -a: max user processes 32768 open files 32768 And within /etc/my.cnf: [safe_mysqld] open-files-limit=32768 set-variable= open

Re: spontanious performance problem :(

2001-10-22 Thread Michal Žejdl
Wouter de Jong wrote: > > Does anyone have a clue about what could be going on ? Blank shot - have you enough FD? sql -- Ing. Michal Žejdl e-mail: [EMAIL PROTECTED] Sokolovská uhelná, a.s. tel.: +420 168 46-5418

spontanious performance problem :(

2001-10-22 Thread Wouter de Jong
Hi, We are having serious load problems suddenly at one of our MySQL-servers. There are running about 830 databases on this one. The machine was up for 40 days, running peacefully (load avg. of 2) but suddenly it went to an average of 25. We've been trying to find a reason, but SHOW PROCESSLIS