David, your response was artful, I'm going to put a "cool dude" check next to your name in my book. :)
Did you bring in any hired guns/experts for your MySQL stuff? I think the Dolphin is blue, that might be your problem right there! =) We all have our strengths and weaknesses, which is pretty cool, so more power too you for finding a solution to your problems. I wouldn't blame a hammer for not being a good wrench, though. :)p -- Nothing endures but personal qualities. Walt Whitman On Sun, Sep 6, 2009 at 11:44 AM, David McGuigan wrote: > > Oh you're totally right, I obviously had it misconfigured. I must've not > even thought to research and implement strategic configuration of the MySQL > instance itself. Man I wish I had thought of that in the enormous amount of > research and testing we had to do. It sounds like such a simple, obvious > place to start. Oh wait, that was one of the things we spent the most time > on. > Or no maybe you were right the second time. It had to do with my attitude. > MySQL was particularly bad at certain types of queries because for some > reason, that's what I believed in my heart that it would be. I guess maybe > the purple dolphin logo triggered some kind of subliminal prejudice in my > mind and that's what's been holding MySQL back. Hold on I'm going to go say > a little prayer and then run them again. I'm sure that'll fix it. Thanks > buddy! > 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4