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

[Richard K Miller]

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?