Log in

No account? Create an account
entries friends calendar profile My Website Previous Previous Next Next
Mark Atwood
Talk about doing it wrong...
Friday, I helped a friend who is working a MySQL gig to optimize a query that should have been way fast, but was taking about 100 seconds. Brian even took a look and helped with it. I learned today what the real problem was. The whole system was running on a single ec2-small instance. And by "whole system", I mean a test mysql server, the production mysql server, a test apache server, and the production apache server. All on one ec2-small.

Talk about doing it wrong.


4 comments or Leave a comment
dcseain From: dcseain Date: January 5th, 2009 12:12 am (UTC) (Link)
Having spent years supprorting enterprise software, you'd likely be shocked at how common such a config is, and doubly shocked at how hard it is to get them to migrate at least the prod instance to a dedicated server.
From: bkarwin Date: January 5th, 2009 12:29 am (UTC) (Link)


Yes, shocked, but not surprised!
fallenpegasus From: fallenpegasus Date: January 5th, 2009 02:01 am (UTC) (Link)
One of the nice things in my tour of being a MySQL Professional Services guy was that when faced with such a broken configuration and told "make it go faster", I could say "this configuration is broken and you're doing it wrong. I will try to tune your db server and your sql queries, but you are just wasting my time and a whole lot of your money", and they usually had enough money on the line bringing me in that they would listen.
awfief From: awfief Date: January 5th, 2009 02:19 am (UTC) (Link)
My favorite is when they migrate to their very own 32-bit OS.

4 comments or Leave a comment