Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Profiler in MySQL

Posted on 2010-09-04
Medium Priority
Last Modified: 2012-05-10
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.
Question by:Mohit Vijay
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 33602319

Author Comment

by:Mohit Vijay
ID: 33602327
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..
LVL 26

Assisted Solution

Umesh earned 1300 total points
ID: 33605606
>> 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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.


Author Comment

by:Mohit Vijay
ID: 33605670
any Gui tool available?
LVL 26

Assisted Solution

Umesh earned 1300 total points
ID: 33605789
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...

LVL 15

Accepted Solution

Insoftservice earned 700 total points
ID: 33607410

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

ANJlab sql profiler is an open source.

Author Closing Comment

by:Mohit Vijay
ID: 33662525
Thanks All.

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question