GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Technical Suggestion to GFY for board problems

Varius · 10-24-2004, 09:34 PM

I'm not familar with the latest version of VB, but since it does use MySQL you might find less problems if you alter the tables (or atleast the huge ones affected by the 5 million+ posts) from INNODB to InnoDB.

InnoDB is better suited to handle millions of rows than INNODB is. From experience, usually after 1-2 million INNODB starts to choke and have corruption problems.

InnoDB seems to be fine for 10-15 million rows atleast.

10-24-2004, 09:34 PM
Varius Confirmed User Industry Role: Join Date: Jun 2004 Location: New York, NY Posts: 6,890	Technical Suggestion to GFY for board problems I'm not familar with the latest version of VB, but since it does use MySQL you might find less problems if you alter the tables (or atleast the huge ones affected by the 5 million+ posts) from INNODB to InnoDB. InnoDB is better suited to handle millions of rows than INNODB is. From experience, usually after 1-2 million INNODB starts to choke and have corruption problems. InnoDB seems to be fine for 10-15 million rows atleast. __________________ Skype variuscr - Email varius AT gmail