Thanks, I did it and it works. I just would like to know one more thing. You mention a "slow" log option, how do invoke that type specifically? I restarted mysql with safe_mysqld --log & and it created a myserver.log file in the data directory, but it seems to log ALL queries and is growing pretty fast, so the slow option seems a better bet, as I *think* that the slow queries would be the ones most likely to cause the problems anyway?
So do I do safe_mysqld --log-slow & or how? Thanks On Thu, 2002-10-17 at 09:51, Chung Ha-nyung wrote: > > 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:internet@;boesmanland.com] > > 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:internet@;boesmanland.com] > > > > 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
