[UPHPU] Re: Using named pipe for MySQL error log

[Richard K Miller]

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."