|
| |
| 1. SQL Profiler | | By: | | | License: | Apache Software License | | URL: | http://www.jahia.net/jahia/page597.html | | Description: | This is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create indexes.
This small tool, released under an Apache-based license 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 and can generate SQL index creation files. 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.
|
| 2. Sequoia | | By: | | | License: | Apache Software License | | URL: | http://sequoia.continuent.org/HomePage | | Description: | Sequoia is a transparent middleware solution for offering clustering, load balancing and failover services for any database. Sequoia is the continuation of the C-JDBC project8. The database is distributed and replicated among several nodes and Sequoia balances the queries among these nodes. Sequoia handles node failures and provides support for checkpointing and hot recovery.
|
|