article thumbnail

Comparing PostgreSQL DigitalOcean Performance & Pricing – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

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
article thumbnail

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

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
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Most Important MySQL Setting

Percona

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? To be fair, that is also true with PostgreSQL; it hasn’t been tuned either, and it, too, can also perform much better.

Tuning 135
article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Comparison Overview. PostgreSQL offers more light-weight tuning capabilities, like their Query Optimizer, and DBaaS platforms like ScaleGrid offer advanced slow query analysis. Compare Ease of Use. PostgreSQL.

article thumbnail

Percona Database Performance Blog 2018 Year in Review: Top Blog Posts

Percona

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.

article thumbnail

The Speed of Time

Brendan Gregg

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
article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

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 --. sec) mysql> ALTER TABLE employees_compressed ROW_FORMAT=COMPRESSED; Query OK, 0 rows affected (0.14