CoderTakeout - MySQL

(SUMMARY) DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, you could be in for a surprise. Let s take a table with data as example, column c1 on table t2 references column c1...

(SUMMARY) An attendee to Espen s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is...

(SUMMARY) I ll be presenting at MySQL Meetup in Raleigh,NC February 21,2012. The talk with be about Optimizing MySQL Configuration which I believe is a great topic for my first talk at this meetup group as it covers something every MySQL user has to deal with,...

(SUMMARY) We ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don t remember that announcement, here s the short version: this is a tool to help you generate my.cnf files based on your server s...

(SUMMARY) Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if...

(SUMMARY) I am pleased to announce the schedule for Percona Live: MySQL Conference And Expo 2012 is now published . This is truly great selection of talks with something for MySQL Developers, DBAs, Managers, people just starting to use MySQL as well as looking...

(SUMMARY) I spent last week at linux.conf.au in Ballarat, Victoria (that s the Victoria in Australia, not wherever else there may be one) which is only a pleasant two hour drive from my home town of Melbourne (Australia, not Florida). I sent an email...

(SUMMARY) On the 25th of January at 10 am PST, I will present a webinar on preventing MySQL emergencies titled “Preventing Downtime in Production MySQL Servers”. The material I will present is based on in-depth research done by Percona across many production...

(SUMMARY) Sometimes you might hear people talk about full backups, and differential backups versus incremental backups. What is the difference? A full backup is pretty self-explanatory. It makes a copy of all of your MySQL data. A differential backup, on the...

(SUMMARY) If you ve missed Percona Live in Washington,DC and even if you did not you should be happy to know we have now published slides from majority of talks at this conference. Enjoy! This conference had great talks, whenever you re Beginner or Advanced...