[客户]port ,,,,,,,,,,=
socket ,,,,,,,,=/数据//mysql.sock
,
(mysql) no-auto-rehash
,
(mysqld) user ,,=mysql ,,,,,,
port ,,=
socket =/数据//mysql.sock ,
basedir=/应用程序/mysql ,,
datadir=/数据//data ,,,,
open_files_limit ,,=1024,,,
back_log=600,,,,,,,,,,
max_connections=800,,,,,,,
max_connect_errors=3000,,,,,
table_cache=614,,,,,,,,,
外部锁=FALSE ,,,,
max_allowed_packet=8 m ,,,,,
sort_buffer_size=1 m ,,,,,,
join_buffer_size=1 m ,,,,,,
thread_cache_size=100,,,,,,
thread_concurrency=2,,,,,,
query_cache_size=2 m ,,,,,,
query_cache_limit=1 m ,,,,,
query_cache_min_res_unit=2 k ,,
# default_table_type=InnoDB ,,
thread_stack=192 k ,,,,,,,
# transaction_isolation=读取提交
tmp_table_size=2 m ,,,,,,,
max_heap_table_size=2 m ,,,
# long_query_time=1,,,,,,,# log_long_format
#日志错误=/数据//error.log
# log-slow-queries=/数据//slow.log ,,,,
pid文件=/数据//mysql.pid ,
# log-bin=/数据//mysql-bin ,
relay-log=/数据//relay-bin ,
relay-log-info-file=/数据//relay-log.info
binlog_cache_size=1 m ,,,,,,
max_binlog_cache_size=1 m ,,,,
max_binlog_size=2 m ,,,,,,,
expire_logs_days=7
key_buffer_size=16 m
read_buffer_size=1 m
read_rnd_buffer_size=1 m
bulk_insert_buffer_size=1 m
# myisam_sort_buffer_size=1 m
# myisam_max_sort_file_size=10 g
# myisam_max_extra_sort_file_size=10 g
# myisam_repair_threads=1 # myisam_recover
,
lower_case_table_names=1,,,,
skip-name-resolve ,,,,,,,,,
slave-skip-errors=1032, 1062,,,,
replicate-ignore-db=mysql ,,,,,
,
,
innodb_additional_mem_pool_size=4米通过innodb_buffer_pool_size=32 m
innodb_data_file_path=ibdata1:128M: autoextend
innodb_file_io_threads=4
innodb_thread_concurrency=8
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=2 m
innodb_log_file_size=4 m
innodb_log_files_in_group=3
innodb_max_dirty_pages_pct=90
innodb_lock_wait_timeout=120
innodb_file_per_table=0
[, mysqldump]
快速max_allowed_packet=2 m
,
[mysqld_safe]
/mysqld.pid
- - - - - - - - - - - mysql多实例启动文件
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
- - - - - - - - - - - -通过以上配置启动mysql数据库后生成的文件如下:
mysql-bin。000001年,,
mysql-bin。指数,,
mysqld。pid,,,,
mysql_3307。呃,,,
mysql。袜子,,,,
注意:当数据强制关机会导致状态显示启动,实际并没有运行的状态,遇见此种状态将mysql.sock文件改革名字,然后重新启动数据库即可,它会生成新的mysql。袜子文件
