Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 38.855.412 Times

MyProfi 0.161 Beta

  Date Added: November 06, 2010  |  Visits: 1.026

MyProfi 0.161

Report Broken Link
Printer Friendly Version


Product Homepage
Download (87 downloads)



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.

Requirements: No special requirements
Platforms: Linux
Keyword: Command Line Command Line Tool Id Line Tool May Be Myprofi Mysql Query Mysql Query Log Queries Query Query Log Select Select Name From User Where Id Statistics Where
Users rating: 0/10

License: Freeware Size: 6.14 KB
USER REVIEWS
More Reviews or Write Review


MYPROFI 0.161 RELATED
Social Networking  -  Caller Hunter 0.1.0.0
Imagining, one day you missed a phone call. Don't you want to look it up before calling it back? May be it just is a business survey or a swindler or even some 'one' from Mars..... Caller Hunter is a simple and quick tool that trace the...
1024 KB  
Multimedia & Graphics  -  Kst for Linux 2.0.4 RC 2
Kst is the fastest real-time large-dataset viewing and plotting tool available (you may be interested in some benchmarks) and has built-in data analysis functionality. Kst is very user-friendly (both the community and the program itself!). Kst...
10.8 MB  
Multimedia & Graphics  -  Kst 2.0.4 RC 2
Kst is the fastest real-time large-dataset viewing and plotting tool available (you may be interested in some benchmarks) and has built-in data analysis functionality. Kst is very user-friendly (both the community and the program itself!). Kst...
10.1 MB  
Multimedia & Graphics  -  Kst for Mac OS X 2.0.4 RC 2
Kst is the fastest real-time large-dataset viewing and plotting tool available (you may be interested in some benchmarks) and has built-in data analysis functionality. Kst is very user-friendly (both the community and the program itself!). Kst...
22.9 MB  
Business  -  db2dot 0.2.2
db2dot reverse engineers an existing database and produces an ER diagram in dot format. The dot file can be fed through graphvizs dot to produce a pretty ER diagram. The diagram includes tables and relationships derived from db meta-data and...
11.26 KB  
Libraries  -  SQLitepp
SQLitepp is a C/C++/Python wrapper to sqlite library for database management. It implements an object oriented way to manipulate the database in every supported language. SQLitepp supports selfupdatable queries and a straight SQL code query...
19.46 KB  
Miscellaneous  -  Parse Command Line String from CommandLine 1.2
This script represents a way to parse command line from user provided string or try to get the original Argv from Windows OS Platform.
 
Utilities  -  Arbitrary Command Output Colourer 0.7.1
acoc is a regular-expression based colour formatter for programs that display output on the command-line. It works as a wrapper around the target program, executing it and capturing the stdout stream. Optionally, stderr can be redirected to...
40.96 KB  
Utilities  -  XGngeo 16 Final
XGngeo is a frontend (GUI) for Gngeo which is a powerful command line Neo Geo emulator for the GNU/Linux system (and may be some other Unices). Both are free softwares released under the GNU GPL license. XGngeo is written in Python and uses the...
337.92 KB  
ActiveX Components  -  A7Soft JExamXML 0.2+
A7Soft JExamXML is an XML comparison Java based command line application. Aimed at professional java developers, this tool may be very useful for all users working with XML. This software can be used either as a standalone program or as a jar file...
80 KB  
NEW DOWNLOADS IN PROGRAMMING, DATABASE TOOLS
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  Math::GMPf 0.29
Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.
30.72 KB  
Programming  -  Net::Wire10 1.08
Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...
30.72 KB  
Programming  -  logilab-common 0.56.2
a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...
174.08 KB  
Programming  -  OpenSSL for linux 1.0.0a
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...
3.83 MB  
Database Tools  -  mel, XML Data Binding for C 2
Language: C, XMLLibrary: libxml2OS: AnyXML Databinding for C similar to JAXB, including but not limited to:.dtd to .[ch] production..xsd to .[ch] production (in progress)
53.07 KB  
Database Tools  -  CitrusDB 1.1.4
CitrusDB is an open source customer database application that uses PHP and a database back-end (currently MySQL). This software can keep track of customer information, CRM, services, products, billing, and customer service information. The...
1.1 MB  
Database Tools  -  MyJgui 0.5.5.1
MyJgui is a light-weight graphical user interface for MySQL databases. It aims to be easy to use for new users as well as experts. Motivation: After the MySQL Front project went commercial, there was no light weight, feature rich and free...
21.5 KB  
Database Tools  -  PHPCoder 1.4
PHPCoder is a web based front-end to the Turck MMCache encoding functions, which are similar to the Zend Encoder product. Turck MMCache is a free open source PHP accelerator, optimizer, encoder and dynamic content cache for PHP. It increases...
16.38 KB  
Database Tools  -  Rekall 2.2.6
Rekall is a database front-end, somewhat in the style of MicroSoft Access. However, Rekall is not itself a database, and does not include a database. By this we mean that data is stored somewhere else in an SQL server, and Rekall is fundementaly...
4.9 MB