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.

Read full article as PDF:

ExtSQL.pdf (1.84 MB)

Related content

comments powered by Disqus

Direct Download

Read full article as PDF:

ExtSQL.pdf (1.84 MB)

News

njobs Europe
What:
Where:
Country:
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