Solved

Profiler in MySQL

Posted on 2010-09-04
7
591 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

630 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