my.cnf
发布时间:2011-07-25 11:47:23 来源: 亚狐科技
Code:
# The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 1024 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 128M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 #PERSONALIZZAZIONI max_connections = 800 tmp_table_size = 64M max_heap_table_size = 64M open_files_limit = 8192 #innodb_buffer_pool_size = 126M #tmpdir=/tmpdb join_buffer_size = 256K # Disable Federated by default skip-federated # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout = 30
上一页1下一页 |
原文链接地址:https://www.yahuhost.com/server_technology/n354.html
版权所有@转载请注明原文地址
版权所有@转载请注明原文地址
【责任编辑:亚狐科技】
(Top) 返回页面顶端