Jump to content

Converting Post Table from MyIsam to Innodb

Recommended Posts

If i do so, its better to convert the post table to innodb?

It will work on both engines but we use also use Innodb for that table :smile:

Also, its safe to convert back and forth the post tables from myisam to innodb and vice-versa?

Yes but do such changes from ssh.

Link to comment
Share on other sites

Ok, I've installed Sphinx 2.0.8(last Sphinx version did not work), and everything is working fine.

Search is now much more accurate and a lot faster.

Im using Mysql 5.5, so that means innodb does not have fulltext indexing.

I do not use Sphinx for the View New Content.

Does that mean that the View New Content will not work with the table in Innodb?

Also my post table has ~1,5 Million posts and occupies 1Gb. Innodb is a better solution that Myisam is this case?

Link to comment
Share on other sites

Best advice I can offer is make sure you have good backups, dump your database before you do anything.

I have switched most of my tables to InnoDB and I am also using MySQL 5.6 now, but when I converted I was using MySQL 5.5 so I had to remove the index's.

If you search IPS forums you'll find a couple threads with more info on how to switch tables to InnoDB and how to remove the index's

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...