VoltDB

MAY 2, 2017

Here’s how we explain it in our Documentation: Support for different cluster sizes in passive Database Replication (DR). because they want to use a lower k- factor (even 0) on the replica cluster to lower hardware costs. This time, however, you can avoid any loss of data by using a controlled cutover process.

Hardware 40

Hardware Database Servers Tuning 40

Percona

AUGUST 29, 2018

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. SHMMAX is a kernel parameter used to define the maximum size of a single shared memory segment a Linux process can allocate. A page is a chunk of RAM that is allocated to a process.

Tuning 54

Tuning Database Servers Processing 54

O'Reilly

NOVEMBER 28, 2023

Users and Nonusers AI adoption is in the process of becoming widespread, but it’s still not universal. Until AI reaches 100%, it’s still in the process of adoption. Automating the process of building complex prompts has become common, with patterns like retrieval-augmented generation (RAG) and tools like LangChain.

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

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 97

Hardware Storage Big Data Blockchain 97

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. systemctl stop tuned $ systemctl disable tuned Dirty ratio The dirty_ratio is the percentage of total system memory that can hold dirty pages.

Best Practices 52

Best Practices Design Tuning Database 52

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 44

Tuning Virtualization Testing Servers 44

Percona

AUGUST 5, 2023

This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. Special considerations are needed to ensure these processes still work seamlessly after partitioning. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

Brendan Gregg

SEPTEMBER 5, 2017

There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). On Linux, containers are a combination of namespaces (restricting what a process sees) and cgroups (similar to Solaris resource controls).

Virtualization 76

Virtualization AWS Engineering Hardware 76

O'Reilly

OCTOBER 11, 2022

There seems to be broad agreement that hyperautomation is the combination of Robotic Process Automation with AI. We’ll see it in the processing of the thousands of documents businesses handle every day. We can certainly apply the slogan to many, if not all, clerical tasks–and even to the automation process itself.

Games 114

Games Healthcare Processing Retail 114

SQL Performance

JUNE 21, 2019

Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. Part of that process is his Index Optimize procedure, which can take additional parameters to update statistics.

Servers 49

Servers Azure Hardware Database 49

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

HammerDB

FEBRUARY 25, 2021

Top 10 Processes. We could use processes, however given we may want to create hundreds or thousands of virtual users multithreading is the best approach to implement a Virtual User. But let’s quantify fast by running the same calculation in SQL Server (see the HammerDB documentation for the Oracle example).

Programming 67

Programming Benchmarking Virtualization C++ 67

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. SQL Server uses the high-precision QueryPerformanceCounter API to capture timing data.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

AUGUST 22, 2021

This is a bit more difficult to explain, because it depends on the physical properties of the medium (for example, the used frequency of radio waves), the number of users on the network, and also the devices that interconnect different subnetworks (because they typically can only process a certain number of packets per second). Did You Know?

Performance 106

Performance Network Latency Servers 106

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

High Scalability

NOVEMBER 25, 2019

Your Laptop has a filesystem used by hundreds of processes. 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. Document store. On prem data processing. Locks used for strong consistency across processes.

Architecture 52

Architecture Cache Azure Storage 52