Admin SQL Profiling

The SQL Profiling page provides information about interactions between the database and commands and queries being issued from within the ]project-open[ interface.  This is useful in tracking down lags and seeing the actions leading up to crashes.  From the main page a list of every command run on the database within the parameter range of time can be seen.  


The time and duration of the query are recorded along with the IP address and the file pathname containing the SQL.  If you would like to see the SQL along with the statistics associated with each SQL commands, first turn on,

 

  • "Database statistics is currently off (turn it on)"

and make sure that the statistics have been enabled.  Once they have been enabled, click on any of the commands that are listed and get a more detailed breakdown of what exactly was contained in each request.


To set the parameters on the time window and other viewing options click, 

 

  • "Set Package Parameters"

for an options menu. 


References

  • Admin Home Page
  • [Interactive Shell] - executes commands and displays their results by direct interaction with the AOLserver

 


  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com