On Tue, Mar 28, 2006 at 09:42:51PM +0200, PFC wrote:
> However, throw in some maintenance operation which involves a long
> query with writes (like a big joined UPDATE) and all access to your
> website is blocked while the query lasts.
> This is worsened by the fact that MySQL sucks at complex queries.
>
> If all of your updates are done to a few rows, MyISAM is cool, but
> someday you'll want to do this query which locks a table during one
> minute... and then you got a problem.
Not to mention that MyISAM loves to eat data. Livejournal suffered at
least one major crash due to MyISAM corruption.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
