diff options
Diffstat (limited to 'linhes/linhes-system/lh_sqlserver.cnf')
-rw-r--r-- | linhes/linhes-system/lh_sqlserver.cnf | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/linhes/linhes-system/lh_sqlserver.cnf b/linhes/linhes-system/lh_sqlserver.cnf new file mode 100644 index 0000000..be2d5bd --- /dev/null +++ b/linhes/linhes-system/lh_sqlserver.cnf @@ -0,0 +1,82 @@ +# +# These groups are read by MariaDB server. +# Use it for options that only the server (but not clients) should see +# +# See the examples of server my.cnf files in /usr/share/mysql/ +# + +# this is read by the standalone daemon and embedded servers +[server] + +# this is only for the mysqld standalone daemon +[mysqld] + +# +# * Galera-related settings +# +[galera] +# Mandatory settings +#wsrep_on=ON +#wsrep_provider= +#wsrep_cluster_address= +#binlog_format=row +#default_storage_engine=InnoDB +#innodb_autoinc_lock_mode=2 +# +# Allow server to accept connections on all interfaces. +# +#bind-address=0.0.0.0 +# +# Optional setting +#wsrep_slave_threads=1 +#innodb_flush_log_at_trx_commit=0 + +# this is only for embedded server +[embedded] + +# This group is only read by MariaDB servers, not by MySQL. +# If you use the same .cnf file for MySQL and MariaDB, +# you can put MariaDB-only options here +[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 +[mariadb-10.8] + |