With --log[=filename] option to mysqld_safe, you can specify the path and name of log file. You may put the line like this to my.cnf file log = filename
If absoulte path is not given, the path is considered one relative to $data directory, in my case /usr/local/mysql/var and filename is not given, `hostname-s`-slow.log will be used. -- 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:39 PM > To: Á¤ Çϳç > Cc: [EMAIL PROTECTED] > Subject: RE: loggin all calls made to mysql from php > > > 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
