Re: no log generated?

2006-12-20 Thread Bing Du
> 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]



Re: no log generated?

2006-12-19 Thread Daniel da Veiga

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]



no log generated?

2006-12-19 Thread Bing Du
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]