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 Peter Zaitsev | Nov 16, 2009 | Benchmarks
Couple of months ago there was a post by FreshBooks on getting great performance improvements by lowering table_cache variable. So I decided to investigate what is really happening here. The “common sense” approach to tuning caches is to get them as large...
by Morgan Tocker | Nov 16, 2009 | MySQL, Percona Events
A final update on training for this year – registration for InnoDB/XtraDB training in Chicago (8th December) and Atlanta (10th December) are now open. While in Atlanta I’ll be giving a talk at the Atlanta PHP User Group on Optimizing MySQL Performance...
by Morgan Tocker | Nov 16, 2009 | Insight for DBAs, MySQL
I forwarded on a list of questions about PBXT to Paul McCullagh today. While Paul’s busy answering them, I’d like to announce that Robert Dempsey (InfiniDB storage engine) and Bradley C. Kuszmaul (TokuDB storage engine) have also accepted an interview....
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 Yves Trudeau | Nov 15, 2009 | Insight for Developers, MySQL
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, a customer asked an example on how to perform a simple scan. Remembering that some examples are within the NDB source tree, under ./storage/ndb/ndbapi-examples/ and I...
by Yves Trudeau | Nov 13, 2009 | Insight for DBAs, MySQL
In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL,...
by Morgan Tocker | Nov 12, 2009 | Insight for Developers, MySQL
In the next week, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any questions for Paul, please post them here by Monday 16th November. Note: The idea for this interview was inspired by a previous interview with...
by Matt Yonkovit | Nov 12, 2009 | Benchmarks, Cloud, MySQL
This is part 3 of my Tyrant extra’s, part 1 focused on durability, part 2 focused on the perceived performance wall. #3. Tokyo Cabinet Can have only a single writer thread, bottlenecking performance When writing an application using Tokyo Cabinet only one...
by Matt Yonkovit | Nov 11, 2009 | Benchmarks, Cloud, MySQL
Continuing my look at Tokyo Tyrant/Cabinet and addressing some of the concerns I have seen people have brought up this is post #2. #2. As your data grows does Tokyo Cabinet slow down? Yes your performance can degrade. One obvious performance decrease with a larger...
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 Matt Yonkovit | Nov 10, 2009 | Benchmarks, Cloud, MySQL
by Vadim Tkachenko | Nov 5, 2009 | Benchmarks, MySQL
This is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries in InfiniDB: early alpha Let me explain the reason of choosing these engines. After initial three posts I am often asked...
by Morgan Tocker | Nov 5, 2009 | MySQL, Percona Events
We’ve been busy expanding our training curriculum to include training for developers building applications with MySQL. We have reached the point where we’re ready for a pilot teach – and it brings me great pleasure to announce that we’re...
by Vadim Tkachenko | Nov 5, 2009 | Insight for DBAs, MySQL
One problem made me puzzled for couple hours, but it was really interesting to figure out what’s going on. So let me introduce problem at first. The table is CREATE TABLE `c` ( `tracker_id` int(10) unsigned NOT NULL, `username` char(20) character set latin1...
by Vadim Tkachenko | Nov 2, 2009 | Benchmarks, MySQL
As Calpont announced availability of InfiniDB I surely couldn’t miss a chance to compare it with previously tested databases in the same environment. See my previous posts on this topic: Analyzing air traffic performance with InfoBright and MonetDB Air traffic...
by Morgan Tocker | Nov 1, 2009 | MySQL, Percona Events
A recent photo from Highload.ru I said in my last post, that we’re interested in speaking at MySQL meetups, and I’m happy to say that the Los Angeles MySQL Meetup has taken us up on the offer. On November 18th, I’ll be giving an introductory talk on...
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 Peter Zaitsev | Oct 30, 2009 | Percona Events
MariaDB project kept development going in the repository only not providing any binary releases since April, so release was well over due and it is here now. If you’re wondering how this release of MariaDB is different from MySQL you should read this...
