Tracking SQL statistics with ExtSQL


Because you might not want to share ExtSQL information with every user, the configuration file lets you specify the users who will have access:


The root user is always allowed access.

Controlling ExtSQL

Additional commands (Table 2) allow the database administrator to temporarily suspend data collection, store data, and even change what data is being collected – without a server restart.

A configuration option called extsql_reload_file allows you to store collected data, which is automatically saved and restored during a restart.

Future Directions

Development with ExtSQL should be strong, and we plan to provide a focal point for community discussion, bug reports, fixes, and enhancements.


  1. ExtSQL:

The Author

John Murtari has a B.S. in Astronautical Engineering from the Air Force Academy and an M.S. in Computer Science from Syracuse University. He represents Software Workshop Inc. as a member of the INCITS H2 Technical Committee for SQL standards ( Contact John at

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy Linux Magazine

Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

comments powered by Disqus

Direct Download

Read full article as PDF:

ExtSQL.pdf (1.84 MB)