beer planet

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

Updated: March 18th, 2008

Today Robin Schumacher, MySQL's Director of Product Management, announced that the mysql Falcon storage engine has moved into a beta release stage. Falcon, a new transactional storage engine introduced in mysql 6 (aka 5.2), has been in alpha for years. Other popular storage engines include MyISAM, InnoDB, which Falcon is supposed to challenge (successfully? :-/), and the upcoming Maria.

Falcon features:

• ACID transaction compliant
• Crash recovery
• User-defined tablespaces
• High-speed data caches
• Advanced B-Tree indexes
• Performance/diagnostic monitoring tables
• Simplified configuration

You can download mysql 6 with Falcon here: http://dev.mysql.com/downloads/mysql/6.0.html.

Updated: March 18th, 2008

"Didn't see that one coming. Their blog contains details to what this could mean for both companies. May as well be one of the most important takeovers of 2008 already!"

read more | digg story

Could this mean that the mysql cluster is finally going to get proper development attention? I don't know but sure as hell hope so. Congratulations to all mysql employees!

Updated: July 23rd, 2008

sysbench - Linux test bench. Easy as pie to test CPU, memory, threads, mysql, and disk performance.

Full description is available here: http://sysbench.sourceforge.net/docs/

install mysql, mysql-devel
wget http://superb-west.dl.sourceforge.net/sourceforge/sysbench/sysbench-0.4.8.tar.gz
tar xvzf sysbench*gz
cd sysbench*
./configure && make install

mysql tests

This will run 10 separate consecutive mysql tests using an InnoDB table type, each with 100 mysql threads, doing a total of 1000 various SQL operations per test. Then it will print the total time they took to finish:

sysbench --test=oltp --mysql-user=USER --mysql-password=PASS --mysql-db=test \
  --mysql-host='HOST' --mysql-table-engine=innodb prepare
 
time perl -e "foreach(1..10){print \`sysbench --max-requests=1000 --test=oltp \
  --mysql-user=USER --mysql-password=PASS --mysql-db=test --mysql-host='HOST' \
  --mysql-table-engine=innodb --num-threads=100 run\`}"
 
sysbench --test=oltp --mysql-user=USER --mysql-password=PASS --mysql-db=test \
  --mysql-host='HOST' cleanup