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. The PostgreSQL documentation contains more information about shared memory configuration. The PostgreSQL documentation contains more information about shared memory configuration. Summing up.

Tuning 58

Tuning Database Servers Processing 58

O'Reilly

NOVEMBER 28, 2023

A year after the first web servers became available, how many companies had websites or were experimenting with building them? And there are tools for archiving and indexing prompts for reuse, vector databases for retrieving documents that an AI can use to answer a question, and much more. Certainly not two-thirds of them.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

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. 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 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. Resource groups permit assigning threads running within MySQL to particular groups so that threads execute according to the resources available to this group. MySQL determines, at startup, how many virtual CPUs are available. Will this work?

Tuning 46

Tuning Virtualization Testing Servers 46

Adrian Cockcroft

NOVEMBER 13, 2023

In the simplest case, you have a growing workload, and you optimize it to run more efficiently so that you don’t need to buy or rent additional hardware, so your carbon footprint stays the same, but the carbon per transaction or operation is going down. I’ve written before about how to tune out retry storms.

Energy 52

Energy Cloud Traffic Transportation 52

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. This helps identify potential issues and fine-tune the partitioning strategy. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

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

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

This is possible because the Tcl interpreter is exceptionally compact and lightweight (Also for this reason Tcl is often used as an embedded language in hardware such as Cisco Routers). 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

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. The data available to our retail business is much more limited.

Games 116

Games Healthcare Processing Retail 116

John McCalpin

JANUARY 22, 2018

Since “peak performance” for the processor is two (512-bit SIMD) FMA instructions per cycle, any instructions that are not FMA instructions subtract directly from the available peak performance. of the “adjusted peak performance”, there is no longer a significant upside to performance tuning.

Latency 40

Latency Hardware Code Testing 40

Smashing Magazine

AUGUST 22, 2021

Additionally, even if we knew the available physical bandwidth, that wouldn’t mean we could use all of it ourselves. Several users are typically active on a network concurrently, each of whom need a fair share of the available bandwidth. More in-depth information is available. What Does It All Mean?

Performance 106

Performance Network Latency Servers 106

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. We can do the correct offset calculation manually using the data available in the plan.

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. Complying with all applicable copyright laws is the responsibility of the user. ​​ Read it before you read this paper.

Servers 40

Servers Cache Database Media 40

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. Documentation: [link]. Multiple queries run at the same time will be using different threads and will utilize more than one CPU core. With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 48

Cache C++ AWS Airlines 48

High Scalability

NOVEMBER 25, 2019

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. Always be available: Have a service level circuit breaker and a circuit breaker by customer. Video Transcoding. Permissions.

Architecture 52

Architecture Cache Azure Storage 52