ElysianMasters.com is a world class mastering studio in Los Angeles. Our Services include Audio CD mastering, Audio Restoration, Mixing, and more.
Read more »ElysianMasters.com is a world class mastering studio in Los Angeles. Our Services include Audio CD mastering, Audio Restoration, Mixing, and more.
Read more »Nation's leading coaching firm, motivational seminars, corporate events, keynotes, and best selling books & CDs by Jordan Wirsz, dubbed “the next generation personal development superstar
Read more »It is rather typical for systems to start as MyISAM but as system growths to move to Innodb.
Read more »Today’s the day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week.
Our Montreal practice teach at Station-C went great – it was an opportunity to do a road test and iron out any kinks in the delivery.
What did I learn in the process?
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
Recently I had a chance to take a look at Redis project, which is semi-persistent in memory database with idea somethat similar to memcache but richer feature set.
Read more »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)
Read more »Dear Community,
The release 0.9 of the opensource backup tool for InnoDB and XtraDB is available for download.
Changelog:
Fixed bugs:
Read more »I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go:
Read more »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:
Fixed bugs:
Read more »Ever wondered how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against a "roughly equivalent" subquery. The idea -- and there may be shortcomings that are poisoning the results here, your comments welcome -- is to see how fast the SQL procedure code is at doing basically the same thing the subquery code does natively (so to speak).
Read more »Note: This post is part 2 of 4 on building our training workshop.
As you might have seen Innodb Plugin 1.0.4 was released today. I am very excited to see this release which is released exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released by MySQL Conference and Expo in April).
Read more »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:
Fixed bugs in the build:
Read more »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.
Read more »Inspired by NILFS: A File System to Make SSDs Scream and some customers asked if they should try NILFS on their SSD disks I decided to run quick tests to see how it performs.
Installation on our Ubuntu 8.10 with SSD disk (Intel X25-E, 32GB) was pretty plain and I got partition with NILFS without problem. After that I run script for sysbench fileio:
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
So during preparation of XtraDB template for EC2 I wanted to understand what IO characteristics we can expect from EBS volume ( I am speaking about single volume, not RAID as in my previous post). Yasufumi did some benchmarks and pointed me on interesting behavior, there seems several level of caching on EBS volume.
Read more »Note: This blog post is part 1 of 4 on building our training workshop.
Read more »If you do not follow MariaDB development, I want to head up XtraDB has been commited to MariaDB server and will be included in binary releases of MariaDB (scheduled on end of August – September) as replacement of InnoDB storage engine. MariaDB will also include PBXT storage engine, Sphinx storage engine and few our non-InnoDB related patches (extended stats into slow-log)
Entry posted by Vadim |
One comment

Recent comments
11 hours 10 min ago
1 day 11 hours ago
4 days 11 hours ago
5 days 12 hours ago
6 days 8 hours ago
1 week 11 hours ago
1 week 1 day ago
1 week 1 day ago
1 week 4 days ago
1 week 5 days ago