by Fernando Laudares Camargos | Jun 23, 2014 | Insight for DBAs, MySQL, Percona Software
During last April’s Percona Live MySQL Conference and Expo, TokuDB celebrated it’s first full-year as an open source storage engine. I still remember reading the official announcement and the expectations it created one year ago. The premises were very...
by Zardosht.Kasheff | Jun 13, 2014 | MySQL
In my last post, I gave a technical explanation of the performance characteristics of partitioned collections in TokuMX 1.5 (which is right around the corner) and partitioned tables in relational databases. Given those performance characteristics, in this post, I will...
by Hrvoje Matijakovic | Jun 11, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.17-66.0 on June 11, 2014. Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.17, including all the bug fixes in it, Percona Server 5.6.17-66.0 is the current...
by Zardosht.Kasheff | Jun 10, 2014 | MySQL
In TokuMX 1.5 that is right around the corner, the big feature will be partitioned collections. This feature is similar to partitioned tables in Oracle, MySQL, SQL Server, and Postgres. A question many have is “why should I use partitioned tables?” In short, it’s...
by Dave Rosenlund | May 9, 2014 | MySQL
Background: If you did not read my first blog post about why I am sharing my thoughts on the benchmarks published by Mark Callaghan on Small Datum you may want to skim through it now for a little context: “Thoughts on Small Datum – Part 1”...
by Dave Rosenlund | May 1, 2014 | MySQL
The title of this post should really be, “Maybe He Should Try Taking a Walk in Your Shoes.” The he I’m referring to is economist and author, Tim Harford. The you is the people who use NewSQL and NoSQL approaches to mine big data with database platforms...
by Dave Rosenlund | Apr 29, 2014 | MySQL
If you did not read my first blog post about Mark Callaghan’s (@markcallaghan) benchmarks as documented in his blog, Small Datum, you may want to skim through it now for a little context. ——————- On March 11th, Mark, a former Google and now Facebook database guru,...
by Jon Tobin | Apr 21, 2014 | MySQL
Three weeks ago I had the privilege of attending my first Percona Live MySQL conference, which was incredible! In particular, there were two things that I found impressive about the conference. First, was the amount of knowledge sharing and support that MySQL users...
by Dave Rosenlund | Apr 18, 2014 | MySQL
A little background… When I ventured into sales and marketing (I’m an engineer by education) I learned I would often have to interpret and simply summarize the business value that is sometimes hidden in benchmarks. Simply put, the people who approve the purchase...
by Joel.Epstein | Apr 10, 2014 | MySQL
During a typical release cycle for TokuDB at Tokutek, we spend time qualifying and hardening the product using numerous tools. For example, we run stress and unit tests directly on the Fractal Tree indexes, MySQL Test Runner (MTR) tests on the storage engine as well...
by Rich.Prohaska | Apr 8, 2014 | MySQL
The ‘uint3korr’ function inside of the mysqld server extracts a 3 byte unsigned integer from a memory buffer. One use is for ‘mediumint’ columns which encode their value in 3 bytes. MySQL 5.6 and MariaDB 10.0 claims to have optimized this...
by Tim.Callaghan | Apr 4, 2014 | MySQL
The MySQL community continues to amaze me, everyone is friendly and always willing to answer questions and help others. It’s always nice to meet people in-person that I’ve met virtually in the last 12 months. Percona Live 2014 MySQL Conference and Expo in Santa Clara...
by Rich.Prohaska | Apr 3, 2014 | MySQL
A TokuDB MySQL test run with valgrind reported an uninitialized data error when writing into the TokuDB recovery log. ==1032== Syscall param write(buf) points to uninitialised byte(s) ==1032== at 0x3EFA60E4ED: ??? (in /lib64/libpthread-2.12.so) ==1032== by 0xB894038:...
by Rich.Prohaska | Mar 27, 2014 | MySQL
We have seen TokuDB lock escalation stall the execution of SQL operations for tens of seconds. To address this problem, we changed the lock escalation algorithm used by TokuDB and TokuMX so that the cost of lock escalation only affects big transactions. We also...
by Zardosht.Kasheff | Mar 18, 2014 | MySQL
At an extremely high level, replication in MongoDB and MySQL are similar. Both databases have exactly one machine, the primary (or master), that accepts writes from clients. With a single transaction (or atomic operation, in MongoDB’s case), the tables and oplog (or...
by Vadim Tkachenko | Mar 18, 2014 | MySQL, Percona Software
Two weeks ago we released
by Rich.Prohaska | Mar 17, 2014 | MySQL
What good is a zero-length character column in a MySQL table? A zero-length character column has type of ‘char(0)’. If it is nullable, then it can at least store one bit. If it is not nullable, then the value for this column in all rows is a null string....
by Dave Rosenlund | Mar 13, 2014 | MySQL
You may think that you have to buy, install, and get up to speed on a new database if you want to work with large amounts of data, but you can do more than you think with the MySQL you already have. Register Now! SPEAKER: Jon Tobin, Tokutek DATE: Thursday, March 20th...
by Tim.Callaghan | Mar 12, 2014 | MySQL
Yesterday we released TokuDB v7.1.5, which includes the following important features and fixes: Upgraded MySQL and MariaDB to version 5.5.36. Six months of performance improvements to our underlying Fractal Tree indexing. Fixes for bugs, stalls, and behavioral issues...
by Tim.Callaghan | Mar 5, 2014 | MySQL
I’ve been a little behind in recent blogging efforts, and realized that in less than a month we’ll be back at Percona Live: MySQL Conference and Expo 2014, aka PLMCE. Last year’s PLMCE was my first, as well as the event where Tokutek announced the...
