ExtSQL is not a new database server. It is a significant set of independently developed software additions and patches to the existing source code of both MySQL and PostgreSQL. It provides a new set of SQL language features that make it easy for a DBA to monitor and audit activity on a busy server and account for activity by user, database, or even connecting client host. It even includes the ability to store historical usage data in amounts and time intervals specified by the DBA. It is not a separate monitoring utility, but built into the core of both servers.
StreamCruncher is an event processor. It supports a language based on SQL that allows you to define "event processing" constructs like sliding windows, time-based windows, partitions, and aggregates. Such constructs allow for the specification of boundaries (some are time sensitive) on a stream of events that SQL does not provide. Queries can be written using this language, which in turn can be used to monitor streams of incoming events. It also provides a feature similar to materialized views. Joins and sub-queries are also supported to allow event co-relation. A database is used underneath to do the heavy lifting. Pattern matching or multi-stream correlation are also possible.
nexB OpenAssets is a tool for inventorying, managing, and monitoring applications, software, hardware, networks, and generally any IT asset. It is designed so that system administrators, IT, and finance can determine what they have, how it is configured, what it is used for, and how much it is being used, so that informed decisions can be made. It complements existing network management software, integrates with a growing number of protocols and tools, and features no-agent discovery and inventory, configuration management including dependencies and correlation, monitoring, and reporting. It makes extensive and innovative use of XML, Xpath, and Xquery.
This small tool connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns to enable database index creation. Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.
MyAM is an alert manager. Send an alert to MyAM and it will perform the following operations: archive the alert, update the user views that are concerned in the alert, and execute actions depending on the alert type and content. Additionnaly, MyAM will clean old archived alerts. MyAM stores alerts on your disk (not in a database), which makes it easy to develop, easy to install, and easy to administer.