by Justin Swanhart | May 11, 2011 | MySQL
Infobright and InnoDB AMI images are now available There are now demonstration AMI images for Shard-Query. Each image comes pre-loaded with the data used in the previous Shard-Query blog post. The data in the each image is split into 20 “shards”. This blog...
by Baron Schwartz | May 10, 2011 | MySQL
We have mostly finalized the Percona Live schedule at this point, and I thought I’d take a few minutes to introduce who’s going to be speaking and what they’ll cover. A brief explanation first: we’ve personally recruited the speakers, which is...
by Peter Zaitsev | May 10, 2011 | MySQL
Few weeks ago I wrote about Innodb Caching with main idea you might need more cache when you think you are because Innodb caches data in pages, not rows, and so the whole page needs to be in memory even if you need only one row from it. I have created the simple...
by Valentine Gostev | May 9, 2011 | MySQL
On 10th May at 9 AM PST I will be giving a webinar about Percona XtraBackup. If you can not attend this time, recorded session will be available soon after webinar. We always want to store our data in safe way, keep it consistent and be prepared for any kinds of...
by Peter Zaitsev | May 9, 2011 | MySQL
I started going over the slides from talks from MySQL Conference and Expo 2011 to pick set of must see presentations and publish the list, but this is not happening due to lack of time. Instead I’m only going to recommend 1 talk, from list of tutorials I had a...
by Baron Schwartz | May 8, 2011 | MySQL
Percona is sponsoring RailsConf again this year, and we’ll be at booth #110 in the expo hall. Use our discount code to save 20% off the ticket price: rc11mysql. We hope to see you there! (Sadly, we didn’t get any sessions accepted this year, so we...
by Martin.FarachColton | May 6, 2011 | MySQL
On April 1st, the Department of Computer Science at Rutgers University, where I am a professor, held an open house. I gave a talk called “Elephants on a Trapeze: Keeping Big Data Agile”. The talk is an introduction to performance issues related to big data...
by Justin Swanhart | May 6, 2011 | MySQL
Shard-Query is an open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar to the divide and conquer approach that Hive takes in combination with...
by Baron Schwartz | May 6, 2011 | MySQL
We’ve given discount coupon codes to all of our Percona Live sponsors, so watch the Twitter tag #perconalive to find discount announcements. Here’s the list of sponsoring organizations: Clustrix Vork Continuent Fusion-io Infobright Pentaho Schooner...
by Baron Schwartz | May 5, 2011 | MySQL
In a recent blog post, I wrote about four fundamental metrics for system performance analysis. These are throughput, residence time, “weighted time” (the sum of all residence times in the observation period — the terminology is mine for lack of a...
by Laurynas Biveinis | May 3, 2011 | MySQL
Part of the InnoDB duties, being an MVCC-implementing storage engine, is to get rid of–purge–the old versions of the records as they become obsolete. In MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving...
by Baron Schwartz | May 3, 2011 | MySQL
We’ve just rented more rooms, and published an additional two tracks of speakers for Percona Live in New York on May 26th. The schedule is here. There is a long queue of speaker submissions we’re finalizing and will be adding to the schedule, to fill the...
by Vadim Tkachenko | May 2, 2011 | MySQL
My previous benchmark on Performance Schema was mainly in memory workload and against single tables. Now after adding multi-tables support to sysbench, it is interesting to see what statistic we can get from workload that produces some disk IO. So let’s run...
by Vadim Tkachenko | May 2, 2011 | MySQL
We see demand on MacOS binaries and decided to prepare binaries you can download and use. The are marked as “experimental”, as we do not have big history of using MacOS in production, so we are looking for your feedback and bug reports. Binaries: Percona...
by Peter Zaitsev | Apr 30, 2011 | MySQL
Just few short hours remain for Early Bird Discount for Percona Live, New York City. This is your last chance to grab the ticket at almost 50% discount, for $129 instead of $259. We have a Great Session Lineup and outstanding networking opportunities !
by Vadim Tkachenko | Apr 29, 2011 | MySQL
We just pushed to sysbench support for workload against multiple tables ( traditionally it used only single table). It is available from launchpad source tree lp:sysbench . This is set of LUA scripts for sysbench 0.5 ( it supports scripting), and it works following...
by Rodrigo Gadea | Apr 28, 2011 | MySQL
Percona Server 5.5.11-20.2 is now available for download, including an experimental build for MacOS. Released on April 28, 2011, it is the current stable release in the the 5.5 series. New Features HandlerSocket, a NoSQL plugin for MySQL, has been updated to the...
by Peter Zaitsev | Apr 28, 2011 | MySQL
Good news for all Percona Software users out there. There are more ways how you can get access to Percona Software. If you’re using Scalr (See also Scalr Project on Google Code) you might be interested in Percona Server roles support Scalr team has announced...
by Baron Schwartz | Apr 27, 2011 | Insight for DBAs, MySQL
There are many ways to slice and aggregate metrics of activity on a system such as MySQL. In the best case, we want to know everything about the system’s activity: we want to know how many things happened, how big they were, and how long they took. We want to...
by Zardosht.Kasheff | Apr 26, 2011 | MySQL
Kudos to Ronald Bradford for creating a new MySQL meetup group in New York city and giving MySQL related talks. The next one is tonight, titled “MySQL Idiosyncrasies That Bite”. Information on it can be found at...
