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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
