Peter Zaitsev was kind enough to share with me an idea for a script which I have now finished. mysqlidxchk checks MySQL databases/tables for unused indexes. Version 1.0 with documentation and guide is available for download: mysqlidxchk v1.0 (Linux or Windows).

Please report any bugs or problems you experience.

It was a tough decision, but after much deliberation, the Proven Scaling Free Ride panel has made their decision, and the MySQL Conference & Expo 2007 Free Ride winners have been chosen. To recap, each of the winners will receive:

• Round-trip airfare from their location to SJC, SFO, or OAK airport
• Transportation from the airport to hotel/conference
• Hotel accommodations
• A meal stipend
• A full conference pass, provided by MySQL AB (Thanks, MySQL!)

Without further ado, here are the winners and their stories:

Jan Lehnardt, a student from …

If anyone’s missed these excellent posts, I should really point them out.

• Chris DiBona tells us all that the moral is “Don’t Talk. Do. Don’t yammer. Launch. Release. Ship.” He’s right. Look at Microsoft talking about freeing their database, and wanting to release their beloved FoxPro code to the world, via CodePlex. Open source or not, they surely received a lot of positive karma last week. I don’t doubt their delivery aspect of things, but why talk about it before it happens - it means a lot more, doing it first, I’d think. With the possiblity of users expanding on this, maybe someone will work on a FoxPro to MySQL migration suite, that will be feature complete?
• Then Jeremy Zawodny tells us about how silly lame announcements are (really, they are) and we should …

This is a tale about Ruby On Rails, custom stored procedures for MySql 5 and how Rails 1.2.3 is not only opinionated against stored procedures but also actually incompatible with creating and sometimes calling (mysql) stored procedures. The tales does not end with a truly happy ending but some “hacks” are mentioned that I have found useful.

Background
The rails framework developers, being of the opinion that complexity is best located in the code and not in the database, does not advocate using stored procedures as a abstraction layer between the database and the application. Instead dynamic sql generated from RoR code is used. For typical application databases, this approach works very well indeed.

Examples where the traditional rails way of database thinking sometimes fails short are projects …

As like many people in the MySQL community, I am looking at planning out my sessions at the upcoming conference. I have been waiting for an iCal file with the sessions to make it easier to plan and keep track of what sessions I am going to at the conference. Last year one was available, but have not seen one this year to date. I am guessing it may still be in development or overlooked, so I am making mine available for people to use.

I will probably be adding more detail to the calendar as I get a chance, but the majority of the session information should be there. I did a simple transform on the session details that was on the conference website and did a quick check to see that it was all matching.

You can download the

Tags for this post: mysql conference mysqluc2007 mysql presentation …

Here's my tentative agenda for sessions I am interested in at the MySQL Conference:
Monday

• MySQL 5.1 In-depth
• Real-World MySQL Performance Tuning

Tuesday

• Using Stored Routines for MySQL Administration
• MySQL 5.1's Log Tables
• …

I've been working on how to efficiently compare and synchronize data between two tables on different MySQL servers. I've also been working on a tool, sort of like rsync for database tables, which implements both algorithms. I profiled it to see how well the comparison algorithms work on real data. This article is about the results.

The 38th edition of Log Buffer, the weekly review of database blogs, has been published on Padgraig O’Sullivan’s Padraig’s Blog. Don’t forget, Log Buffer uses a distributed editorship. It needs your perspectives, so if you want to try your hand at editing and publishing an edition, please read the Log Buffer homepage for more [...]

The first version of this code failed to work on 5.1 so here is a version that does:

if(DATABASE_REPLICATION_CHECK)
{
$result = mysql_query("show slave status;");
$row = mysql_fetch_assoc($result);
if( ($row['Slave_IO_Running']!='Yes') || ($row['Slave_SQL_Running']!='Yes') )
{
$fp = fopen('tmp/halt', 'w+');
fclose($fp);
header('Location: index.php');
}
}

Remember to add something like:

if(file_exists('tmp/halt')) exit('Unable to complete request at this time');

at the start of your app execution so as to stop users entering data that can cause all kinds of living nightmares when it comes to patching the data together.
--
Copyright 2006-2008 Andrew Rose [rose.andrew@gmail.com] [andrewrose.co.uk]