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. vCore Pricing Tier. GB per vCore. HyperScale Database.

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

Percona

JULY 1, 2023

Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc. What is Amazon RDS?

AWS 52

AWS Database Serverless Storage 52

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

Abhishek Tiwari

DECEMBER 27, 2017

faster access to external storage and data locality (I/O, bandwidth). Kubernetes has all necessary primitives available to make it happen. 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.

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

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. Another blocker was that I had no way of finding out which songs in my Spotify library would be available on the Tidal service.

Website 108

Website Media Hardware Monitoring 108

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. 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.

Servers 86

Servers Tuning Database Efficiency 86

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

Highly Scalable

APRIL 2, 2012

In this article, I describe major architectural decisions we made and techniques we used. Besides this, each product has some transient information like in-stock availability that is a subject of frequent updates (every 5 minutes or so). I can recommend this article by Peter Morville and Jeffrey Callender for further reading.

Ecommerce 100

Ecommerce Cache Storage Architecture 100

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. There is an issue with this, which causes the OS to swap even with memory available. Spoiler alert: This post focuses on MongoDB 3.6.X 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

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

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

Any rows are then available in a table variable which can then be used in standard T-SQL coding, which eliminates the need to write specialized processing logic for breaking the data down again. 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

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

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. Largest Contentful Paint ( LCP ) < 2.5 considerations.

Performance 145

Performance Cache Media Metrics 145

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. Read/Write latency. Consistency.

Database 213

Database Latency C++ Scalability 213

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. Large preview ). Getting started with Webpack can be tough though.

Performance 145

Performance Cache Network Metrics 145

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. Modern network performance and availability. Hardware Past As Performance Prologue. But the hardware future is not evenly distributed, and web workloads aren't heavily parallel.

Performance 124

Performance Network Cache Metrics 124

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. Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 104

Performance Cache Metrics Network 104

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

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

Alex Russell

OCTOBER 22, 2017

If our example document wasn’t reliant on JavaScript to construct the <my-app> custom element, the contents of the document would likely be interactive as soon as enough CSS and content was available to render meaningfully. Any DOM or UI created in JS is not available for use until the script runs. 400Kbps transfer.

Performance 68

Performance Benchmarking Network Mobile 68

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. Test data and versions.

Cache 46

Cache C++ AWS Airlines 46

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

AUGUST 27, 2018

Resource groups permit assigning threads running within MySQL to particular groups so that threads execute according to the resources available to this group. 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.

Tuning 44

Tuning Virtualization Testing Servers 44