kaanozer Posted May 31, 2008 Posted May 31, 2008 Hi all, Can you help me for optimize my dedicated. I use Core2Quad Q6600 2.4 Ghz 4 GB DD2 Ram 2x500 GB Hdd Cpanel Mysql 5 and Apache2. I host large IPB forums 10K, 5K, 3K hits. Total 3K online users. my.cnf if[mysqld] local-infile=0 datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=4M query_cache_size=32M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=100 max_connections=250 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=128M ## 128MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=8000 open_files_limit=30000 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 collation-server=latin1_general_ci log_queries_not_using_indexes long_query_time=3 log_slow_queries=/var/log/mysql/log-slow-queries.log low_priority_updates=1 concurrent_insert=2 [mysql.server] user=mysql [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout Where can i change this sets? Thanks.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.