Skip to content
This repository has been archived by the owner on Sep 5, 2022. It is now read-only.

jcc2010/w-slow

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Requirements:
PHP 5.xx
MySQL 5.1

Install:

1) Extract contents of package.
2) Edit w-slow/index.php for MySQL connect information at the top:
   MARKED WITH SET HERE
3) Open w-slow/index.php, this will set the logging and slow log time to 1
4) Load pages as you normally would during development.
5) Reload w-slow/index.php to see MySQL slow log of any SELECT statements.
6) Truncate and turn off via the link provided.  This will set your slow log time to default
   and will turn off your slow log.  Close the page.
7) To re-enable your slow query log, just reload w-slow/index.php

Please Note, you need to have adequate permissions for to administer your MySQL database for w-slow
to work.

w-Slow only looks at SELECT queries that have accumulated in the slow log.  For a complete list
of your slow log, you can query within phpMyAdmin using:

SELECT * FROM mysql.slow_log

This will show you all queries.

Further information about EXPLAIN can be found here:

* http://dev.mysql.com/doc/refman/5.0/en/using-explain.html


This script uses blueprint.css.  Please read the credits and documentation provided in
styles/blueprint

About

Analyze your mysql slow query log

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages