mysql issue

Steve Meyers steve-plug at spwiz.com
Wed Feb 8 19:07:49 MST 2012


On 2/8/12 4:37 PM, Steve Alligood wrote:
> In the past, I have done a lot of work with ISPs and shared hosting,
> etc, and most of their setups are single server, doing mysql for their
> pet blog.  A lot of this opensource stuff used InnoDB simply because it
> looks cool or the book they bought says to use it, and it causes a lot
> of issues due to not being setup very well, which causes issues for
> other users as MySQl doesn't expect to have thousands of databases all
> doing InnoDB poorly, and when the inevitable crash comes it doesn't
> bother to tell you which user, which database, or which table, just a
> memory pagedump, which can be very annoying playing "to whom does the
> wordpress data belong to".

I can agree with that.  If you're on a shared host, or a minimal virtual 
server, MyISAM is probably easier.  MyISAM also requires less tweaking 
to get the best performance out of it.

Steve


More information about the PLUG mailing list