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.
> 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]
