Home

Query Optimization

Video: Chasing Bottlenecks

Posted July 6th, 2009 by sheeri

Video for the presentation at the 2009 MySQL Camp:
Chasing Bottlenecks
by Morgan Tocker

Description:
The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

Video: Map/Reduce and Queues for MySQL Using Gearman

Posted April 23rd, 2009 by sheeri

Video for the presentation at the 2009 MySQL Conference:
Map/Reduce and Queues for MySQL Using Gearman
Eric Day (Sun Microsystems), Brian Aker (Sun Microsystems, Inc.)

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

Download the PDF slides.

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

Posted April 22nd, 2009 by sheeri

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:

Download the 106 Mb .mov file at <

Video: Beginner Guide to Website Performance with MySQL and memcached

Posted April 22nd, 2009 by sheeri

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: Advanced Query Manipulation with MySQL Proxy

Posted April 21st, 2009 by sheeri

Video for the presentation at the 2009 MySQL Conference

Advanced Query Manipulation with MySQL Proxy
Kay Roepke (Sun Microsystems)

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

Video: Testing with the MySQL Random Query Generator

Posted April 21st, 2009 by sheeri

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: Sphinx Full-Text Search Engine

Posted April 19th, 2009 by sheeri

Andrew Aksyonoff speaks at the April 2009 Los Angeles MySQL User Group about how to use Sphinx, the free open source full-text search engine.

Description:
Just how do you implement keyword search through that 10-million-row InnoDB table? Meet Sphinx, a blazing fast open source engine that makes it a breeze. We'll talk about what it is, how it works, and when and why use it.

The user group page is at: http://www.meetup.com/lamysql/calendar/9882984/

Real Time Data Warehousing Presentation

Posted March 26th, 2009 by sheeri

At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.

The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf.

Video: Partitioning in MySQL 5.1

Posted February 4th, 2009 by sheeri

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

Posted November 15th, 2008 by sheeri

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

Posted November 15th, 2008 by sheeri

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.

The Top 20 Design Tips for Enterprise Data Architects

Posted April 30th, 2008 by sheeri
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

Video: Addressing Challenges of Data Warehousing - a Panel Discussion

Posted April 30th, 2008 by sheeri
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: Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community

Posted April 30th, 2008 by sheeri
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

Video: The MySQL Query Cache

Posted April 30th, 2008 by sheeri
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
12next ›last »