Hi

Currently our forum has about 400,000 postings and I would consider my forum heavily utilized. Under peak hours, whenever someone does a search in the forum, the first initial search takes 20-40 secs to complete. During this period, my forum will slow down to a crawl for the rest of the users who are just browsing the forum and my server load shoots up.

I am running GForum on mod_perl with mysql and my 2.8Ghz server has 2GB of ram dedicated to running GForum. I am also using the reverse proxy as recommend by the mod_perl guide for max performance.

Does anyone have any advise on how to finetune the search performance? I am not very familiar with mysql and I think that should be where I should focus my attention on?? I am using the sample my.cnf config file supplied from mysql for large servers with at least 512mb of ram.

I have already converted the following tables suggested by Jason here into InnoDB.
http://www.gossamer-threads.com/...orum.cgi?post=263938
The tables converted are
Online
PostNew
PostView
Post_tree

Do you think converting the Post table into InnoDB will help as well? According to phpMyAdmin, my Post table is taking up 250MB of space now.

What other steps should I take to optimise and speedup the search function. Any advise is appreciated from the gurus here.

Thanks!!