I just made a snapshot of the development branch of the innotop MySQL and InnoDB monitor, and released it as version 1.3.0. This code will eventually become version 1.4. Here's what's new.

Just got email from Jay today about two of my talks being accepted to MySQL Users Conference 2007 "MySQL Server Settings Tuning" and "MySQL Performance Cookbook". This is great as MySQL Conferences are always fun and great way to get to know people and learn things about MySQL and connected areas.

This will be my 5th time, but only first time, not being MySQL Employee.

No word so far about other talk I proposed - "Innodb Performance Optimization" which I think is one of my best talks. Might be the name sounds old, even though I add new information to it each time to keep it fresh.

This person dreamed that they were trying to compile part of Firefox, and the compile button was actually the snooze button on the alarm clock. I experienced a similar dream years ago: I dreamt I was a debugger, and this breakpoint kept firing (the breakpoint turned out to be my alarm clock).

Anyone else had dreams that you were a computer? Or a MySQL storage engine? Or a compiler?

bkf clone -rmysql-5.0.33 bk://mysql.bkbits.net/mysql-5.0-community mysql-5.0.33

cd mysql-5.0.33

BUILD/autorun.sh

cd ../

tar cvzf /usr/src/redhat/SOURCES/mysql-5.0.33.tar.gz mysql-5.0.33

export CC=/usr/bin/gcc
export CXX=/usr/bin/gcc
export LD_LIBARY_PATH=$LD_LIBARY_PATH:/lib64:/usr/lib64
export CFLAGS="-O2 -static -fomit-frame-pointer -ffixed-ebp"
export CXXFLAGS="-02 -felide-constructors -fno-exceptions -fno-rtti"

rpmbuild -ba --define '_with_static 1' mysql-5.0.33.spec

Now mysql-5.0.33.spec is just any spec file distributed with the RHEL source RPM - if requested I can upload it.


UPDATE: Lenz left a refinement in a comment here

Really good stuff

A friend pointed out to me number of our our articles were translated and included in PHPInside.RU - electronic magazine about PHP and surrounding technologies which of course include MySQL. You can download PDF for free right here.

We love our articles being translated and or republished, as long as they are available for free same as original articles and as long as you give us a credit for being authors.

I'll be giving a talk at mysqluc2007. The talk will be entitled, Federation at Flickr: Doing Billions of Queries per day. Personally I think it's a pretty catchy title, and full of info that might be helpful for many other organizations.

I've won 2005 (1st year that they offered this award), and 2006 Application of the year award for the uses of mySQL. Three years in a row would be cool! This will be my second speaking engagement at mysql uc. The 1st one was entitled Friendster back in 2005. It says I'm a Sr. Support Engineer, I have no idea what that is, really I'm the Database (DataLayer) Architect / Database Administrator, or Technical Yahoo - in Yahoo Land. I'm not to big on titles because doing is much greater then being(tm).




Hope to see you there.

We used to use Google mini to index our site to serve search results to our users. It worked great for a while until sometime back it just stopped indexing. It would get a fatal error and stop index after couple urls. It was also not so kind about sending me an email to let me know that it has stopped indexing. It was still serving pages which were indexed prior to this so we didn?t realize it wasn?t indexing new content.

And than one day we logged in to the admin console to see whats going on with it and found out it wasn?t indexing. I checked the logs and found out that it was stopping due too too many 4xx errors. After looking at logs on our web server I found out that it was stopping because Apache was giving back 406 response code which is described at w3.org as:

The resource identified by the request is only capable of generating response entities which have content characteristics not acceptable according to the accept …

Stewart was hoping the MySQL MiniConf (hereinafter called mysql.conf.au) would rock. In fact, it actually did.

At any one time, we had over 60-75 people in the room. It was a standing room, with full attendance at all the talks!

As soon as I get all the slides, I’ll place it up at Forge.

[Update 28/1/2007: New Version and new website.]

Amit Singh ported FUSE to MacOS X. This is just cool. Thanks!

I created a little Cocoa GUI around sshfs to manage and mount your remote drives via ssh conveniently from a program and not from the commandline. This is early alpha software and may break things. It is not heavily tested and could sleep with your wife while beating your kids, so BEWARE! Additionally, the software it interfaces with is in its early stages as well and it includes a custom kernel extension (written by Amit, so I trust it). You have been warned. It's so new that it doesn't even have an icon. But sssssh!

See this announcement for …