----- Original Message -----
From: "Achilleas Mantzios" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 3:45 PM
Subject: Re: [aseek-users] Too many open files in system: couldn't spawn
child process
> On Sat, 17 Feb 2001, you wrote:
> > On Sat, 17 Feb 2001, Achilleas Mantzios wrote:
> >
> > RedHat and some other distributions often have "--log-file=..." option
in
> > "/etc/rc.d/init.d/mysqld" startup script (in newer dists it is in
> > /etc/my.cnf).
> > A simple solution is to replace
> > it (ar add) "--log-slow-queries=/var/log/mysqld.log" to line containing
> > "/usr/bin/safe_mysqld". This option forces mysql to log only queries
> > longer than 10 seconds to log file. Default setup logs every query,
which
> > also drastically reduces the performance.
> >
> >
>
> Mysql has no problem running without logging its activity.
> The question is why index seemed to have opened too many handles.
> Anyway thanx for the mysql info.
100 handles are used for delta files.
4*R handles are used for pipes for R resolver processes.
Up to N handles are used for TCP/IP connections for each of N threads.
1 handle is for "logs.txt"
>
> > Best regards,
> >
> > Andrej
> >
> > > Thats what i got in my apache error log, when i tried to to execute
s.sgi.
> > > What happened was that index couldnt write to the mysql log cause
> > > it exceeded the ext2 size limit.
> > > Does index take that in account someway???
> > > The problem was fixed initially by stoping the index and then
> > > by forcing a more frequent rotation of the mysql log file, and
increasing
> > > openfiles limit prior to running index.
> > >
> > > Any clues??
> > >
> >
> > --
> > _____________________________________________________________
> > dr. Andrej Filipcic, E-mail: [EMAIL PROTECTED]
> > Department of Experimental High Energy Physics - F9
> > Jozef Stefan Institute, Jamova 39, P.o.Box 3000
> > SI-1001 Ljubljana, Slovenia
> > Tel.: +386-1-477-3674 Fax: +386-1-425-7074
> > -------------------------------------------------------------
> --
> �������� ��������
> Application Developer
> Eurisko A.E.
> �������� 9
> 106 71 �����
> ���: +301 3633362
> ���: +301 3633074
> e-mail: [EMAIL PROTECTED]
