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

The Surprising Effectiveness of Non-Overlapping, Sensitivity-Based Performance Models

John McCalpin

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). This data is from the 2007 presentation.

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

DevOps automation: From event-driven automation to answer-driven automation [with causal AI]

Dynatrace

The evolution of DevOps automation Since the concept of DevOps emerged around 2007 and 2008 in response to pain points with Agile development, DevOps automation has been continuously evolving. For instance, in the case of poor performance, you can seamlessly toggle a feature flag and mitigate any detrimental effects.

DevOps 224
article thumbnail

Transparent Huge Pages Refresher

Percona

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages?

article thumbnail

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

All Things Distributed

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. Performant – The service would need to be able to maintain consistent performance in the face of diverse customer workloads.

Internet 130
article thumbnail

The Best In Performance Interview Series – Episode #4: Recap with Rich Howard

Rigor

Reading time 8 min Rigor’s “The Best in Performance” interview series offers the chance to listen in on conversations with web performance industry experts, thought leaders, and technologists as they discuss current trends, challenges, and lessons that impact the performance and APM space today. Retrospectives.

article thumbnail

Revamp MySQL Query Optimization and Overcome Slowness of ORDER BY with LIMIT Queries

Percona

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. However, for 16 years since 2007, the MySQL query optimizer has had a “bug” that not only makes LIMIT 1 slower than LIMIT 10 but can also make the former a table scan, which tends to cause problems.