MySQL Forums
Forum List  »  InnoDB

Re: InnoDB Support in 4.1.10a-standard installation?
Posted by: James Day
Date: April 24, 2005 02:03PM

"Standard" installations not from MySQL AB can vary. Your host can check whether InnoDB is present by using SHOW VARIABLES LIKE 'have_innodb';. If the answer is yes, InnoDB is in the build. If it's no, which build is it? And also if it's no, consider asking the build maintainer to stop removing a key part of MySQL from the build.

As you noted over there, skip-innodb in my.cnf can also remove InnoDB support and shouldn't normally be present these days, particularly at hosting places, where many hosting customers may be relying on transactions to protect financial and other data.

I just returned from the MySQL Users Conference and it was notale how many serious people (myself included, when asked during a Wikipedia presentation) were saying that you should be using InnoDB unless you know that you need MyISAM or one of the other engines for something.

The hosts are likely to benefit as well. InnoDB generally recovers more reliably and more quickly and reliably after crashes than MyISAM and that's a significant part of why I prefer it in the Wikipedia situation.

Speaking personally, I'd say that any hosting provider who isn't making InnoDB available isn't really being serious about getting business customers who have serious data to protect.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB Support in 4.1.10a-standard installation?
2257
April 24, 2005 02:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.