MyProfi 0.161

Description

MyProfi project is a command line tool that parses mysql query log and outputs statistics of most frequently used queries, sorting them by number of times they appear in a log file. The similar queries are groupped together. Thus, select id from user where login="admin" and select id from user where login=root become select id from user where login={} - the variable parts of queries are replaced with {} markers, this make statistics analysis as easy as revewing the top of most frequently occured queries patterns. When developing an application one can hardly predict, which of the sql queries will run the most often, and which less often. The most popular queries are to be the first candidates for optimisation, fine tuning and polishing. By optimizing the most frequenly run queries the developer may achieve significant performance gain for overall system. By reviewing the statistics of MyProfi output its becomes too easy to extract those queries to start optimizing db by adding indexes, reconsidering database structure, etc.. MyProfi is a command line tool that parses mysql query log and outputs statistics of the most frequently used or the slowest queries, sorting them by number of times they appear in a log file or by total/average execution time.

Myprofi - Select - Id - Select Name From User Where Id - Where - Mysql Query Log - Command Line Tool - Query Log - May Be - Line Tool - Mysql Query - Command Line - Queries - Query - Statistics

Published By:camka

License Type:Freeware

Date Added:22 October, 2010

Version:Beta

Price:Free

Downloads:22

Size:6.1 KB

Platform: Linux

What people say
- required fields
     
Related Downloads

ReleaseAction - call actions upon release.

DateAug 25, 2010

AuthorBen Tilly

Size4.1 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

SQLayer is a Perl interface to DB..

DateAug 13, 2010

AuthorAndrew Gromozdin, Sergei Kadurin and Andrei V. Shetuhin

Size3.1 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

Gentoo Category Select is a graphical tool for selecting Gentoo Package Categories to exclude from your local package repository.

DateOct 13, 2010

AuthorCraig Hurley

Size8.2 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

SQL::Interpolate is a Perl module to interpolate Perl variables into SQL statements.

DateAug 31, 2010

AuthorDavid Manura

Size57.3 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

DBIWrapper is a Perl Module that provides for easier access to databases using DBI. It supports MySQL, PostgreSQL and ODBC DBD modules. High level methods for reading and writing to the database are provided. DBI data structures or XML are returned.

DateAug 3, 2010

AuthorDBIWrapper 0.22 (Stable) Section: Unix FREE WH

Size27.6 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming