Percona

MAY 1, 2023

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness.

Tuning 52

Tuning Efficiency Database Performance 52

The Morning Paper

FEBRUARY 18, 2020

Here are the three big directional bets that align with the three main areas cited by the authors: We will train in the cloud , where its possible to take advantage of managed infrastructure well suited to large amounts of data, spiky resource usage, and access to the latest hardware.

Government 95

Government Software Engineering Storage Database 95

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. There is an issue with this, which causes the OS to swap even with memory available.

Best Practices 52

Best Practices Design Tuning Database 52

Percona

AUGUST 30, 2023

In general terms, here are potential trouble spots: Hardware failure: Manufacturing defects, wear and tear, physical damage, and other factors can cause hardware to fail. heat) can damage hardware components and prompt data loss. Human mistakes: Incorrect configuration is an all-too-common cause of hardware and software failure.

Database 87

Database Hardware Open Source Strategy 87

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it. How does high availability work?

Availability 107

Availability Database Open Source Hardware 107

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements. there cannot be high availability.

Availability 83

Availability Open Source Architecture Database 83

Dynatrace

AUGUST 11, 2022

Cloud providers then manage physical hardware, virtual machines, and web server software management. Infrastructure as a service (IaaS) handles compute, storage, and network resources. Increased availability. FaaS drills down even deeper to scale specific aspects of storage, compute, or other services.

Development 251

Development Serverless Best Practices Lambda 251

Percona

SEPTEMBER 1, 2023

To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. Sharding is a preferred approach for database systems facing substantial growth and needing high availability.

Best Practices 71

Best Practices Traffic Database Servers 71

Dynatrace

NOVEMBER 11, 2020

The same default deployment approach applies to all future updates, too—the experience can best be described as “fully SaaSified.” Easier rollout thanks to log storage best practices. Easier rollout thanks to log storage best practices. What does this mean for existing installations?

Best Practices 197

Best Practices Storage Java Benchmarking 197

All Things Distributed

APRIL 5, 2012

In addition to using Edmodo to engage students in classroom activities, teachers all over the world build profile pages on Edmodo, which they use to discover and share content, meet and stay in contact with other educators, and best practices and top resources. Jack, how did this idea come about?

Innovation 146

Innovation AWS Education Network 146

Abhishek Tiwari

JULY 12, 2018

Data Pipeline A data pipeline is a software that ingests data from multiple sources, transforms it and finally makes it available to internal or external products. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Evaluating your hardware requirements is another vital aspect of resource allocation.

Open Source 91

Open Source Database Hardware Strategy 91

Dynatrace

DECEMBER 8, 2021

Let’s explore this concept as we look at the best practices and solutions you should keep in mind to overcome the wall and keep up with today’s fast-paced and intricate cloud landscape. Another aspect of microservices is how the service itself relates to the underlying hardware.

Cloud 226

Cloud Serverless Hardware Operating System 226

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level.

Best Practices 40

Best Practices Scalability Performance C++ 40

Smashing Magazine

JANUARY 15, 2019

how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website. An obvious metric here is CPU usage, but memory usage and other forms of data storage also play their part. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

AUGUST 5, 2023

Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance. You want to ensure that table lookups go to the correct partition or group of partitions.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. It provides redundancy and data availability for your data. Replication provides redundancy, and having multiple copies of the same data increases data availability. MongoDB is popular with developers as it is easy to get started with.

Database 79

Database Servers Storage Strategy 79

SQL Server According to Bob

JANUARY 11, 2020

​​ The storage ​​ space that is required ​​ for the sparse file is only that of the actual bytes written to the file and not the ​​ maximum ​​ file ​​ size.

Servers 40

Servers Cache Database Media 40

Scalegrid

JULY 13, 2020

Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services. Not available. Not available. Not available. See how open source PostgreSQL Community version costs compare to Oracle Standard Edition and Oracle Enterprise Edition. Compare Functionality. Compare Ease of Use. Total Cost. $0.

Open Source 244

Open Source Tuning C++ Database 244

Smashing Magazine

JANUARY 11, 2021

Usually, the most specific and relevant ones are: Time to Interactive (TTI) The point at which layout has stabilized , key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Large preview ). Watch out for the Webpack Roadmap 2021.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

Usually, the most specific and relevant ones are: Time to Interactive (TTI) The point at which layout has stabilized, key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Getting started with Webpack can be tough though.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

Time to Interactive (TTI) The point at which layout has stabilized, key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 104

Performance Cache Metrics Network 104