MySQL Lists are EOL. Please join:

List:Internals« Previous MessageNext Message »
From:Sergei Golubchik Date:March 24 2008 1:09pm
Subject:Re: mysql 5.1.23 and syslog for query log: more questions, plz
View as plain text  
Hi!

On Mar 18, Mariella Petrini wrote:
> 
> I would like to ask more questions, please, related to
> mysqld and syslog logging for general log and slow-log
> and using syslog-ng.
> 
> Would it make sense, which could be the best way and
> which could be the cons of trying to make mysqld code
> working with syslog-ng ?
> Or is there an easier way of doing that ?

The simplest way is, indeed, speficic to syslog-ng. But looks like it's
what you want anyway :)

syslog-ng can use a file or a unix pipe as a source. Try

source testfile { file("/tmp/logfile" follow_freq(1) flags(no-parse)); };

or

source testpipe { pipe("/tmp/logpipe" flags(no-parse)); };

in your syslog-ng.conf, then use them in log {} directive, and configure
MySQL to log to a specified file or a pipe.
 
Regards / Mit vielen Grüssen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Developer/Server Architect
/_/  /_/\_, /___/\___\_\___/  MySQL GmbH, Dachauer Str. 37, D-80335 München
       <___/                  Geschäftsführer: Kaj Arnö - HRB
München 162140
Thread
Re: mysql 5.1.23 and syslog for query log: more questions, plzMariella Petrini18 Mar
  • Re: mysql 5.1.23 and syslog for query log: more questions, plzSergei Golubchik24 Mar
    • Re: mysql 5.1.23 and syslog for query log: more questions, plzMariella Petrini26 Mar
Re: mysql 5.1.23 and syslog for query log: more questions, plzMariella Petrini25 Mar
  • Re: mysql 5.1.23 and syslog for query log: more questions, plzChad MILLER25 Mar