Hi Thanks for the prompt reply. Can you please tell me where the logfile will be located if I start it with the --log option? Will syslogd take over the function of the logging, ie, do the log rotation etc. and if possible, could you give me an example of how the log would look?
Sorry for asking all these questions, I just want to make sure that it is what I'm looking for, as I will need to stop the mysql server to do this... Thanks On Thu, 2002-10-17 at 09:21, Chung Ha-nyung wrote: > > 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
