Video: How to Stop Hating MySQL

Nov 12, 2008 / By Sheeri Cabral

Tags: ,

(Note: updated with the presentation video on 11/15/2008)

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

3 Responses to “Video: How to Stop Hating MySQL”

  • Tom Krouper says:

    I was going through your slides and they were obvious just an outline for your talk. But, I did have one quick question… you mentioned innodb_file_per_table but it was just a line item. I couldn’t tell if you were pro or anti (or neither). I’ve heard different takes on using this. I know it is nice for saving space if you are doing lots of deletes followed by optimizing, but I’ve also heard that once you get above 200 tables, there is a hit on performance with opening tables. I was hoping you could give your opinion on when to use or not use innodb_file_per_table. Thanks.

  • Sheeri Cabral says:

    Tom — I’ve added the video, so you (and everyone else) can get the full information. The short version is that using innodb_file_per_table can help optimize disk usage because each InnoDB table has a file for indexes and data.

    As far as opening tables, you can increase the size of table_cache.

  • [...] Video: How to Stop Hating MySQL [...]

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>