by Leif.Walsh | Feb 5, 2013 | MySQL
In Part 1, we showed performance results of some of the work that’s gone in to TokuDB v6.6. In this post, we’ll take a closer look at how this happened, on the engineering side, and how to think about the performance characteristics in the new version....
by Ernie Souhrada | Feb 4, 2013 | Insight for DBAs, MySQL
Recently some of my fellow Perconians and I have noticed a bit of an uptick in customer cases featuring the following error message: SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a...
by Ovais Tariq | Feb 1, 2013 | Insight for DBAs, Insight for Developers, MySQL
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It...
by Peter Zaitsev | Jan 31, 2013 | MySQL, Percona Events
Thank you to everyone who attended Percona MySQL University in Raleigh, N.C. We had a great turnout and a lot of positive feedback! What’s next for Percona MySQL University? Next week we’re going to hold events in Montevideo and Buenos Aires which are...
by Vadim Tkachenko | Jan 31, 2013 | MySQL, Percona Software
With our newest release of Percona XtraDB Cluster, I would like to highlight a very nice ability to recovery a node and bring it back to the cluster with an incremental transfer after a crash. This feature was available even in previous release, but now I want to give...
by Hrvoje Matijakovic | Jan 30, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraDB Cluster on January 30th, 2013. Binaries are available from downloads area or from our software repositories. Bugs fixed: In some cases when node is recovered variable threads_running would become huge. Bug...
by Frederic Descamps | Jan 29, 2013 | Percona Software
Before version 5.5.28 of Percona XtraDB Cluster, the easiest way was to join the cluster using wsrep_urls in [mysqld_safe] section of my.cnf. So with a cluster of 3 nodes like this : node1 = 192.168.1.1 node2 = 192.168.1.2 node3 = 192.168.1.3 we defined the setting...
by Vadim Tkachenko | Jan 29, 2013 | MySQL, Percona Software
We continue to improve Percona XtraBackup, and today I would like to give a preview for one feature which comes in next Percona XtraBackup 2.1 release. This feature is “Compact backups”, and let me explain what it does. As you may know InnoDB PK (Primary...
by Leif.Walsh | Jan 28, 2013 | MySQL
With TokuDB v6.6 out now, I’m excited to present one of my favorite enhancements: concurrency within a single index. Previously, while there could be many SQL transactions in-flight at any given moment, operations inside a single index were fairly serialized. We’ve...
by Peter Zaitsev | Jan 28, 2013 | Insight for DBAs, Insight for Developers, MySQL
At Percona we offer a number of services. One of them, Custom MySQL Server Development, is commonly the most misunderstood and undervalued. There are a lot of ways Percona custom MySQL server development can help your business be more successful with MySQL. Here are...
by Peter Zaitsev | Jan 27, 2013 | Insight for DBAs, Insight for Developers, MySQL
Preparing for my talk for Percona MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to give a feel for how massive work have been done for this release in variety...
by Peter Zaitsev | Jan 24, 2013 | MySQL, Percona Events
Following our Percona MySQL University event in Raleigh,NC Percona MySQL University comes to South America! We’ll have a Full day FREE MySQL Technical Educational events in Montevideo on February 5th, 2013 and Buenos Aires on February 7th. I’m very excited...
by Hrvoje Matijakovic | Jan 23, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.67-14.3 on January 23rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67-14.3 is now the...
by Hrvoje Matijakovic | Jan 23, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.29-29.4 on January 23rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona Server 5.5.29-29.4 is now the...
by Bill Karwin | Jan 23, 2013 | Insight for Developers, MySQL, Percona Events
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I...
by Hrvoje Matijakovic | Jan 23, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.0.5 on January 23rd, 2012. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. New...
by Peter Zaitsev | Jan 23, 2013 | MySQL, Percona Events
We got a great response to our Percona MySQL University event in Raleigh With about a week to go before event we’re around 90% full, so if you plan to attend do not delay your registration until last minute. Also if you have registered before but can’t...
by Tokutek | Jan 22, 2013 | MySQL
TokuDB allows the lab to write to the database while altering it, a boon for larger databases.
by Tokutek | Jan 22, 2013 | MySQL
For us, TokuDB proved to be over 50x faster to add or update data into big tables.
by Tokutek | Jan 22, 2013 | MySQL
University of Montreal Tracks Genomic Data With Tokutek’s TokuDB. Faster insertion rates, improved scalability and agility support lab’s fast growing research database as it grows from 100s of GBs to 1 TB and beyond. Issue addressed: MySQL database used for genomic...
