Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 28 Apr 2010, 15:49
DarkSuyan DarkSuyan is offline
 
Join Date: Feb 2007
Search Fix without Sphinx

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

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

Last edited by DarkSuyan; 28 Apr 2010 at 18:06.
Reply With Quote
  #2  
Old 28 Apr 2010, 22:17
cory_booth cory_booth is offline
 
Join Date: Jul 2006
I have ran this mod and executed the DB convert function.
Will let you all know how it goes...
But...
No database errors or other anomolies that I have noticed.
Reply With Quote
  #3  
Old 28 Apr 2010, 23:30
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
This isnt an add-on - moved to vb4 discussion forum.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #4  
Old 03 Sep 2010, 05:43
Jaxel Jaxel is offline
 
Join Date: Sep 2005
n/m
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:39.

Layout Options | Width: Wide Color: