[UPHPU] Using named pipe for MySQL error log

Richard K Miller richardkmiller at gmail.com
Tue May 13 14:26:30 MDT 2008


Why does this work?
$ vim my.cnf  # add "log=/opt/local/var/log/mysql.log"
$ tail -f /opt/local/var/log/mysql.log

But this does not?
$ mkfifo /opt/local/var/log/mysql.fifo
$ vim my.cnf  # add "log=/opt/local/var/log/mysql.fifo"
$ tail -f /opt/local/var/log/mysql.fifo

I would like my MySQL queries to be logged to a name pipe so that I  
can watch them (with tail) whenever I want, without filling my hard  
drive with log files. Is this possible?

Richard



More information about the UPHPU mailing list