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.

Database 217
article thumbnail

Is Thread Pool Plugin the Right Choice for Your Workload?

Percona

TL&DR : Depending on the workload, the thread pool plugin can cause serious performance drops. In each situation, I’ve seen huge drops in the performance where the QPS were going to almost zero. After removing the thread pool plugin from the clusters, the performance was more steady, even when running these queries.

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

Matching Supply With Demand Challenge

SQL Performance

It's a pretty common need in real life; it's simple to describe, and it's quite easy to solve with reasonable performance using a cursor-based solution. When Peter sends me a puzzle, I typically respond with a suggested solution, and he usually comes up with a better-performing, brilliant solution. It will be used as a benchmark.

C++ 133
article thumbnail

Web Performance Bookshelf

Rigor

Reading time 1 min Why share the library of the web performance books while there’s a substantial collection of fantastic websites and articles on the net? High Performance Browser Networking. This book is about performance problems and the various technologies created to fight them. High Performance Websites.

article thumbnail

HammerDB v4.8 New Features : Viewing your Benchmark results with the HammerDB Web Service

HammerDB

We can now see the list of Jobs we generated with autopilot, that they all ran successfully, and also pinpoint the highest performance. Copy Code Copied Use a different Browser C:Program FilesHammerDB-4.8>hammerdbws >hammerdbws wait HammerDB Web Service v4.8

article thumbnail

Impact of Querying Table Information From information_schema

Percona

A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. performance degradation. That is (46320 – 38472) * 100 / 46320 = 16.9%

Cache 98
article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

While the technologies have evolved and matured enough, there are still some people thinking that MySQL is only for small projects or that it can’t perform well with large tables. With disks being faster nowadays and CPU and memory resources being cheaper, we could easily say MySQL can handle TBs of data with good performance.