Excluding queries from statistics

Posted March 13th by Jet Profiler team
The latest update (v 3.0.9) includes a feature for excluding queries from statistics. To make Jet Profiler ignore certain queries, you need to edit the original query in the application code.

Start the query with /*jp-ignore*/ (no spaces), for example "/*jp-ignore*/ SELECT ... FROM ..."

This will prevent the query from showing up in Top Queries and the other tabs. The query will, however, still affect general preset statistics (such as number of threads running and threads busy). Also make sure that your mysql client library preserves comments - some libraries including the mysql command line client removes comments by default.

1 comments

Add your own

John Nicholls | June 12th at 05:04
It would be nice if instead of changing SQL on multiple systems that we could provide Jet Profiler with some regex to identify patterns within queries that need to be ignored... e.g. to certain columns/tables/databases


Post a comment


(required)

(will not be published) (required)





Notify me of followup comments via e-mail



Subscribe without commenting