Performance Tuning Best Practices for MySQL

You're viewing a comment by Paul and its responses.

Paul Permalink
July 25, 2008, 20:08

So I frequently hear not to denormalize until it's been proven necessary. But in my experience, adding a column to a large MySQL table causes downtime. So my questions are:

1 am I doing the schema refactoring wrong?

2 if not, then wouldn't it be in my users interest to make some educated guesses and minimze downtime?

Reply to this comment

Reply To This Comment

(why do I need your e-mail?)

(Your twitter name, if you have one. (I'm @pkrumins, btw.))

Comment Help

Type first 3 letters of your name: (just to make sure you're a human)

Please preview the comment before submitting to make sure it's OK.