Profiler in MySQL

Can we use Profiler like MS - SQL in MySQL also? I googled over internet but did not get satisfactory answer.

If you are going to provide link, please make sure they are usable/and workable. :)


Thanks beforehand.
LVL 8
Mohit VijayAsked:
Who is Participating?
 
InsoftserviceConnect With a Mentor Commented:
Hi,

try out jet profiler for mysql .
Please note its an paid version. but good tool to use.

ANJlab sql profiler is an open source.
0
 
Loganathan NatarajanLAMP DeveloperCommented:
0
 
Mohit VijayAuthor Commented:
yes I have gone through this, but did not like it.

Reason: I am also looking for a special feature of MS SQL profiler where it show all SQL Statements/procedures/queries running on server, with all parameters etc..
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
>> I am also looking for a special feature of MS SQL profiler where it show all SQL Statements/procedures/queries running on server, with all parameters etc..

The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld.

•Before 5.1.6, the general query log destination is always a file. To enable the log, start mysqld with the --log[=file_name] or -l [file_name] option.

•As of MySQL 5.1.6, the destination can be a file or a table, or both. Start mysqld with the --log[=file_name] or -l [file_name] option to enable the general query log, and optionally use --log-output to specify the log destination

Beware of the fact that general query log on a busy production box should be enabled for a short period of time otherwise it would fill up the disk in no time...

more can be read on http://dev.mysql.com/doc/refman/5.1/en/query-log.html

### If you are interested to trace only those staments(Statements/procedures/queries) which are causing the problem then you may want to take a look at the slow query logs (need to set the threshold for long query time parameter in order to get accurate results)

more can be read on http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
0
 
Mohit VijayAuthor Commented:
any Gui tool available?
0
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
MySQL Enterprise monitoring tool provides a module by name "Query Analyzer"... but its part of Enterprise MySQL version.but you can give a try it for 1 month or so...

http://www.mysql.com/products/enterprise/query.html
0
 
Mohit VijayAuthor Commented:
Thanks All.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.