Normally I write for the MySQL DBA audience. But this blog entry is different. Print out a hard copy and hand it to friends and family when they ask you what sort of presents you want for Christmas, Hanukkah, Festivus or other end of the year gift exchange instead of grunting ‘I do not know1‘ and ending up with something you will have to pretend to like.
[Update: need to take more breaks: now NOT crashing my servers! See clarifications below]
INFORMATION_SCHEMA Optimizations are meant to make your INFORMATION_SCHEMA queries lighter and safer.
For example, if you're going to query the COLUMNS table for just the columns of a single table, then the following:
When an open source project becomes popular, bug reports start flocking in. This is both good and bad news for the project developers. The good news is that someone is using the product, and they are finding ways of breaking it that we didn't think of. The bad news is that most of the times the reporters assume that the developers have super human powers, and that they will find what's wrong by the simple mentioning that a given feature is not working as expected. Unfortunately, it doesn't work that way.
MySQL is the 2011 Readers Choice Award for Best Database.
It may not be the most-exciting topic around, but databases make the world go round. MySQL with its dolphin mascot takes first place again this year, with more than twice as many votes as its closest competition, PostgreSQL.
However, I do take issue with the It may not be the most-exciting topic around quip. MySQL is very exciting!
One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is stable, reliable, easy to manage and has plenty of resources available online. It should also allow running MySQL without too much hassle. Unless there are individual circumstances, it actually makes the decision quite easy.