kaanozer Posted May 31, 2008 Share 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. Link to comment Share on other sites More sharing options...
WoLeRiNe` Posted July 24, 2008 Share Posted July 24, 2008 I have this server. How can we optimize server? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.