LYONS, N.Y., Dec. 1 /PRNewswire/ -- Many MySQL(R) and PostgreSQL DBAs are frustrated by their inability to account for high server usage. The engineers at Software Workshop had similar feelings when trying to find 'usage hogs' among web hosting clients.
Relying on years of expertise, Software Workshop developed their own modifications to Open Source MySQL and called it ExtSQL(R). It gives DBAs a simple way to monitor activity by individual users, database, or even connection. ExtSQL has new commands built into the server as an extension to the SQL language, e.g.
SHOW STATISTICS select, insert FROM user HISTORY -- display the
number of select and insert statements issued per hour by each user.
Kelly Button, a senior admin stated, "We'd see a usage spike, but it was hard to track down to a user. ExtSQL makes monitoring easy by storing historical data and high usage patterns are easy to see. Many customers didn't know they were running poorly designed applications."
MySQL and PostgreSQL have a large installed base. DBAs can be very reluctant to go through an upgrade process. Software Workshop decided to pursue this huge 'after-market' by offering source patches and binaries for older versions on a variety of OS and hardware combinations. ExtSQL was recently featured in Linux Pro Magazine's December Issue. ExtSQL is being released under the GPL and can be found at http://www.ExtSQL.com/
Software Workshop is a member of the INCITS DM32.2 Technical Committee (the U.S. National Standards body with responsibility for SQL) and has made an initial proposal SQL be extended to define a usage accounting standard that could be implemented by other DB vendors such as Oracle(R), IBM(R), and Microsoft(R).
A company spokesperson said, "We anticipate our source code will eventually become part of the main MySQL & PostgreSQL distributions. But we hope to remain a focal point for future development and anticipate feedback and changes generated by the user community."
WEB:
http://www.SoftwareWorkshop.com/
http://www.LinuxProMagazine.com/
SOURCE Software Workshop Inc.