im using invision board 1.3

my server is a 2.4ghz p4 w/ 512 mb ram, on RHE///


i have about 7mb worth of data in the post table in my mysql database (22069 posts).. i dont have a lot of regular users, most is around 8 or so at a time online and that happens maybe a few times a day. All my other pages in the fourm load fast, but threads take anywhere from 6 - 12 seconds to display... and these can be threads with hardly any pics or only one post. im not the only user who experiences the slow loads.

ive updated php to 4.3.8 and mysql to 4.0.20... recently and i have seen no performance gain

could it be i need more memory? i have about 20 other sites on the server that get light / moderate traffic (under 10k each/month)..

=========

03:43:56 up 10 days, 4:17, 1 user, load average: 0.00, 0.00, 0.00
109 processes: 108 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 0.9% 0.0% 0.4% 0.0% 0.0% 0.0% 98.5%
cpu00 1.9% 0.0% 0.0% 0.0% 0.0% 0.0% 98.0%
cpu01 0.0% 0.0% 0.9% 0.0% 0.0% 0.0% 99.0%
Mem: 495772k av, 473416k used, 22356k free, 0k shrd, 29056k buff
229264k actv, 4k in_d, 6688k in_c
Swap: 1052248k av, 34320k used, 1017928k free 157676k cached

Greetings

I currently run 6 invision forums on one box.

Currently have 35,000 members, 250,000 posts and avergaing 8,000 uniques a day and I am running a xeon dual 2.8 with 2 gig of ram on Linux.

it handles these fine.

One thing I have had to optimise was

Http logs were huge.. now have rotation for every 100 meg

Backups at a different time as these really bogged our forums

I would suggest adding more ram first. if this doesnt happen then ask support to spend some time on your box.. I paid for level 2 support and they fixed a few problems and did some great optimisation.

alos do you have Gzip enabled?

yup gzip is enabled... and i dont think my http logs are huge... they are archived at the end of every month... i dont have too many people vistiting this site a day... maybe less than 75

well i put in a request for an extra 512... i HOPE that helps.

i have never had to much problems with invision.. its a pretty good forum.

Also make sure you have the latest Mysql

BTW.. do you have a url? Also try adding the page loading reports on the settings.. this will show how long it takes to load a page on the bottom of your forums.

This wil help when before and after your memory upgrade you should be able to spot the difference.

thats what i did and thats where im getting my info from for page loads..

http://fraggers.com

latest mysql, and php 4.3.8

Thats bad. I've never liked IPB, but have you tried optimising your database? and have you optimised your mysql config (my.conf) file? Do you have any caching (php or mysql or both) enabled?

ive analyzed and optimized the tables through IPB and it didnt improve anything,


i have not optimized thru my.conf ... im not sure where to start with that or how to check if caching is enabled

Here is a guide to my.conf: http://forums.ev1servers.net/showthread.ph...?threadid=20983

the thing is my my.cnf on my server is pretty much blank... it shows none of those variables

just


[mysqld]
set-variable = max_connections=500
safe-show-database

ok, i got the new memory in, and it didnt do anything