Thread: Logger
View Single Post
  #21 (permalink)  
Old 03-30-2006, 12:56 PM
jholder jholder is offline
Former Zimbran
 
Posts: 5,606
Default

Howdy,
I tried to run logmysql.server start with grant tables.

[root@tusd-exch01 zcs]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060330 12:58:50 mysqld ended


So, I thought I'd take a look at the mysqld.log

060330 12:58:49 mysqld started
060330 12:58:50 [ERROR] /opt/zimbra/logger/mysql/bin/mysqld: unknown variable 'defaults-file=/opt/zimbra/conf/my.logger.cnf'

060330 12:58:50 mysqld ended

So I decided to look at the my.logger file.

Code:
[mysqld]

basedir      = /opt/zimbra/logger/mysql
datadir      = /opt/zimbra/logger/db/data
socket       = /opt/zimbra/logger/db/mysql.sock
pid-file     = /opt/zimbra/logger/db/mysql.pid
bind-address = localhost
port         = 7307

skip-external-locking

log-slow-queries = /opt/zimbra/log/logger_myslow.log
long-query-time  = 1
log-long-format
log-queries-not-using-indexes
log-bin

thread_cache      = 10
max_connections   = 10

# We do a lot of writes, query cache turns out to be not useful.
query_cache_type = 0

[mysqld_safe]

err-log = /opt/zimbra/log/logger_mysqld.log
Does this log look correct?

thx
Reply With Quote