Solved

Profiler in MySQL

Posted on 2010-09-04
7
588 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
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:ushastry
ushastry 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 8

Author Comment

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

Assisted Solution

by:ushastry
ushastry 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
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…

830 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