article thumbnail

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

Percona

This post was originally published in June 2020 and was updated in September 2023. This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. MySQL relies heavily on the availability of hardware resources to perform at its best.

Tuning 52
article thumbnail

The Return of the Frame Pointers

Brendan Gregg

2015-2020: Overhead As part of production rollout I did many performance overhead tests, which I've described publicly before: The overhead of adding frame pointers to everything (libc and Java) was usually less than 1%, with one exception of 10%. The actual overhead depends on your workload. Others have reported around 1% and around 2%.

Java 145
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

The Performance Inequality Gap, 2021

Alex Russell

twitter.com/slightlylate/status/1139684093602349056 455 06:18 AM ยท Feb 28, 2020. A silver lining on this dark cloud is that mobile JavaScript payload growth paused in 2020. Hardware Past As Performance Prologue. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. Mind The Gap. How bad is it?

article thumbnail

AMD EPYC 7002 Series Processors and SQL Server

SQL Performance

It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). The initial reviews and benchmarks for these processors have been very impressive: AMD EPYC 7002 Series Rome Delivers a Knockout. TPC-H Benchmark Results with SQL Server 2017.

Servers 52
article thumbnail

Is Intel Doomed in the Server CPU Space?

SQL Performance

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46
article thumbnail

The Performance Inequality Gap, 2024

Alex Russell

HTML, CSS, images, and fonts can all be parsed and run at near wire speeds on low-end hardware, but JavaScript is at least three times more expensive, byte-for-byte. 1] For these sites, we have to factor in the heavy cost of running JavaScript on the client when describing how much content we can afford. GHz Cortex-A73 and 4x1.7

article thumbnail

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]

Smashing Magazine

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. 2020-01-06T10:30:13+00:00. 2020-01-06T12:35:48+00:00. New metrics landing in Lighthouse v6 in early 2020. Vitaly Friedman. Web performance is a tricky beast, isnโ€™t it? Large view.