Database Configurations
General Syntax
This collection of commands configures settings related to the MySQL database that stores transfer data (for use with Aspera Console before version 3.0).
The syntax for setting database parameters is the following:
# asconfigurator -x "set_database_data;parameter,value"
Database Configurations
- server
- The IP address of the database server (or the IP address of the Aspera Console server).
- port
- The port that the database server listens on. The default value for an Aspera Console installation is 4406.
- user
- The user login for the database server.
- password
- The password for the database server.
- database_name
- The name of the database used to store Aspera transfer data.
- threads
- The number of parallel connections used for database logging.
- exit_on_database_error
- Whether all transfers are stopped on a database error
(
true
) or not (false
). - session_progress
- Whether transfer status should be logged at a given interval
(
true
) or not (false
). Transfer status includes number of files transferred, bytes transferred, among other stats. - session_progress_interval
- The frequency at which an Aspera node logs transfer session data, in seconds.
- file_events
- Whether complete file paths and file names should be logged
(
true
) or not (false
). Performance may be impacted when setting this to true for transfers of thousands of files. - file_progress
- Whether file status, such as bytes transferred, should be logged
(
true
) or not (false
). - file_progress_interval
- The frequency with which an Aspera node logs file transfer data, in seconds.
- files_per_session
- The number of file names to be recorded for any transfer session. For example, if the value is set to 50 the first 50 filenames will be recorded for any session. A setting of 0 logs all filenames. The session will still record the number of files transferred, and the number of files completed, failed or skipped.
- file_progress_interval
- The frequency at which an Aspera node logs file transfer data, in seconds.
- ignore_empty_files
- Whether to block the logging of zero byte files (
true
) or not (false
). - ignore_skipped_files
- Whether to block the logging of skipped files (
true
) or not (false
). - ignore_no_transfer_files
- Whether to block the logging of files that were not transferred because they
already exist at the destination (
true
) or not (false
).