SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers. Certain sizes also support premium storage, which should be a requirement for a production SQL Server.

Azure 76

Azure Benchmarking Storage Virtualization 76

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

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. With the ever-increasing and evolving sector of Android users, Android device testing is of the essence. . Why Is Android Device Testing Important?

Testing 52

Testing Mobile Testing Tools Strategy 52

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

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

Percona

MAY 1, 2023

Load balancing and replication: Scaling the database system horizontally by distributing the workload across multiple servers using techniques like connection pooling, read replicas, or implementing a primary-replica replication setup. For testing purposes, let’s increase this to 256MB and see if there is any impact on cost.

Tuning 52

Tuning Efficiency Database Performance 52

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

Smashing Magazine

FEBRUARY 15, 2021

To figure out what exactly is the problem, we can use FFMPEG , which is open source and free, and proves to be one of the most reliable tools to optimize videos. In FFMPEG, the principal quality/size benchmark is the Constant Rate Factor (CRF) compression, with values ranging from 0 (no compression) to 50 (high compression).

Network 143

Network Speed Website Mobile 143

Speed Curve

JULY 2, 2013

SpeedCurve focuses on a third which I like to call web performance benchmarking. These services often check from various geographic locations to keep an eye on network routes to your server and will send you alerts via email and txt if your website is down. Web Performance Benchmarking. Uptime Monitoring. Real User Monitoring.

Benchmarking 40

Benchmarking Performance Website Analytics 40

Percona

AUGUST 31, 2018

Bear in mind that while optimizing PostgreSQL server configuration improves performance, a database developer must also be diligent when writing queries for the application. For testing purposes, let’s increase this to 256MB and see if there is any impact on cost. That said, you obviously do not want to reserve all RAM for PostgreSQL.

Tuning 57

Tuning Database Performance Benchmarking 57

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 228

Architecture Artificial Intelligence Cloud Open Source 228

Rigor

SEPTEMBER 11, 2019

Sergey is an open source developer, tireless educator on performance topics, and author of many web performance-related tools, including ShowSlow , SVN Assets , drop-in.htaccess and more. The future of HTTP/2 server push. He tweets about Chrome initiatives, open source tools, and performance news @ paul_irish.

Performance 89

Performance Education Google Website 89

Smashing Magazine

MARCH 2, 2021

The State Of Mobile And Why Mobile Web Testing Matters. The State Of Mobile And Why Mobile Web Testing Matters. This goes way beyond basic optimizations such as color contrast and server response times. And to ensure the quality of a product, we always need to test — on a number of devices, and in a number of conditions.

Mobile 133

Mobile Testing Website Benchmarking 133

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

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 as your application grows and more clients connect to the database, pgpool-II can distribute the load across multiple servers, preventing any one server from becoming overwhelmed.

Cache 116

Cache Open Source Benchmarking Database 116

KeyCDN

OCTOBER 2, 2018

Its blog articles will definitely come in handy as your projects scale, but they’re also great reading for those who simply want to understand the philosophies behind specific dev practices in the front end or server side. If you frequently rely on Pens to test ideas, this blog is a must-read for its highlights of new functionalities.

Development 75

Development Website Design Code 75

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? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 137

Tuning Cache Servers Benchmarking 137

Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 110

Availability Database Open Source Hardware 110

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. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 127

Performance Hardware Tuning Storage 127

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

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

Percona

AUGUST 22, 2023

We’ll wrap it up by suggesting high availability open source solutions, and we’ll introduce you to support options for ensuring continuous high performance from your systems. Load balancing: Traffic is distributed across multiple servers to prevent any one component from becoming overloaded.

Availability 80

Availability Hardware Open Source Database 80

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

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? Similarly for SQL Server TPM records Batches/sec which is the same value seen in the Activity Monitor in SSMS. and earlier. <benchmark>

C++ 52

C++ Benchmarking Metrics Database 52

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. In fact all of this source code is also included in readable form with each and every release. MS SQL Server/Linux and Windows. Oracle /TimesTen. Oratcl 4.6.

Architecture 40

Architecture Virtualization Open Source C++ 40

CSS - Tricks

JUNE 5, 2020

It took a few months for major CDN players to support Brotli, but meanwhile it was seeing widespread adoption in tools, services, browsers and servers. In my benchmarks, Brotli:11 takes several hundred milliseconds to compress a single minified jQuery file. I put my fears aside and built Brotli:11 as a configurable server option.

Cache 79

Cache Website Servers Open Source 79

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. Testing and Validation : Thorough testing and validation are essential when working with triggers, especially in a production environment.

Cache 62

Cache Database Games Healthcare 62

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. I guessed that maybe ChatGPT only knew about v2 since it was trained on open-source code from before September 2021 (its knowledge cutoff date) and v2 was the dominant format before that date.

Programming 98

Programming Code Design Benchmarking 98

Enprowess

SEPTEMBER 20, 2021

is a structural, open-source progressive JavaScript framework used to build complex UIs and single-page applications (SPAs). It is an open-source front-end library based on JavaScript used in web development for creating interactive components and User Interfaces. Server-Side Rendering. HTML templating vs JSX.

Open Source 52

Open Source Mobile Scalability Google 52

Smashing Magazine

JUNE 1, 2022

You’ve tested and retested the site for errors. These services use requests to external hosts (not servers you control) to deliver JavaScript framework libraries, custom fonts, advertising content, marketing analytics trackers, and more. They are more of a benchmark than a true measurement of real user experience.

Website 131

Website Design Network Best Practices 131

Rigor

OCTOBER 30, 2019

This allows your teams baseline, benchmark, review (including retroactively reviewing past data), report, and compare and contrast your data month-over-month or even year-over-year. ” But what if you want to test one of your web pages on a specific device running on a different network?

Google 51

Google Best Practices Energy Website 51

Percona

NOVEMBER 3, 2023

PostgreSQL Cluster One coordinator node citus-coord-01 Three worker nodes citus1 citus2 citus3 Hardware AWS Instance Ubuntu Server 20.04, SSD volume type 64-bit (x86) c5.xlarge 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

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

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. Today, the website is much faster and ranks highly in various showcases and benchmarks. Working with jewellerybox on its online store was a welcome change of pace for us. Large preview ).

Performance 115

Performance Cache Website Mobile 115

Smashing Magazine

JANUARY 11, 2021

Testing And Monitoring Auditing workflow, proxy browsers, 404 page, GDPR cookie consent prompts, performance diagnostics CSS, accessibility. You can then mimic the 90th percentile’s experience for testing. Networking, HTTP/2, HTTP/3 OCSP stapling, EV/DV certificates, packaging, IPv6, QUIC, HTTP/3. Quick Wins.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Testing And Monitoring. You can then mimic the 90th percentile’s experience for testing. Table Of Contents.

Performance 145

Performance Cache Network Metrics 145