The Arcive of Official vBulletin Modifications Site.

XenonKilla · #1 06-13-2016, 05:01 PM

I know that the in the past it was impossible to convert the 'post' and 'thread' tables to InnoDB without losing the full-text capabilities. But now I'm reading that the InnoDB engine in MySQL v5.6+ now supports Full-Text. So is it now possible to convert my tables from MyISAM to InnoDB and still retain full-text capabilities? Will everything still function properly or am I missing something here?

Paul M · #2 06-14-2016, 02:52 PM

Yes its possible, and in fact we did it on vb.org's database a while ago.

XenonKilla · #3 06-14-2016, 07:02 PM

Hey Paul, Thanks for the response.

Once the 'post' and 'thread' tables are converted to InnoDB is it still possible to convert them back to MyISAM later on down the road if things don't work out?

Also, right now all my tables are using MyISAM (except of course MEMORY tables) so would it be beneficial for me to only convert just my 'post' and 'thread' tables to InnoDB and leave the rest as MyISAM? Or should I just convert everything to InnoDB? I run a pretty large forum and my post table currently has over 1,003,525 rows. The site runs good but I'm know that table locking on the post and thread tables is definitely killing me.

Zachery · #4 06-14-2016, 10:02 PM

Short answer is yes on converting them back.

You should probably convert your memory tables to INNODB or MyISAM as well. The session table breaks down as a memory table around 50k sessions, not that you're likely to see that on most sites.

XenonKilla · #5 06-14-2016, 10:20 PM

Good to know, Thanks for the tip!

What about the other tables? I know that both storage engines have their pros and cons but should I just convert them all to InnoDB or would it be more beneficial to just leave them as MyISAM?

AusPhotography · #6 06-15-2016, 01:01 AM

Yes. 5.6 is good for the change.
A better alternate is MariaDB (if you can) and Aria tables as this is faster.

Paul M · #7 06-15-2016, 03:03 PM

Quote:

Originally Posted by XenonKilla

Good to know, Thanks for the tip!

What about the other tables? I know that both storage engines have their pros and cons but should I just convert them all to InnoDB or would it be more beneficial to just leave them as MyISAM?

Unless they are causing you a problem, leave them alone.

Dont make changes for the sake of making changes.

XenonKilla · #8 06-15-2016, 03:11 PM

I agree but if something is clearly going to be better then I'd rather do that instead. But yeah MyISAM has been great thus far so I'll probably just leave those other tables alone. Was just fishing for some advice that's all.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04030 seconds Memory Usage 2,224KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)postbit (8)postbit_onlinestatus (8)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!