Next Monday's MySQL Meetup in San Francisco should be lots of fun. We'll meet at JasperSoft (303 2nd Street, Suite 450) at 7:00 PM, Mon 11 Sep., and have special guest Teodor Danciu, the creator and architect of Jasper Reports. The guys from JasperSoft will also show off some freely available reports for Bugzilla, and I'm going to give a quick 5-slide presentation on the MySQL Roadmap.

Trudy Pelzer, Engineering Project Manager extraordinaire at MySQL, has added a new section to the Forge wiki detailing the design specs for a proposed simple data auditing functionality for future versions of MySQL. Feel free to provide Trudy your feedback on the proposal and comment either on the Wiki itself, or email Trudy personally at trudy at mysql dot com. What exactly is the simple data auditing functionality?

Well, the proposal outlines essentially an updated logging mechanism that combines some of the features of the slow query log, general query log, and other mechanisms into a method of auditing commands, authentication, and even errors, to log files (or tables) within the server. Essentially, we're talking about writing log tables of everything that goes on inside the server, to ensure that in the case of an audit or a security breach, it is …

I'll be giving a presentation on MySQL performance tuning at the Ohio LinuxFest on September 30th. It will be a discussion about performance tuning guidelines, indexing concepts, benchmarking and profiling guidelines, and other such goodies. There will be some big names giving sessions at the conference, including Jon "maddog" Hall, Jeff Waugh and Jorge Castro from Ubuntu. Come on down and say Hi. Admission is free, so no excuses!

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.