This is to announce the availability of 0.6 beta of the Performance Monitor module for ADOdb Lite with MySQL. I wish I had more available time to test this in more detail and support remaining databases, but since I don’t (at present) I am releasing this version so that something exists for people to test/comment on. I intend revisiting in about a week or so (mainly to finish adding Postgres support, fix any Windows platform issues, etc).

Download: ADOdb Lite 1.20 (with perfmon module).

The release includes the modules for the mysqli and mysql drivers, all base perfmon module classes, and a modified version of ADOdb’s tohtml.inc.php file. The release is packaged as a full version of ADOdb Lite 1.20 (though not an official release of course!). I have included a patch file (using subversion diff) between a virgin copy of ADOdb-Lite 1.20 and the final version with all changes required to add the module – may be useful.

Main differences in ADOdb-Lite version of the Performance Monitor tool (compared to ADOdb):

- Now supports the MySQL5 DBMS with the mysqli PHP extension
- HTML has been updated to XHTML 1.0 Transitional compliance
- Removed defunct and/or duplicate methods of disabling/re-enabling SQL logging
- Integrates several methods from ADOdb (MetaTables(), ServerInfo(), etc.)

Please read the README file in the downloaded library. The unix patch file is called “adodblitepatch”. Any questions/queries/bugs can be addressed via comments, or posted to the main QS forums. Documentation for using the module is identical to that distributed with ADOdb, or available on the ADOdb website – I have not packaged this. See http://phplens.com/lens/adodb/docs-perf.htm and the included README.

The module has been tested for MySQL5/PHP5 using the mysqli driver on Linux (the situation I required it for). Support for MySQL 4.0 using the mysql driver is also added, but has not been tested well. Also, no testing has been performed on the Windows platform – so expect something to go wrong if testing there. Support for PostgreSQL while not included is forthcoming. Please note this is a beta release – and unfinished.

Thanks go out to Panama Jack (Mark Dickenson) for making the ADOdb Lite library leading to me having to integrate a perfmon module for MySQL5 in the first place…;-).

Related posts:

  1. Performance Monitoring for ADOdb-Lite?
  2. More on ADOdb-Lite and Perfmon…
  3. ADOdb-Lite PerfMon: Basics Completed
  4. ADOdb Lite
  5. ADOdb vs ADOdb-Lite? It’s not a war…