by Vadim Tkachenko | Sep 14, 2009 | Insight for DBAs
Since DTrace was released for Solaris I am missing it on Linux systems… It can’t be included in Linux by the same reason why ZFS can’t be – it’s licensing issue. Both ZFS and DTrace are under CDDL, which is incompatible with GPL. So you...
by Peter Zaitsev | Sep 14, 2009 | Insight for DBAs
What is wrong here (the part of SHOW INNODB STATUS): ————– ROW OPERATIONS ————– 8 queries inside InnoDB, 9 queries in queue 100 read views open inside InnoDB It is relationship between queries active –...
by Vadim Tkachenko | Sep 14, 2009 | Percona Software
If you ever wondered how big is that or another index in InnoDB … you had to calculate it yourself by multiplying size of row (which I should add is harder in the case of a VARCHAR – since you need to estimate average length) on count of records. And it...
by kuszmaul | Sep 12, 2009 | MySQL
I saw Mark Callaghan’s post, and his graph showing miss rate as a function of cache size for InnoDB running MySQL. He plots miss rate against cache size and compares it to two simple models: A linear model where the miss rate is (1-C/D)/50, and A...
by Peter Zaitsev | Sep 12, 2009 | Insight for Developers
I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should expect. There are 3 main ways how MySQL can use the indexes for query execution, which are not mutually exclusive, in fact some queries will use...
by kuszmaul | Sep 11, 2009 | MySQL
We’re supporting the OpenSQL Camp, which will be held in Portland on November 14. One of my objectives for the camp is to make progress on a universal storage engine API, to make it possible to use the same storage engines in MySQL, PostgreSQL, Ingres, or any...
by Peter Zaitsev | Sep 10, 2009 | Insight for Developers
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could be just desire for better data consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably...
by Morgan Tocker | Sep 10, 2009 | Percona Events
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...
by Baron Schwartz | Aug 29, 2009 | Insight for Developers
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...
by Peter Zaitsev | Aug 28, 2009 | Insight for Developers
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) As I went from 1 value to 3 or 10...
by Peter Zaitsev | Aug 27, 2009 | Cloud
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. Redis has simple single process event driven design, which means it does not have to deal with any locks...
by Morgan Tocker | Aug 26, 2009 | Percona Events
I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go: We’ve had reports of some lost comments. Â We reported this via Twitter a while ago, but thought it was fixed. Â We’ll try and...
by Aleksandr Kuzminsky | Aug 20, 2009 | Percona Software
Dear Community, The release 0.9 of the opensource backup tool for InnoDB and XtraDB is available for download. Changelog: tar4ibd could not treat over 8GB file, now max 64GB prepare-speed-hack is added Fixed bugs: Bug #386179: “InnoDB: Error: space id in fsp...
by kuszmaul | Aug 17, 2009 | MySQL
Sorting a Terabyte in 197 seconds I just returned from The 21st ACM Symposium on Parallelism in Algorithms and Architectures (SPAA), held in Calgary, where I gave a talk about my entry to the sorting contest. I sorted 1TB in 197s on a 400-node machine at MIT Lincoln...
by Aleksandr Kuzminsky | Aug 17, 2009 | Percona Software
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...
by Baron Schwartz | Aug 16, 2009 | Benchmarks
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,...
by Morgan Tocker | Aug 13, 2009 | Percona Software
Note: This post is part 2 of 4 on building our training workshop. Last week I talked about why you don’t want to shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. ...
by Peter Zaitsev | Aug 11, 2009 | Insight for DBAs
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...
by Aleksandr Kuzminsky | Aug 11, 2009 | Percona Software
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...
by Peter Zaitsev | Aug 10, 2009 | Insight for Developers
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...
