1

Need advise on mysql/apache performance tuning. Are my parameters right?

view story
linux-howto

http://serverfault.com – I have DS with 3g RAM and my processor is AMD Athlon(tm) 64 X2 Dual Core Processor 4200+. My server is running: Fedora release 15 (Lovelock) Linux * 2.6.40.6-0.fc15.x86_64 #1 SMP Tue Oct 4 00:39:50 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux my.cnf file is: [mysqld] #skip-innodb #log user=mysql log-slow-queries=/var/log/mysql/log-slow-queries.log long_query_time = 5 #query_cache_size = 20000000 query_cache_size = 134217728 thread_cache_size=40 wait_timeout=30 max_user_connections=40 max_connections=150 #default-character-set=cp1251 #skip-grant-tables datadir=/var/lib/mysql socket=/var (HowTos)