Performance

Video: Beginner Guide to Website Performance with MySQL and memcached

Video for the presentation at the 2009 MySQL Conference:

Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009

Video: Top 10 MySQL Pet Peeves and How to Workaround Them

Video for the presentation at the 2009 MySQL Camp:
Top 10 MySQL Pet Peeves and How to Workaround Them
Jeremy Zawodny

Watch it online here:

Video: Testing with the MySQL Random Query Generator

Video from the 2009 MySQL Conference presentation:

If You Love It, Break It: Testing MySQL with the Random Query Generator Philip Stoev (Sun Microsystems)

The description is at:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363

Download the presentation slides (ppt).

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.

Moving Application Logic Into the Database by Bruce Momjian

Bruce Momjian talks about general strategies for moving application logic into databases, mostly why to do it and why to not do it. This talk is mostly DB agnostic. Note that the slides have a title of "Processing Data Inside PostgreSQL". The slides can be found at http://www.slideshare.net/EnterpriseDB/data-processing-inside-postgresql.

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.

MySQL Views Presentation at the September 2008 Boston MySQL User Group

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:

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.

OSCon 2008 Video: Top 10 Scalability Mistakes

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.

Why Drizzle? (video)

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.

Pages


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