by Tokutek | Dec 16, 2009 | MySQL
Last week Tokutek released version 3.0.0 of TokuDB, adding ACID transactions to its list of features. This post discusses an experiment we ran to measure recovery time following a system crash. In summary, while actively inserting records into a MySQL database using...
by Devananda van der Veen | Dec 4, 2009 | Benchmarks, MySQL
I recently had the chance to witness the effects of innodb_adaptive_flushing on the performance of InnoDB Plugin 1.0.5 in the wild, which Yasufumi wrote about previously here and here. The server in question was Solaris 10 with 8 disk RAID10 and 2 32GB SSDs used for...
by Zardosht.Kasheff | Nov 17, 2009 | MySQL
Last spring, we added a feature that allows the user to see the progress of writes in a statement. Vadim liked it. In 2.2.0, in “show processlist”, we add progress information on reads. Here is an example of what “show processlist” displays on...
by John.Partridge | Nov 16, 2009 | MySQL
KAYAK, the world’s leading travel search engine, is using TokuDB for MySQL to provide a more personalized user experience. Read all about it in today’s press release.
by Morgan Tocker | Nov 16, 2009 | Insight for Developers, MySQL
I wrote a post a while back that said why you don’t want to shard. In that post that I tried to explain that hardware advances such as 128G of RAM being so cheap is changing the point at which you need to shard, and that the (often omitted) operational issues...
by kuszmaul | Nov 10, 2009 | MySQL
We just updated our web site and blogs. We hope the update didn’t cause any trouble for people trying to read the blogs or download TokuDB, our MySQL storage engine. In addition to a new look, we now provide pricing as well as easier downloads.
by John.Partridge | Oct 30, 2009 | MySQL
Tokutek is pleased to announce the general availability of TokuDB for MySQL, version 2.2.0. This version offers several improvements: Better multi-core load balancing for concurrent workloads. Faster bulk loading performance. Enhanced diagnostics for easier tuning and...
by Tokutek | Oct 16, 2009 | MySQL
At Tokutek, Rich Prohaska used Gearman to automate our nightly build and test process for TokuDB for MySQL. Rich is busy working on TokuDB, so I’m writing up an overview of the build and test architecture on his behalf. Build and Test Process Rich created a...
by Morgan Tocker | Oct 16, 2009 | MySQL, Percona Events
I wanted to provide an update on two things: Firstly, we have opened registration for InnoDB/XtraDB training in Los Angeles (Nov 18th). The second is that while I am in New York City for training (Oct 29th), I’ll be giving a (free) talk at the MySQL Meetup group...
by Morgan Tocker | Oct 16, 2009 | Insight for DBAs, MySQL
I’ve seen a few people link to an INFORMATION_SCHEMA query to be able to find any indexes that have low cardinality, in an effort to find out what indexes should be removed. This method is flawed – here’s the first reason why: CREATE TABLE `sales`...
by Morgan Tocker | Sep 24, 2009 | MySQL, Percona Events
This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow). I’ll be presenting on a few topics: MySQL Performance Tuning (Conference Session) Quick Wins with Third Party Patches for MySQL (Conference...
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 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 Morgan Tocker | Aug 4, 2009 | Percona Events
Today, we are announcing that we’re ready to offer training for InnoDB and XtraDB in Santa Clara and San Francisco. The course was developed by Morgan Tocker with input from all our team – and covers a lot of the performance problems we run through in...
by Morgan Tocker | Jul 21, 2009 | Insight for DBAs
We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the...
by Vadim Tkachenko | Jul 14, 2009 | Benchmarks
There was small delay in our releases, part of this time we worked on features I mentioned before: – Moving InnoDB tables between servers – Improve InnoDB recovery time and rest time we played with performance trying to align XtraDB performance with MySQL...
by Morgan Tocker | Jul 7, 2009 | Insight for DBAs
It seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I’ve managed to cut down my spiel I give to customers to these two points: DRBD’s aim (assuming replication mode C) is...
by Alexey Kovyrin | Apr 23, 2008 | Benchmarks, Insight for DBAs
In one of his recent posts Vadim already gave some information about possible benefits from using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could be useful for large warehousing tasks. One...
by Peter Zaitsev | Feb 4, 2008 | Insight for DBAs
Finding the largest tables on a MySQL instance is a no brainer in MySQL 5.0+ thanks to Information Schema, but I still wanted to post a little query I use for the purpose so I can easily find it later. Plus it is quite handy in a way it presents information: SELECT...
by Alexey Kovyrin | Jan 24, 2008 | Benchmarks
Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state”, “gender”, “status”, “weapon_type”, etc, etc. Frequently we suggest to...
