Yeah, I heard that too. I don't think UBBT support this type. 0.02
Can't wait to upgrade to 6.5. A 6.4 is too slow for a half million row posts with 250 users online at a time using a dedicated Xeon HT 2.4Ghz/1024MB/10,000 RPM Cheetah and tweaked Mysqld.
InnoDB will require more RAM than MyIsam and from my experience it isn't faster than MyIsam in the ubb.threads enviroment. The advantage of InnoDB ist that the tables aren't looked while performing an insert or update statement. That helps if you have a large user and/or posts table.
[]Astaran said: InnoDB will require more RAM than MyIsam and from my experience it isn't faster than MyIsam in the ubb.threads enviroment. The advantage of InnoDB ist that the tables aren't looked while performing an insert or update statement. That helps if you have a large user and/or posts table. [/]
Hmm, this might be my answer. CPU load isn't too busy, and I have lots of RAM, but at times with 30% load users have to wait 30 seconds to view a record. InnoDB might be the answer then. Any advice when converting to this. Also is it easy to convert back should problems arise.
A backup is always a good idea, but switching to InnoDB is easy. Just run an alte table command for every table you want to migrate: alter table <tablename> type=InnoDB;
To change it back to MyISAM run: alter table <tablename> type=MyISAM;
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.