ExtSQL Provides Usage Accounting

Pete Prestipino
by Pete Prestipino 03 Oct, 2008
ExtSQL Provides Usage Accounting

One of the many challenges of being a MySQL database administrator is the inability to account for high server usage. While some current tools provide good reports on overall activity -- none report usage by individual users, a specific database, or connecting client to help DBA's identify usage hogs among web hosting clients.

EXTSQLSoftware Workshop developed their own modifications to Open Source MySQL and called it ExtSQL and it's something you might want to look into. It gives DBAs a simple way to monitor activity by individual users, database, or even connection.

MySQL has an installed base of millions, with many installations running older versions. DBAs can be very reluctant to go through an upgrade process. Software Workshop decided to pursue this huge 'aftermarket' by offering source patches and binaries for older versions of MySQL on a variety of OS and hardware combinations. ExtSQL is being released under the GPL.

Pete Prestipino
Pete Prestipino
Digital marketing executive with proven experience in all aspects of search engine optimization (SEO), performance-based advertising, consumer-generated/social media, email marketing, lead generation, Web design, usability, and analytics. - 20-year Internet marketing veteran, currently serving as the Digital Marketing Campaign Manager at Antenna Group (formerly Chicago Digital). - Former Editor-In-Chief of Website Magazine, and a regular speaker on Web technology digital marketing strategy - Author of several books on digital marketing Including Web 360: The Fundamentals of Web Success; Affiliate 360: The Fundamentals of Performance Marketing; Domains 360: The Fundamentals of Buying & Selling Domain Names, and SEO 360: The Fundamentals of Search Engine Optimization.