Tracking SQL statistics with ExtSQL

Security

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

extsql_users="john,domenic,phil,mary"

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.

Infos

  1. ExtSQL: http://www.ExtSQL.com/

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 (http://www.incits.org/). Contact John at mailto:jmurtari@softwareworkshop.com.

Buy this article as PDF

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

Buy Linux Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • systemd Tips

    Sure, you've heard about systemd, which is rapidly replacing the old System V init system as the go-to service management daemon for the Linux world. But what can you do with systemd really? We'll show you some tricks for improving security, managing processes, and analyzing boot times with systemd.

  • 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.

comments powered by Disqus