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