Novell Archive and Version Services 2.1 uses the ArkSQL.cnf file to configure the ArkSQL settings. Use the sys:\arkManager\arkSQL_sample.cnf file as a guide to configure the sys:\arkManager\arkSQL.cnf file.
For information about configuring ArkSQL.cnf, see Section 7.3.6, Installing and Configuring the ArkSQL Server.
#This is the sample file to configure the MySQL server instance for ArkManager use.
#Copy the contents to sys:\arkManager\arkSQL.cnf, and modify it accordingly.
# The MySQL server
[mysqld]
port = 3306
datadir = Ark:/archive
default-table-type=InnoDB
lower_case_table_names=1
skip-locking
set-variable = key_buffer=32M
set-variable = max_allowed_packet=5M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = read_buffer_size=1M
set-variable = net_buffer_length=16K
set-variable = query_cache_size=32M
#log-bin
server-id = 1
thread_cache_size = 8
# thread cache
# thread concurrency
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname # deprecated
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000
# Comment the following if you are using Innobase tables
#skip-innodb
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:400M:autoextend
#innodb_data_home_dir = Ark:/archive/
innodb_log_group_home_dir = Ark:/archive/
innodb_log_arch_dir = Ark:/archive/
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = transaction_isolation=READ_COMMITTED