by Vadim Tkachenko | May 15, 2009 | Insight for DBAs
I want to make this Friday a bit more interesting – how do you feel to train a bit in InnoDB data recovery techniques. I have .ibd datafile which was created by query CREATE TABLE tryme ( email mediumblob, content mediumblob ) ENGINE=InnoDB … (SOME...
by kuszmaul | May 14, 2009 | MySQL
The talk I gave at the Percona Performance Conference at the MySQL Users Conference in April 2009 can be found here. This talk provides some examples where covering indexes help, and then describes a performance model that can be used to understand and predict query...
by Baron Schwartz | May 14, 2009 | Insight for DBAs
I see a lot of people filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there are uses for these, they are dangerous and in my opinion, they are overused. For many cases, there’s a safer alternative....
by Vadim Tkachenko | May 13, 2009 | Percona Software
I do not know if you noticed it, but Google (Mark Callaghan, Justin Tolmer and their internal mysql-team) made a great contribution to MySQL. Patches global transaction IDs, binlog event checksums and crash-safe replication state are separated and published on...
by Peter Zaitsev | May 13, 2009 | Percona Events
Percona and Monty Programming AB announced formation of Open Database Alliance. Read on press release for details.
by Peter Zaitsev | May 13, 2009 | Percona Events
As you know Sun/MySQL and MeetUp.com could not agree on terms of the sponsorship and so now all MySQL meetup organizers have to pay for their Meetups or move them to the different location. Facebook is suggested as one of alternatives. I’m not to take any sides...
by Vadim Tkachenko | May 12, 2009 | Benchmarks, Insight for DBAs
Last week we were busy to align XtraDB performance with 5.4, now we have some results. Currently it is available as “hacks” to XtraDB (available on Lauchpad lp:~percona-dev/percona-xtradb/hacks-porting-tune if you are interested). Basically we took...
by Vadim Tkachenko | May 8, 2009 | Percona Events
This is rather a theoretical interest for me for now (what else to do Friday evening) , but I see how it can be used in current dual-licensed mixed open / closed source storage engines MySQL world. So problem is: Let’s keep MySQL aside for simplicity and imagine...
by Vadim Tkachenko | May 7, 2009 | Percona Software
It is obvious thing for me, but I just figured out it may be not common understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done in almost...
by Peter Zaitsev | May 1, 2009 | Insight for DBAs
As I’ve wrote few times using multiple key caches is a great way to get CPU scalability if you’re using MyISAM. It is however very annoying – this feature really looks half baked to me. The problem with multiple key caches and mapping of tables to...
by Vadim Tkachenko | May 1, 2009 | Benchmarks
In benchmarks passion (see my two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse Dell PowerEdge R900 (btw, to do that I had to switch from CentOS 5.2 to...
by Vadim Tkachenko | May 1, 2009 | Benchmarks
As continue to my benchmarks https://www.percona.com/blog/2009/04/30/looking-on-54-io-bound-benchmarks/ on 5.4 I tried in-memory load (basically changed buffer pool from 3GB to 15GB, and database size is 10GB). The results are on the same spreadsheet...
by Vadim Tkachenko | Apr 30, 2009 | Benchmarks
With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested it on our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS...
by Peter Zaitsev | Apr 29, 2009 | Percona Events
MySQL 5.4 comes with Innodb engine which seems to have much better performance than MySQL 5.0 – this is due to locking and IO patches from Google integrated in this release (which are similar to appropriate Percona patches) as well as some unique fixes such as...
by Vadim Tkachenko | Apr 29, 2009 | Percona Software
We announce next beta version of our xtrabackup tool. Changelist includes: – set innodb_fast_shutdown=1 on xtrabackup shutdown – set innodb_write_io_threads=10 by default for fast buffer_pool flushing during recovery – build xtrabackup with...
by Martin.FarachColton | Apr 28, 2009 | MySQL
Schlomi Noach recently wrote a useful primer on the depth of B-trees and how that plays out for point queries — in both clustered indexes, like InnoDB, and in unclustered indexes, like MyISAM. Here, I’d like to talk about the effect of B-tree depth on...
by Vadim Tkachenko | Apr 28, 2009 | Uncategorized
(Note: Review was done as part of our consulting practice, but is totally independent and fully reflects our opinion) I had a chance to take look TokuDB (the name of the Tokutek storage engine), and run some benchmarks. Tuning of TokuDB is much easier than InnoDB,...
by Evgeniy Stepchenko | Apr 28, 2009 | Percona Software
Today we glad to announce release 1.0.3-5 of our XtraDB storage engine. Here is a list of enhancements in this release: move to MySQL 5.1.34 removed rw_lock patch, so we now use Google’s rw_locks fix crash after upgrade 5.1.31 -> 5.1.33 fix mysql-test Percona...
by Ryan Lowe | Apr 27, 2009 | Percona Events
The 2009 Percona Performance Conference finished up last week, and was overall a resounding success. Thanks to all of the speakers, O’Reilly, and Sun/MySQL for help making it happen! Most slides have been uploaded; look for the stragglers over the next couple of...
by kuszmaul | Apr 26, 2009 | MySQL
Every time I visit the Sun Santa Clara Campus, I’m reminded of Mel Brooks’s movie “High Anxiety”. The campus was known as The Great Asylum for the Insane in the 19th century, and even includes a tower. High Anxiety, whenever you’re near....
