Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Oracle Costs.

Open Source 244

Open Source Tuning C++ Database 244

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. ” Usually when benchmark results are surprising it is a major hint that something could be misconfigured and that certainly seems the case here, so what could it be?

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Dynatrace

FEBRUARY 10, 2022

Static Application Security Testing (SAST) solutions are a traditional way of addressing this. This also means we do not rely on vulnerability databases but are able to identify and block such attacks automatically even if they are exploiting unknown weaknesses. Unfortunately, they also introduce risk. How to get started.

Traffic 234

Traffic Benchmarking Innovation Java 234

Dynatrace

OCTOBER 2, 2023

Because monolithic applications combine database, client-side interfaces, and server-side application elements in a single executable, they’re difficult to understand, even for their own administrators. remove the dependency on the monolith after all testing is successful. Migration is time-consuming and involved.

Architecture 231

Architecture Artificial Intelligence Cloud Open Source 231

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 127

Performance Hardware Tuning Storage 127

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. While many AWS users default to their managed database solution, Amazon RDS, there are alternatives available that can improve your MySQL performance on AWS through advanced customization options and unlimited EC2 instance type support.

AWS 183

AWS Latency Performance Benchmarking 183

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark.

Cache 105

Cache Hardware Servers Benchmarking 105

HammerDB

OCTOBER 18, 2018

An essential part of database performance testing is viewing the statistics generated by the database during the test and in 2009 HammerDB introduced automatic AWR snapshot generation for Oracle for the TPC-C test. However what if you want to review performance data in real time as the test is running?

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Dynatrace

APRIL 8, 2021

When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. These served as our benchmark when creating our Lambda monitoring extension. So, stay tuned for more blog posts and announcements. Top enterprise use-cases for AWS Lambda.

Lambda 221

Lambda AWS Serverless Monitoring 221

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). Basic Benchmarking Concepts. As we have seen databases are designed to handle multiple database sessions at the same time.

Programming 67

Programming Benchmarking Virtualization C++ 67

Adrian Cockcroft

JUNE 21, 2022

Another big jump, but now it was my job to run benchmarks in the lab, and write white papers that explained the new products to the world, as they were launched. I was mostly coding in C, tuning FORTRAN, and when I needed to do a lot of data analysis of benchmark results used the S-PLUS statistics language, that is the predecessor to R.

Tuning 52

Tuning Benchmarking Engineering C++ 52

High Scalability

AUGUST 24, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100

Education DevOps Infrastructure Benchmarking 100

n0derunner

JULY 23, 2019

In this video I migrate a Postgres DB running PGbench benchmark. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform. The Postgres DB is totally un-tuned and contains purely default settings. The DB is running on a Host which is CPU constrained.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

Dynatrace

APRIL 8, 2021

When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. These served as our benchmark when creating our Lambda monitoring extension. So, stay tuned for more blog posts and announcements. Top enterprise use-cases for AWS Lambda.

Lambda 182

Lambda AWS Serverless Monitoring 182

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

The Netflix TechBlog

OCTOBER 19, 2020

Our engineering teams tuned their services for performance after factoring in increased resource utilization due to tracing. In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes. What’s next?

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. sec) db1 test> CREATE TABLE tb3 (id int auto_increment primary key, test_text tinytext); Query OK, 0 rows affected (0.13

Open Source 91

Open Source Storage Database Big Data 91

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. There's also a test and println() in the loop to, hopefully, convince the compiler not to optimize-out an otherwise empty loop. This will slow this test a little.)

Speed 126

Speed Java AWS Virtualization 126

Apica

MAY 10, 2019

Whatever size of company you are, performance monitoring and testing is a critical part of the success you will have. It is also worth noting that brand popularity doesn’t translate into more success if you are not testing load to confirm your streaming services will performs. Apica’s scale is enterprise-grade.

Testing 40

Testing Performance Social Media Wireless 40

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

Strategy 40

Strategy Storage Database Best Practices 40

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings.

Performance 75

Performance Benchmarking Cache Tuning 75

IO River

NOVEMBER 15, 2023

Let's break down this Security Flywheel into its core components: ‍Research, Close Breaches, and Test. But hold your horses—before switching them to "block" mode, it's crucial to test them extensively. After you've researched, closed breaches, and tested, you start all over again. It's an ongoing, iterative process.

Traffic 52

Traffic Network Logistics Architecture 52

IO River

NOVEMBER 2, 2023

Let's break down this Security Flywheel into its core components: ‍Research, Close Breaches, and Test. But hold your horses—before switching them to "block" mode, it's crucial to test them extensively. After you've researched, closed breaches, and tested, you start all over again. It's an ongoing, iterative process.

Traffic 40

Traffic Network Logistics Architecture 40

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings.

Performance 40

Performance Benchmarking Cache Tuning 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. There's also a test and println() in the loop to, hopefully, convince the compiler not to optimize-out an otherwise empty loop. This will slow this test a little.)

Speed 40

Speed Java AWS Virtualization 40

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. HammerDB difference from Sysbench. 10 rows in set (0.02

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

O'Reilly

JULY 25, 2023

Swift Papers felt like a well-scoped project to test how well AI handles a realistic yet manageable real-world programming task. Similarly, it taught me that “Background scripts are ideal for handling long-term or ongoing tasks, managing state, maintaining databases, and communicating with remote servers.

Programming 98

Programming Code Design Benchmarking 98

High Scalability

NOVEMBER 25, 2019

Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. Automate schema management for some remaining databases. We use a variant of git-flow, for every ticket, we clone the repo and we run automation tests on every merge request.

Architecture 52

Architecture Cache Azure Storage 52