MySQL Performance: MySQL => MySQL Profiler

Members

Help

Home

Home » Performance » MySQL » MySQL Profiler

Show: Today's Messages :: Show Polls :: Message Navigator

MySQL Profiler [message #47]

Tue, 15 August 2006 05:27

safari
Messages: 26
Registered: August 2006
Location: Vietnam

Junior Member

Anyone could advise me a tool for MySQL which similar to MS SQL Server Profiler?

Sorry for any inconvenient but I don't know anywhere else to ask.

Report message to a moderator

Re: MySQL Profiler [message #50 is a reply to message #47 ]

Tue, 15 August 2006 09:25

vadimtk
Messages: 12
Registered: August 2006

Junior Member

I am not familiar with MS SQL Server Profiler.
What does this tool do ?

Report message to a moderator

Re: MySQL Profiler [message #51 is a reply to message #50 ]

Tue, 15 August 2006 16:52

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Honestly I do not know.
I'm not big fan of GUI tools, especially as they are frequently unavailable with remote installations.

Generally I would not expect something with same functionality as MySQL does not provide similar amount of information. Ie there is simply no info on how much phyisical IOs query did etc.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: MySQL Profiler [message #53 is a reply to message #47 ]

Tue, 15 August 2006 20:55

yejr
Messages: 3
Registered: August 2006
Location: China

Junior Member

execute

show full processlist;

show status;

welcome to http://imysql.cn

Report message to a moderator

Re: MySQL Profiler [message #54 is a reply to message #47 ]

Tue, 15 August 2006 22:42

safari
Messages: 26
Registered: August 2006
Location: Vietnam

Junior Member

A brief description of MS SQL Profiler:
"SQL Profiler can help you diagnose and fix SQL Server performance issues. This tool lets you trace events and play back the results, which can help you determine application and/or query problems."

Do you think such a tool needed for MySQL?

BTW, thanks all for your quick replies.

Report message to a moderator

Re: MySQL Profiler [message #58 is a reply to message #54 ]

Wed, 16 August 2006 06:22

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

There is no event tracing functionality available in MySQL at this point. Best you have is slow query log, SHOW STATUS, SHOW MUTEX STATUS, SHOW INNODB STATUS.

It is planned to have such functionality but it will take time before it is made available.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Previous Topic:	1-n distinct/group by optimization
Next Topic:	large table to temp table or direct select ?

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 20 19:59:49 EST 2008

Total time taken to generate the page: 0.01472 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.