Optimization Request! :)

[M1th]

Heya Eva,

Attached are the info you need. Any help would be appreciated. :)

Cheers,
M1th

PS. I have a problem caching images on my site as well. images are downloaded everytime. Now I have checked every vB setting that I know but still no luck trying to sort out this problem. I've been told that its a server config but I have no idea how that can be achieved. :confused:

[eva2000]

1. upgrade to mysql 4.0.17
2. change my.cnf to below and restart mysql


[mysqld]
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb

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

[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log

[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


3. in admincp -> vB options -> Help Cookies and HTTP Header Options -> Add No-Cache HTTP Headers = NO

[M1th]

Thank for the optimization :)

3) I did all that but no luck.. not sure if you've been following this thread or not.. it will explain my problem better :)


http://www.vbulletin.com/forum/showthread.php?t=91182

Scott tried it (many thanks for taking the time to help) but still hasnt been able to figure out what the problem is.. :/

[M1th]

Hmm, I've just installed the php accelerator [well, it wasnt working so I fixed the problem] on my forum and now the server load average has gone up by 2. Is this normal?

[M1th]

Thank for the optimization :)

3) I did all that but no luck.. not sure if you've been following this thread or not.. it will explain my problem better :)


http://www.vbulletin.com/forum/showthread.php?t=91182

Scott tried it (many thanks for taking the time to help) but still hasnt been able to figure out what the problem is.. :/

^^^ Anyone got any ideas? Vary Headers are keep getting added to my site no matter what I do... :/

[eva2000]

remove PHP accelerator for now until you can figure out the problem

[M1th]

Okay, I've upgraded my server to something more powerful since the activity/database has drastically increased compared to last time.

Any optimization help (if necessary) is appreciated, eva!


Thanks :)

[eva2000]

you actually look fine there with the mysql status etc all is well with your my.cnf as well :)

[Zachery]

And he didnt want to believe that i gave him a good config :p

[M1th]

Yep, thanks Zak.

Onto another (most recent) problem... I've been getting numerous reports from members telling me that they keep getting "Page cannot be found" errors at times when they want to search for a word or post, although I couldnt reproduce it in IE myself. This problem arose since the upgrade to php 4.3.8, i think ( http://www.cosforums.com/info.php ) but I'm not sure how this could've been the reason. :S

Any ideas?

[Scott MacVicar]

You should check the error log if you can as "Cannot find server" means that apache gave no content back, not even headers which is most likely a crash.

[M1th]

Ah, I meant "Page cannot be displayed" my bad. Also, here's the page if you want more details on this issue:

http://www.cosforums.com/showthread.php?t=21641&page=21&pp=30

I'm trying to figure out why this is happening, no luck so far. Any help on this is much appreciated.

[M1th]

Okay, that thread seems to have been deleted for some reason but anyway, this problem still persists and I'm going mad trying to find what is up. When you load a page, it gets stuck at times, like a pause or something then loads fast after a few seconds.

I've been keeping an eye on the top stats for a couple of hours too and been seeing alot of <defunct> httpd connections:

27217 user 23 0 0 0 0 Z 0.1 0.0 0:00 3 httpd <defunct>

Could this be related to my problem? Any ideas?

Thanks again

[mrfox1979]

Okay, that thread seems to have been deleted for some reason but anyway, this problem still persists and I'm going mad trying to find what is up. When you load a page, it gets stuck at times, like a pause or something then loads fast after a few seconds.

I've been keeping an eye on the top stats for a couple of hours too and been seeing alot of <defunct> httpd connections:

27217 user 23 0 0 0 0 Z 0.1 0.0 0:00 3 httpd <defunct>

Could this be related to my problem? Any ideas?

Thanks again

your log files for apache i bet are over 2gigs rotate or del

[M1th]

Hmm, how do I check? I dont see any options to configure log rotation in cpanel/whm.

EDIT: Yep, that was the issue. Fixed now. thanks!!

[eva2000]

Hmm, how do I check? I dont see any options to configure log rotation in cpanel/whm.

EDIT: Yep, that was the issue. Fixed now. thanks!!
glad to see ya fixed it! ... to everyone with large high traffic sites, always manage your logs!

[M1th]

I added this to my.cnf about a month ago

log_slow_queries=/var/log/slow-queries.log
long_query_time=2
log-long-format

But the slow-queries.log file is always empty. Is this normal?

[Zachery]

That means theres no slow querys ;)

[M1th]

No actually I didnt chown the log file so it couldnt write to it.

Anyway, I've been having some server load problems during the past couple of days. It seems to me that the server load shoots up to about 4 and sticks there for a few hours. (like now, it is on 3.55, 3.46, 3.46), although the site is still accessible. So, is there any way I can detect exactly what is causing this? I cant quite figure out when this happens either...