The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
I am facing a problem with my forum that located in a very powerful server and the server contain only the vb forum.
the problem is the load of the server is often high it reaches (80%) some time although the specification of the server are quite enough to run it. I have written this problem in the vbulletin.com and this is the topic link: http://www.vbulletin.com/forum/showthread.php?t=139532 after receiving a command from this Guy MarcoH64 the server load went down till 7 - 11% and I am looking for a better result and a final solution. ----------- About my database I would like to empty these four tables, if there is any critical problem if I empty them, please inform me or if it is normal send me the command that empty the tables without any errors. pm 1,335,172 MyISAM 63.8 MB 47,022 Bytes pmtext 526,413 MyISAM 306.3 MB 1,141 KB postindex 69,701,315 MyISAM 1.5 GB - word 2,232,375 MyISAM 167.7 MB - I would like to reduce the number of the attachments for a specific forum not all forums, please give me the command that empty the attachments from one specific forum. attachment 24,563 MyISAM 1.5 GB 55,384 Bytes |
#2
|
|||
|
|||
![]() Quote:
![]() PS I already send you all commands to do this at vbulletin.com. But instead of removing data, i see more use of adding some more indexes on data often used in WHERE or ORDER BY clauses. That might be your best solution (beside server tuning) on the long term. It is not an easy process, you would be monitoring the queries that take most time and focus on improving those. |
#3
|
||||
|
||||
![]() Quote:
Quote:
|
#4
|
|||
|
|||
![]()
Paul,
Look up his posts on vbulletin.com. This have already been discussed long there. |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|