diff options
Diffstat (limited to 'linhes/linhes-system/lh_sqlserver.cnf')
| -rw-r--r-- | linhes/linhes-system/lh_sqlserver.cnf | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/linhes/linhes-system/lh_sqlserver.cnf b/linhes/linhes-system/lh_sqlserver.cnf index 1850f8e..be2d5bd 100644 --- a/linhes/linhes-system/lh_sqlserver.cnf +++ b/linhes/linhes-system/lh_sqlserver.cnf @@ -40,6 +40,41 @@ [mariadb] datadir=/data/srv/mysql +skip-external-locking + +net_buffer_length = 8K +key_buffer_size = 768M +max_allowed_packet = 1M +tmp_table_size = 256M +max_heap_table_size = 256M +sort_buffer_size = 2M +read_buffer_size = 2M +read_rnd_buffer_size = 2M +myisam_sort_buffer_size = 64M +thread_cache_size = 8 +query_cache_type = 0 +query_cache_size = 0 +query_cache_limit = 2M +join_buffer_size = 1M +ignore-db-dir = lost+found +table_open_cache = 5000 +open_files_limit = 10000 + +# Uncomment the following if you are using InnoDB tables +#innodb_data_home_dir = /var/lib/mysql +#innodb_data_file_path = ibdata1:10M:autoextend +#innodb_log_group_home_dir = /var/lib/mysql +# You can set .._buffer_pool_size up to 50 - 80 % +# of RAM but beware of setting memory usage too high +#innodb_buffer_pool_size = 16M +#innodb_additional_mem_pool_size = 2M +# Set .._log_file_size to 25 % of buffer pool size +innodb_log_file_size = 16M +#innodb_log_buffer_size = 8M +#innodb_flush_log_at_trx_commit = 1 +#innodb_lock_wait_timeout = 50 +innodb_buffer_pool_instances = 1 + # This group is only read by MariaDB-10.8 servers. # If you use the same .cnf file for MariaDB of different versions, # use this group for options that older servers don't understand |