Googling for "mysql profiler" brings a link: http://amr.activechannel.net/myprofiler.htm Well... that looks like something really good. I have a question for all of list subscribers: has anyone use this tool? Does it really do what it pretends to do?
On 5/15/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
I'm not sure what you mean by profiler -- where are you getting your information from? It's not referenced in the article I sent. If you mean checking to see if indexes are being used during a query, check out the EXPLAIN syntax. http://dev.mysql.com/doc/refman/5.0/en/explain.html -Sheeri On 5/14/06, Jim <[EMAIL PROTECTED]> wrote: > > Thanks Sheeri, > > How do you run the profiler and what does it do? > Have recently had to add some indexes to various tables to improve > performance so does not seen to be running automatically. > > > > -----Original Message----- > From: sheeri kritzer [mailto:[EMAIL PROTECTED] > Sent: Saturday, 13 May 2006 2:05 AM > To: Jim > Cc: mysql@lists.mysql.com > Subject: Re: "optemizer" for mySQL! > > http://www.devshed.com/c/a/MySQL/A-Technical-Tour-of-MySQL/ > > The MySQL server has it built in. > > -Sheeri > > On 5/8/06, Jim <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > > > > > Didn't know there was an "optemizer" for mySQL. > > > > Where can I get it from? > > > > > > > > Thanks > > > > Jim > > > > > > > > > > > > Best regards, > > > > > > > > Jim Clark > > Project Manager > > Multilink Systems > > Ph: 03 9425 9400 > > Fax: 03 9425 9811 > > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
