Skip to content

Yii profiler adjusted to deal with MySQL performance optimizations

Notifications You must be signed in to change notification settings

samdark/yii-db-profiler

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

DB profiler

Instead of regular CProfileLogRoute DB profiler displays database queries and query-related info only. Also it have an ability to highligt possibly slow queries and queries repeated many times.

Installation

Unpack to protected/extensions/. Add the following to your protected/config/main.php:

<?php
return array(
	// …
	'components' => array(
		// …
		'db' => array(
			// …
			'enableProfiling'=>true,
			'enableParamLogging' => true,
		),
		'log'=>array(
			'class'=>'CLogRouter',
			'routes'=>array(
					// …
            	    array(
                	    'class'=>'ext.db_profiler.DbProfileLogRoute',
						'countLimit' => 1, // How many times the same query should be executed to be considered inefficient
						'slowQueryMin' => 0.01, // Minimum time for the query to be slow
                	),
			),
		),
	),
);

About

Yii profiler adjusted to deal with MySQL performance optimizations

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages