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. Throughput.

Database 217

Database Benchmarking Latency Performance 217

Percona

DECEMBER 20, 2018

I found the comparison of InnoDB vs. MyISAM quite interesting, and I’ll use it in this post. Linux OS Tuning for MySQL Database Performance. In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. Tuning InnoDB Primary Keys.

Database 40

Database Tuning Performance AWS 40

Percona

JANUARY 19, 2023

sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> INSERT INTO employees_compressed SELECT * FROM employees; Size comparison: [user1] percona@db1: ~ $ sudo ls -lh /var/lib/mysql/employees/|grep employees -rw-r --. It is available under a paid subscription. 1 mysql mysql 704M Dec 30 02:28 employees.ibd -rw-r --.

Open Source 90

Open Source Storage Database Big Data 90

Scalegrid

JUNE 4, 2020

Now, let’s take a look at the throughput and latency performance of our comparison. ScaleGrid for PostgreSQL is architectured to leverage-high performance SSD disks on DigitalOcean, and is finely tuned and optimized to achieve the best performance on DigitalOcean infrastructure. PostgreSQL Benchmark Setup. Benchmark Tool.

Database 230

Database Latency Benchmarking Performance 230

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. Why is that?

Tuning 137

Tuning Cache Servers Benchmarking 137

Brendan Gregg

SEPTEMBER 25, 2021

As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result. I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 6. How long is each time call?

Speed 126

Speed Java AWS Virtualization 126

Brendan Gregg

SEPTEMBER 25, 2021

As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result. I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 7. us on Centos and 0.68

Speed 40

Speed Java AWS Virtualization 40