ElysianMasters.com is a world class mastering studio in Los Angeles. Our Services include Audio CD mastering, Audio Restoration, Mixing, and more.

It is rather typical for systems to start as MyISAM but as system growths to move to Innodb.

I have run into a number of cases recently that all had a similar look and feel. In most of these cases, the symptoms were very complicated, but they boiled down to just a few problems that can be prevented in very simple ways.
If you are not doing any of the following three simple things, you probably should. These are essential practices for building successful applications, which everyone should be doing. And the best part is how easy it is to do them — read on for the details.
1. Archive or Purge Your Database

Couple of days ago I was looking for a way to improve update performance for the application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw the same problem with INSERT ON DUPLICATE KEY UPDATE)

I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go:

Dear Community,
Today we are announcing XtraDB release 7.
This is the last release based on InnoDB plugin version 1.0.3, as you might know Innobase has released 1.0.4.
The release includes following new features:

• MySQL 5.1.37 as a base release
• speed hack for buf_flush_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery

Fixed bugs:

Dear Community,
The 18-th build of MySQL server with Percona patches is available now.
Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.84
• Fixed the issue with CLIENT_STATISTICS
• New patch innodb_recovery_patches.patch greatly improves recovery time

Fixed bugs in the build:

I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application.

During preparation of Percona-XtraDB template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see it as device in your OS, so you can easily make software RAID from several volumes.
So I created 4 volumes ( I used m.large instance), and made:
RAID0 on 2 volumes as:
mdadm -C /dev/md0 --chunk=256 -n 2 -l 0 /dev/sdj /dev/sdk

Note: This blog post is part 1 of 4 on building our training workshop.