vBulletin Mods

The Official vBulletin Modifications Site

Search Fix without Sphinx
by DarkSuyan
28 Apr 2010 16:49

Hello Everybody.

Like many of you i got a very slowly Search since VBulletin 4.
But some Days ago i found finally a Way to fix it and without installing a 2. Serch Engine like Sphinx.

You should know there are 2 Ways a Table in a Database can be in VB, "innodb" or "MyISAM".
The Problem is that VB3 gots only "MyISAM" and VB4 now use's "innodb" and "MyISAM".

For any Reason alot Server are getting Problems with innodb and VBulletin 4 together, well anyways i used a addon some Days ago which changed all Non-Fulltext Tables to "innodb" and well what do you think what happend? The Site was that slowly, it keeps 5 Minuts to open the AdminCP :D

Well then i got the Idea to change all to "MyISAM" (after i realize that not all was MyISAM before...)so i changed the Addon a bit which i wanna share with you ;)

Remember: Do it at you own Risk. My Times needed for Searching changed from 16-20 sec. to 0 sec. !

Well here you go:

Goto http://www.vbulletin.org/forum/showthread.php?t=228846, download the addon and install it at you Site. (AdminCP -> Addon's & Plugins -> manage Addon's -> import)

Now go to AdminCP -> Addons & Plugins -> manage Plugins -> MyISAM 2 innoDB

In the 5. Box replace ALL for:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Then Save and got to Maintence -> Update Counters -> Change tables engine to InnoDB

It will takes some time, depends how big your Database is and dont get fooled by the Name or Description of the Addon is only edited the executing Code not the Names or Descriptions...

So thats it, remember: Do it at your own Risk, it worked great for me but must not mean that it does to you too ;P

PS: Yes, im German and my English isnt that well... ;)

Credits for original Addon goes to PlusVB

cory_booth 28 Apr 2010 23:17

I have ran this mod and executed the DB convert function.
Will let you all know how it goes...
No database errors or other anomolies that I have noticed.

Paul M 29 Apr 2010 00:30

This isnt an add-on - moved to vb4 discussion forum.

Jaxel 03 Sep 2010 06:43


All times are GMT. The time now is 19:38.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.