Create New Thread Issue, Long Wait Then Times Out

[boxingscene]

I have a very large forum, over 96K users, 3.5 million posts and 180K threads. As many as 1500-2000 users/guests can be on at any given time. The server being used is pretty high-end.

Some of my users have issues with creating threads. The problem only happens in the two largest sections of the forum, which house over 1 million posts a piece.

The person creates the thread, there is a long wait and then it times out. Sometimes it happens and other times it does not. Pretty much hit and miss. I increased the execution timeout to 60 seconds which helped some users but not everyone. Replying to threads is very quick and no issues with creating threads in smaller sections of the forum.

Is there a way around this or some kind of a fix?

[royo]

Hmm, any addons/hacks that could possibly interfere? Also, what hardware specs do you have and what is the result of the top command during high traffic hours?

[boxingscene]

These are just some of the main specs. As you can see, the server has the power. Not that many hacks installed, just the basics that most forums have like the arcade and one or two others. Not sure if the problem began before or after upgrade from 3.6 to 3.7.

SuperMicro X7DBR-E Intel Xeon DualCore DualProc SATA SuperMicro X7DBR-E Intel Xeon DualCore DualProc SATA [2Proc]

Processor - Intel Xeon-Clovertown 5320-QuadCore Intel Xeon-Clovertown 5320-QuadCore [1.9GHz]

RAM - Generic 8GB ECC FB-DIMM DDR2 Generic 8GB ECC FB-DIMM DDR2

Drive Controller 3ware 9550SX SATA RAID 3ware \ 9550SX \ SATA RAID

Hard Drive 1 Western Digital Raptor 10,000 RPM WD1500ADFD Western Digital Raptor 10,000 RPM WD1500ADFD
Hard Drive 2 Western Digital Raptor 10,000 RPM WD1500ADFD Western Digital Raptor 10,000 RPM WD1500ADFD
Hard Drive 3 Western Digital Raptor 10,000 RPM WD1500ADFD Western Digital Raptor 10,000 RPM WD1500ADFD
Hard Drive 4 Western Digital Raptor 10,000 RPM WD1500ADFD Western Digital Raptor 10,000 RPM WD1500ADFD

[royo]

Have you already trying optimizing your SQL tables? You may want to post here: http://www.vbulletin.com/forum/forumdisplay.php?f=14 and provide all information requested, as your server might require some optimizations, or some changes to the MySQL config.