Announcement

Collapse
No announcement yet.

Which tables I should convert to InnoDB?

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

  • 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?

  • #2
    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
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      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?

      Comment


      • #4
        None of the search tables.

        Comment


        • #5
          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.

          Comment


          • #6
            You won't be able to convert those tables.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API - Full / Mobile
            Vote for your favorite feature requests and the bugs you want to see fixed.

            Comment


            • #7
              im droped indexes title from vb_blog_text and converted this table.

              Comment


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

                Comment


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

                  Comment


                  • #10
                    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.
                    Translations provided by Google.

                    Wayne Luke
                    The Rabid Badger - a vBulletin Cloud demonstration site.
                    vBulletin 5 API - Full / Mobile
                    Vote for your favorite feature requests and the bugs you want to see fixed.

                    Comment


                    • #11
                      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

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X