]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

3 registered users
 in last 24 hours

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.  

 

image:screenshot_page_ds_index.gif

 

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.

 

image:screenshot_page_ds_index_1.gif

 

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

 

  • "Set Package Parameters"

for an options menu. 

 

image:screenshot_page_ds_index_2.gif

 

References

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

 



Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy