There is like 500 options to enable or disable while recompiling a kernel.... I'm wondering if anyone has a rather, "better" .config that would work for a dual amd athlon 2400 MP+ and also one for Dual xeon 2.4 & 3.06 ghz.... I just am aiming for efficiency and getting the loads down, so I'm trying to optimize everywhere possible...
mysql .conf... /etc/my.cnf
./configure --prefix=/usr/local/apache2.2 --enable-rewrite --enable-so --enable-http --enable-vhost-alias;make && make install
./configure --prefix=/usr/local --with-apxs=/usr/local/apache2.2/bin/apxs --with-curl --with-zlib --enable-mbstring --with-mysql --with-xml;make && make install
That is how I install php and apache 2.2.2, is there any better tags? Those are the ones I could see using, gzip would be nice if anyone recommends it, is it a simple extra tag or anything more to install? someone recommended I add --with-mpm=prefork or worker, is that a good idea?
What are good settings to edit for
port = 3306
set-variable = max_connections=100
set-variable = max_user_connections=20
set-variable = key_buffer=16M
set-variable = join_buffer=4M
set-variable = record_buffer=4M
set-variable = sort_buffer=6M
set-variable = table_cache=1024
set-variable = myisam_sort_buffer_size=32M
set-variable = interactive_timeout=100
set-variable = wait_timeout=100
set-variable = connect_timeout=10
set-variable = thread_cache_size=128
obviously, I'm having some BIG problems hence why i'm trying to get the "pertected" setup. My friend has a forum with 2,000 people online and his mysql server only uses 100 mb ram, and his apache server only uses 900 mb ram at PEAK times, my apache server uses 2 gb ram for 250 requests currently being processed, which is ridiculous.
Yes I am on a 18.104.22.168-EL kernel, hence why I am planning to upgrade to 22.214.171.124 once I have a good config, but there are too many darn options.... Is there any "very good" .config files out there for this kernel ?
I love to learn, I am spending the past months only learning and experimenting but not making too much progress, google will probably block my ip for too many searches about learning linux in the past few weeks....hehe...