Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
RevengeFNF Posted July 7, 2014 Posted July 7, 2014 Hello, Im thinking of installin Sphing on my VPS and start using it. If i do so, its better to convert the post table to innodb? Also, its safe to convert back and forth the post tables from myisam to innodb and vice-versa?
ASTRAPI Posted July 7, 2014 Posted July 7, 2014 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.
RevengeFNF Posted July 7, 2014 Author Posted July 7, 2014 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?
Sull5 Posted July 9, 2014 Posted July 9, 2014 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.