Tag - insight for DBAs

The Evolution of the DBA Role

evolution of the DBA role

As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is the evolution of the DBA role.  With the rise of the cloud, DBAs seem to be spending less time doing traditional DBA roles of performance tuning, configuring backups, and so on.  Instead, DBAs are […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Three)

MySQL high traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here.  
13. Configure MySQL Server Properly
Complexity:Medium
Potential Impact: High 
A poorly configured MySQL Server can cause severe issues, especially under high load during a traffic […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Two)

MySQL High Traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here.
7. Get More Memory
Complexity: Low
Potential Impact: High
If your data does not fit into memory well, your MySQL performance is likely to be […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)

remove MySQL traffic bottlenecks

This is a three-part blog series. Part two is located here, and part three can be found here.
There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal with […]

Read more

Tips for MySQL 5.7 Database Tuning and Performance

MySQL 5.7 Database Tuning

While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical […]

Read more