Use --log option when starting mysqld_safe(or safe_mysqld)
-- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -----Original Message----- > From: Petre Agenbag [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 17, 2002 4:05 PM > To: [EMAIL PROTECTED] > Subject: loggin all calls made to mysql from php > > > 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 > > --------------------------------------------------------------------- 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
