[asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?

[Steve Edwards]

On Thu, 8 Jul 2010, bruce bruce wrote:

> Thanks for the input. Tailing the mysql log file doesn't show me 
> anything even though FreePBX does right to the asterisk table. I think 
> log is more for errors and unexpected shutdowns etc....and not queries. 
> In the my.cnf file there is no configuration to higher or lower the 
> verbose to show queries. Any other method of checking queries coming 
> through? Maybe FreePBX uses MySQL direct sockets and its different?

Googling "mysql query log" brings up:

http://dev.mysql.com/doc/refman/5.1/en/query-log.html

as the first hit.

-- 
Thanks in advance,
-------------------------------------------------------------------------
Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867 PST
Newline                                              Fax: +1-760-731-3000