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 30.153.950 Times

MyProfi 0.161 Beta

  Date Added: November 06, 2010  |  Visits: 844

MyProfi 0.161

Report Broken Link
Printer Friendly Version


Product Homepage
Download (76 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
MYPROFI 0.161 RELATED
Entertainment  -  Fool Mail 1.0.0.0
Tool To Fool !!! This app is your tool to fool people by sending mails to them. Using this app you can easily send email to anyone from any email ID of your choice. If you love pranks, you surely don't want to miss this...
1024 KB  
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  
Code Management Tools  -  PyDBDesigner 0.1.4.1
PyDBDesigner is a free relational database modeling tool that is planned to be able to design both logical and physical models similarly to Erwin(c) and PowerDesigner. Its goal is to provide a useful toolset that allows developers analysts and...
54.27 KB  
Libraries  -  Audio::DB::Adaptor::dbi::sqlite 0.01
Audio::DB::Adaptor::dbi::sqlite is a database adaptor for a specific mysql schema. This adaptor implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract...
62.46 KB  
Libraries  -  Audio::DB::Adaptor::dbi::mysql 0.01
Audio::DB::Adaptor::dbi::mysql implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract SQL-generating methods of Audio::DB::Adaptor::dbi, this module also...
62.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  -  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  
NEW DOWNLOADS IN PROGRAMMING, DATABASE TOOLS
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
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  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
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