分享到:
发表于 2009-01-08 09:55:04 楼主 | |
两台服务器,一台web,一台mysql,show processlist 会出现一些unauthenticated user ,之后我添加了 --skip-name-resolve禁止解析 并,在/etc/hosts里也添加了 x.x.x.x apache 用来解析web主机,但是还是会出现unauthenticated user ,但是速度似乎没有受到影响, 这是为什么呢? 我用的是mysql 5.1.30 ,配置文件是 port = 3306 socket = /usr/local/mysql/tmp/mysql.sock bbsedir = /usr/local/mysql datadir = /usr/local/mysql/var open_files_limit = 60 skip-name-resolve back_log = 1000 max_connections = 100 max_connect_errors = 200 table_cache = 6 external-locking = FALSE max_allowed_packet = 32M sort_buffer_size = 128K join_buffer_size = 128K thread_cache_size = 10 thread_concurrency = 8 query_cache_size = 102M query_cache_limit = 2M query_cache_min_res_unit = 2k default_table_type = MyISAM thread_stack = 192K transaction_isolation = READ-COMMITTED tmp_table_size = 10M max_heap_table_size = 10M long_query_time = 1 log_long_format server-id = 1 binlog_cache_size = 4M max_binlog_cache_size = 8M max_binlog_size = 512M expire_logs_days = 7 key_buffer_size = 308M read_buffer_size = 1M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover |
|
楼主热贴 |
针对ZOL星空(中国)您有任何使用问题和建议 您可以 联系星空(中国)管理员 、 查看帮助 或 给我提意见