GoDaddy服务器MySQL配置文件,仅供参考

GoDaddy服务器MySQL配置文件,有空研究研究,哈哈。。

[mysqld]
connect_timeout                  = 60
datadir                          = /var/lib/mysql
innodb_additional_mem_pool_size  = 10M
innodb_buffer_pool_size          = 4096M
innodb_fast_shutdown             = 1
innodb_flush_log_at_trx_commit   = 0
innodb_flush_method              = O_DIRECT
innodb_lock_wait_timeout         = 50
innodb_log_buffer_size           = 16M
innodb_log_file_size             = 64M
interactive_timeout              = 60
join_buffer_size                 = 4M
key_buffer                       = 128M
local-infile                     = 1
#log-bin
log_warnings                     = 0
max_allowed_packet               = 268435456
max_connections                  = 1000
max_connect_errors               = 10000
max_user_connections             = 200
myisam-recover                   = FORCE
myisam_sort_buffer_size          = 128M
net_buffer_length                = 8K
open_files_limit                 = 65535
query_cache_size                 = 32M
read_buffer_size                 = 1M
read_rnd_buffer_size             = 2M
skip-external-locking
sort_buffer_size                 = 4M
thread_cache                     = 100
tmpdir = /tmp/mysqltmp/
tmp_table_size                   = 64M
transaction_isolation            = READ-COMMITTED
user=mysql
wait_timeout                     = 60
table_definition_cache           = 1000
max_heap_table_size              = 64M
default-storage-engine           = MyISAM
innodb_file_per_table=1
performance_schema               = OFF

[mysqld-5.6]
table_open_cache                 = 5000

[mysqld-5.5]
table_cache                      = 5000
default-storage-engine           = MyISAM
innodb_file_per_table
innodb_support_xa                = 0
log_bin_trust_function_creators  = 0
sync_binlog                      = 0
binlog_format                    = MIXED
sysdate-is-now

[mysqldump]
max_allowed_packet               = 1024M
quick

[mysql]
disable-auto-rehash
prompt=\d>\_

[myisamchk]
key_buffer                       = 512M
read_buffer                      = 32M
sort_buffer_size                 = 512M
write_buffer                     = 32M

[mysqlhotcopy]
interactive-timeout

!include /root/.my.cnf

 

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值