Talk about doing it wrong...

Log in

03:19 pm January 4th, 2009

No account? Create an account

Remember me




			Mark Atwood

fallenpegasus


	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. Tags: mysql

4 comments or Leave a comment


	Comments

	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.

(Reply) (Thread)

From: bkarwin	Date: January 5th, 2009 12:29 am (UTC)		(Link)
shocked?

Yes, shocked, but not surprised!

(Reply) (Parent) (Thread)

	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.

(Reply) (Parent) (Thread)

	From: awfief	Date: January 5th, 2009 02:19 am (UTC)		(Link)

My favorite is when they migrate to their very own 32-bit OS.

sigh.

(Reply) (Parent) (Thread)


	4 comments or Leave a comment