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

Database 217
article thumbnail

Impact of Querying Table Information From information_schema

Percona

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.}. While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 98
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

Why MySQL Could Be Slow With Large Tables

Percona

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

article thumbnail

Top500 list: a brief introduction

PDC

It ranks the world’s 500 most powerful supercomputers based on their performance as measured by the Linpack benchmark. A supercomputer that is capable of 1 exaFLOPS or higher would be called an exascale supercomputer, and, when they become available, they are expected to contribute significantly to the advancement of science and technology.

Energy 40
article thumbnail

Progress Delayed Is Progress Denied

Alex Russell

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Higher is better.

Media 145
article thumbnail

How to deploy HammerDB CLI fast with Docker

HammerDB

The scripts are available in both Python and Tcl formats. Benchmark set to TPC-C for MariaDB. Vuser 3: 2000. Benchmark set to TPC-C for MariaDB. Benchmark set to TPC-C for MariaDB. There is a driver script that can be used to build, test, delete and query the results of a workload with a single script. TMP/hammer.DB

C++ 62
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

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 These systems must maintain support for I/O ordering.

Servers 40