beer planet

Updated: March 26th, 2008

April 14-17th is going to be an exciting time. Why? Because the 2008 MySQL Conference and Expo is going to be held in Santa Clara, CA. Who would want to miss out on a chance to lurk around, let alone talk to, some of the smartest people in the MySQL world? Well, those who don't have at least $1000+, of course. A 3 day pass to the conference without tutorials costs a whopping $1199. A full pass would dry up your pockets $1499.

Well, "good news everyone". Thanks to Sheeri Cabral of The Pythian Group, PlanetMySQL.org, Jeremy, and, most importantly, LinuxQuestions.org, I am now in possession of a 3-day conference pass!! I'm incredibly excited that I will be able to attend and finally meet many geniuses, including the ones mentioned on my Must-Know People In The MySQL Field page. I've never won anything worth over 50 cents before. As a funny side note, there were 4 pages of replies to the raffle post, 90% of them saying that they could not attend (mostly due to living in other countries), so in reality only 2-3 people out of everyone could actually attend. I like those odds.

Here is a link to the oh so colorful conference schedule. I'm particularly interested in this short list of highly exciting subjects:

April 15th

• State of MySQL - the keynote by Mårten Mickos (former CEO of MySQL).
• Performance Guide for MySQL Cluster - parallel query processing guide perhaps?
• Lessons Learned in Building a Highly Scalable MySQL Database - definitely need more lessons.
• Big Bird (Scaling Twitter) - should be fun, considering I heard twitter was started in ruby on rails and had major problems scaling out.
• InnoDB: Status, Architecture, and New Features - an update would be nice, kthx.
• Dramatically Improving MySQL Database Performance in Data Warehouse Applications - more lessons!
• Investigating Innodb Scalability Limits by Peter Zaitsev from MySQL Performance Blog!
• Disaster is Inevitable—Are You Prepared? by Farhan Mashraqi from Fotolog.
• Mitigating Replication Latency in a Distributed Application Environment - I need to get rid of these constant replication lags already, for the love of god!

April 16th

• Portable Scale-out Benchmarks for MySQL - tasty MySQL bench goodies? Sign me up.
• Applied Partitioning and Scaling Your Database System - sharding, disk spanning? Whatever this will be, I'm all ears.
• Architecture of Maria: A New Storage Engine with a Transactional Design - I'm very interested in this new, very promising future replacement engine for MyISAM.
• Astronomy, Petabytes, and MySQL - sounds like fun. I liked astronomy… I think.
• Benchmarking and Monitoring: Tools of the Trade (Part I) - more tools, invaluable.
• Benchmarking and Monitoring: Tools of the Trade (Part II) - even more? Tool overload for today.

April 17th

• A Match Made in Heaven? The Social Graph and the Database - by Jeff Rothschild from Facebook.com, sounds like something to wake me up in the morning.
• Stored Routines: Tips, Tricks, and Solutions
• MySQL Proxy, the Friendly Man in the Middle - probably one of the most interesting things in development right now.
• Sphinx: High Performance Full Text Search for MySQL
• Helping InnoDB Scale on Servers with Many CPU Cores and Disks - more scaling, always good.
• MySQL Hidden Treasures - man, how do I combine 3 sessions that go on at the same time?
• Top 20 DB Design Tips Every Architect Needs to Know
• Partitioned mySQL and …. realtime - by Dathan Pattishall from Flickr.
• Deadly Sins Using MySQL and PHP - by Arjen Lentz

April 18th

• temporarily unload all the information gathered in the previous 3 days and drown in beer

Excitement is in the air. Can you FEEL IT?

Pine is a UNIX command line mail application. So how do you delete all messages in a folder?

The combination is

1

; A A D

If after pressing ; you see

1

[Command ";" not defined for this screen. Use ? for help]

then you don't have a check in the "Enable aggregate command set" settings checkbox. To enable it, go to the main menu (M) -> Setup (S) -> Config (C) and scroll down to "Enable aggregate command set". Then press X (to check it), E (Exit). Now repeat the above.

Updated: May 1st, 2008

Sometimes in my line of work, I need to figure out if a url or filename point to a media file by checking for the file extension. If it's a url, however, it may be followed by various parameters. Not to overcomplicate things, I came up with the following Perl code:

1
2
3
4
5
6
7
8
9
10

#!/usr/bin/perl -w
use strict;
my $name = "some_file.flv"; # or http://example.com/file.mp4?foo=bar
my $is_media_type = ($name =~ /\.(wmv|avi|flv|mov|mkv|mp..?|swf|ra.?|rm|as.|m4[av]|smi.?)\b/i);
if($is_media_type){
  print "media extension found\n";
}
else{
  print "not a media file\n";
}

This gets the job done without triggering any false positives (at least for the files/urls I've been dealing with so far). Am I missing any obvious types? Do you have a better way to accomplish the same thing? If so, please share in the comments.

Updated: April 8th, 2008

If you're serious about MySQL, it doesn't hurt to know the people closely tied to its development and maintenance as well as famous bloggers. Here's my ongoing list of people I consider important:

Peter Zaitsev - MySQL Performance Blog, former head of MySQL AB High Performance Group. His company Percona is available for consulting. He's a co-author of High Performance MySQL 2nd edition (great book).

Baron Schwartz - also know as Xaprb, Baron a co-author of High Performance MySQL 2nd edition and creator of innotop and Maatkit. Maatkit is simply brilliant, and so is Baron. Baron recently joined Peter Zaitsev at Percona.

Jeremy Zawodny - MySQL guru, works for Yahoo, and is considered a legend. He wrote mytop and both editions of High Performance MySQL 2nd edition among other things. Here's Jeremy's twitter. I suggest subscribing to his rss feed as his blog is quite interesting and versatile.

Paul McCullagh - developer of the PBXT transactional storage engine for MySQL.

Ronald Bradford - active blogger and a recent addition to PrimeBase Technologies, the maker of PBXT.

Roland Bouman - a MySQL developer and blogger, active in the community. He likes to post really, really, REALLY long but detailed and informative posts. He's one of the speakers at the upcoming MySQL conference (as most of the people here, actually).

Jan Kneschke - senior software developer in the MySQL AB Enterprise Tools team. He maintains the MySQL Proxy and the awesome lighttpd web server (!!!).

Giuseppe Maxia - a MySQL QA developer and tester for MySQL Proxy. Giuseppe loves LUA and maintains a blog called The Data Charmer where he writes about the MySQL Proxy a lot.

The Pythian Group - a group of ingenious DBAs (who also blog). This company does remote DB management and consulting.

Paul Vallee - CEO of The Pythian Group. A smart, dedicated, really great guy.

Sheeri Cabral - a very active and insightful blogger and speaker who also happens to work for The Pythian Group. She posts often and calls herself a MySQL She-BA.

Farhan (Frank) Mashraqi - Director of Database Infrastructure at fotolog.com, one of the top 15 sites in the world. He maintains a blog called MySQL Database Administration.

… more to come.

If you want to see some pictures of these fascinating people, head over to:

• http://jcole.us/gallery/uc2006

Computer Science majors out there that went through tedious hours of studying Lisp - this is for you from xkcd. If you know Perl, it will make even more sense.

Source: http://xkcd.com/224/

See Also: Best Programming Comic Ever: Code Quality In WTFs/Minute