Category Archives: MySQL

Scripts, queries, gotchas and more about MySQL databases

Creating better MySQL indexes: The basics

Posted on March 20, 2009 by Samuel Huckins

The well-developed MySQL platform allows anyone to play with a full-featured database just by following a few links and clicking through an install wizard. You can download it at home for free, and have access to the same high end … Continue reading →

Posted in MySQL | Tagged , , , | Leave a comment

Exploring the power of the mysql client

Posted on March 15, 2009 by Samuel Huckins

One of the things that surprised me at the MySQL Bootcamp was the focus on using the mysql CLI client. I used to only use this, since the GUI-based Query Browser was rather unstable on Linux. I just got tired … Continue reading →

Posted in CLI, MySQL | Tagged , , , , | 2 Comments

MySQL Bootcamp: Highly recommended!

Posted on March 14, 2009 by Samuel Huckins

I was able to attend the MySQL Bootcamp this week, and it was incredible. Instructors David Swain and George Trujillo really knew their stuff, and they did an admirable job sharing their experience and knowledge. They were an interesting pair, … Continue reading →

Posted in MySQL, Programming | Tagged , , | 1 Comment

Joining a table to itself in MySQL

Posted on March 4, 2009 by Samuel Huckins

Joining a table to itself is a technique that, while moderately painful to contemplate, can prove quite valuable in making certain updates possible. Consider an example case where we have a table containing various company names, some of which actually … Continue reading →

Posted in MySQL | Tagged , , | 3 Comments

MySQL replication and flush tables with read lock gotcha

Posted on December 11, 2008 by Samuel Huckins

I ran into something that stumped me for a few minutes today while trying to setup some replicated databases in MySQL. As with any replication setup, you have to lock the master tables and note the binary log position via: … Continue reading →

Posted in MySQL | Tagged , , , | 6 Comments