Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Results for Percona Server for MySQL 5.7

Cache 98

Cache Hardware Servers Benchmarking 98

The Netflix TechBlog

APRIL 29, 2019

We use and contribute to many open-source Python packages, some of which are mentioned below. video streaming) takes place in the Open Connect network. Such applications track the inventory of our network gear: what devices, of which models, with which hardware components, located in which sites.

Open Source 279

Open Source Network Infrastructure Big Data 279

O'Reilly

NOVEMBER 28, 2023

16% of respondents working with AI are using open source models. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” A year after the first web servers became available, how many companies had websites or were experimenting with building them?

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

All Things Distributed

MARCH 19, 2018

Amazon SageMaker training supports powerful container management mechanisms that include spinning up large numbers of containers on different hardware with fast networking and access to the underlying hardware, such as GPUs. Post-training model tuning and rich states.

Scalability 159

Scalability Hardware AWS Tuning 159

Percona

JANUARY 4, 2024

Flexible location : Data files can reside within the MySQL data directory or an independent location, enabling finer control over storage management and performance tuning. mysql> mysql> pager grep -i keyring_file; PAGER set to 'grep -i keyring_file' mysql> SHOW PLUGINS; 50 rows in set (0.00

Storage 85

Storage Engineering Database Hardware 85

Percona

NOVEMBER 3, 2023

PostgreSQL Cluster One coordinator node citus-coord-01 Three worker nodes citus1 citus2 citus3 Hardware AWS Instance Ubuntu Server 20.04, SSD volume type 64-bit (x86) c5.xlarge Steps Provisioning The first step is to provision the four nodes with both PostgreSQL and Citus.

Database 102

Database Benchmarking Latency C++ 102

HammerDB

APRIL 19, 2023

For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement. sysbench is a widely used open-source benchmarking tool that is designed to evaluate the performance of CPU, memory, disk I/O, and database systems. and 8.0.32

Performance 54

Performance Benchmarking Cache Storage 54

Percona

JANUARY 19, 2023

Sharding: Sharding is the concept of splitting data horizontally, i.e. by distributing data into multiple servers (shards), meaning that the different portions of data for a given table, may be stored on many different servers. This can help to split large data sets into smaller ones stored in multiple servers.

Open Source 85

Open Source Storage Database Big Data 85

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

HammerDB

JANUARY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and any opinions are specific to the context of HammerDB as an independent personal project and are not related to Intel in any way. Repeatability. can you be sure that it scales?

Benchmarking 40

Benchmarking Database Social Media Scalability 40

KeyCDN

AUGUST 15, 2019

Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. Bottlenecks can occur, for example, if you have a sudden surge in traffic that your servers are not equipped to handle. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

HammerDB

FEBRUARY 25, 2021

When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. Glue language.

Programming 67

Programming Benchmarking Virtualization C++ 67

O'Reilly

JANUARY 16, 2024

I’ve been diligent about data backup throughout my life, but my files are fragmented amongst different media over the years—burning CDs and DVDs back in the day, several generations of external hard drives (that are in various states of decay), university servers, Dropbox, and other cloud services.

Entertainment 72

Entertainment Internet Internet Design 72

Smashing Magazine

AUGUST 22, 2021

Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). It is physically limited by the speed of light or, practically, how fast signals can travel in wires or in the open air. As such, even low latencies of less than 50 milliseconds can add up to considerable delays.

Performance 106

Performance Network Latency Servers 106

KeyCDN

SEPTEMBER 20, 2018

Back-End Error Tracking Back-end, or server-side, errors include things like page exceptions and JavaScript errors. Not all back-end errors affect the user experience, but keeping track of them can prove helpful when tuning your app. While lastly, APM allows you to gather data on server-side bottlenecks.

Strategy 67

Strategy Monitoring Website Google 67

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. In other words, whether the workload is dominated by reads or writes. Why should you care?

Benchmarking 46

Benchmarking Database Operating System Architecture 46

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63