HI I posted this question on PHP list as well. I would like to be able to log all mysql queries made from php scripts. I have had a couple of strange mysql lockups on my RedHat server, where mysqld process won't even be killed, and since no user works with mysql except through PHP, the normal mysql logs doesn't seem to be very helpful. I have multiple virtual hosts on the server, all allowing .php and most having mysql db's, so I want to be able to see what scripts are causing the problem.
Is this the right way to go about finding the problem? Are there any other ideas or methods in use by other admins out there to determine if there are poorly coded scripts/queries run on the server? Thanks --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
