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

  • Liferay CMS

    Liferay is a powerful and easily customizable CMS that is ideal for community collaboration – once you get it configured.

  • Snort

    Search out hidden attacks with the Snort intrusion detection system.

  • Free Software Projects

    Even hardened nerds are often over-challenged by the less than intuitive field of statistics. Besides the theory, you need to know how to use the software that converts all the theory into a practical application.

  • VpsAdmin Manages OpenVZ Instances

    The developers of a Czech hosting company has released a Web interface for administering virtual servers under OpenVZ.

  • MySQL Workbench 5.1

    A small database is easy to plan on paper, but the structure quickly becomes more complex as you add more elements. MySQL Workbench can help you keep the tables arranged.

comments powered by Disqus

Direct Download

Read full article as PDF:

ExtSQL.pdf (1.84 MB)


njobs Europe
Njobs Netherlands Njobs Deutschland Njobs United Kingdom Njobs Italia Njobs France Njobs Espana Njobs Poland
Njobs Austria Njobs Denmark Njobs Belgium Njobs Czech Republic Njobs Mexico Njobs India Njobs Colombia