All Things Distributed

OCTOBER 8, 2014

We are introducing native support for document model like JSON into DynamoDB, the ability to add / remove global secondary indexes, adding more flexible scaling options, and increasing the item size limit to 400KB. We designed DynamoDB to operate with at least 99.999% availability. NoSQL and Flexibility: Document Model.

Availability 145

Availability Performance Scalability AWS 145

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

Percona

AUGUST 27, 2018

MySQL 8 introduced a feature that is explained only in a single documentation page. 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. Then we need to see IF implementing the tuning will work or not.

Tuning 45

Tuning Virtualization Testing Servers 45

O'Reilly

SEPTEMBER 19, 2023

Doubly so as hardware improved, eating away at the lower end of Hadoop-worthy work. A single document may represent thousands of features. Google goes a step further in offering compute instances with its specialized TPU hardware. Millions of tests, across as many parameters as will fit on the hardware.

Hardware 98

Hardware Storage Big Data Blockchain 98

Percona

AUGUST 5, 2023

If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. HASH partitioning HASH partitioning in MySQL divides a table into partitions based on the hash value of a designated column’s contents. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document.

Servers 40

Servers Cache Media Hardware 40

O'Reilly

OCTOBER 11, 2022

We’ll see it in the processing of the thousands of documents businesses handle every day. Andrew Ng , Christopher Ré , and others have pointed out that in the past decade, we’ve made a lot of progress with algorithms and hardware for running AI. They’re inefficient, poorly designed, and perhaps even wholly inappropriate for the task.

Games 116

Games Healthcare Processing Retail 116

HammerDB

FEBRUARY 25, 2021

As we have seen databases are designed to handle multiple database sessions at the same time. HammerDB abandoned Python as a glue language at the design stage because of the lack of multithreading and parallel capabilities. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

John McCalpin

JANUARY 22, 2018

Hardware performance counter results for a simple benchmark code calling Intel’s optimized DGEMM implementation for this processor (from the Intel MKL library) show that about 20% of the dynamic instruction count consists of instructions that are not packed SIMD operations (i.e., addl $1, %eax vfmadd213pd %zmm16, %zmm17, %zmm29.

Latency 40

Latency Hardware Code Testing 40

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. This uses hardware, typically a crystal oscillator, that produces ticks at a very high constant rate regardless of processor speed, power settings, or anything of that nature. Alternate designs. The clock keeps running at the same rate even during sleep.

Servers 95

Servers Tuning Architecture Processing 95

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. After reading ​​ this document you will better understand SQL Server I/O needs and capabilities.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

AUGUST 22, 2021

As such, tuning congestion logic is usually only done by a select few developers, and evolution is slow. While this is conceptually possible (QUIC does exactly that), things were initially not designed like this, because we need to be able to use TCP with and without TLS on top. see figure 2c above).

Performance 106

Performance Network Latency Servers 106

High Scalability

NOVEMBER 25, 2019

To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. Document store. Egnyte Connect as the content collaboration and data management platform is used by thousands of customers as the single Secure Content Platform for all of their document management needs.

Architecture 52

Architecture Cache Azure Storage 52