by Ryan Lowe | Dec 30, 2010 | MySQL, Percona Events
Percona is pleased to officially (and belatedly) welcome Sasha Pachev to our team of consultants. Before joining Percona, Sasha worked as an independent MySQL consultant. Sasha was the original implementer and maintainer of MySQL replication from 3.23 to 4.02. He is...
by Fred Linhoss | Dec 29, 2010 | MySQL, Percona Software
Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version. Functionality Added or Changed  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added: Precompiled UDFs for Maatkit (FNV and...
by Morgan Tocker | Dec 25, 2010 | Insight for DBAs, MySQL
Inspired by Baron’s earlier post, here is one I hear quite frequently – “If you enable innodb_file_per_table, each table is it’s own .ibd file. You can then relocate the heavy hit tables to a different location and create symlinks to the...
by Vadim Tkachenko | Dec 22, 2010 | Insight for DBAs, MySQL
In my previous posts I highlighted that one of improvements in Percona Server is support of innodb_log_file_size > 4G. This test was done using Percona Server 5.5.7, but the same performance expected for InnoDB-plugin and MySQL 5.5. The valid question how long is...
by Vadim Tkachenko | Dec 21, 2010 | Benchmarks, Hardware and Storage, MySQL
This is to follow up on my previous post and show the results for MySQL 5.5.8 and Percona Server on the fastest hardware I have in our lab:Â a Cisco UCS C250 server with 384GB of RAM, powered by a Virident tachIOn 400GB SLC card. To see different I/O patterns, I used...
by Vadim Tkachenko | Dec 20, 2010 | Benchmarks, MySQL
As we can see, MySQL 5.5.8 comes with great improvements and scalability fixes. Adding up all the new features, you have a great release. However, there is one area I want to touch on in this post. At Percona, we consider it important not only to have the best...
by Yves Trudeau | Dec 20, 2010 | Insight for DBAs, MySQL
Last Friday I published results of DBT2 performance while varying the number of idle connections here, but I had compiled MySQL with the debugging code enabled. That completely screw up my results, be aware… debug options have a huge performance impact. So, I...
by Yves Trudeau | Dec 17, 2010 | Insight for DBAs, MySQL
Be careful with my findings, I appear to have compile in debug mode, I am redoing the benchmarks. Updated version here. I recently had to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal, I had...
by Fred Linhoss | Dec 16, 2010 | MySQL, Percona Software
Percona Server version 5.1.53-11.7 is now available for download. The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.53-11.7 is now based on MySQL...
by Vadim Tkachenko | Dec 14, 2010 | Cloud, MySQL, Percona Software
Just yesterday we released Percona Server 5.1.52-12.3 which includes HandlerSocket. This is third-party plugin, developed by Akira Higuci, DeNA Co., Ltd and explained in Yoshinori Matsunobu’s blog post. What is so special about it: It provides NOSQL-like...
by Vadim Tkachenko | Dec 13, 2010 | Benchmarks, Hardware and Storage
This is crosspost from https://www.percona.com/blog/. Disclaimer: The benchmarks were done as part of our consulting practice, but this post is totally independent and fully reflects our opinion. One of the biggest problems with solid state drives is that write...
by Fred Linhoss | Dec 13, 2010 | MySQL, Percona Software
Percona Server version 5.1.52-12.3 is now available for download. The main purpose of this release is to update the current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features...
by Fred Linhoss | Dec 13, 2010 | MySQL, Percona Software
Percona XtraBackup 1.5-Beta is now available for download. This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup. This is a beta release. Functionality Added or Changed Support for MySQL 5.5...
by Peter Zaitsev | Dec 11, 2010 | Insight for DBAs, MySQL
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First, you need to understand how partitions work internally. Partitions are on the low level are separate table. This...
by John.Partridge | Dec 9, 2010 | MySQL
Tokutek is pleased to announce support for MariaDB for the first time with TokuDB v4.1.1 for MariaDB v5.1.47. Our customers are choosing MariaDB more and more frequently for their most demanding database applications. We are delighted to help raise MariaDB performance...
by Peter Zaitsev | Dec 9, 2010 | Insight for DBAs, MySQL
Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not – it may be because the tables and indexes they are accessing are not in cache, for example being washed away by...
by Peter Zaitsev | Dec 9, 2010 | Insight for DBAs, MySQL
Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get a better feel for the primary key and index pages, and so use less space, it’s just that MySQL OPTIMIZE TABLE might not be the...
by Baron Schwartz | Dec 9, 2010 | MySQL, Percona Software
XtraBackup works great for backing MySQL up to an NFS volume, but there is a gotcha that you need to be aware of. This applies to anything you do with NFS, not just XtraBackup. The gotcha is that NFS uses client-side caching to reduce overhead of sending data across...
by Peter Zaitsev | Dec 8, 2010 | Insight for DBAs, MySQL
One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for capacity planning and simply watching the growth of space used on partition is not very helpful. Now as...
by Peter Zaitsev | Dec 7, 2010 | MySQL, Percona Events
I’m going to be in NY next week and as part of the meeting I agreed to speak on New York MySQL Meetup. I’m going to speak about Scaling MySQL driven applications by us of caching, replication, sharding and other technologies. Hope to see you...
