I want to set my users table to innoDB.
Do i need any other command than this to do it correctly?
ALTER TABLE mybb_users ENGINE = INNODB;
+InnoDB is currently disabled on my server. How to enable it?
Remove "skip-innodb" from my.cnf or what?
Thanks!!!
Just put a # in front of skip-innodb.
Ok, many thanks, but can you answer to the first question too?
That command is correct.
It will work without the ; too.
ALTER TABLE mybb_users ENGINE = InnoDB
Also consider sessions and threads table. And posts table if you're brave.
Don't forget to make a full back up just in case anything goes wrong.
I've tested the users table. myisam > innodb >myisam > innodb.
The cpu load is much better now. average 5.0 instead of 10...
To be honest you should go 100% InnoDB and use MySQL 5.5. You'll see vast improvement.
Really? Well i can do it, but on the threads and posts table is very tricky.
Btw do i need to do something else with sessions table before run that command from the first post?