PHP Classes

LSM Explain Plan: Show a MySQL query execution plan and performance

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 34%Total: 894 All time: 3,953 This week: 488Up
Version License PHP version Categories
lsmexplain_plan 1.0.0GNU General Publi...3Databases, Performance and optimization
Description 

Author

Claudio Adonai Muto

This class can retrieve the explanation of the execution of a given MySQL database SELECT query and compute a relative performance factor.

The class executes an EXPLAIN query to retrieve the information about the tables, columns, indexes and search methods involved in a SELECT query.

It uses the retrieved information to compute a relative performance factor that is presented in a simple report along with other details pertaining to the execution plan of the query.

Innovation Award
PHP Programming Innovation award winner
April 2005
Winner

Prize: One copy of the Zend Studio		 When it is necessary to improve the performance of database applications, the developers often evaluate the SQL queries that are executed, so they can determine how to make the applications run faster.

MySQL has a SQL command named EXPLAIN that lets the developers see which tables, columns, indexes are involved in an SELECT query. Then they can consider eventual database changes that can make the query execute faster.

This class uses the information returned by the EXPLAIN command and computes a performance factor that can be used to easily determine if the changes in the query statement or in the database tables and indexes that are tried effectively lead to performance improvements.

Manuel Lemos
Picture of Claudio Adonai Muto
Name: Claudio Adonai Muto <contact>
Classes: 6 packages by
Country: Brazil Brazil
Age: 51
All time rank: 90662 in Brazil Brazil
Week rank: 195 Up14 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Recommendations

What is the best PHP mysql tuner class?
MySQL tuner for optimizing the performance of a database

Screenshots (1)  
  • sql.jpg
  Files folder image Files (2)  
File Role Description
Plain text file LSMexplain_plan.class.php Class Executes a explain in a SQL statement

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadlsmexplain_plan-2005-05-21.zip 63KB
Downloadlsmexplain_plan-2005-05-21.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:894
This week:0
All time:3,953
This week:488Up
 User Ratings  
 
 All time
Utility:58%StarStarStar
Consistency:54%StarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:34%StarStar
Rank:4193
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.