Percona

AUGUST 22, 2023

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 80

Availability Hardware Open Source Database 80

Scalegrid

JULY 13, 2020

The unstoppable rise of open source databases. One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. See how open source PostgreSQL Community version costs compare to Oracle Standard Edition and Oracle Enterprise Edition. What’s causing this massive shift?

Open Source 244

Open Source Tuning C++ Database 244

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. In fact, according to ScyllaDB’s performance benchmark report, their 99.9 This number is more inline with our recent 2019 Open Source Database Trends Report where 56.9% year for a total of 48 cores.

Big Data 187

Big Data Database Open Source Azure 187

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. This means that when a query is executed, pgpool-II can check the cache first to see if the results are already available rather than sending the query to the database server.

Cache 116

Cache Open Source Benchmarking Database 116

Scalegrid

JUNE 4, 2020

As an open source database, it’s a highly popular choice for enterprise applications looking to modernize their infrastructure and reduce their total cost of ownership, along with startup and developer applications looking for a powerful, flexible and cost-effective database to work with. PostgreSQL DigitalOcean Performance Test.

Database 230

Database Latency Benchmarking Performance 230

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Quality assurance: How do you plan to test? Have you built a testing environment? Percona, for example, has helped hundreds of companies migrate to open source.

Database 85

Database Open Source Benchmarking Strategy 85

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 107

Database Benchmarking Latency C++ 107

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks . uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. MySQL on AWS Performance Test. MySQL Performance Benchmark Configuration. MySQL Performance Test Scenarios and Results. Amazon RDS. Instance Type. AWS High Performance XLarge (see system details below).

AWS 183

AWS Latency Performance Benchmarking 183

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

JUNE 22, 2023

A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. You should not only monitor the backup mount for disk space and backup log but also regularly test the restores and log to match RPO and RTO objectives.

Performance 106

Performance Monitoring Traffic Database 106

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

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. Are these results good enough? Why is that?

Tuning 137

Tuning Cache Servers Benchmarking 137

Testsigma

MAY 19, 2020

Software testing is the process of finding bugs or discrepancies in a software. As a beginner in software testing, you would make your own mistakes and learn from them to shape your career path. Following are a few common mistakes often made by software testing beginners when they start their journey in the world of testing.

Software 85

Software Software Testing Open Source 85

Percona

MARCH 27, 2023

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. The same tests have been executed in Percona Server for MySQL 5.7

Cache 104

Cache Hardware Servers Benchmarking 104

Testsigma

MARCH 23, 2021

It is open source and its development can be ported across devices with relative ease. And, precisely due to this diversity, the need for testing on many devices is paramount. As of September 2020, Statista reports that around 30,40,000 apps are available on Google Playstore. Why Is Android Device Testing Important?

Testing 52

Testing Mobile Testing Tools Strategy 52

Percona

JULY 25, 2023

the IBD file is “self-describing”; for example, the table schema is available within an IBD file. ibd in the test directory. For example, mysql datadir/test/t1.ibd. ibd2sdi data/test/t1.ibd Benchmarks xtrabackup –prepare on backup directory of other sizes like 10K, 50K, 100K, and 250K tables.

Cache 87

Cache Benchmarking Servers Design 87

Percona

JANUARY 24, 2023

This will be clearly visible in PostgreSQL performance benchmarks as a “ Sawtooth wave ” pattern observed by Vadim in his tests: As we can see, the throughput suddenly drops after every checkpoint due to heavy WAL writing and gradually picks up until the next checkpoint. I couldn’t see any adverse effect on the TPS on quick tests.

Database 118

Database Benchmarking Open Source Latency 118

KeyCDN

AUGUST 15, 2019

Web performance is a broad subject, and you’ll find no shortage of performance testing tips and tutorials all over the web. Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

SQL Performance

NOVEMBER 18, 2019

and the overall size will determine the amount of temporary storage available. The common trend is to choose a VM based exclusively on vCPU, memory, and storage capacity without benchmarking the current IO and throughput requirements. Once you select your filter options, if any, you will see a list of available servers.

Azure 76

Azure Benchmarking Storage Virtualization 76

HammerDB

DECEMBER 5, 2020

Additionally both commercial and open source tools based on the specifications also continued to use TPC-C and TPC-H to describe these workloads. In the days before highly performant SSDs and persistent memory, database benchmarks had a significant challenge in comparing performance due to the available I/O performance.

C++ 40

C++ Benchmarking Virtualization Open Source 40

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). This post explains why HammerDB made the language decisions it made to make it the best performing and most usable database benchmarking software.

Programming 67

Programming Benchmarking Virtualization C++ 67

High Scalability

OCTOBER 29, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. ScaleGrid offers a compelling alternative to hosting MySQL on AWS that offers better performance, more control, and no cloud vendor lock-in and the same price as Amazon RDS.

AWS 133

AWS Latency Performance Open Source 133

Percona

JANUARY 19, 2023

Example: Creating four simple tables to store strings but using different data types: db1 test> CREATE TABLE tb1 (id int auto_increment primary key, test_text char(200)); Query OK, 0 rows affected (0.11 sec) db1 test> CREATE TABLE tb2 (id int auto_increment primary key, test_text varchar(200)); Query OK, 0 rows affected (0.05

Open Source 90

Open Source Storage Database Big Data 90

Percona

MARCH 23, 2023

Benchmark before you decide. Typically a good value is 70%-80% of available memory. The optimal value can be decided after testing multiple settings, starting from eight is a good choice. For database servers, we usually recommend our clients have: Jemalloc installed and enabled for MySQL. Transparent huge pages (THP) disabled.

Performance 127

Performance Hardware Tuning Storage 127

HammerDB

MAY 26, 2022

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. The build has been tested on x64 Red Hat 8.X The build has been tested on x64 Windows 10 and 11.

C++ 113

C++ Database Open Source Servers 113

Speed Curve

FEBRUARY 15, 2021

Web pages are unbelievably complex, and there are hundreds of different metrics available to track. You can then configure your monitoring tools to send you alerts – or even break the build, if you're testing in your staging environment – when your budgets are violated. Is it loading? > Last Painted Hero (Synthetic).

Performance 134

Performance Metrics Benchmarking Google 134

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. Apple Corporate is at fault, not Open Source engineers or the line managers who support them. With each team, benchmarks lost are understood as bugs. Steve & Tim's Close-up Magic. Lower is better.

Media 145

Media Games Education Engineering 145

HammerDB

DECEMBER 9, 2020

<benchmark> <first_result>TPM</first_result> </benchmark> So why not just print NOPM and report a single metric for TPROC-C as per the official TPC-C workloads? From tests it should be slightly higher with the newer ODBC v3 interface). and earlier. <benchmark> Transaction Counter.

C++ 52

C++ Benchmarking Metrics Database 52

Percona

MAY 1, 2023

PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases. In production environments, it is observed that a large value for shared_buffer gives really good performance, though you should always benchmark to find the right balance.

Tuning 52

Tuning Efficiency Database Performance 52

Speed Curve

MAY 1, 2023

You can then configure your monitoring tools to send you alerts – or even break the build, if you're testing in your staging environment – when your budgets are violated. Use synthetic testing to visually validate your metrics The metrics mentioned above are not hard-and-fast suggestions.

Performance 98

Performance Metrics Media Google 98

The Morning Paper

MAY 27, 2019

The CheriABI implementation is used to compile FreeBSD and PostgreSQL, then all of the respective test suites are run. In the table below, the numbers in each column represent the number of test programs , not the number of individual tests. The MIPS rows show the test suite results on a standard mips64 system.

C++ 61

C++ Hardware Virtualization Benchmarking 61

Rigor

FEBRUARY 19, 2020

When evaluating open source tools or enterprise-grade synthetic monitoring tools, you want to look for capabilities that maximize its strengths. Can you manually edit recorded tests or do you need to completely re-record? Some common examples include: Testing your site with and without a CDN, or with different CDNs.

Monitoring 59

Monitoring Benchmarking Mobile Traffic 59

CSS - Tricks

JUNE 5, 2020

In my benchmarks, Brotli:11 takes several hundred milliseconds to compress a single minified jQuery file. This number is based on a very small subset of libraries but is not incorrect by a big margin as I was seeing this much gain on all of the websites that I tested. It costs significantly more in terms of CPU time. KB 21.24% D3.js

Cache 79

Cache Website Servers Open Source 79

Percona

DECEMBER 20, 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. AMD EPYC Performance Testing… or Don’t get on the wrong side of SystemD.

Database 40

Database Tuning Performance AWS 40