- 积分
- 105
- 威望
-
- 金钱
-
- 注册时间
- 2011-12-21
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
![](static/image/common/ico_lz.png)
楼主 |
发表于 2021-3-11 09:53:37
|
显示全部楼层
- [client]
- #password = your_password
- port = 3306
- socket = /tmp/mysql.sock
- [mysqld]
- port = 3306
- socket = /tmp/mysql.sock
- datadir = /home/mysql
- skip-external-locking
- key_buffer_size = 256M
- max_allowed_packet = 1M
- table_open_cache = 1024
- sort_buffer_size = 4M
- net_buffer_length = 8K
- read_buffer_size = 4M
- read_rnd_buffer_size = 512K
- myisam_sort_buffer_size = 64M
- thread_cache_size = 128
- tmp_table_size = 128M
- performance_schema_max_table_instances = 6000
- explicit_defaults_for_timestamp = true
- #skip-networking
- max_connections = 1000
- max_connect_errors = 100
- open_files_limit = 65535
- default_authentication_plugin = mysql_native_password
- wait_timeout = 60
- interactive_timeout = 60
- log-bin=mysql-bin
- binlog_format=mixed
- server-id = 1
- binlog_expire_logs_seconds = 864000
- early-plugin-load = ""
- default_storage_engine = InnoDB
- innodb_file_per_table = 1
- innodb_data_home_dir = /home/mysql
- innodb_data_file_path = ibdata1:10M:autoextend
- innodb_log_group_home_dir = /home/mysql
- innodb_buffer_pool_size = 1024M
- innodb_log_file_size = 256M
- innodb_log_buffer_size = 8M
- innodb_flush_log_at_trx_commit = 1
- innodb_lock_wait_timeout = 50
- sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
- [mysqldump]
- quick
- max_allowed_packet = 16M
- [mysql]
- no-auto-rehash
- [myisamchk]
- key_buffer_size = 256M
- sort_buffer_size = 4M
- read_buffer_size = 4M
- write_buffer_size = 2M
- [mysqlhotcopy]
- interactive-timeout
- [mysqld_safe]
- malloc-lib=/usr/lib/libjemalloc.so
复制代码 |
|