|
|
|
|
|
|
|
|
|
|
- Overview
- General
- Logs
- Logs
- Activity statistics
- System
- Caches
- Notifications
- Replication
- Version
HFSQL server configuration
 Available only with this kind of connection
The HFSQL Control Center allows you to fully manage HFSQL servers. To display the characteristics of an HFSQL server: - Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
- Double-click the name of HFSQL server in the tree structure.
- The right section of Control Center displays a tab with the server name. This tab includes:
- several tabs used to manage the characteristics of HFSQL server.
- a ribbon used to configure the HFSQL server.
In the ribbon, in the "Parameters" group, the "Server configuration" option allows you to configure the HFSQL server.
In the server configuration window, click "General". The following options are displayed:
You can configure: - Location of the databases, i.e. the data files of the different HFSQL Client/Server applications. Shortcuts can be used to indicate the specific directories:
- "%%EXE%%": Manta service directory.
- "%%COMMONAPPDATA%%": Common data directory for all applications.
- Calculation of statistics on keys This option automatically optimizes query and filter execution.
- Local storage directory: This directory contains all recovered data (logs and statistics) for consolidation over long periods..
- Server language: Server message language.
If the client application was able to open the connection on the HFSQL Client/Server server, then any error (an incorrect password, for example) is returned by the HFSQL server in the client application's language..
If the client application was unable to open the connection (incompatible encryption, for example), then the error message is returned in the language configured in the HFSQL Client/Server server.
In the server configuration window, click "File logs". The following options are displayed:
You can define the log file and backup file directories. In the server configuration window, click "Server logs". The following options are displayed:
You can: - specify the directory of log files.
- enable the backup of calls to the server in the log file.
- enable the backup of call parameters in the log file.
You also have the ability to specify the maximum size for log file. In the server configuration window, click "Activity statistics". The following options are displayed:
The activity statistics are used to measure the server workload. You can: - enable the activity statistics,
- specify the backup directory,
- specify the maximum file size,
- specify the period for calculating performance (in seconds).
In the server configuration window, click "System". The following options are displayed:
- Sever listening port,
- Server user account (Linux only)
- Allow sizes larger than 2GB for system files.
- Port for remote debugging,
- Enable authentication via Active Directory.
 New in version 2025It is also possible to manage the history of plan executions. The various scheduled elements (tasks, optimizations, etc.) have an execution history, so that you can see when they were carried out, as well as the report, etc. It is possible to: - define the maximum size of the execution history, i.e. the maximum number of executions stored in the scheduling history (default: 100,000).
- clear history. In this case, all execution histories of planned items will be deleted.
In the server configuration window, click "Caches". The following options are displayed:
- Size of index cache.
Note: in 32-bit mode, the size of the index cache is limited to 1GB. - Disk cache (Windows server only): Windows' standard disk cache management in 64-bit mode (independently of HFSQL) can lead to memory saturation.. This option is used to customize the management of memory caches.
In the server configuration window, click "Notifications". This option is used to manage the recipients of notifications. Please note: it is necessary to configure the sending of notifications before adding recipients.. In the server configuration window, click "Replication". In the server configuration window, click "Version". This option is used to: - Find out the current version of the server:
- Major version: Version corresponding to the version of the HFSQL engine used by the server..
- Minor version: Number of the update used.
- Language: Language used for the server.
The link "More details" is used to get the details of the modules used. - Implement the automatic server update. If this option is enabled, the HFSQL server can be automatically updated as soon as a new version is available:
- on the PC SOFT server.
- on a custom server.
For more details, see Updating the server.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|