Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
MyISAM 2 InnoDB - Changes tables engine from MyISAM to InnoDB Details »
MyISAM 2 InnoDB - Changes tables engine from MyISAM to InnoDB
Mod Version: 1.0.0, by PlusVB (Member) PlusVB is offline
Developer Last Online: Mar 2013 I like it Show Printable Version Email this Page

vB Version: 3.8.x Rating: (5 votes - 5.00 average) Installs: 24
Released: 25 Nov 2009 Last Update: 25 Nov 2009 Downloads: 273
Not Supported DB Changes Uses Plugins Re-usable Code Translations  

After reading Anders is blog: Part 1 vB4mance: Helping communities grow, performance data model changes in vB 4.0 Thanks Anders, I've decided to make a simple product to bring the power of InnoDB to anyone who wants it.

Just import the product and go to Maintenance->Update Counters and scroll down, more down, then you'll find Change tables engine to InnoDB

It can be used with 3.5 3.6 3.7 3.8 and 4.0, and I don't know if I should start a new thread in the "vBulletin 4.0 Add-ons".

Please make sure to back-up your database before doing this.

Enjoy.

Download Now

Only licensed members can download files, Click Here for more information.

Addons

Screenshots

Click image for larger version

Name:	Change tables engine to InnoDB.png
Views:	480
Size:	5.9 KB
ID:	106740  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #16  
Old 17 Feb 2013, 01:16
gabrielt gabrielt is offline
 
Join Date: Apr 2007
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.
Reply With Quote
  #17  
Old 19 Feb 2013, 00:21
gabrielt gabrielt is offline
 
Join Date: Apr 2007
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.
Reply With Quote
  #18  
Old 11 Aug 2016, 16:33
s_cocis s_cocis is offline
 
Join Date: Nov 2011
how to convert back?

Last edited by s_cocis; 11 Aug 2016 at 16:40.
Reply With Quote
  #19  
Old 12 Jan 2017, 02:49
kotkerk's Avatar
kotkerk kotkerk is offline
 
Join Date: Nov 2005
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
__________________
YouTube
Reply With Quote
  #20  
Old 20 Jan 2019, 16:21
masterross's Avatar
masterross masterross is offline
 
Join Date: Dec 2005
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!
Reply With Quote
Reply


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

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 21:17.

Layout Options | Width: Wide Color: