Quick installation guide for Percona Cloud Tools for MySQL

Feb 03, 2014 | Insight for DBAs, MySQL, Percona Software

Here in Percona Support, we’re receiving several requests per day for help with Percona Cloud Tools installation steps. So I decided to prepare a step-by-step example of the installation process with some comments based on experience.  Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses. After a […]

How to recover an orphaned .ibd file with MySQL 5.6

Nov 05, 2013 | Insight for DBAs, MySQL

A few years ago Yves Trudeau and Aleksandr Kuzminsky wrote posts about different ways for recovering orphaned .ibd files: Connecting orphaned .ibd files A recovery trivia or how to recover from a lost ibdata1 file Today I want to show you how to do that in a more easy and quick way. In my example, […]

The power of MySQL GROUP_CONCAT

Oct 22, 2013 | Insight for DBAs, MySQL

In the very early days of Percona, Vadim wrote very nice post about MySQL GROUP_CONCAT (GROUP_CONCAT). But I want to show you a bit more about it. When is MySQL GROUP_CONCAT useful? Usually while working with Support customers I recommend it when you have aggregation of many-to-many info. It makes the view simpler and more beautiful and […]

tpcc-mysql: Simple usage steps and how to build graphs with gnuplot

Jul 01, 2013 | Benchmarks, Percona Software

Lots of times we could see different benchmarks performed by tpcc-mysql. So today I want to tell you about how to use tpcc-mysql and how to build graphs with gnuplot in a few easy steps. As an example I’ll compare Percona Server 5.5 (latest version: 5.5.31) performance by changing InnoDB buffer pool size: innodb_buffer_pool_size = […]

Presentations Announcement: 2010 O’Reilly MySQL Conference & Expo

Apr 29, 2010 | Percona Events

The Percona team participated at this year’s O’Reilly MySQL Conference & Expo held April 12-15, 2010 in Santa Clara, California. We gave a lot of talks on…

Author: Peter Zaitsev, Justin Swanhart

MySQL Graphing and Trending with Cacti

Author: Baron Schwartz

Percona‘s Performance and Feature Enhancements to MySQL and InnoDB

Author: Bill Schuler, Baron Schwartz…a Bottleneck

Author: Morgan Tocker

XtraBackup Hot Backups and More

Author: Vadim Tkachenko, Morgan Tocker

You can also read more about this conference on Percona site.