i've been working for 2 weeks already doing some stress testing on a server with a forum software written in php that uses mysql as the database.
the first test was to write posts into the forum as fast as we could to see the stats of server load and how many posts the server can handle without clogging.
now the second test was to see how many posts the server can have before it starts to slow down (when browsing the forum) after 2.2 million posts
with all random data text posted - the server load is at 1 or 1.50 which is alright but when browsing the forum some pages load slow.. we're using the same forum
software with a different database and a different domain on the same server with 10,000 posts and browsing it also loads fast.. what could be the problem here?
all tables in the database have been checked and 'ANALYZE' and 'OPTIMIZE' them.. all indexes are also checked and fine.. when I say load slow sometimes to load
a page takes 8 seconds sometimes takes less than 1 second sometimes takes 5 seconds, this is the only issue we are trying to figure out and find a solution to...
maybe running the database off memory can make things faster? although the size of the forum is over 4.2GB while for the 10k forum its just 17MB