vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=228846

gabrielt 17 Feb 2013 00:16

Thanks. I was looking for something like this for a while, and for some reason I didn't find this before. I will do some tests and post here is the performance of our forum increased or not.

gabrielt 18 Feb 2013 23:21

With our very busy forums, converting to InnoDB made the CPU load on our MySQL server to go throught he roof. I had to revert back to MyISAM.

s_cocis 11 Aug 2016 15:33

how to convert back?

kotkerk 12 Jan 2017 01:49

create file cv.php with content:

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

change args in the line

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

1 arg = convert FROM
2 arg = convert TO
3 arg = show or no output (optional, default = false)
4 arg = test mode. if set to true - no changes in DB (optional, default = false)

close forum
make Data Base backup
upload file to forum root and execute in browser
confirm chages in DB
delete file
open forum

masterross 20 Jan 2019 15:21

A little update of the script on vb 4.2.x:



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

In this way it will exclude vb_language as it should stay in MyISAM.


Aldo this script should be run in AdminCP, not the root!
And if you have some big tables you should manually convert them trough shell console and after that run the script.


Regards!


All times are GMT. The time now is 10:03.

Powered by vBulletin® Version 3.8.12
Copyright © 2019, 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.