mysql query

From: Dave Markham (dave.markham@fjserv.net)
Date: Fri Jul 07 2006 - 10:17:03 EDT


Sorry a bit off topic but mysql is running on solaris and im not
subscribed to any mysql threads.

I have a web application written mostly in perl which writes to and
queries a database. I can get onto this database and see the tables etc
but im interested in seeing what query some of the buttons are creating
from the application.

If i do

mysql> show processlist;

while the query is runnig i can see some of the query syntax but most
of it is chopped off. So does anyone know how to capture the full query
which is taking place?

I have also tried

mysql>show processlist\G

Thanks
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:40:21 EDT