So one of the things I finally started to figure out, at least sorta, is the concept of VIEWS. I had known about them for some time but never really understood why to use them. I had thought they provided worse performance than by not using them and simply using JOINs in a query. Well...the results I found were somewhat surprising. When using a view to de-normalize a dataset used for my Blog, I noticed an improvement of about 4-6 seconds on average when running 80 threads with 10000 iterations than by using the standard query. I ran these tests multiple times with the same configuration and even tried different numbers of threads/iterations. In all cases, using the view was faster. For completeness, here is the original query and the updated one using the view:

Using the view:

SELECT * FROM blogposts_view 
WHERE postid=$randomNumber;

Without the view:

SELECT BlogPosts.title, BlogCategories.name, …

And just like that the 2007 MySQL Conference is over and folks are on their way back home, or off to vacations, or whatever comes next.

It has been a great week hearing how others are using technology to build good things. It has also been good to meet folks and have good conversation sharing ideas about what works, what doesn't work, and how to change things so they will work.

MySQL is in a really good place right now. I commented to more than one person that it is impressive the kinds of folks who are driving their business/application with MySQL and came to talk about it. These include (in no order) YouTube, digg, flickr, Yahoo!, Wikipedia, Google, NASA, US Navy, SugarCRM, TicketMaster, and more. It is hard to beat that list when it comes to proof that a technology is viable.

Here's to another good year of pushing the LAMP stack and open source to wider use and …

In my fourth day at the MySQL Conference and Expo 2007, I attended several great sessions, starting with my own. If you’re wondering why this is a day late, it’s because the conference ended in the late afternoon, and they almost immediately – within a half-hour or so – removed the free wireless Internet access in the hotel. That was uncool. Keynotes etc I skipped the opening keynotes to polish off last-minute changes to innotop and my presentation.

Closing keynote of the 2007 MySQL Conference is Pasha Sadri from Yahoo! talking about pipes.

Pasha starts with a story about looking for an apartment near a park (this happened to him a few years ago). It was very tedious to go looking on Craigslist every hour clicking on every apartment and looking to see if the apartment was near a park.

Made a 50-line Perl script to merge database between Craigslist and Yahoo! local to get data sets. This turned into Yahoo! pipes which provides a visual editor to take data sources and create a set of controls over that data source and output the data in a certain way.

If you haven't seen pipes it is hard to describe, but very cool.

For design, pipes relied heavily on the idea of Unix pipes. The goal to …

Adobe open sources Flex. MySQL AB releases new performance benchmarks. SugarCRM supports Oracle Unbreakable Linux. (and more)

Adobe to Open Source Flex, Adobe (Press Release)

MySQL AB Announces Record Cluster Database Benchmark Results, MySQL AB (Press Release)

SugarCRM Expands Support for Oracle Unbreakable Linux Support, SugarCRM (Press Release)

EMC and Oracle Join Forces Under the Oracle Unbreakable Linux Support Program, Oracle (Press Release)

…

mysqlconf mysqlconf07

It’s not easy to do a DW in MySQL — but it’s not impossible either. Easier to go to Teradata than to write your own.

DW characteristics:

1) Organic, evolves over time from OLTP systems — issues, locking, large queries, # of userss.

2) Starts as a copy of OLTP, but changes over time — schema evolution, replication lag, duplicate data issues

3) Custom — designed from the ground up for DW — issues with getting it started, growth, aggregations, backup.

4) How do you update the data in the warehouse? — write/update/read/delete, write/read/delete, or write only — which means that roll out requires partitions or merge tables.

The secret to DW is partitioning — can be based on:
data — date, groups …

In a community session yesterday at MySQL Conference 2007, I first heard about Dorsal Source. A collaboration between Solid DB and Proven Scaling that allows for community people to upload patches to MySQL, get it compiled across multiple platforms, and have a downloadable distribution available on H/W individual contributors will never have access to.

That’s a great idea. I also hope we get the opportunity to get compiling of patches into multiple versions, as well to get builds of a lot of patches together. Personally, I’m running 3 versions just to diagnose one problem. 5.0.36 with a custom binary change, 5.0.37 so I have SHOW PROFILE, and 5.0.33 so I have …

In a community session yesterday at MySQL Conference 2007, I first heard about [Dorsal Source][1]. A collaboration between [Solid DB][2] and [Proven Scaling][3] that allows for community people to upload patches to [MySQL][4], get it compiled across multiple platforms, and have a downloadable distribution available on H/W individual contributors will never have access to.

MySQL Conference 2007 Day 4 started early again at 8:20 am with PHP on Hormones by the father of PHP Ramus Lerdorf. A very funny man, one of the best insightful talks of the conference (rather scary actually).

MySQL Conference 2007 Day 4 started early again at 8:20 am with PHP on Hormones by the father of PHP Ramus Lerdorf.

A very funny man, one of the best insightful talks of the conference (rather scary actually). Here are some opening comments.

• In his own words as Keynote speaker. “I’m here because I’m old”.
• Php 1 from 1994 started after seeing Mozilla in 1993. Because it was just me using it, I could change the language any time.
• In 2005 the code looks like this (in comparison on 1995) — I’m not sure if this is worth 10 years of development
• I wrote PHP to avoid programming
• It’s changed to be more OO because people expect that. Universities teach this.
• Hey, I was fixing bugs in my sleep. Iwould wake up, and in my mail …