article thumbnail

InnoDB Performance Optimization Basics

Percona

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? Experiencing database performance issues?

Tuning 52
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

RedisĀ® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. You might already use ScaleGrid hosting for Redis hosting to power your performance-sensitive applications.

Metrics 130
article thumbnail

MySQL Key Performance Indicators (KPI) With PMM

Percona

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

article thumbnail

The Return of the Frame Pointers

Brendan Gregg

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway. The actual overhead depends on your workload.

Java 145
article thumbnail

Use Distributed Caching to Accelerate Online Web Sites

ScaleOut Software

The Solution: Distributed Caching. A widely used technology called distributed caching meets this need by storing frequently accessed data in memory on a server farm instead of within a database. Itā€™s not enough simply to lash together a set of servers hosting a collection of in-memory caches.

Cache 52
article thumbnail

Use Distributed Caching to Accelerate Online Web Sites

ScaleOut Software

The Solution: Distributed Caching. A widely used technology called distributed caching meets this need by storing frequently accessed data in memory on a server farm instead of within a database. Itā€™s not enough simply to lash together a set of servers hosting a collection of in-memory caches.

Cache 52