UBB.Developers Forums Community Development Programming MySQL and Server Configuration innodb

Anyone running the DB as an innodb rather than myisam? I hear it should be faster, but wanted to check what real world experience with Threds is?

Thanks,

Fred

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.

Thanks,

Fred

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;

Please let me know if it helps or not.

Well, I did the conversion this morning and can't say I notice a difference

Any ideas if this problem will be fixed in 6.5?

If you're using 6.4.x, here is post that may help solve performance problems.