SQL Performance

JULY 16, 2019

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. Despite all of this, Intel is not going to lose their entire server processor business any time soon.

Servers 46

Servers Hardware Architecture Retail 46

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 69

Best Practices Traffic Database Servers 69

Percona

JULY 7, 2023

This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers.

Availability 80

Availability Open Source Architecture Database 80

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. html [unroll the loop]: /blog/2014-04-26/the-noploop-cpu-benchmark.html 30.14% in the middle of the flame graph.

Speed 126

Speed Java AWS Virtualization 126

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers.

Servers 52

Servers Database Availability Traffic 52

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, With faster disks (i.e. MySQL on ec2.

Cache 45

Cache C++ AWS Airlines 45

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. Check out this blog to learn how to avoid disaster!

Strategy 40

Strategy Storage Database Best Practices 40

Rigor

MARCH 20, 2018

I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. I wrote a blog in 2016 that discussed the need for businesses to flip the traditional monitoring investment pyramid on its head.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. html [unroll the loop]: /blog/2014-04-26/the-noploop-cpu-benchmark.html [unused]: [link] [unused2]: [link]

Speed 40

Speed Java AWS Virtualization 40

ACM Sigarch

FEBRUARY 23, 2018

Richard Thaler won the 2017 Nobel prize in Economics for his work on Behavioral Economics. Hardware engineers design and implement solutions in RTL, while software engineers attempt to solve the problem either at the OS or application level. We believed existing hardware and OS protocols protected the processor.

Architecture 47

Architecture Cache Hardware Virtualization 47