Tag Archives: MySQL

Reminder for mysql rubygem install on Ubuntu

Posted on January 3, 2011 by Samuel Huckins

Quick easy steps to get up and running with ruby, mysql, sqlite, rails, and most especially the mysql gem on a fresh Ubuntu 10.10 64-bit system: 123456789# mysql and dev packages needed for mysql rubygem: sudo apt-get install mysql-server mysql-client … Continue reading →

Posted in Programming, Ruby | Tagged , | 1 Comment

Troubleshooting MySQL queries: a useful workflow

Posted on December 12, 2010 by Samuel Huckins

Configuring and optimizing MySQL servers, from the underlying hardware to the instance settings on up to the application queries, is a multi-faceted and complex process. Here I’d like to assume you’ve got a well-configured physical server (it’s at least functioning … Continue reading →

Posted in MySQL | Tagged , , | Leave a comment

Debugging bottlenecks with the MySQL Query Profiler

Posted on December 12, 2010 by Samuel Huckins

I was throughly pleased to discover the MySQL Query Profiler facility recently. Somehow I hadn’t heard about it (or recalled anyway) until now. In short it provides a very easy way to view how much time (down to the microsecond) … Continue reading →

Posted in MySQL | Tagged , , | 3 Comments

Tune MySQL like a pro with MySQLTuner

Posted on March 13, 2010 by Samuel Huckins

I came across MySQLTuner recently and was most pleasantly surprised. It’s a Perl script that only requires your MySQL user and password to provide detailed and useful checks of a running MySQL instance. First though, check out the awesome URL … Continue reading →

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

Better access to MySQL create view statements

Posted on November 15, 2009 by Samuel Huckins

I’ve found that I often create several views that are variations on an initial one, providing a slightly different convenient slice of the data as the need arises. But when a view is created the syntax actually stored can be … Continue reading →

Posted in MySQL | Tagged | 2 Comments