What Causes Downtime in MySQL?

PREVIOUS POST
NEXT POST

We’ve just published a new white paper analyzing the causes of emergency incidents filed by our customers. The numbers contradict the urban myth that bad SQL is the most common problem in databases. There are a number of surprises in other areas, too, such as the causes of data loss. This is the companion to my earlier white paper suggesting ways to prevent emergencies in MySQL. It is a re-published and re-edited version of an article that just appeared in IOUG’s SELECT magazine. You can download it for free from the MySQL white papers page on the Percona web site.

PREVIOUS POST
NEXT POST

Share this post

Comments (10)

  • Sean Hull Reply

    Another great whitepaper Baron. These are invaluable sources of information. We are lucky to enjoy this material freely!

    March 21, 2011 at 12:00 am
  • Baron Schwartz Reply

    I’ll take that as a compliment to the quality of the writing :) But seriously, I do have a pending task to create a nice white paper layout and reformat all of them. This is just LaTeX 2-column default.

    March 21, 2011 at 12:00 am
  • bob Reply

    Arrrrghhhh, two column layout! So old fashioned! And really, really hard to read on screen.

    March 21, 2011 at 12:00 am
  • Baron Schwartz Reply

    Jason, thanks, that is a typo. I’ll fix.

    March 21, 2011 at 12:00 am
  • Jason Reply

    Hey,

    This must be a typo?

    “Another frequent error was failing to set the InnoDB log file size, so the server was running with the default 10MB of redo logs instead of hundreds of GIGAbytes.”

    Cheers

    March 21, 2011 at 12:00 am
  • Jason Reply

    Hey,

    This must be a typo?

    “Another frequent error was failing to set the InnoDB log file size, so the server was running with the default 10MB of redo logs instead of hundreds of GIGAbytes.”

    Cheers

    March 21, 2011 at 3:10 pm
  • Baron Schwartz Reply

    Jason, thanks, that is a typo. I’ll fix.

    March 21, 2011 at 6:23 pm
  • bob Reply

    Arrrrghhhh, two column layout! So old fashioned! And really, really hard to read on screen.

    March 23, 2011 at 4:13 am
  • Baron Schwartz Reply

    I’ll take that as a compliment to the quality of the writing 🙂 But seriously, I do have a pending task to create a nice white paper layout and reformat all of them. This is just LaTeX 2-column default.

    March 23, 2011 at 10:12 am
  • Sean Hull Reply

    Another great whitepaper Baron. These are invaluable sources of information. We are lucky to enjoy this material freely!

    March 23, 2011 at 12:23 pm

Leave a Reply