by Hrvoje Matijakovic | Oct 11, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.27-29.0 on October 11th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-29.0 is now the...
by Vadim Tkachenko | Oct 11, 2012 | MySQL, Percona Events
Call for Papers for the annual Percona Live MySQL Conference and Expo in Santa Clara, are set to close at the end of the day tomorrow Oct. 12th. Please consider submitting one or more speaking proposals. If you are selected to speak you will receive a free full...
by Tokutek | Oct 9, 2012 | MySQL
Recently, our CTO, Martín Farach-Colton had a chance to talk about scaling MySQL and MariaDB with Roberto Zicari of ODBMS. In the article, Martin states “While I believe that one size fits most, claims that RDBMS can no longer keep up with modern workloads come...
by Vadim Tkachenko | Oct 8, 2012 | Benchmarks, MySQL
MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and stability standpoints. I can’t say that my experience was totally flawless, I bumped into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL...
by Peter Zaitsev | Oct 8, 2012 | Insight for DBAs, MySQL
James Day just posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good changes and many defaults are now computed instead of hardcoded. Though some of changes are rather puzzling for me. Lets go over them:...
by Stephane Combaudon | Oct 8, 2012 | Insight for DBAs, MySQL
Choosing a good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the amount of writes in the redo logs. You can find a detailed explanation in this post. To sum up, here are the main points: The redo logs should be large enough to...
by Peter Zaitsev | Oct 7, 2012 | MySQL, Percona Events
Over 200 attendees attended last week’s Percona Live NY event. This year we structured event different than in 2011 with Tutorial Day allowing for in-depth 3 hour presentations for those looking to dive deep into specific topics. We also added an Expo Hall which...
by Bill Karwin | Oct 4, 2012 | Insight for DBAs, Insight for Developers, MySQL
I presented a webinar this week to give an overview of Tools and Techniques for Index Design. Even if you missed the webinar, you can register for it, and you’ll be emailed a link to the recording. I’d like to invite folks who are interested in tools for query...
by Tokutek | Oct 4, 2012 | MySQL
Recently, our CEO, John Partridge had a chance to talk about novel database technologies for “Big Data” with Peter Cohan of Forbes. According to the article, “Fractal Tree indexing is helping organizations analyze big data more efficiently due to its...
by Tokutek | Oct 4, 2012 | MySQL
TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, replication performance and online schema flexibility. Tokutek’s recently launched TokuDB v6.5 delivers all of these features and...
by Tim.Callaghan | Oct 3, 2012 | MySQL
Tokutek sponsored the Percona Live MySQL / New York 2012 Conference which took place this past Monday and Tuesday. I spent much of the time at our booth discussing TokuDB with conference attendees but also managed to attend the following presentations: Understanding...
by Hrvoje Matijakovic | Oct 1, 2012 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.0.3 on October 1st, 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 Bill Karwin | Oct 1, 2012 | Insight for DBAs, Insight for Developers, Percona Events
The proper tools and techniques for designing indexes in MySQL is a broad subject, which causes grief for many developers and database administrators. I’ll present a webinar Tools and Techniques for Index Design on October 3, 2012 at 10:00am Pacific time to give...
by Tim.Callaghan | Sep 29, 2012 | MySQL
TokuDB v6.5 adds the ability to expand certain column types without downtime. Users can now enlarge char, varchar, varbinary, and integer columns with no interruption to insert/update/delete statements on the altered table. Prior to this feature, enlarging one of...
by Peter Zaitsev | Sep 29, 2012 | MySQL, Percona Events
Attending MySQL Connect ? Do not miss our talks! Peter Zaitsev is doing “Optimizing MySQL Configuration” talk at 2:30 PM in Golden Gate 4 room Vadim Tkachenko is talking about “MySQL and Solid-State Drives: Usage and Tuning” at 4:00 PM in the...
by kuszmaul | Sep 27, 2012 | MySQL
Since Fractal Tree indexes turn random writes into sequential writes, it’s easy to see why they offer a big advantage for maintaining indexes on rotating disks. It turns out that that Fractal Tree indexing also offers signficant advantages on SSD. Here are three...
by Miguel Angel Nieto | Sep 27, 2012 | MySQL
In the last blog post I wrote about how to log deadlock errors using Percona Toolkit. Foreign key errors have the same problems. InnoDB only logs the last error in the output of SHOW ENGINE INNODB STATUS, so we need another similar tool in order to have historical...
by Brian Fraser | Sep 26, 2012 | MySQL, Percona Events, Percona Software
The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.4. This is the fourth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools. The complete list of...
by Martin.FarachColton | Sep 25, 2012 | MySQL
We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers optimization for Flash as well as more hot schema change operations for improved agility. We’ll be posting more...
by Tokutek | Sep 25, 2012 | MySQL
/products/
