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. Download the 132 Mb .mov file at http://technocation.org/node/761/download or, if you are more patient, wait (15-20 min) for the streaming to occur at http://technocation.org/node/761/play

A short time ago I posted how I was Using XtraDB Backup to backup InnoDB. Overall, the blog post was positive, but experiences that others have had (and commented to on that blog post) have made me want to put out another short article about using XtraDB backup.

The first ...

A short time ago I posted how I was Using XtraDB Backup to backup InnoDB. Overall, the blog post was positive, but experiences that others have had (and commented to on that blog post) have made me want to put out another short article about using XtraDB backup.
The first few points remain the same — the backup process is stable, we were able to use the binaries without compiling, and using Innobackupex as the wrapper script, analogous to Innobackup.pl.
However, we did figure out why Xtrabackup had to be run as the mysql user:

A short time ago I posted how I was Using XtraDB Backup to backup InnoDB. Overall, the blog post was positive, but experiences that others have had (and commented to on that blog post) have made me want to put out another short article about using XtraDB backup.
The first few points remain the same — the backup process is stable, we were able to use the binaries without compiling, and using Innobackupex as the wrapper script, analogous to Innobackup.pl.
However, we did figure out why Xtrabackup had to be run as the mysql user:

Today's trivial MySQL system variable:

old_alter_table

The interesting bit is that this is a system variable, and shows up in SHOW GLOBAL VARIABLES, but is not documented on the Server System Variables manual page.

Instead, it is documented on the manual page for Server options.

Unfortunately, that documentation is very sparse. It tells ...

Today’s trivial MySQL system variable:
old_alter_table
The interesting bit is that this is a system variable, and shows up in SHOW GLOBAL VARIABLES, but is not documented on the Server System Variables manual page.
Instead, it is documented on the manual page for Server options.
Unfortunately, that documentation is very sparse. It tells us:
old-alter-table is an option that can be set in an option file (such as /etc/my.cnf)

The July meeting of the Boston MySQL User Group will feature Eric Day, a prominent Drizzle developer, talking about Drizzle and Gearman:

In this talk we will discuss two growing technologies: Drizzle and Gearman.

We will explain what the Drizzle project is, what we aim to accomplish, and an overview of ...

The July meeting of the Boston MySQL User Group will feature Eric Day, a prominent Drizzle developer, talking about Drizzle and Gearman:
In this talk we will discuss two growing technologies: Drizzle and Gearman.
We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at. We will also be introducing the fundamentals of how to leverage Gearman, an open-source, distributed job queuing system. Gearman’s generic design allows it to be used as a building block for almost any use - from speeding up your website to building your own Map/Reduce cluster. We will tie Drizzle and Gearman together and demonstrate how they work in a custom Search Engine application.

So I got my hands on an HP mini 1000 last week. Not bad for $250 at Best Buy, although it has needed some help, namely:

- External USB hard drive - I got the Mini 1000 that comes with a 16 Gb SSD, and want this to be my primary computer (I'm not a gamer, just web surfing and *occasional* video editing). I bought a 320Gb Buffalo Mini Station, for about $60 at Microcenter.

- 2 Gb RAM - already had a stick, free for me (otherwise $20), easy to pop in.

- USB to VGA adapter - HP has a nice proprietary VGA port, to which they didn't have an adapter for a long time (6 months or so)....now, the adapters exist, but they're out of stock. I bought a USB to VGA adaptor at Microcenter for about $70.

This is the 150th edition of Log Buffer, the weekly review of database blogs. Someone accidentally left Dave Edwards' cage unlocked, and he escaped, thus leaving me with the pleasurable duty of compiling the 150th weekly Log Buffer.

Many people other than Dave are finding release this week. Giuseppe ...