Announcement

Collapse
No announcement yet.

Which tables I should convert to InnoDB?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • eh69
    replied
    Okay. I will restore MyISAM tables od blog_text, vb_thread, vb_post, vb_language. postindex will be innodb too? this table is very large. have 15 000 000 records :P

    Leave a comment:


  • Wayne Luke
    replied
    Modifying the database like dropping indexes isn't supported. You're free to make whatever modifications to the code that you wish however we won't necessarily provide support for it.

    If it works to your satisfaction then you're free to do what you want.

    Leave a comment:


  • eh69
    replied
    Are You sure? Searching now is working fine. I have vbulletin 4.2.2, not vb3...

    Leave a comment:


  • Zachery
    replied
    You won't be able to search the blog, or language tables then.

    Leave a comment:


  • eh69
    replied
    im droped indexes title from vb_blog_text and converted this table.

    Leave a comment:


  • Wayne Luke
    replied
    You won't be able to convert those tables.

    Leave a comment:


  • eh69
    replied
    I have problem with some tables:
    mysql> alter table vb_blog_text engine=InnoDB;
    ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
    mysql> alter table vb_language engine=InnoDB;
    ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

    Leave a comment:


  • Zachery
    replied
    None of the search tables.

    Leave a comment:


  • eh69
    replied
    Without search*?
    http://www.vbulletin.com/forum/blogs/ibxanders/3935819-
    alter table searchcore engine=InnoDB;

    alter table searchgroup engine=InnoDB;

    alter table searchlog engine=InnoDB;

    So do convert or not?

    Leave a comment:


  • Wayne Luke
    replied
    If you're going to switch, then you should switch all tables except the search* tables, session, and cpsession.

    See:
    http://www.vbulletin.com/forum/entry...nges-in-vB-4-0
    http://www.vbulletin.com/forum/entry...oDB-Conversion
    http://www.vbulletin.com/forum/entry...XtraDB-5-5-5-1
    http://www.vbulletin.com/forum/entry...pt-and-Hosting
    http://www.vbulletin.com/forum/entry...vanced-Caching

    Leave a comment:


  • eh69
    started a topic Which tables I should convert to InnoDB?

    Which tables I should convert to InnoDB?

    Im using MyIsam now. I will convert my vbulletin tables to innodb, buty which? All? Some tables are small ex: vb_settings. Maybe myisam will be better for this table?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X