Performance

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths". The presentation slides can be downloaded as a PDF at: http://technocation.org/files/doc/stophatingmysql.pdf View the video online at http://technocation.org/node/646/play or download the 202.5 MB Flash video file (.flv) directly at http://technocation.org/node/646/download. Here are some notes and links I referred to: Technocation, Inc containing free videos, a MySQL podcast (currently on hiatus) and blog posts about MySQL. Why you want to switch to MySQL 5.1 How MySQL Uses Memory Query Cache Configuration EXPLAIN manual page EXPLAIN cheatsheet

This Monday, September 8th, the Boston MySQL User Group broke our 2-month summer hiatus with a presentation on MySQL Views. The slides can be downloaded from http://www.technocation.org/files/doc/2008_09_Views.pdf -- 89 kB, .pdf format. The 199 Mb .flv file can be downloaded at http://technocation.org/node/621/download or played directly in your browser at http://technocation.org/node/621/play. The presentation covers: * Defining views, changing views, deleting views * Using views for column and row level security * Using views for schema abstraction * Simulating check constraints using views * Performance implications * How to find out which tables are views, and information about views * What a materialized view is, and that MySQL does not have them * What makes a view updateable * Problems with updateable views * How views interact with replication

Homer Hummel of the Computer Sciences Corporation gives a presentation on Load Testing Using Perl. A must-view! Stream directly online at http://technocation.org/node/615/play or download the 247 Mb .wmv file at http://technocation.org/node/615/download.

John Coggeshall of Automotive Computer Services presents "Top 10 Scalability Mistakes". From the official conference description: From growing your development team from 5 to 50, or your code base from 10,000 to a million, there are clear patterns and mistakes. Join me as we investigate some of my favorites and how to both avoid and learn from the mistakes of others. Stream directly online at http://technocation.org/node/607/play or download the 301 Mb .wmv file at http://technocation.org/node/607/download.

Brian Aker gives the "zinger" lightning talk about the newly announced "Drizzle". This short (under 8 minutes) video captures Aker's highlights of why he started the Drizzle project and how Drizzle is different from MySQL -- both in what has been removed from MySQL and what features Drizzle can accomodate. Play the video directly in your browser at http://technocation.org/node/576/play or download the 116 Mb file at http://technocation.org/node/576/download.

At the 2008 MySQL Conference and Expo, Ronald Bradford delivered "The Top 20 Design Tips for Enterprise Data Architects". See the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Top_20_DB_Design_Tips_Every_Architect_Needs_to_Know

At the 2008 MySQL Conference and Expo, there was a panel discussion on "Addressing Challenges of Data Warehousing - a Panel Discussion" including: Robin Schumacher (Sun/MySQL) (moderator) Brian Miezejewski (MySQL), Charles Hooper (Pro Relational Systems), Paul Whittington (NitroSecurity, Inc.), Raj Cherabuddi (Kickfire), Victoria Eastwood (InfoBright Inc.)

At the 2008 MySQL User Conference and Expo, Farhan Mashraqi spoke about "Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Optimizing_MySQL_and_InnoDB_on_Solaris_10_for_World.27s_Largest_Photo_Blogging_Community

At the 2008 MySQL User Conference and Expo, Baron Schwartz spoke on "The MySQL Query Cache". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#The_MySQL_Query_Cache

At the 2008 MySQL User Conference and Expo, Phil Hildebrand spoke on "Applied Partitioning and Scaling Your Database System". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Applied_Partitioning_and_Scaling_Your_Database_System.

At the 2008 MySQL User Conference and Expo, Robert Hodges spoke on "Portable Scale-out Benchmarks for MySQL". Download slides and see links to blog postings at the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Portable_Scale-out_Benchmarks_for_MySQL

At the 2008 MySQL User Conference and Expo, Rick Falkvinge of the Swedish Pirate Party delivered a keynote on "Copyright Regime vs. Civil Liberties".

At the 2008 MySQL User Conference and Expo, Domas Mituzas gave a workshop on "Practical MySQL for Web Applications".

At the 2008 MySQL Users Conference and Expo, Lars Thalmann and Mats Kindahl gave a tutorial on replication. Download the slides and see blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008MondayNotes#MySQL_Replication_Tutorial. If you'd like to download the WMV video file in parts, here's a link to: Part 1, 175.27 Mb and Part 2, 172.42 Mb

At the 2008 MySQL Users Conference and Expo, Brian Aker (MySQL) and Allan Kasindorf (SixApart) gave a presentation on Memcached and MySQL. Download the slides and see blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008MondayNotes#Memcached_and_MySQL. If you'd like to download the WMV video file in parts, here's a link to: Part 1, 112.09 Mb and Part 2, 111.31 Mb