On May 13, 2008, at 2:34 PM, Richard K Miller wrote:

On May 13, 2008, at 2:26 PM, Richard K Miller wrote:

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?

Go figure, now it's working. I had to restart MySQL twice.

Let me change the subject of my email to "A convenient way to do MySQL development and debugging."


If MySQL logs to a named pipe, and "no one is there to hear it," does it affect database performance?



_______________________________________________

UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net

Reply via email to