Percona

JANUARY 11, 2024

In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones.Most importantly, we also had MySQL Router going back to being a level 7 proxy […]

Performance 87

Performance Benchmarking Availability Servers 87

Percona

MARCH 17, 2023

Percona’s co-Founder Peter Zaitsev wrote a detailed post about migration from Prometheus to VictoriaMetrics , One of the most significant differences in terms of performance of PMM2 comes with the usage for VM, which can also be derived from performance comparison on node_exporter metrics between Prometheus and VictoriaMetrics.

Monitoring 95

Monitoring Scalability Cache Database 95

The Morning Paper

AUGUST 29, 2019

use the TPC-H benchmark to assess Redshift, Redshift Spectrum, Athena, Presto, Hive, and Vertica to find out what works best and the trade-offs involved. We focused on OLAP-oriented parallel data warehouse products available for AWS and restricted our attention to commercially available systems. Key findings. Query restrictions.

Architecture 76

Architecture Cloud Storage Serverless 76

Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. Performance Comparison: Redis vs Memcached Although Redis and Memcached are high-performance in-memory data stores, their performance characteristics are distinct.

Cache 130

Cache Storage Scalability Architecture 130

Dynatrace

JANUARY 23, 2020

This breakout session will discuss the deployment models available for cloud implementations and how Dynatrace helps in iterating faster deployments. Using the Davis assistant for comparison and benchmarking. From big bang to progressive deployments. My session will cover various options, such as: Tagging different deployments.

Performance 35

Performance Benchmarking Innovation DevOps 35

Dareboost

JULY 18, 2019

A new version of our performance comparison reports has just been released. With an improved user experience and some additional data available, benchmarking your competition is now easier than ever!

Website Performance 55

Website Performance Benchmarking Website Performance 55

Speed Curve

JULY 2, 2013

SpeedCurve focuses on a third which I like to call web performance benchmarking. Uptime services like Pingdom and Uptime Robot ping your website with an HTTP request every couple of minutes to check that it's online and available. Web Performance Benchmarking. Uptime Monitoring. Real user monitoring dashboard on New Relic.

Benchmarking 40

Benchmarking Performance Website Analytics 40

Percona

JANUARY 19, 2023

sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> INSERT INTO employees_compressed SELECT * FROM employees; Size comparison: [user1] percona@db1: ~ $ sudo ls -lh /var/lib/mysql/employees/|grep employees -rw-r --. It is available under a paid subscription. 1 mysql mysql 704M Dec 30 02:28 employees.ibd -rw-r --.

Open Source 85

Open Source Storage Database Big Data 85

Percona

DECEMBER 20, 2018

I found the comparison of InnoDB vs. MyISAM quite interesting, and I’ll use it in this post. As the MyRocks storage engine (based on the RocksDB key-value store [link] ) is now available as part of Percona Server for MySQL 5.7 , I wanted to take a look at how it performs on a relatively high-end server and SSD storage.

Database 40

Database Tuning Performance AWS 40

DZone

FEBRUARY 27, 2021

As a Software Engineer, the mind is trained to seek optimizations in every aspect of development and ooze out every bit of available CPU Resource to deliver a performing application. One, by researching on the Internet; Two, by developing small programs and benchmarking. These include Python, PHP, Perl, and Ruby.

Java 207

Java C++ Benchmarking Programming 207

Percona

DECEMBER 11, 2023

We performed a standard benchmarking test using the sysbench tool to compare the performance of a DLV instance vs a standard RDS MySQL instance, as shared in the following section. Benchmarking AWS RDS DLV setup Setup 2 RDS Single DB instances 1 EC2 Instance Regular DLV Enabled Sysbench db.m6i.2xlarge 2xlarge c5.2xlarge MySQL 8.0.31

AWS 93

AWS Benchmarking Performance Traffic 93

Scalegrid

JULY 29, 2020

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! This is shared between all clients, so a pooled connection is available to all clients. High availability. PostgreSQL Connection Pooling Series.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Scalegrid

JUNE 4, 2020

Now, let’s take a look at the throughput and latency performance of our comparison. PostgreSQL Benchmark Setup. Here is the configuration we used for the ScaleGrid and DigitalOcean benchmark performance tests highlighted above: Configuration. Benchmark Tool. We used 50% reads and 50% writes in this comparison.

Database 230

Database Latency Benchmarking Performance 230

Percona

MARCH 20, 2023

In short, each cluster is, in reality, a single database with high availability and other functionalities built in. ProxySQL was penalized by the limited resources, but this was the game, we had to get the most out of the few available. Anyhow, we are here to talk about Proxies. MySQL Router was never in the game.

Games 118

Games Latency Traffic Cache 118

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

Daniel Lemire

FEBRUARY 8, 2019

It is a multiplication by a constant followed by a comparison of the result with said constant: it does not get much cheaper than that. We also published our benchmarks for research purposes. I make my benchmarking code available. It seems that compilers could easily apply such an approach. It tells a nice story.

C++ 279

C++ Benchmarking Hardware Testing 279

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. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 133

Tuning Cache Servers Benchmarking 133

Enprowess

SEPTEMBER 20, 2021

Talent availability. It has a vast community that explains online courses, many available tutorials, articles, and three times more questions on Stack overflow. Vue vs React: Talent Availability. Its documentation has set a benchmark that beats anything from react camp. In this article, I will compare React.js and Vue.js

Open Source 52

Open Source Mobile Scalability Google 52

Brendan Gregg

SEPTEMBER 25, 2021

As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result. I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 6. How long is each time call?

Speed 126

Speed Java AWS Virtualization 126

HammerDB

DECEMBER 9, 2020

NOPM should be considered the primary metric and is the only one that should be used for a cross database comparison. <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? . <benchmark>

C++ 52

C++ Benchmarking Metrics Database 52

Alex Russell

APRIL 29, 2021

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

Media Games Education Engineering 145

Adrian Cockcroft

JANUARY 20, 2023

Here’s some predictions I’m making: Jack Dongarra’s efforts to highlight the low efficiency of the HPCG benchmark as an issue will influence the next generation of supercomputer architectures to optimize for sparse matrix computations. In comparison, for Linpack Frontier operates at 68% of peak capacity. petaflops, which is 0.8%

Architecture 52

Architecture Latency Benchmarking AWS 52

Brendan Gregg

SEPTEMBER 25, 2021

As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result. I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. us on Ubuntu.

Speed 52

Speed Java AWS Virtualization 52

Rigor

FEBRUARY 19, 2020

For example, here is what a comparison report looks like in Rigor. Synthetic monitoring is one of the best ways to detect outages or availability issues since it actively tests your site from the outside. Competitive & Industry Benchmarking. Benchmarking your performance against your competitors and industries.

Monitoring 59

Monitoring Benchmarking Mobile Traffic 59

Brendan Gregg

SEPTEMBER 25, 2021

As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result. I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 7. us on Centos and 0.68

Speed 40

Speed Java AWS Virtualization 40

SQL Performance

AUGUST 27, 2019

The initial reviews and benchmarks for these processors have been very impressive: AMD EPYC 7002 Series Rome Delivers a Knockout. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked. TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

Speed Curve

DECEMBER 25, 2013

There are plenty of automated front-end optimisation tools available like modpagespeed and CloudFlare but being a bit old-school and craft-orientated I prefer the ability to control the load order and optimise not only the individual assets but their sequencing as well. Control and branch the loading of CSS and JS. Source: SpeedCurve.

Performance 60

Performance Mobile Website Benchmarking 60

Speed Curve

JANUARY 31, 2018

Here's how to set up ongoing competitive benchmarking and generate comparison videos. One excellent practice that's used effectively by companies like Lonely Planet and Ticketmaster is to have monitors mounted in open areas of their offices, displaying key performance stats and comparison videos.

Performance 40

Performance Metrics Traffic Monitoring 40

Smashing Magazine

JUNE 26, 2019

You can see in his example that he suggests a number of optimizations, like limiting which styles and character sets are available for use on the website. When compared against Arial, a web-safe font that isn’t pulled from an external source, this is what happened: A comparison of loading speeds between Arial and Open Sans.

Website 110

Website Speed Mobile Design 110

ScaleOut Software

MAY 15, 2014

Well, performance comparisons aren’t so easy since the AppFabric license agreement states: “You may not disclose the results of any benchmark tests of the software to any third party without Microsoft’s prior written approval.” Use Fully Peer-to-Peer Design for Simplicity and High Availability. Testing Scale-Up Performance.

Cache 40

Cache Servers Network Design 40

HammerDB

OCTOBER 12, 2018

For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench. GHz available cpufreq governors: performance powersave . HammerDB difference from Sysbench. hardware limits: 1000 MHz - 3.80

Best Practices 40

Best Practices Scalability Performance C++ 40

Alex Russell

MAY 9, 2022

It's challenging for teams climbing the maturity ladder to sift through the many available browser and tool-vendor data points to understand which ones to measure and manage. Treating data as a distribution fundamentally enables comparison and experimentation because it creates a language for describing non-binary shifts.

Performance 86

Performance Latency Metrics Engineering 86

John McCalpin

JANUARY 22, 2018

Since “peak performance” for the processor is two (512-bit SIMD) FMA instructions per cycle, any instructions that are not FMA instructions subtract directly from the available peak performance. If this reduces the required concurrency to less than the number of available rename registers, full performance should be obtained.

Latency 40

Latency Hardware Code Testing 40

Scalegrid

JULY 13, 2020

Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services. Not available. Not available. Not available. Comparison Overview. See how open source PostgreSQL Community version costs compare to Oracle Standard Edition and Oracle Enterprise Edition. Compare Functionality. PostgreSQL.

Open Source 244

Open Source Tuning C++ Database 244

SQL Server According to Bob

JANUARY 11, 2020

​​ Various defragmentation ​​ utilities ​​ are ​​ available ​​ on the market today. Therefore, the database can have pages in any one of the three available verification states. SQL Server uses read-ahead logic to avoid query stalls caused by I/O waits.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 11, 2021

Alternatively, you can also use: Addy Osmani’s Chrome UX Report Compare Tool , Speed Scorecard (also provides a revenue impact estimator), Real User Experience Test Comparison or SiteSpeed CI (based on synthetic testing). Layout Shift GIF Generator that visualizes CLS with a simple GIF (also available from the command line).

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

Alternatively, you can also use Speed Scorecard (also provides a revenue impact estimator), Real User Experience Test Comparison or SiteSpeed CI (based on synthetic testing). Paddy Ganti’s script constructs two URLs (one normal and one blocking the ads), prompts the generation of a video comparison via WebPageTest and reports a delta.

Performance 145

Performance Cache Network Metrics 145