by Peter Zaitsev | Sep 11, 2012 | Insight for DBAs, MySQL
One question I often get is how one can find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause the large portion of the load on the system but how do we know whenever there is any...
by Miguel Angel Nieto | Sep 11, 2012 | MySQL
MySQL Replication is useful and easy to setup. It is used for very different purposes. For example: split read and writes run data mining or reporting processes on them disaster recovery Is important to mention that a replication server is not a backup by itself. A...
by Vadim Tkachenko | Sep 10, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
Recently there has been a storm of bugs and problems in all variants of MySQL including MySQL, Percona Server, and MariaDB. To list a few: MySQL 5.5.25 UPDATE on InnoDB table enters recursion, consumes all disk space All MariaDB and MySQL versions up to 5.1.61,...
by Vadim Tkachenko | Sep 10, 2012 | Benchmarks, MySQL
This is to continue my previous experiments on adaptive flushing in MySQL 5.6.6. Now I am running Ubuntu 12.04, which seems to provide a better throughput than previous system (CentOS 6.3), it also changes the profile of results. So, as previous I run tpcc-mysql...
by Roel Van de Paar | Sep 9, 2012 | Insight for DBAs, Insight for Developers, MySQL
by kuszmaul | Sep 7, 2012 | MySQL
Next week Michael and I (Bradley) will be travelling to Silicon Valley to present a tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference. The tutorial, which is 4 hours on Monday afternoon, aims to cover the following topics (but...
by Vadim Tkachenko | Sep 7, 2012 | Benchmarks, Hardware and Storage, MySQL, Percona Software
I continue my benchmarks of Intel SSD 910, the raw IO results are available in my previous experiment. Now I want to test this card under MySQL workload to see if the card is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under...
by Hrvoje Matijakovic | Sep 7, 2012 | MySQL
Percona is glad to announce the release of Percona XtraDB Cluster on September 7th, 2012. Binaries are available from downloads area or from our software repositories. Features: Percona XtraDB Cluster supports tunable buffer size for fast index creation in InnoDB....
by Peter Zaitsev | Sep 7, 2012 | MySQL, Percona Events
You surely have heard about Percona Live,NY taking place October 1-2 in New York, you however might have been wondering what kind of talks you would see on this event and why would should you attend. The day one of this event is Tutorial day, which is long (half to a...
by Tim.Callaghan | Sep 6, 2012 | MySQL
In my two previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase and a 268x query performance increase. MongoDB’s covered indexes can provide some performance benefits over a regular MongoDB...
by Stephane Combaudon | Sep 5, 2012 | Insight for DBAs, MySQL
While doing a performance audit for a customer a few weeks ago, I tried to improve the response time of their top slow query according to pt-query-digest’s report. This query was run very frequently and had very unstable performance: during the time data was...
by Hrvoje Matijakovic | Sep 4, 2012 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.5.27-28.1 on September 5th, 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-28.1 is now the...
by Jervin Real | Sep 4, 2012 | MySQL
I’ve been helping customers deploy and maintain MySQL (and variants) for the last couple of years and it has always been interesting to hear customer thoughts on how they want their servers installed. It has also been asked many times not only by our support and...
by Vadim Tkachenko | Sep 4, 2012 | Benchmarks, Hardware and Storage, MySQL
Intel came on PCI-e SSD market with their Intel SSD 910 card. With a slogan “The ultimate data center SSD” I assume Intel targets rather a server grade hardware, not consumer level. I’ve got one of this card into our lab. I should say it is very...
by Vadim Tkachenko | Sep 4, 2012 | Benchmarks, MySQL
As you may know, flushing in MySQL is an area of my interest, I wrote about it several times, i.e. https://www.percona.com/blog/2011/09/18/disaster-mysql-5-5-flushing/ https://www.percona.com/blog/2011/03/31/innodb-flushing-a-lot-of-memory-and-slow-disk/...
by Hrvoje Matijakovic | Sep 4, 2012 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.1.65-14.0 on September 4th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.65, including all the bug fixes in it, Percona Server 5.1.65-14.0 is now the...
by Ernie Souhrada | Sep 4, 2012 | Insight for DBAs, Insight for Developers, MySQL
Inspiration for this post is courtesy of a friend and former colleague of mine, Greg Youngblood, who pinged me last week with an interesting MySQL puzzle. He was running Percona Server 5.5.21 with a table structure that looks something like this: CREATE TABLE foo ( id...
by Roman Vynar | Aug 31, 2012 | Insight for DBAs, MySQL
When you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical values for review trend analysis into query_review_history table. But it could be difficult to easily browse those tables without a...
by Tim.Callaghan | Aug 30, 2012 | MySQL
Last week I wrote about our 10x insertion performance increase with MongoDB. We’ve continued our experimental integration of Fractal Tree® Indexes into MongoDB, adding support for clustered indexes. A clustered index stores all non-index fields as the “value” portion...
by Peter Zaitsev | Aug 30, 2012 | MySQL
This month was a busy month in Percona Community Forums with a lot of great questions asked and most answered. It is great to see both independent community and Percona employees participating in discussion. Thank you. Here are some things you would learn from...
