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 what most of the database administrators […]Read more
Although Percona Toolkit 2.1.4 was recently released, we soon after found and fixed a couple of bugs concerning how pt-table-checksum works with Percona XtraDB Cluster:
pt-table-checksum 2.1.4 doesn’t detect diffs on Percona XtraDB Cluster nodes
pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
There was also a bug affecting pt-table-sync –version-check, and the version check […]Read more
The core technology behind Tokutek is based on the academic research by our founders: Michael Bender, Bradley Kuszmaul and Martin Farach-Colton. They are all still in academia, in addition to their work at Tokutek.
Back in March, the White House kicked off a new Initiative for Big Data. Last week, the National Science Foundation announced […]
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 current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]
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 conference pass valued at over […]Read more
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 in from all directions. When people talk about performance of […]
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 5.6.7-rc crashed under tpcc-mysql workload
But at the end, is not this why RC […]Read more
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:
back_log = 50 + ( max_connections / […]
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 store at most an […]Read more
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 allowed a lot of MySQL Ecosystem participant to […]Read more