EmergencyEMERGENCY? Get 24/7 Help Now!

Using sysbench 0.5 for performing MySQL benchmarks

 | September 2, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, OpenStack, Percona MySQL Consulting, Percona MySQL Support

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including: fileio – File I/O test cpu – CPU performance test memory – […]

Read More

Galera data on Percona Cloud Tools (and other MySQL monitoring tools)

 | August 29, 2014 |  Posted In: MySQL, Percona Cloud Tools, Percona MySQL Support, Percona XtraDB Cluster, XtraDB Cluster

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and […]

Read More

mysqld_multi: How to run multiple instances of MySQL

 | August 26, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support, Percona Server, Percona XtraBackup

The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona Support team receives a request from a customer to assist in the configuration of […]

Read More

When (and how) to move an InnoDB table outside the shared tablespace

 | August 22, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona MySQL Support, Percona Server, TokuDB

In my last post, “A closer look at the MySQL ibdata1 disk space issue and big tables,” I looked at the growing ibdata1 problem under the perspective of having big tables residing inside the so-called shared tablespace. In the particular case that motivated that post, we had a customer running out of disk space in his […]

Read More

A closer look at the MySQL ibdata1 disk space issue and big tables

 | August 21, 2014 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, Percona MySQL Support

A recurring and very common customer issue seen here at the Percona Support team involves how to make the ibdata1 file “shrink” within MySQL. I can only imagine there’s a degree of regret by some of the InnoDB architects on their design decisions regarding disk-space management by the shared tablespace* because this has been a big […]

Read More

What I learned while migrating a customer MySQL installation to Amazon RDS

 | July 28, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Consulting, Percona MySQL Support

Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons: You can scale your CPU, IOPS, and storage space separately by using Amazon […]

Read More

Encrypted and incremental MySQL backups with Percona XtraBackup

 | April 24, 2014 |  Posted In: MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona Software, Percona XtraBackup

We’ve recently received a number of questions on how to implement incremental MySQL backups alongside encryption with Percona XtraBackup. Some users thought it was not initially possible because with the default --encrypt options with XtraBackup, all files will be encrypted, but alas, that is not the case. This is where the option --extra-lsn-dir becomes useful, […]

Read More

Monitoring MySQL with MONyog

 | March 12, 2014 |  Posted In: Events and Announcements, MySQL, Percona MySQL Support, Percona Software

Monitoring MySQL and effectively managing it can be challenging. Identifying issues before they grow into performance problems that impact end users can be crucial. Knowing which tools to use, which key metrics to monitor, and how to resolve issues can be enormously important. When considering these facts, we at Percona decided to take steps to […]

Read More

How to monitor ALTER TABLE progress in MySQL

 | February 26, 2014 |  Posted In: MySQL, Percona MySQL Support, Percona Toolkit

While working on a recent support issue as a Percona Support Engineer,  I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the table in a running production environment especially for large tables (with millions records). Because it will rebuild and lock the table […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.