Percona

MARCH 27, 2023

The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 101

Cache Hardware Servers Benchmarking 101

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. For instance: mysql> show create table authorsG 1. mysql> ALTER TABLE authors ENCRYPTION='Y'; Query OK, 0 rows affected (0.05

Storage 87

Storage Engineering Database Hardware 87

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. This can all be done without touching a single line of code.

Scalability 159

Scalability Hardware AWS Tuning 159

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 104

Database Benchmarking Latency C++ 104

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

Percona

JANUARY 19, 2023

It is available under a paid subscription. ProxySQL: It is a feature-rich open-source MySQL proxy solution, that allows query routing for the most common MySQL architectures (PXC/Galera, Replication, Group Replication, etc.). MyRocks: MyRocks is a storage engine developed by Facebook and made open source.

Open Source 87

Open Source Storage Database Big Data 87

HammerDB

OCTOBER 18, 2019

As noted previously the main developer of HammerDB is an Intel employee (#IAMINTEL) however HammerDB is a personal open source project and any opinions are my own, specific to the context of HammerDB as an independent personal project and not representing Intel. hardware limits: 1000 MHz - 4.00 hardware limits: 1000 MHz - 4.00

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Percona

AUGUST 29, 2023

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Now let’s stretch our imagination and consider a second method of high availability, ala Citus. The same can be said for Citus data sharding. 1 citus | 11.1-1

C++ 79

C++ Database Storage Testing 79

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. Google Lighthouse Google Lighthouse is a free and open source tool that is part of the Google Chrome DevTools family. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

O'Reilly

NOVEMBER 28, 2023

16% of respondents working with AI are using open source models. ChatGPT was opened to the public on November 30, 2022, roughly a year ago; the art generators, such as Stable Diffusion and DALL-E, are somewhat older. But 18% already have applications in production. Certainly not two-thirds of them.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

KeyCDN

SEPTEMBER 20, 2018

Not all back-end errors affect the user experience, but keeping track of them can prove helpful when tuning your app. The Google DevTools console can give you real-time feedback to help you trace the source of errors, and you can set handlers to automate exception data collection.

Strategy 67

Strategy Monitoring Website Google 67

Abhishek Tiwari

JULY 12, 2018

Data Pipeline A data pipeline is a software that ingests data from multiple sources, transforms it and finally makes it available to internal or external products. 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

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). Whereas within Python all threads run in a single interpreter (after acquiring the GIL) in Tcl each thread has its own copy of the interpreter.

Programming 67

Programming Benchmarking Virtualization C++ 67

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