The statistics on server use are accessible from the HyperFileSQL Control Center. Simply select the database you want and access the "Log and Statistics" tab. From this tab, you can access the server's logs and activity statistics.

Server logs
The server logs contain information about the calls to the server, i.e. about the requests sent by the applications.
Logs allow you to monitor applications that use a HyperFileSQL server. For example, you can detect queries that are run an abnormal number of times, queries that take too long ...

Activity statistics
The activity statistics provide information about the HyperFileSQL server machine. For instance, the amount of information sent through the network, the amount of information read from the disk...
The activity statistics allow you to see whether the server is properly configured to support its loads: is the network card fast enough, are the disks fast enough, ...

Activation
The logs and statistics are enabled and configured in the "Configuration" tab of the HyperFileSQL Control Center.

To enable the logs, simply:
• select "Logs",
• check the "Enable the backup of the calls to the server in the log file" box. When selecting this option, all the calls to the server are stored along with the function that made the call (for example, HExecuteQuery or HReadSeek).

You can also store all the parameters of the calls to get an even more detailed log. To find out which query has been executed for example, the query parameters ...

To enable activity statistics, simply:
• select "Activity statistics",
• check "Enable the activity statistics of the server".

Note:
In order for the modifications to be taken into account, you need to click the "Apply" button.

Once the execution log have been enabled, you can display
• the most used queries,
• the longest queries,
• the longest function calls,
• the applications that consume the most,
• all the logs.

Simply select the information to display and the start and end dates you want, then click the "Display" button.