[ask]Apache and mySQL tweak tunning

[nixell]

Hello,

Anyone have suggestion how best apache and mysql tweak for shared hosting provide

thank you

 

[serversignature]

For Apache : Using KeepAlive can increase speed for both you and the client.
I think it's best to have KeepAlive on, and KeepAliveTimeout very low (like 1-2 seconds).

If you serve 100% static files with Apache, each httpd process will use around 2-3 megs of RAM. If you serve 99% static files & 1% dynamic files with Apache, each httpd process will use from 3-20 megs of RAM

For mysql see how it is performing: mytop - display MySQL server performance info like `top'

The latest version of mytop is available from mytop - a top clone for MySQL.

Thanks,
Kiran

 

[nixell]

i using this for mysql

[mysqld]
skip-bdb

max_connections = 100
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 10
wait_timeout = 10
connect_timeout = 10
max_allowed_packet = 1M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 10M
query_cache_type = 1
tmp_table_size = 16M

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 32M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

and this for apache

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 1
MinSpareServers 5
MaxSpareServers 10
StartServers 15
MaxClients 250
MaxRequestsPerChild 1000
HostnameLookups Off

that tweak is correct??

 

[webcave]

i using this for mysql

[mysqld]
skip-bdb

max_connections = 100
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 10
wait_timeout = 10
connect_timeout = 10
max_allowed_packet = 1M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 10M
query_cache_type = 1
tmp_table_size = 16M

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 32M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

and this for apache

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 1
MinSpareServers 5
MaxSpareServers 10
StartServers 15
MaxClients 250
MaxRequestsPerChild 1000
HostnameLookups Off

that tweak is correct??

I tried those and they seem to work great thanks!

 

[zitro]

how?

hi there, i a newbie just wanted to ask how can i add this tweak, (what specific file will i open to do this) thanks in advance. :D