Emergency

What Causes Downtime in MySQL?


Posted on:

|

By:


PREVIOUS POST
NEXT POST
Share Button

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.

Share Button
PREVIOUS POST
NEXT POST


Baron Schwartz

Baron is the lead author of High Performance MySQL. He is a former Percona employee.



Categories:
Insight for DBAs, MySQL


Comments

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

  • Baron Schwartz Post author

    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.

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

  • Baron Schwartz Post author

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

  • 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

  • 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

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

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

  • 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.

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

Leave a Reply

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