by Maciej Dobrzanski | Apr 14, 2010 | MySQL, Percona Events
While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here – Improving MySQL-based...
by kuszmaul | Apr 14, 2010 | MySQL
I (Bradley C. Kuszmaul) am presenting two talks at the MySQL User Conference. The first talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD. The bottom line is...
by John.Partridge | Apr 8, 2010 | MySQL
Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index...
by John.Partridge | Apr 7, 2010 | MySQL
At this year’s O’Reilly MySQL Conference we will be showing the latest version of our MySQL storage engine, TokuDB v3.1. Come visit us at Table T1 in the OEM section of the Exhibit Hall. We will be talking about how TokuDB can dramatically improve...
by John.Partridge | Mar 25, 2010 | MySQL
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 3.1. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties. TokuDB v3.1’s new...
by John.Partridge | Mar 5, 2010 | MySQL
Matt Aslett over at The 451 Group has written a Market Development report entitled “Tokutek delivers ACID transaction support with TokuDB version 3.0.” Get the full report and you can try out The 451 Group’s services for free by visiting...
by Morgan Tocker | Jan 22, 2010 | MySQL, Percona Events
February and March as busy months for Community events. There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca. Here are the details: February 4th – I’ll be presenting a talk via MySQL University on Optimizing Queries with...
by Morgan Tocker | Jan 21, 2010 | Insight for Developers, MySQL
A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do...
by Morgan Tocker | Jan 9, 2010 | Insight for Developers, MySQL
There was a discussion on LinkedIn one month ago that caught my eye: Database search by “within x number of miles” radius? Anyone out there created a zipcode database and created a “search within x numer of miles” function ? Thankful for any...
by Rich.Prohaska | Jan 5, 2010 | MySQL
We recently made transactions in TokuDB 3.0 durable. We write table changes into a log file so that in the event of a crash, the table changes up to the last checkpoint can be replayed. Durability requires the log file to be fsync’ed when a transaction is...
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`...
