vb.org Archive - FractalizeR: VBulletin 4 extensive optimization guide (Part II)

Page 4 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=242)

- - FractalizeR: VBulletin 4 extensive optimization guide (Part II) (https://vborg.vbsupport.ru/showthread.php?t=241783)

KissOfDeath

02-18-2011 07:16 PM

I'm trying the "InnoDB: Migrating" and managed to convert all tables successfully except

Code:

alter table thread engine=InnoDB;

Which gives me this error

Code:

#1214 - The used table type doesn't support FULLTEXT indexes

Is their a way to fix it, and if not is it ok to leave it as it is?

FractalizeR

02-19-2011 07:30 AM

Did you convert all tables without exceptions?

KissOfDeath

02-19-2011 10:50 AM

Quote:

Originally Posted by FractalizeR (Post 2164218)

Did you convert all tables without exceptions?

Only the tables you listed here:

Code:

http://www.vbulletin.com/forum/entry.php?2413-Part-2-vB4mance-vBulletin4-Optimization-Basic-Guide-to-InnoDB-Conversion

and thread was the only one that gave the full text error

FractalizeR

02-20-2011 07:10 AM

Well, it's some legacy indexes. You can safely drop them:

Code:

alter table post drop index title;

alter table thread drop index title;

KissOfDeath

02-20-2011 10:40 AM

Quote:

Originally Posted by FractalizeR (Post 2164526)

Well, it's some legacy indexes. You can safely drop them:

Code:

alter table post drop index title;

alter table thread drop index title;

thanks you, worked great

FractalizeR

02-21-2011 06:33 AM

Welcome.

cpvrx

03-09-2011 05:34 AM

Great article. :)

cpvrx

03-15-2011 09:40 AM

One thing that also speeds up your community is switching from Apache to Litespeed(web server).

All times are GMT. The time now is 06:37 PM.

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01200 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: