Insight for DBAs

A Day in the Life of a Technical Account Manager

technical account manager percona

So, what do you do when you love technology but are ready for a change in the day-to-day activities of a DBA?  One consideration is to become a Technical Account Manager, or TAM for short.  At Percona, a TAM is an account manager who is also technical (the big “T” in TAM).  While everyone’s […]

Read more

Implementing a Database Center of Excellence

Database Center of Excellence

In your organization, who decides what database platform will be utilized for that new application being built?  For many groups, that decision is made by the Development Team while for others, it is the Database Team.  But, which is best equipped to make that decision?  As is usually the case, the answer lies in […]

Read more

Contention in MySQL InnoDB: Useful Info From the Semaphores Section

Contention in MySQL InnoDB

In a high concurrency world, where more and more users->connections->threads are used, contention is a given. But how do we identify the contention point easily?
Different approaches had been discussed previously, like the one using SHOW ENGINE INNODB STATUS command output.
SEMAPHORES
The SEMAPHORES section displays all the metrics related to InnoDB mechanics on waits. This section […]

Read more

The Benefits of Amazon RDS for MySQL

benefits of Amazon RDS

As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon RDS.
Amazon RDS allows you to deploy scalable MySQL servers […]

Read more

Give Love to Your SSDs – Reduce innodb_io_capacity_max!

reduce innodb io capacity max

The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an optimal value for performance? What about the SSD/Flash wear leveling?
Innodb_io_capacity 101
Let’s begin with what […]

Read more