MySQL Profiler
Displays a list of each page's SQL queries and the functions calling them that can be searched and sorted by time, type, etc.
The facts
- Rating
- 4.2★ from 5
- Active installs
- 10+
- Price
- Free
- Last updated
- 6 Mar 2012
- Added
- Mar 2012
- Requires WP
- 2.9
- Tested up to
- WP 3.3.2
- Downloads
- 7,197
Our analysis
AI-assistedMySQL Profiler is a WordPress plugin designed for admin users to display debugging information about SQL queries. It shows details such as execution time, syntax-highlighted SQL, and a trace of the functions called, including their file and line number.
The plugin allows you to sort and filter the list of queries based on various criteria, making it useful for developers who want to analyse database performance and query origins. It is suitable for those who have a technical understanding of SQL and WordPress development.
Best for: Developers and technical users looking to debug SQL queries in WordPress.
What it does well
- ✓Displays execution time and syntax-highlighted SQL for queries
- ✓Allows sorting and filtering of queries by various criteria
- ✓Provides a trace of functions called, including file and line number
Where it falls short
- •Last updated in March 2012, may not be compatible with newer WordPress versions
- •Limited active installs may indicate low usage or support
Verdict
MySQL Profiler provides useful debugging information for SQL queries, but its age and limited support may be a concern for some users.
From the developer
tombenner's own description of MySQL Profiler, lightly tidied.
MySQL Profiler displays debugging information about SQL queries to admin WordPress users. For each query, the profiler displays the time, syntax-highlighted SQL, and a trace of the functions (as well as the file and line number that the functions were called from) that were called.
The list can be sorted by any of its columns, so you can, for example:
- Order the list by ID to see the chronological order of the queries
- Order the list by time to see the slowest queries
- Order the list by query to group the queries by type (SELECT, UPDATE, etc)
- Order the list by trace to group the queries by similar origins
The list can also filtered by typing in the search box, so you can, for example:
- View all queries that use the wp_posts table
- View all queries that are related to the use of a function in taxonomy.php
- View all queries that are related to the use of a specific function or class
- View all queries that call a specific MySQL function
To turn off syntax highlighting, put the following in wp-config.php:
define('MP_HIGHLIGHT_SYNTAX', false);
To omit the file and line number from the function trace and display the functions as a comma-separated list (to save vertical space), define the following in wp-config.php:
define('MP_DISPLAY_FILES', false);
This plugin was loosely based on Frank Bueltge‘s Debug Queries plugin, so a hearty thanks to him for the development of that.
If you’d like to grab development releases, see what new features are being added, or browse the source code please visit/follow the GitHub repo.