EmergencyEMERGENCY? Get 24/7 Help Now!

How to calculate the correct size of Percona XtraDB Cluster’s gcache

 | September 8, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support, Percona Software, Percona XtraDB Cluster

When a write query is sent to Percona XtraDB Cluster all the nodes store the writeset on a file called gcache. By default the name of that file is galera.cache and it is stored in the MySQL datadir. This is a very important file, and as usual with the most important variables in MySQL, the […]

Read More

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