Re: Looking for Database Profiling Tool
Posted by: Rick James
Date: July 12, 2015 08:15AM

The metrics you suggest are interesting, but can't tell you much about what to fix or how.

My favorite tool for investigating performance issues (and to a lesser degree, monitoring them) is the slowlog.
1. set long_query_time = 1 (or some value smaller than the too-high default of 10)
2. turn on slowlog (and leave it on)
3. periodically (daily? weekly?) run pt-query-digest against the slowlog
4. ponder whether anything can be done to improve the top couple of queries, such as

* Different/additional index
* reformulation of the query
* redesign the application to avoid the use of the query
* etc.

Options: ReplyQuote

Written By
Re: Looking for Database Profiling Tool
July 12, 2015 08:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.