On Sun, Sep 6, 2009 at 10:44 AM, David McGuigan<[email protected]> wrote: > We iterated through a kaleidoscope of configuration strategies and were on > more than ample hardware ( 2 xeon quads, 16GB ram, a RAID 5 of 15k drives ) > but even the ones that should've been ideal on paper, though they did > improver performance quite a bit compared to other configurations, could not > exempt MySQL from the fact that it is very bad at certain things.
Out of curiosity, which things did you find it perform poorly on? I haven't really used MySql in production because I was always on either MS SQL or Sybase starting back before MySql was really around (and definitely before it had support for transactions or foreign keys). One of the things I have appreciated about MySql from afar (again, haven't used it in production myself) is that you could choose different engines for different tables based on the type of interaction you'd have with that table. I always thought that was pretty sweet. So what didn't MySql do well at in your testing? I'm genuinely curious as I keep meaning to get my hands more dirty with the new versions. Cheers, Judah ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
