Wow, that was long!!!

[Leongsam]

those rubbish and flame threads can be pinpointed to a small group of probably less than 15 users ( you know better )
LKY blame floods on God, you can play God and ban all those trolls.

That's not my style.

 

[uncleyap]

If I used a US$5.95 plan, this forum would have died 2 years ago. :p It's far too large for any VPS package. I'd be kicked off the server in no time for hogging resources.

The forum is on a dedicated server and has been so since day 1.

The hosting plan costs USD284 per month for unmetered bandwidth. I just paid the bill this morning.

Vbulletin is extremely resource hungry because the huge number of queries it generates. Very few VPS hosting plans allow the installation of vbulletin.

I am looking at one of these packages as the server specs are better than what I'm paying for now. However, there is a bandwidth cap.

I was looking capacity for the SQL db only, 20GB no enough?

Most of the data are logistics and HTML what? Media wise you set only tiny quote for each user's attachments, the rest are off-line as far as your server is concerned.

If you spent USD284 / month then can consider the Euro$275 dedicated server which is Sun (Oracle) Fire Grade hardware, hosted in EU. Spec is good!

http://easyspeedy.com/servers/
http://easyspeedy.com/servers/high_performance_dedicated_servers.jsf


For €264/mo: you get 2x Quad-Core AMD Opteron Model 2354, 2.2 GHz; 8GB Registered ECC DDR2; 2x500GB SATA; LSI 4-Port SAS PCI-E Host Bus RAID Adapter; iSCSI 1000Mbit; UNMETERED BANDWIDTH; WAN 100MBT; Private LAN 1000BT; KVM/IP 1000BT; 8 IP address;

You can run Solaris OS where MYSQL is at it's best supposedly, because it is running on it's blood mother's OS on it's father's hardware! :p MYSQL is by Sun.

It is not the cheapest in their price table, it worked out as about $340.77USD today.

The lower of the range Euro$237 is USD$305, spec also not bad, only diff from above spec is half the RAM.:(

 

[Leongsam]

I

Most of the data are logistics and HTML what? Media wise you set only tiny quote for each user's attachments, the rest are off-line as far as your server is concerned.

The size of the database is not the issue. It's the structure of the database and the resulting number of queries/sec generated by 600 simultaneous users that is the cause of the huge consumption of processor resources.

In order to understand why vbulletin is so resource hungry, you need to take a look at the number of tables the database consists of. When the "submit reply" button is clicked, the reason why it takes a long time to respond is because the command queues behind all the other queries that have been generated by the other 500 or so users who are using the forum at the same time.


<table class="tborder" id="cpform_table" width="90%" align="center" border="0" cellpadding="4" cellspacing="0"><tbody><tr valign="top" align="center"><td class="thead" align="left">Table</td> <td class="thead">Data Length</td> <td class="thead">Index Length</td> <td class="thead">Overhead</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">access</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">addonchat_settings</td> <td class="alt2">400 Bytes</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">addonchat_who</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">adminhelp</td> <td class="alt2">81.7 KB</td> <td class="alt2">63.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">administrator</td> <td class="alt1">128 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">adminlog</td> <td class="alt2">577.6 KB</td> <td class="alt2">160.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">adminmessage</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">adminutil</td> <td class="alt2">6.4 KB</td> <td class="alt2">2.0 KB</td> <td class="alt2">6.3 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">album</td> <td class="alt1">3.3 KB</td> <td class="alt1">3.0 KB</td> <td class="alt1">40 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">albumpicture</td> <td class="alt2">2.1 KB</td> <td class="alt2">12.0 KB</td> <td class="alt2">26 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">announcement</td> <td class="alt1">7.2 KB</td> <td class="alt1">4.0 KB</td> <td class="alt1">388 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">announcementread</td> <td class="alt2">1.3 KB</td> <td class="alt2">8.0 KB</td> <td class="alt2">1.3 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">attachment</td> <td class="alt1">51.80 MB</td> <td class="alt1">151.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">attachmentpermission</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">attachmenttype</td> <td class="alt1">764 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">attachmentviews</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">avatar</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">bbcode</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">bookmarksite</td> <td class="alt1">472 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">calendar</td> <td class="alt2">56 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">calendarcustomfield</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">calendarmoderator</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">calendarpermission</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">cron</td> <td class="alt2">1.8 KB</td> <td class="alt2">4.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">cronlog</td> <td class="alt1">324.5 KB</td> <td class="alt1">94.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">customavatar</td> <td class="alt2">3.88 MB</td> <td class="alt2">10.0 KB</td> <td class="alt2">31.9 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">customprofilepic</td> <td class="alt1">1.26 MB</td> <td class="alt1">6.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">datastore</td> <td class="alt2">108.4 KB</td> <td class="alt2">2.0 KB</td> <td class="alt2">9.3 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">deletionlog</td> <td class="alt1">19.3 KB</td> <td class="alt1">19.0 KB</td> <td class="alt1">2.4 KB</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">editlog</td> <td class="alt2">365.5 KB</td> <td class="alt2">141.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">event</td> <td class="alt1">728 Bytes</td> <td class="alt1">6.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">externalcache</td> <td class="alt2">10.38 MB</td> <td class="alt2">4.0 KB</td> <td class="alt2">10.33 MB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">faq</td> <td class="alt1">1.8 KB</td> <td class="alt1">4.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">forum</td> <td class="alt2">7.7 KB</td> <td class="alt2">2.0 KB</td> <td class="alt2">1.8 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">forumpermission</td> <td class="alt1">33 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">forumprefixset</td> <td class="alt2">20 Bytes</td> <td class="alt2">2.0 KB</td> <td class="alt2">20 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">forumread</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">groupmessage</td> <td class="alt2">5.4 KB</td> <td class="alt2">4.0 KB</td> <td class="alt2">2.7 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">groupmessage_hash</td> <td class="alt1">988 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">holiday</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">humanverify</td> <td class="alt1">28.3 KB</td> <td class="alt1">40.0 KB</td> <td class="alt1">27.1 KB</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">hvanswer</td> <td class="alt2">32 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">hvquestion</td> <td class="alt1">20 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">icon</td> <td class="alt2">600 Bytes</td> <td class="alt2">2.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">imagecategory</td> <td class="alt1">80 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">imagecategorypermission</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">infraction</td> <td class="alt1">519.6 KB</td> <td class="alt1">656.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">infractionban</td> <td class="alt2">23 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">infractiongroup</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">infractionlevel</td> <td class="alt2">162 Bytes</td> <td class="alt2">2.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">language</td> <td class="alt1">384.3 KB</td> <td class="alt1">2.0 KB</td> <td class="alt1">1.1 KB</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">mailqueue</td> <td class="alt2">457.0 KB</td> <td class="alt2">2.0 KB</td> <td class="alt2">457.0 KB</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">moderation</td> <td class="alt1">110 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">110 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">moderator</td> <td class="alt2">68 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">moderatorlog</td> <td class="alt1">3.50 MB</td> <td class="alt1">1.38 MB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">notice</td> <td class="alt2">184 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">104 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">noticecriteria</td> <td class="alt1">156 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">64 Bytes</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">passwordhistory</td> <td class="alt2">684.6 KB</td> <td class="alt2">199.0 KB</td> <td class="alt2">0</td> </tr> <tr valign="top" align="center"> <td class="alt1" align="left">paymentapi</td> <td class="alt1">2.0 KB</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr valign="top" align="center"> <td class="alt2" align="left">paymentinfo</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr></tbody></table>

 

[Leongsam]

continued...

<table class="tborder" id="cpform_table" align="center" border="0" cellpadding="4" cellspacing="0" width="90%"><tbody><tr align="center" valign="top"><td class="alt1" align="left">paymenttransaction</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">phrase</td> <td class="alt2">1.65 MB</td> <td class="alt2">589.0 KB</td> <td class="alt2">1.2 KB</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">phrasetype</td> <td class="alt1">2.2 KB</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">picture</td> <td class="alt2">5.83 MB</td> <td class="alt2">8.0 KB</td> <td class="alt2">93.2 KB</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">picturecomment</td> <td class="alt1">6.1 KB</td> <td class="alt1">4.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">picturecomment_hash</td> <td class="alt2">1.3 KB</td> <td class="alt2">5.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">plugin</td> <td class="alt1">8.9 KB</td> <td class="alt1">3.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">pm</td> <td class="alt2">137.9 KB</td> <td class="alt2">425.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">pmreceipt</td> <td class="alt1">2.7 KB</td> <td class="alt1">4.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">pmtext</td> <td class="alt2">5.77 MB</td> <td class="alt2">197.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">podcast</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">podcastitem</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">poll</td> <td class="alt1">29.8 KB</td> <td class="alt1">4.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">pollvote</td> <td class="alt2">55.1 KB</td> <td class="alt2">136.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">post</td> <td class="alt1">393.84 MB</td> <td class="alt1">16.96 MB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">postedithistory</td> <td class="alt2">40.99 MB</td> <td class="alt2">844.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">posthash</td> <td class="alt1">11.1 KB</td> <td class="alt1">19.0 KB</td> <td class="alt1">7.3 KB</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">postindex</td> <td class="alt2">206.26 MB</td> <td class="alt2">253.10 MB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">postlog</td> <td class="alt1">115.4 KB</td> <td class="alt1">39.0 KB</td> <td class="alt1">102.5 KB</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">postparsed</td> <td class="alt2">36.67 MB</td> <td class="alt2">1.08 MB</td> <td class="alt2">5.87 MB</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">prefix</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">prefixset</td> <td class="alt2">20 Bytes</td> <td class="alt2">2.0 KB</td> <td class="alt2">20 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">product</td> <td class="alt1">540 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">productcode</td> <td class="alt2">3.2 KB</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">productdependency</td> <td class="alt1">68 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">profilefield</td> <td class="alt2">96 Bytes</td> <td class="alt2">4.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">profilefieldcategory</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">profilevisitor</td> <td class="alt2">121.0 KB</td> <td class="alt2">284.0 KB</td> <td class="alt2">170 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">ranks</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">reminder</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">reputation</td> <td class="alt1">309.9 KB</td> <td class="alt1">389.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">reputationlevel</td> <td class="alt2">135 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">rssfeed</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">rsslog</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">search</td> <td class="alt1">1.53 MB</td> <td class="alt1">130.0 KB</td> <td class="alt1">1.43 MB</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">setting</td> <td class="alt2">39.1 KB</td> <td class="alt2">10.0 KB</td> <td class="alt2">52 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">settinggroup</td> <td class="alt1">1.4 KB</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">sigparsed</td> <td class="alt2">221.8 KB</td> <td class="alt2">19.0 KB</td> <td class="alt2">392 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">sigpic</td> <td class="alt1">1.08 MB</td> <td class="alt1">5.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">smilie</td> <td class="alt2">2.7 KB</td> <td class="alt2">2.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">socialgroup</td> <td class="alt1">1.2 KB</td> <td class="alt1">9.0 KB</td> <td class="alt1">940 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">socialgroupmember</td> <td class="alt2">434 Bytes</td> <td class="alt2">4.0 KB</td> <td class="alt2">392 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">socialgrouppicture</td> <td class="alt1">884 Bytes</td> <td class="alt1">4.0 KB</td> <td class="alt1">884 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">spamlog</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">stats</td> <td class="alt1">12.4 KB</td> <td class="alt1">10.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">strikes</td> <td class="alt2">189.3 KB</td> <td class="alt2">106.0 KB</td> <td class="alt2">188.7 KB</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">style</td> <td class="alt1">152.8 KB</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">subscribeevent</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">subscribeforum</td> <td class="alt1">130 Bytes</td> <td class="alt1">4.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">subscribethread</td> <td class="alt2">2.71 MB</td> <td class="alt2">5.94 MB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">subscription</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">subscriptionlog</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">subscriptionpermission</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">tachyforumcounter</td> <td class="alt2">742 Bytes</td> <td class="alt2">2.0 KB</td> <td class="alt2">84 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">tachyforumpost</td> <td class="alt1">208 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">208 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">tachythreadcounter</td> <td class="alt2">14.0 KB</td> <td class="alt2">23.0 KB</td> <td class="alt2">247 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">tachythreadpost</td> <td class="alt1">6.2 KB</td> <td class="alt1">8.0 KB</td> <td class="alt1">48 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">tag</td> <td class="alt2">13.8 KB</td> <td class="alt2">28.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">tagsearch</td> <td class="alt1">630.0 KB</td> <td class="alt1">857.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">tagthread</td> <td class="alt2">14.5 KB</td> <td class="alt2">41.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">template</td> <td class="alt1">2.61 MB</td> <td class="alt1">29.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">templatehistory</td> <td class="alt2">2.0 KB</td> <td class="alt2">3.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">thread</td> <td class="alt1">7.51 MB</td> <td class="alt1">4.19 MB</td> <td class="alt1">36.9 KB</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">threadrate</td> <td class="alt2">410.7 KB</td> <td class="alt2">412.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">threadread</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">threadredirect</td> <td class="alt2">9 Bytes</td> <td class="alt2">3.0 KB</td> <td class="alt2">9 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">threadviews</td> <td class="alt1">6.4 KB</td> <td class="alt1">13.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">upgradelog</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">user</td> <td class="alt1">2.14 MB</td> <td class="alt1">985.0 KB</td> <td class="alt1">224 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">useractivation</td> <td class="alt2">26.0 KB</td> <td class="alt2">43.0 KB</td> <td class="alt2">27 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">userban</td> <td class="alt1">2.5 KB</td> <td class="alt1">3.0 KB</td> <td class="alt1">184 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">userchangelog</td> <td class="alt2">854.8 KB</td> <td class="alt2">1.48 MB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">usercss</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">usercsscache</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">userfield</td> <td class="alt1">274.2 KB</td> <td class="alt1">140.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">usergroup</td> <td class="alt2">1.2 KB</td> <td class="alt2">2.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">usergroupleader</td> <td class="alt1">0</td> <td class="alt1">1.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">usergrouprequest</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">userlist</td> <td class="alt1">12.6 KB</td> <td class="alt1">57.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">usernote</td> <td class="alt2">0</td> <td class="alt2">1.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">userpromotion</td> <td class="alt1">29 Bytes</td> <td class="alt1">3.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">usertextfield</td> <td class="alt2">354.9 KB</td> <td class="alt2">143.0 KB</td> <td class="alt2">160 Bytes</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">usertitle</td> <td class="alt1">771 Bytes</td> <td class="alt1">2.0 KB</td> <td class="alt1">0</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">visitormessage</td> <td class="alt2">118.4 KB</td> <td class="alt2">37.0 KB</td> <td class="alt2">0</td> </tr> <tr align="center" valign="top"> <td class="alt1" align="left">visitormessage_hash</td> <td class="alt1">1.7 KB</td> <td class="alt1">5.0 KB</td> <td class="alt1">1.7 KB</td> </tr> <tr align="center" valign="top"> <td class="alt2" align="left">word</td> <td class="alt2">24.77 MB</td> <td class="alt2">12.38 MB</td> <td class="alt2">0</td> </tr></tbody></table>

 

[vamjok]

His site is lousy lah! No firewall!

People just overload his server he can close shop leow!

This kind of software can easily download from Internet!

you still dare to appear here, you and your religious bullshit is one of the reasons that is causing all these

 

[uncleyap]

If you said the actual size of db isn't too big, but the number of equerries are overwhelming then may be it is Vbulletin's code not being too efficient or rather to say it treats the SQL db mercilessly like a beast.

In this case there may be a solution using RAMFS approach.

Assuming SQL db is 2-3GB and yr RAM is at least 8GB, your CPUs got at least quad core Opteron or Xeon, mount a RAMFS on a mount point and copy the SQL db in there. It should be lightning fast to generate answers to Vbulletin's queries, these are mostly SQL 'select' commands, which in binary terms are intensive binary searches.

In this method you are basically running RAM-DISK.

http://www.linux-mag.com/id/7689

But your better have a corntab job dumping (e.g. mysqldump function) that SQL out e.g. hourly to actual HDD which has daily backup. Otherwise of OS hang or power blackout then doomed is your db.

I have no idea weather yr server offer you KVM over ip, aka if you can get a remote X session to it. If so your resource meters would tell you how busy is your physical HDD. The more is physical HDD being busy the more the RAMFS approach will make a huge difference.

RAM can be added in dedicated servers at some $$$$

But when using, be sure your allocation is sufficiently more than the size of your SQL db. It hangs and lost data when db grows out of allocated space.

For co-location deals I think RAM is only one time cost with a setup fee, that is they power off your box and add RAM for you. For rentals deals there is monthly fees ranging from US$4 to $30 /month per GB.

I think you know all these deals and you know about RAMFS.

Give it a try!