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