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. The concept of HugePages in Linux has existed for many years, first introduced in 2007. In order to understand THP, we should first start with a brief description of Linux HugePages.

article thumbnail

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

Percona

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. This system variable enables control over optimizer behavior. You must understand how to use indexes to make sorting cheaper.

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

Allez, rendez-vous à Paris – An AWS Region is coming to France!

All Things Distributed

Since we opened the first AWS EU Region in Ireland in November 2007, we have seen an acceleration of companies adopting the AWS Cloud. Within the thousands of businesses using AWS in France, we count enterprises such as Schneider Electric, Lafarge and Dassault Systemes as customers as well as CAC40, multinational bank, Societe Generale Group.

AWS 166
article thumbnail

MSMQ is dead

Particular Software

So as a company dedicated to making our customers better at building, maintaining, and running complex software systems, it's basically impossible for us to recommend building a new system using MSMQ. What if you have a current system already running on MSMQ? So what do I need to do? What do you do then? and.NET Standard 2.0,

article thumbnail

COVID-19 Triggered the Turning Point

Tasktop

Understanding previous technological revolutions will focus your digital strategy and help you thrive through the most turbulent economic event of our lifetime. Only 9% of companies flourished after a recession, and the strategies employed by the post-recession winners were surprising. The pandemic affects everyone.

article thumbnail

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

Rigor

When working on a project for the Man Booker Prize in 2007 (now known as the Booker Prize), Howard saw first-hand how a heavy-load day could impact a website. ” From a technology perspective , Howard says that teams should be looking into how to build systems that are more resilient overall. Retrospectives. Lessons learned.

article thumbnail

Is Intel Doomed in the Server CPU Space?

SQL Performance

From 2007 until 2016, Intel was able to successfully execute their Tick-Tock release strategy, where they would introduce a new processor microarchitecture roughly every two years (a Tock release). Now, I am advising people to strongly consider AMD for SQL Server workloads as the AMD EPYC "Rome" processors are released in Q3 of 2019.

Servers 46