article thumbnail

A Tutorial on MongoDB Sharding With Best Practices & When To Enable It

Percona

This blog was originally published in October 2017 and was updated in September 2023. Vertical scaling is also often discussed, which involves increasing the resources of a single server, which can have limitations in hardware capabilities and become costly as demands grow. An example is running MongoDB on Mesos.

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. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source. But I'm not completely sure.

Speed 126
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 Ultimate Guide to MySQL Partitions

Percona

This blog was originally published in July 2017 and was updated in August 2023. This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. It’s a pretty common question around here, so let’s see what we can do about that.

article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

Also, in general terms, a high availability PostgreSQL solution must cover four key areas: Infrastructure: This is the physical or virtual hardware database systems rely on to run. Can you afford the necessary hardware, software, and operational costs of maintaining a PostgreSQL HA solution? there cannot be high availability.

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. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source. But I'm not completely sure.

Speed 40
article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. Oracle support for hardware and software packages is typically available at 22% of their licensing fees. So Which Is Best? Comparison Overview.

article thumbnail

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

Smashing Magazine

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). From Fast By Default: Modern Loading Best Practices by Addy Osmani (Slides 18, 19).