Re: no log generated?
On 12/19/06, Bing Du [EMAIL PROTECTED] wrote: Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid == But /var/log/mysqld.log doesn't have anything more recent than October 2006. Yesterday, the mysqld experienced too many connections problem. But I didn't find anything got logged in mysqld.log. Why is that? I'm sure that's the config file mysqld reads because the pid-file has the pid of the running mysqld. I'd appreciate any insight. Could it be that the problems you mentioned generate warnings and not errors? If so, then you won't see anything in the error log, only if you use the log-warnings variable. Check the manual... Thanks Daniel. The message I got wasn't clear for me to tell if it's a warning or error. I figured there must be some option to set up log level or something. Anyway, I'll check the manual. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no log generated?
Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid == But /var/log/mysqld.log doesn't have anything more recent than October 2006. Yesterday, the mysqld experienced too many connections problem. But I didn't find anything got logged in mysqld.log. Why is that? I'm sure that's the config file mysqld reads because the pid-file has the pid of the running mysqld. I'd appreciate any insight. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: no log generated?
On 12/19/06, Bing Du [EMAIL PROTECTED] wrote: Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid == But /var/log/mysqld.log doesn't have anything more recent than October 2006. Yesterday, the mysqld experienced too many connections problem. But I didn't find anything got logged in mysqld.log. Why is that? I'm sure that's the config file mysqld reads because the pid-file has the pid of the running mysqld. I'd appreciate any insight. Could it be that the problems you mentioned generate warnings and not errors? If so, then you won't see anything in the error log, only if you use the log-warnings variable. Check the manual... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
