Karlsson on databases and stuff: SQLStats 1.3 released

Wednesday, March 16, 2011

SQLStats 1.3 released

I have released SQLStats 1.3 now, and it is available for download from sourceforge. The changes are small:

Cleaned up the build script a bit.
Fixed a bug that caused statements to be counted twice.
Made statement comparison non case sensitive.
A small fix to the normalizer, that would miss a few statements in some cases.

SQLStats is a plugin for MySQL 5.5 and up that allows live monitoring of SQL statements, without using the general query log and with the added benefit of managing statements with the literals removed. read more in my previous blog-post in the subject.

Enjoy!
/Karlsson

2 comments:

David Murphy said...: What version of 5.5 is this for?

When I build again 5.5.17 I am seeing:

sqlstats.cc: In function ‘int sqlstats_plugin_init(void*)’:
sqlstats.cc:70: warning: unused variable ‘i’
sqlstats.cc: In function ‘int sqlstats_plugin_deinit(void*)’:
sqlstats.cc:84: warning: unused variable ‘i’
sqlstats.cc: In function ‘void sqlstats_notify(THD*, const mysql_event*)’:
sqlstats.cc:137: error: invalid use of incomplete type ‘const struct mysql_event’
sqlstats.cc:125: error: forward declaration of ‘const struct mysql_event’
sqlstats.cc:129: warning: unused variable ‘i’
sqlstats.cc:130: warning: unused variable ‘currStmt’
sqlstats.cc: In function ‘tagTOPSTMT* find_in_lru(char*, const char*, unsigned int)’:
sqlstats.cc:245: warning: comparison between signed and unsigned integer expressions
sqlstats.cc: In function ‘tagTOPSTMT* find_in_top(tagTOPSTMT*, int)’:
sqlstats.cc:311: warning: comparison between signed and unsigned integer expressions
sqlstats.cc: In function ‘int sqlstats_is_topsql_fill(THD*, TABLE_LIST*, COND*)’:
sqlstats.cc:415: warning: unused variable ‘pStmt’
sqlstats.cc: In function ‘int sqlstats_is_lastsql_fill(THD*, TABLE_LIST*, COND*)’:
sqlstats.cc:433: warning: unused variable ‘pStmt’
sqlstats.cc: At global scope:
sqlstats.cc:539: error: invalid conversion from ‘void (*)(THD*, const mysql_event*)’ to ‘void (*)(THD*, unsigned int, const void*)’
[damurphy@damurphy-9963 sqlstats-1.3]$; November 11, 2011 at 10:44 PM
Unknown said...: hello
there are some change in the code for sql_audit.cc.
is it possible to have a fix with the last release please; October 19, 2012 at 4:11 PM