Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. This not only enhances performance but also enables you to make more efficient use of your hardware resources, potentially resulting in cost savings on infrastructure.

Tuning 52

Tuning Database Performance Hardware 52

SQL Performance

APRIL 27, 2020

The basic tier provides up to 5 DTUs with standard storage. The standard tier supports from 10 up to 3000 DTUs with standard storage and the premium tier supports 125 up to 4000 DTUs with premium storage, which is orders of magnitude faster than standard storage. New Hardware Configuration for Provisioned Compute Tier.

Azure 55

Azure Database Serverless Hardware 55

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. There are also large differences in storage capacity and throughput between these extremes.

Azure 72

Azure Virtualization Servers Storage 72

Brendan Gregg

FEBRUARY 28, 2023

As I was determined to become great at my new occupation regardless of my location, I read every sysadmin book, article, and magazine I could find on the shelf. I didn't end up getting published in SysAdmin directly, but my performance work did make it as a feature article (thanks Matty). Or even on a plane.

Performance 110

Performance Latency Cache Virtualization 110

Smashing Magazine

JUNE 18, 2020

In this article, we’re going to see some of those differences and how to overcome them. More specifically, we’re going to talk about storage and UI differences, which are the ones that most often cause confusion to developers when writing Flutter code that they want to be cross-platform. Example 1: Storage.

Storage 94

Storage Mobile Website Java 94

Scalegrid

JULY 13, 2020

In this article, we compare Oracle vs. PostgreSQL, outlining the differences in these SQL database costs, features, and ease of use for both developers and database administrators (DBA’s) alike. pg_repack – reorganizes tables online to reclaim storage. What’s causing this massive shift? So Which Is Best?

Open Source 244

Open Source Tuning C++ Database 244

Percona

JULY 1, 2023

Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. It also supports auto-scaling of compute and storage resources, dynamically adjusting capacity based on chosen utilization thresholds to optimize performance and costs.

AWS 52

AWS Database Serverless Storage 52

Brendan Gregg

FEBRUARY 28, 2023

As I was determined to become great at my new occupation regardless of my location, I read every sysadmin book, article, and magazine I could find on the shelf. I didn't end up getting published in SysAdmin directly, but my performance work did make it as a feature article (thanks Matty). Or even on a plane.

Performance 52

Performance Latency Cache Virtualization 52

Abhishek Tiwari

DECEMBER 27, 2017

faster access to external storage and data locality (I/O, bandwidth). Using default scheduler's node affinity feature you can ensure that certain pods only schedule on nodes with specialized hardware like GPU, memory-optimised, I/O optimised etc. Storage provisioning. But Kubernetes storage is evolving quite quickly.

Big Data 63

Big Data Storage Benchmarking Hardware 63

Percona

MAY 1, 2023

Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements. This not only results in cost savings by minimizing hardware requirements but also has the potential to decrease cloud expenses.

Tuning 52

Tuning Efficiency Database Performance 52

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Any storage device that can survive a power outage. Starting with the Linux 4.18

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JANUARY 11, 2020

Important When planning, deploying, and maintaining a Microsoft SQL Server installation, ensure that the I/O system supports all the factors outlined in this article. Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure.

Servers 40

Servers Cache Media Hardware 40

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. For deep technical details and undocumented options, see Dmitry Pilugin's excellent article on the subject. Please see my previous article if you need a refresher on the details. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Highly Scalable

APRIL 2, 2012

In this article, I describe major architectural decisions we made and techniques we used. I can recommend this article by Peter Morville and Jeffrey Callender for further reading. Taking into account the previous considerations, performance requirements were set as 1000 faceted navigation requests/second per typical hardware blade.

Ecommerce 100

Ecommerce Cache Storage Architecture 100

Alex Russell

SEPTEMBER 20, 2020

Pre-publication gates were valuable when better answers weren't available, but commentators should update their priors to account for hardware and software progress of the past 13 years. Fast forward a decade, and both the software and hardware situations have changed dramatically. Don't like the consequences?

Hardware 64

Hardware Mobile Programming Java 64

CSS Wizardry

APRIL 2, 2018

That said, perhaps this article might provide some use to people looking to get a better handle on their digital setup: I know I would have certainly appreciated a post like this when I was setting out. If I sound like I don’t have a clue what I’m talking about, that’s probably because I don’t. Background. Technics OTTAVA™ f SC-C70 – £799.

Website 108

Website Media Hardware Monitoring 108

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

SQL Performance

JANUARY 22, 2020

However, strongly-typed isn't really strictly "strongly-typed" as you would expect, as this article is going to demonstrate, and performance could be impacted as a result. Where this really can make a difference is in cloud implementations where you are paying for more than just compute and storage resources.

Servers 55

Servers Azure Hardware Network 55

Percona

APRIL 17, 2023

The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture. For example: Read/Write tickets WiredTiger uses tickets to control the number of read / write operations simultaneously processed by the storage engine. The report focuses on MySQL, but it is valid for MongoDB as well.

Best Practices 52

Best Practices Design Tuning Database 52

High Scalability

NOVEMBER 25, 2019

It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52

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

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

Highly Scalable

AUGUST 20, 2013

This article is an effort to explore techniques used by developers of in-stream data processing systems, trace the connections of these techniques to massive batch processing and OLTP/OLAP databases, and discuss how one unified query engine can support in-stream, batch, and OLAP processing at the same time. Interoperability with Hadoop.

Big Data 154

Big Data Processing Lambda Database 154

Smashing Magazine

JANUARY 6, 2020

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 Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. To achieve the goals stated in the first paragraph, we have to consider the critical file size budget for JavaScript.

Performance 145

Performance Cache Network Metrics 145

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 74

Website Performance Website Energy Performance 74

Smashing Magazine

JANUARY 11, 2021

It’s worth noting that you will end up with better Core Web Vitals scores by following a general advice in this article.). On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing and execution times (we’ll talk about them in detail later). Largest Contentful Paint ( LCP ) < 2.5 considerations.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 7, 2019

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). awesome-webpack is a curated list of useful Webpack resources, libraries and tools, including articles, videos, courses, books and examples for Angular, React and framework-agnostic projects.

Performance 104

Performance Cache Metrics Network 104

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. now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 46

Cache C++ AWS Airlines 46

Highly Scalable

SEPTEMBER 18, 2012

In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. In the rest of this article we study a number of distributed activities like replication of failure detection that could happen in a database. Data Placement. Consistency. Read-Write consistency.

Database 213

Database Latency C++ Scalability 213

Alex Russell

OCTOBER 22, 2017

This, in turn, drives the single most important trend in setting the global web performance budget hardware baseline: the next billion users will largely come online when they can afford to. Previous versions of this article discussed slow-start, bdp, tcp window scaling, and the like. seconds: 400 Kbps = 50KB/s. 50KB/s * 3.4 = 170KB.

Performance 68

Performance Benchmarking Network Mobile 68

Brendan Gregg

SEPTEMBER 5, 2017

I wrote an ftrace toolkit, [perf-tools], and the article [Ftrace: the hidden light switch]. - **perf**: since 2009, this started as a PMC profiler but can do tracing now as well, usually in a dump-and-post-process style. It requires a subscription to read the latest articles, but if Linux is going to be a big part of your job, it's worth it.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

AUGUST 27, 2018

assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. If you ever wondered how much storage performance could be improved by using faster cloud volumes, you’re not alone. Currently, CPU affinity (i.e.,

Tuning 44

Tuning Virtualization Testing Servers 44