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? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52
article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

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

The Speed of Time

Brendan Gregg

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? Theory (A) is most likely based on the frame widths in the flame graph. But I'm not completely sure.

Speed 126
article thumbnail

InnoDB Performance Optimization Basics

Percona

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. If you see concurrency issues, you can tune this variable. have been released since then with some major changes. I hope this helps!

article thumbnail

Bringing AV1 Streaming to Netflix Members’ TVs

The Netflix TechBlog

AV1 playback on TV platforms relies on hardware solutions, which generally take longer to be deployed. Throughout 2020 the industry made impressive progress on AV1 hardware solutions. The Encoding Technologies team took a first stab at this problem by fine-tuning the encoding recipe. Stay tuned!

Media 246
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. You need to set a value of vm.dirty_background_bytes depending on your disk speed. There are no “good” values for these two parameters since both depend on the hardware.

Tuning 54
article thumbnail

Full visibility into your serverless applications with AI-powered Azure Functions monitoring (GA)

Dynatrace

As companies strive to innovate and deliver faster, modern software architecture is evolving at near the speed of light. With Azure Functions, engineers don’t have to worry about provisioning and maintaining underlying hardware; they simply upload their code, and it’s up and running seconds later. So stay tuned! Dynatrace news.