On Mon, 14 Jun 2004, Orlando Andico wrote: > On Mon, 14 Jun 2004, ian sison (mailing list) wrote: > .. > > True, however MySQL and PgSQL have historically been so stable on > > reasonable loads that it actually is a non-issue :) > > Not MySQL. :P > > What is a "reasonable" load? MySQL concurrency really sucks. It's the only > DB server I've used that can *crash* a box (both Linux and FreeBSD in my > experience). Grantd those were pathological cases (some full-table scan at > the same time lots of inserts/updates) but still.. you don't see Oracle > doing that.
Well i guess you get what you pay for. :) I said "reasonable load" because when my load on one server gets high enough for what you experienced to happen, i quickly divide my load into multiply-replicated MySQL servers. MySQL is good up to a certain load average, i agree. Hitting that 'sweet spot' is a very good reason to consider it (read: speed!). So instead of forcing it to overstep its execution limits, i just move on to clustering using multiple commodity hardware, which is still cheaper then getting an Oracle license. :) -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
