Have you ever seen index which refused to be used even if there is every reason for it to work (from the glance view):

PLAIN TEXT SQL:

1. mysql> EXPLAIN SELECT * FROM article WHERE article_id=10;
2. +----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
3. | id | select_type | TABLE   | type | possible_keys | KEY  | key_len | ref  | rows  | Extra       |
4. +----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
5. |  1 | SIMPLE      | article | ALL  | PRIMARY       | NULL | NULL    | NULL | 93490 | USING WHERE |
6. +----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
7. 1 row IN SET (0.00 sec)

…

The ninth edition of Log Buffer, the weekly review of database blogs, is now available at Daniel Schneller’s Blog.

As did last week's Craig Mullins of dbazine.com I wrote a short post about the LogBuffer recently when I found it in my Blog's referrer list and was promptly asked if I would like to compile one myself.

So here am I am, welcoming all of you to the the 9th issue of the Log Buffer, a Carnival of the Vanities for the DBA community. Once again you will find a plethora of links to all sorts of information on the one thing that keeps many of us both fed and sometimes close to blank despair.

Myself being some sort of a mixture between a software developer and database admin I have had a fair amount of time over the last years to get experience …

So I have been really busy lately dealing with a bunch of stuff including having to reset replication (twice) on some of the slaves that started lagging behind seriously. While I am determined to find and fix this replication lag issue, the majority of it comes from the huge spec differences between the master and the slaves.

Anyway, yesterday I got my plane ticket to go to MySQL Camp which is really exciting. I will be arriving there on Thursday night and leaving Sunday night on an overnight flight.

Last time when I blogged I was writing about MySQL benchmarking, so I will try to pick up where I left off.

I was having some compile issues when trying to compile sysbench on Solaris. When I was running ./configure I was getting the following warnings:

###############################
./configure output …

I've just improved the MySQL duplicate index checker I whipped together a few days ago. As I guessed, my hasty coding left some things to be desired. I've fixed some bugs, added support for finding duplicate foreign keys, and switched to a command-line parsing library that comes standard with Perl, so it's more convenient to run without needing to fetch modules from CPAN.

MySQL is the most popular open source database in the world.

Softpeople Formazione of Milan, Italy, the education company of Softpeople Group, is please to announce that they have been selected by MySQL to be the first Authorized MySQL Education Center (AMEC) partner for Italy, offering certified MySQL training either by the two training Center in Milan, C.so Buenos Aires, 77 and Rome, Via Benedetto Croce, 19 as well as by customers' locations across the country.

Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, about their decision to move to open source, the changes they've made to the code as a result of that move, and various other things.

Sometimes we may need to know geocode of some specific postal location. For example, you have some shops catalogue and want to show shop locations on the map. Then, you will need to ask some service about map marker coordinates. If geocode service is not available or it can’t parse provided address, you will not be able to show map to your users. To solve such problem I’ve created small PHP-module, that helps me to get reliable results from set of miscellaneous geocoding services.

As for now, module can use Google Maps API, Yahoo Maps Services, Geocoder.us and …

activerecord now supports mysql 4.1 (and later) out of the box whether you are using new or old-style passwords, because they applied my patch for handling the related protocol changes correctly.

(it?s not quite out-of-the-box yet ? the fix will appear in the next major release of rails, i guess. it?s fixed in their repository.)

now if only the upstream developer would show signs of life, and get that fixed. i?d complain about that more, but there?s a lot of windows around here.

Our good friends at MySQL and Pentaho are hosting a webinar about ETL for MySQL using Pentaho Kettle. 

ETL is a multipurpose technology, from straight data integration to data migration to reporting systems.  Kettle is primarily used in building Data Warehouse/Data Marts but can also be used for doing other useful MySQL admin tasks. 

Matt Casters and Lance Walter will give you the low down on Kettle:
http://www.mysql.com/news-and-events/web-seminars/etl-using-pentaho-kettle.php

I recommend it, even if you’re not interested in MySQL.  You’ll be surprised that an Open Source ETL tool is so visual and easy to use you may consider it for all kind of tasks.