以下是老牛的数据库配置文件,经过生产环境考验,感觉还行,放出来给大家参考,配置项具体含义请自行问度娘
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 | [client] #password = your_password port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock user = mariadb basedir = 这里是你自己的路径(查安装后的默认配置文件) datadir = 这里是你自己的路径(查安装后的默认配置文件) log_error = 这里是你自己的路径(查安装后的默认配置文件) pid-file = 这里是你自己的路径(查安装后的默认配置文件) back_log = 384 bulk_insert_buffer_size = 8M connect_timeout = 10 group_concat_max_len = 1024 join_buffer_size = 128K key_buffer_size = 1344M max-allowed-packet = 64M max-connect-errors = 1000000 max_length_for_sort_data = 1024 max_connections = 500 max_heap_table_size = 256M myisam-recover-options = FORCE,BACKUP myisam_sort_buffer_size = 256M myisam_max_sort_file_size = 1024M net_buffer_length = 16384 open_files_limit = 65535 query_cache_type= 1 query_cache_size = 128M query_cache_limit = 512K query_cache_min_res_unit = 2K query_prealloc_size = 262144 query_alloc_block_size = 65536 read_buffer_size = 256K read_rnd_buffer_size = 512K sort_buffer_size = 256K skip-name-resolve skip-external-locking tmp_table_size = 256M transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 thread_cache_size = 256 table-definition-cache = 2048 table_open_cache = 2048 thread_concurrency = 8 wait_timeout = 1800 log-bin=mysql-bin binlog_format=mixed server-id = 1 expire_logs_days = 7 default_storage_engine = InnoDB innodb_file_per_table = 1 innodb_data_home_dir = /mnt/mariadb/var innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /mnt/mariadb/var #default innodb_buffer_pool_size = 128M innodb_buffer_pool_size = 128M innodb_log_file_size = 32M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 32M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout |
原文链接：https://xiaohost.com/2612.html，转载请注明出处。
评论0