Scalegrid

JUNE 22, 2020

MySQL DigitalOcean Performance Benchmark. In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL. We are going to use a common, popular plan size using the below configurations for this performance benchmark: Comparison Overview. DigitalOcean.

Database 217

Database Benchmarking Latency Performance 217

Percona

JANUARY 2, 2024

We decided to run a few benchmarks to understand how the thread pool affects long-running transactions. This server is not intended to be a perfectly tuned one but just a baseline to compare the behavior under different concurrency configurations. For this reason, I’ve set up a server with the following specs: r6a.2xlarge

Benchmarking 89

Benchmarking Servers Tuning C++ 89

Percona

MARCH 27, 2023

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

Cache 107

Cache Hardware Servers Benchmarking 107

Percona

JANUARY 19, 2023

There are a couple of blog posts from Yves that describe and benchmark MySQL compression: Compression Options in MySQL (Part 1) Compression Options in MySQL (Part 2) Archive or purge old or non-used data: Some companies have to retain data for multiple years either for compliance or for business requirements. ibd -rw-r --. ibd -rw-r --.

Open Source 93

Open Source Storage Database Big Data 93

Rigor

JANUARY 13, 2020

In her book, Lara Hogan helps you approach projects with page speed in mind, showing you how to test and benchmark which design choices are most critical. Web Performance Tuning. You only have a few seconds to get compelling content onto the screen. Fail, and you can kiss your customers and profits goodbye.”

Performance 75

Performance Social Media Website Website Performance 75

SQL Server According to Bob

JANUARY 11, 2020

Books Online (BOL) References: ​​ All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. SQL Server 2000/7.0 data pages are 8 KB in size.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

The ​​ SQL Server 2000 I/O Basics ​​ document is a prerequisite to ​​ the information contained in this ​​ document. and ​​ 2000. SQL Server 2000, and SQL Server 2005. SQL Server 6. However, as explained above, the SQL Server 6.

Servers 40

Servers Cache Database Media 40