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

Comments

  1. Sean Hull says

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

  2. Baron Schwartz says

    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.

  3. Jason says

    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

  4. Jason says

    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

  5. bob says

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

  6. says

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *