by Leif.Walsh | Feb 13, 2014 | MySQL
Today we are thrilled to announce the availability of the latest release (1.4.0) of TokuMX, our high-performance distribution of MongoDB. For those of you just joining us, TokuMX is an open-source distribution of MongoDB that shares much of the code, and all of the...
by Dave Rosenlund | Feb 13, 2014 | MySQL
As your database begins to scale, sharding can be an effective way to manage your data. In MongoDB, sharding is unique because it retains nearly all of the the full expressiveness of a single server database while scaling out. Register Now! SPEAKER: Leif Walsh,...
by Dave Rosenlund | Jan 21, 2014 | MySQL
You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications? Register Now! SPEAKER: Tim Callaghan, VP of...
by Dave Rosenlund | Jan 8, 2014 | MySQL
MongoDB includes several powerful features like high availability, read scaling, and horizontal scalability in an easy-to-use, schema-free database platform. But, what if you could retain those properties, improve performance, and ensure scalability without...
by Dave Rosenlund | Dec 5, 2013 | MySQL
Get the Most out of Your Database – Understand Indexing SPEAKER: Zardosht Kasheff, Tokutek DATE: Tuesday, December 10th TIME: 1pm ET Register Now! Join Tokutek’s Zardosht Kasheff as he discusses one of the quickest and least expensive ways to increase your...
by Tim.Callaghan | Sep 10, 2013 | MySQL
In talking to existing MongoDB users and TokuMX evaluators, I’ve often heard that the performance of MongoDB is very good as long as your working data set fits in RAM. The story continues that if your working data set grows to be larger than the RAM on your...
by Zardosht.Kasheff | Jul 15, 2013 | MySQL
Before creating a unique index in TokuMX or TokuDB, ask yourself, “does my application really depend on the database enforcing uniqueness of this key?” If the answer is ANYTHING other than yes, do not declare the index to be unique. Why? Because unique indexes may...
by Zardosht.Kasheff | Jul 2, 2013 | MySQL
With our recent release of TokuMX 1.0, we’ve made some bold claims about how fast TokuMX can run MongoDB workloads. In this post, I want to dig into one of the big areas of improvement, write performance and reduced I/O. One of the innovations of TokuMX is that it...
by Peter Zaitsev | Mar 27, 2013 | Benchmarks, MySQL, Percona Live
A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim’s post on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an...
by David Hildebrandt | Mar 15, 2013 | MySQL
Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on...
by Aurimas Mikalauskas | Jan 16, 2013 | MySQL
Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point...
by Ovais Tariq | Oct 12, 2012 | MySQL
Solid State Drive (SSD) have made it big and have made their way not only in desktop computing but also in mission-critical servers. SSDs have proved to be a break-through in IO performance and leave HDD far far behind in terms of Random IO performance. Random IO is...
by Aurimas Mikalauskas | Aug 28, 2012 | Insight for DBAs, Insight for Developers
Spoiler alert: If your boss does not need an elephant, he is definitely NOT going to buy one from you. If he will, he will regret it and eventually you will too. I must appologize to the reader who was expecting to find an advice on selling useless goods to his boss....
by Bill Karwin | Aug 21, 2012 | Insight for Developers, MySQL, Percona Events
Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown. This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM...
by Ovais Tariq | May 31, 2012 | Benchmarks, Insight for DBAs, MySQL
MariaDB 5.3/5.5 has introduced a new join type “Hash Joins” which is an implementation of a Classic Block-based Hash Join Algorithm. In this post we will see what the Hash Join is, how it works and for what types of queries would it be the right choice. I...
by Martin.FarachColton | Jan 19, 2012 | MySQL
TokuDB® v5.2, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB, is now available. This version offers performance enhancements over previous releases, especially for multi-client scale up and point queries, and extends the cases...
by Jay Janssen | Dec 16, 2011 | MySQL
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use...
by Justin Swanhart | Apr 4, 2011 | Insight for Developers, MySQL
“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in the cloud, results...
by Yves Trudeau | Dec 17, 2010 | Insight for DBAs, MySQL
Be careful with my findings, I appear to have compile in debug mode, I am redoing the benchmarks. Updated version here. I recently had to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal, I had...
by Peter Zaitsev | Dec 11, 2010 | Insight for DBAs, MySQL
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First, you need to understand how partitions work internally. Partitions are on the low level are separate table. This...