QOT 0.0.4

QOT (Query analysis and Optimization Tool) is MySQL DBA’s intelligent assistant.

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!
send us
an update
GPL (GNU General Public License) 
3.1/5 18
Marina Golovko
ROOT \ Programming \ Quality Assurance and Testing
1 QOT Screenshot:
QOT (Query analysis and Optimization Tool) is MySQL DBA’s intelligent assistant. Using QOT you can optimize you queries build optimal indexes, perform SQL static checking and more.


The simplest way to compile this package is:

1. `cd' to the directory containing the package's source code and type `./configure' to configure the package for your system. If you're using `csh' on an old version of System V, you might need to type `sh ./configure' instead to prevent `csh' from trying to execute `configure' itself.

Running `configure' takes awhile. While running, it prints some messages telling which features it is checking for.

2. Type `make' to compile the package.

3. Optionally, type `make check' to run any self-tests that come with the package.

4. Type `make install' to install the programs and any data files and documentation.

5. You can remove the program binaries and object files from the source code directory by typing `make clean'. To also remove the files that `configure' created (so you can compile the package for a different kind of computer), type `make distclean'. There is also a `make maintainer-clean' target, but that is intended mainly for the package's developers. If you use it, you may have to get all sorts of other programs in order to regenerate files that came with the distribution.

Usage: qot [input and other options]
--help Print this message
--info Print summary information about every query
--input-file=< path > Read DDL and queries from the file. You can
specify this option more than once in which case
the files are read in the order of their
appearance on the command line
--input-query=< string > Read DDL and queries from the string. You can
specify this option more than once, in which case
the strings are read in the order of their
appearance on the command line
If both --input-file and --input-query options are
present, then the file(s) is/are read first
--output-mode=< mode > Output mode can be one of: xml, sql, text.
--propose=< item > For all the queries from the input perform
propose of < item > and print optimized < item >'s
SQL. < item > is one of: index, cov-index, merged-index.
--rewrite=< item > For all the queries perform rewrite of the < item >
and print the modified version of the < item >'s
SQL. At the moment < item > can be only expand-stars
which means replacing * wildcards in the select
items list.
--static-checks Perform query static checks
--version Print version and copyright info

What's New in This Release:

· This release ORDER BY analysis for index generation, an ORDER BY-specific rewrite (const-field removal), ORDER BY-specific static checks, table and field alias support, and improved error reporting.
· A segfault if query-file doesn't start with create database and use commands general was fixed along with a segfault for queries that use table alias.
· A crash with bigint, datetime, and enum field types was fixed.
· The covering index generation algorithm was fixed.

Last updated on June 17th, 2008

#MySQL DBA #intelligent assistant #query analysis #MySQL #DBA #database #query

Add your review!