Server Tuning

Video: Partitioning in MySQL 5.1

At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The video is embedded at the bottom of this post, and is also available at youtube at http://www.youtube.com/watch?v=zvN9XI-FraI.

OpenSQLCamp Video: How SQL Database Engines Work

Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.

The description:
To many programmers, SQL RDBMSes are a magical black box. A talk can help clear up a lot of the mystery. SQL users tend to make better use of the language once they have a rough idea of what is going on beneath the covers.

http://www.yo

How to Stop Hating MySQL

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://www.youtube.com/watch?v=DylLYQlzuKo (or watch it at the bottom of this page).

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.

Load Testing Using Perl

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.

Video: Addressing Challenges of Data Warehousing - a Panel Discussion

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.)

Video: The MySQL Query Cache

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

Video: Applied Partitioning and Scaling Your Database System

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.

Video: Portable Scale-out Benchmarks for MySQL

Robert Hodges of Continuent presents "Portabe Scaleout Benchmarks for MySQL" at the 2008 MySQL User Conference and Expo. (video is embedded at the bottom of this post).

Slides are at http://assets.en.oreilly.com/1/event/2/Portable%20Scale-out%20Benchmarks%20for%20MySQL%20Presentation.pdf

Database scale-out architectures promise tremendous capacity increases simply by adding hardware. There are, however, significant differences depending on the scale-out approach you choose. This talk presents a new set of open source benchmarking tools called Bristlecone (http://bristlecone.continuent.org) that allow any user with access to Java to set up and start to run performance benchmarks in a few minutes.

Pages


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32