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 135

Tuning Cache Servers Benchmarking 135

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

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.

Open Source 244

Open Source Tuning C++ Database 244

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

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 125

Performance Hardware Tuning Storage 125

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. GHz available cpufreq governors: performance powersave current policy: frequency should be within 1000 MHz and 4.00 hardware limits: 1000 MHz - 4.00 hardware limits: 1000 MHz - 4.00

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Dynatrace

FEBRUARY 10, 2022

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. A perfect OWASP benchmark score for injection attacks – 100% accuracy and zero false positives – impressively proves the precision of our approach. How to get started.

Traffic 234

Traffic Benchmarking Innovation Java 234

Scalegrid

MARCH 22, 2024

This process thoroughly assesses factors like cost-effectiveness, security measures, control levels, scalability options, customization possibilities, performance standards, and availability expectations. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 130

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. With this feature Oracle generates a wealth of performance data that can be reviewed once the test is complete.

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

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

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

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. Results for Percona Server for MySQL 8.0

Cache 104

Cache Hardware Servers Benchmarking 104

Percona

OCTOBER 12, 2023

That said, your application may not be in the list of supported languages, but if it’s compatible with any of the available profilers, you can still produce flame graphs. In case the application is in Go, the selected profiler will be eBPF. ✔ Launching profiler. ✔ Profiling. Try Percona Distribution for MySQL today!

Code 112

Code Tuning C++ Benchmarking 112

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

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.

Open Source 81

Open Source Programming Database Servers 81

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). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

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. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. These can be invisible to top(8).

Speed 126

Speed Java AWS Virtualization 126

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. Some of them are: MySQL Cluster: MySQL NDB Cluster is an in-memory database clustering solution developed by Oracle for MySQL.

Open Source 90

Open Source Storage Database Big Data 90

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. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Much of my testing was on Linux 4.14.11

Performance 75

Performance Benchmarking Cache Tuning 75

IO River

NOVEMBER 15, 2023

Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture. SQL Injection involves inserting malicious SQL queries into an input field, tricking the database into revealing sensitive information.Imagine a login page. Let's dive deep into these challenges.‍1.

Traffic 52

Traffic Network Logistics Architecture 52

IO River

NOVEMBER 2, 2023

Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture. SQL Injection involves inserting malicious SQL queries into an input field, tricking the database into revealing sensitive information.Imagine a login page. Let's dive deep into these challenges.‍1.

Traffic 40

Traffic Network Logistics Architecture 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. I've shared many posts about superpower observability tools, but often humble hacking is just as effective. These can be invisible to top(8).

Speed 40

Speed Java AWS Virtualization 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. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Much of my testing was on Linux 4.14.11

Performance 40

Performance Benchmarking Cache Tuning 40

Apica

MAY 10, 2019

Load and stress-testing benchmark goals for the backend technological components. These companies should involve multiple organizations during Apica’s load testing to observe and pinpoint opportunities for performance tuning. User scenarios specifically expected to have high-loads.

Testing 40

Testing Performance Social Media Wireless 40

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 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

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? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

O'Reilly

JULY 25, 2023

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. I feel that humans are still better than LLMs at coming up with these sorts of hacks since there aren’t readily-available online resources to document them.

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. Always be available: Have a service level circuit breaker and a circuit breaker by customer. Automate schema management for some remaining databases. Cloud Platform. Google cloud.

Architecture 52

Architecture Cache Azure Storage 52