Solved

Profiler in MySQL

Posted on 2010-09-04
7
590 Views
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.
0
Comment
Question by:Mohit Vijay
[X]
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
7 Comments
 
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 33602319
0
 
LVL 8

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..
0
 
LVL 26

Assisted Solution

by:Umesh
Umesh earned 325 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
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 8

Author Comment

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

Assisted Solution

by:Umesh
Umesh earned 325 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...

http://www.mysql.com/products/enterprise/query.html
0
 
LVL 15

Accepted Solution

by:
Insoftservice earned 175 total points
ID: 33607410
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
 
LVL 8

Author Closing Comment

by:Mohit Vijay
ID: 33662525
Thanks All.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
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.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

752 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