Use --log-slow-queries[=filename] option. It will log all queries which take more than "long_query_time" Default value of it is 10 sec and you can ascertain it by "show variable like 'long_query_time'" query and set in my.cnf as "long_query_time = value"
I think you'd better refer to the MySQL's manual; http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database _Administration.html#Log_Files -- 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 7:27 PM > To: Á¤ Çϳç > Cc: [EMAIL PROTECTED] > Subject: RE: loggin all calls made to mysql from php > > > 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 > > --------------------------------------------------------------------- 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
