Apache and Mysql configurations

OttoYiu · 07-09-2006, 04:30 PM

Hello,

Can any webhost give me a copy of their optimized Apache httpd.conf and their Mysql my.cnf?

My server is not really optimized and the load can go up to 20 when there is only 40-50 Apache connections.

I have a:

Pentium 4 2.8 GHz
1 GB of RAM
120 GB IDE

Thanks in advance!

I will rep anyone who helps.

Zeus · 07-27-2006, 06:08 PM

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=500
max_user_connections=10
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
#log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[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=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
????: NamePros.com http://www.namepros.com/web-hosting-discussion/215255-apache-and-mysql-configurations.html

-----------------------------------------------
httpd.conf
"Timeout 300"
"KeepAlive off"
"MinSpareServers 8"
"MaxSpareServers 13"
"MaxRequestsPerChild 50"
"HostnameLookups Off"

Hope this helps you.

Duport · 07-28-2006, 06:40 PM

Timeout should be enabled

07-09-2006, 04:30 PM	THREAD STARTER #1 (permalink)
OttoYiu NamePros Regular Join Date: Nov 2005 Location: Vancouver, B.C. Posts: 969	Apache and Mysql configurations Hello, Can any webhost give me a copy of their optimized Apache httpd.conf and their Mysql my.cnf? My server is not really optimized and the load can go up to 20 when there is only 40-50 Apache connections. I have a: Pentium 4 2.8 GHz 1 GB of RAM 120 GB IDE Thanks in advance! I will rep anyone who helps. __________________ Best Regards, Otto Yiu Backomatic.com

07-28-2006, 06:40 PM	#3 (permalink)
Duport NamePros Member Join Date: Sep 2004 Posts: 27	Timeout should be enabled __________________ █ Duport Online - Virtual Shared / Reseller / Dedicated █ Multiple Domain Hosting .... 24/7 Technical Support - UK Website

07-27-2006, 06:08 PM	#2 (permalink)
Zeus Account Suspended Join Date: Jul 2006 Posts: 48	[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb query_cache_limit=8M query_cache_size=256M query_cache_type=1 max_connections=500 max_user_connections=10 interactive_timeout=20 wait_timeout=20 connect_timeout=6 thread_cache_size=128 key_buffer=16M join_buffer=1M max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=2M read_buffer_size=2M max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=4 myisam_sort_buffer_size=64M #log-bin server-id=1 [mysql.server] user=mysql basedir=/var/lib [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=32M sort_buffer=32M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=32M sort_buffer=32M read_buffer=16M write_buffer=16M ????: NamePros.com http://www.namepros.com/web-hosting-discussion/215255-apache-and-mysql-configurations.html ----------------------------------------------- httpd.conf "Timeout 300" "KeepAlive off" "MinSpareServers 8" "MaxSpareServers 13" "MaxRequestsPerChild 50" "HostnameLookups Off" Hope this helps you.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)