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:	479
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.
Comments
  #2  
Old 25 Nov 2009, 14:37
profanitytalker's Avatar
profanitytalker profanitytalker is offline
 
Join Date: Nov 2006
Thank you! I'll wait to see if its functioning properly. Don't want my db to become corrupted.
Reply With Quote
  #3  
Old 25 Nov 2009, 19:39
Kolbi's Avatar
Kolbi Kolbi is offline
 
Join Date: Mar 2009
Real name: Matthias
There are the advantages?
Reply With Quote
  #4  
Old 25 Nov 2009, 19:51
CHIPIT CHIPIT is offline
 
Join Date: Apr 2007
...
__________________
Jeremy
Reply With Quote
  #5  
Old 26 Nov 2009, 04:00
Coop1979 Coop1979 is offline
 
Join Date: Aug 2006
How are you getting around the search issue?

The main problem is that InnoDB does not support “fulltext” searching; this means that converting to InnoDB will break the default search engine in vBulletin 3. This is due to InnoDB requiring that “fulltext index” be dropped when the conversion occurs. No full text index, no search; it's as simple as that.
Reply With Quote
  #6  
Old 26 Nov 2009, 05:44
TheComputerGuy's Avatar
TheComputerGuy TheComputerGuy is offline
 
Join Date: Oct 2001
Real name: Joe
http://www.yqed.com/mysql-storage-my...odb-explained/

This is a good read.
__________________
I'll buy your forum!
Reply With Quote
  #7  
Old 26 Nov 2009, 09:40
PlusVB PlusVB is offline
 
Join Date: Oct 2008
Originally Posted by Coop1979 View Post
How are you getting around the search issue?
I skiped any FULLTEXT table. if I'm going to make this product for vb 4.0. I may skip only (searchcore_text, searchgroup_text) and maybe language

actuality, I may not need to skip any table, as MySQL well refuse to convert any table with FULLTEXT inside it.
Reply With Quote
  #8  
Old 26 Nov 2009, 10:04
PlusVB PlusVB is offline
 
Join Date: Oct 2008
Originally Posted by TheComputerGuy View Post
Will, this looks more real to me
http://www.mysqlperformanceblog.com/...sam-to-innodb/

Last edited by PlusVB; 26 Nov 2009 at 13:41.
Reply With Quote
  #9  
Old 29 Nov 2009, 17:00
gmerin gmerin is offline
 
Join Date: Dec 2008
I have a few production systems which use innodb (the smallest is a 400gb reporting dbms). So far I only have two issues with them and I'm not sure how that would translate to vb usage: the resource overhead seems significantly higher for innodb, and , when necessary, innodb data recovery has a global impact.

resource overhead is an issue on my non-commercial vb system because i don't use a dedicated server and the demands of ajax database access alone kill it even using myisam.

the data recovery issue is more significant for me: when i have encountered a data structure corruption error (and it's not that frequent an occurrence; it only happened once in 2009) , the entire innodb database instance simply will not come up until the issue is addressed.

using myisam only the affected table(s) becomes unusable (not having foreign key constraints you just don't have the data integrity issues associated with foreign key violations), which makes recovery a simple matter of dropping the structure and reloading it from the most recent backup. since the entire innodb instance will not load when corruption is detected, recovering from a backup becomes unfeasible as reloading all 400GB of table data simply takes too long, so i employ snap mirroring with local protection (dbms redundancy). without these resources, i can't see using innodb with anything over 25gb. i would prefer to use oracle 10/11g for such systems, and as Oracle now owns innodb that's probably going to become the formal migration path over time, but i'll wait for oracle to add similar administrative functionality to innodb before i use it for larger databases.
Reply With Quote
  #10  
Old 29 Nov 2009, 18:11
PlusVB PlusVB is offline
 
Join Date: Oct 2008
gmerin!, haven't you tried to use "innodb_file_per_table"? No? Then you should read this one:
http://www.mysqlperformanceblog.com/...zation-basics/
Reply With Quote
  #11  
Old 21 Jan 2010, 23:46
saadessa's Avatar
saadessa saadessa is offline
 
Join Date: Jan 2008
Real name: saad essa alfallah
thank you iwill try
Reply With Quote
  #12  
Old 16 Oct 2010, 05:23
orok orok is offline
 
Join Date: Jun 2005
Real name: Omar
thank you
no needed to be installed after done ?!
Reply With Quote
  #13  
Old 31 Aug 2012, 22:18
Mr GRiM's Avatar
Mr GRiM Mr GRiM is offline
 
Join Date: Jul 2011
Works on 4.2 thanks
__________________
Do you want to change the look of Windows 7 to make it how you want? Then check out virtualcustoms.net where you will find heaps of great visual styles and much more.
Reply With Quote
  #14  
Old 15 Sep 2012, 09:32
mmikel_atef's Avatar
mmikel_atef mmikel_atef is offline
 
Join Date: Apr 2010
how to convert back?
Reply With Quote
  #15  
Old 14 Oct 2012, 03:54
Mr GRiM's Avatar
Mr GRiM Mr GRiM is offline
 
Join Date: Jul 2011
Yeah it would be nice if this could be reversed but I don't think we are going to get any reply for this

Edit: I just had a go at reversing this by just swapping the names in the xml file and I think it worked OK, just make sure you backup your database first in case anything goes wrong, I am not a coder so if anyone want to have another go at this and make a proper one feel free, just wanted to give the option to reverse this for anyone who found this wasn't for them.
Attached Files
File Type: xml product-MrGRiM_InnoDB_to_MyISAM.xml (3.1 KB, 31 views)
__________________
Do you want to change the look of Windows 7 to make it how you want? Then check out virtualcustoms.net where you will find heaps of great visual styles and much more.

Last edited by Mr GRiM; 14 Oct 2012 at 05:47.
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 03:30.

Layout Options | Width: Wide Color: