News
Choose a News item and you can browse, search, and post messages.
pqa v1.6 released!
Yep, after a long hiatus, v1.6 of the Practical Query Analyzer is out. It fixes a silly bug that prevented it from being run directly, it's got various internal improvements, and if you install it via RubyGems you can run it using "pqa -f file [etc, etc]". You can download v1.6 here:
pqa v1.5 released....
...with numerous bug fixes and improvements, almost all of them done by Thomas Favier. PQA should return more accurate results and the normalization should work better, too. You can download v1.5 here:
Welcome aboard to Thomas Favier!
He's submitted some patches and will be working on various things, including the "need to use the pid" issue.
pqa v1.4 released...
...with several bug fixes to the syslog parser. You can download it here:
pqa v1.3 released...
...with improvements to the MySQL log parser, a new "parse errors" report to assist when things go wrong, and a change - the default log type is now pglog. You can download it here:
pqa v1.2 released...
..with MySQL log file support! Just use the "-logfile mysql" option for fun times.
pqa v1.1 released...
...the syslog report now includes duration information, there are more text reports, and it runs a bit faster than 1.0. Good times!
pqa v1.0 released...
...with a normalization improvement, better syslog support, and a couple of minor bug fixes. You can download it here:
Example report updated
....now includes an analysis of about 50,000 queries off the database behind http://rubyforge.org/:
Oh, and the updated documentation...
...is here:
