SQL Performance

APRIL 13, 2022

To test the performance of your solution, you’ll need to populate the table with larger volumes of sample data. numgroups AS INT = 1000 , @rowspergroup AS INT = 10000 , -- test with 1000 to 10000 here. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise. uniquevalues AS INT = 5 ; ALTER TABLE dbo.

C++ 136

C++ Strategy Testing Servers 136

The Netflix TechBlog

MAY 4, 2023

This blog post will provide a detailed analysis of replay traffic testing, a versatile technique we have applied in the preliminary validation phase for multiple migration initiatives. In this testing strategy, we execute a copy (replay) of production traffic against a system’s existing and new versions to perform relevant validations.

Traffic 339

Traffic Latency Tuning Systems 339

DZone

DECEMBER 3, 2019

Automate Appium Java Tests In Parallel. The beauty of Appium for mobile testing is that its tests can be written in any programming language including Python, Ruby, Java, JavaScript, and C#. You may also like: How to Run a Selenium Test With TestNG. What Is and Why to Use TestNG?

Java 130

Java Testing C++ Programming 130

DZone

JANUARY 29, 2021

What do you think about cross-browser testing ? In theory, cross-browser testing can help companies catch product defects before products get released to customers. But the legacy approach – setting up a bunch of parallel devices and running tests across each – incurs significant engineering skill and resource cost.

Efficiency 140

Efficiency Testing Operating System Engineering 140

Scalegrid

MAY 22, 2020

If your master is running in non-GTID mode, you will get this error from Ripple: Failed to read packet: Got error reading packet from server: The replication sender thread cannot start in AUTO_POSITION mode: this server has GTID_MODE = OFF instead of ON. Issue when using parallel replication for the slaves of Ripple server.

Servers 262

Servers Transportation Database Availability 262

Percona

JULY 25, 2023

When testing the speed of XtraBackup streaming, we can see a limitation of around 1.8 28 introduces a new datasink for true parallel streaming. This new datasink utilizes FIFO (named pipes) to achieve true parallelism to stream data from XtraBackup to xbcloud. FIFO Datasink Percona XtraBackup 8.0.33-28

Storage 79

Storage Speed Open Source Servers 79

Dynatrace

JULY 11, 2023

The example workflow below is triggered every Monday at 8:00 AM to provide a capacity report for all the disks that will likely run out of space within the next week. In this example, two parallel actions are defined. One action sends out an email notification; the other raises a Davis problem for each violating disk.

Metrics 212

Metrics Games Analytics Network 212

John McCalpin

APRIL 25, 2023

This post is about a secondary performance characteristic — sustained memory bandwidth for a single thread running on a single core. This metric is interesting because we don’t always have the luxury of parallelizing every application we run, and our operating systems almost always process each call (e.g.,

Benchmarking 97

Benchmarking Cache Latency Tuning 97

Percona

SEPTEMBER 25, 2023

In this blog post, we’ll explore a technique to help your backup strategy: running pgBackRest’s expire and backup processes in parallel while utilizing custom lock-file paths. This can result in conflicts when these processes run in parallel. Percona and PostgreSQL work better together.

Database 96

Database Open Source Storage Servers 96

Scalegrid

JULY 8, 2020

Our Redis™ customers who have Lua scripts deployed often report this error – “ BUSY Redis is busy running a script. This is the maximum allowed time (in ms) that the script is allowed to run. This is a really long time for CPU-bound activity (scripts have limited access and can’t run commands that access the disk).

Servers 239

Servers Database Availability Monitoring 239

Dynatrace

JANUARY 31, 2022

On the left side of the loop, teams plan, develop, and test software in pre-production. Shift-left is the practice of moving testing, quality, and performance evaluation early in the software development process, thus the process of shifting to the “left” side of the DevOps lifecycle.

DevOps 210

DevOps Testing Monitoring Speed 210

Dynatrace

JANUARY 31, 2022

On the left side of the loop, teams plan, develop, and test software in pre-production. Shift-left is the practice of moving testing, quality, and performance evaluation early in the software development process, thus the process of shifting to the “left” side of the DevOps lifecycle.

DevOps 204

DevOps Testing Monitoring Speed 204

Testsigma

DECEMBER 19, 2020

Regression testing is one of the most critical aspects of quality assurance. It goes without saying that adopting effective regression testing strategies can save development teams hundreds of hours of debugging. Before taking up the task of regression testing, the team needs to define the test framework that they plan to use.

Testing 94

Testing Testing Tools Code Cloud 94

SQL Performance

MARCH 30, 2021

This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. This first part covers the role of the parent task (coordinator) in preparing the plan for parallel execution. To provide a concrete basis for the analysis, we will follow how a particular parallel query starts execution.

Cache 98

Cache Servers Operating System Processing 98

Scalegrid

JULY 29, 2020

If we require N parallel connections, this forks N child processes. Performance Testing. So, we pitted the two connection poolers head-to-head, using the standard pgbench tool, to see which one provides better transactions per second throughput through a benchmark test. Testing Conditions. Resource consumption.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Dynatrace

MAY 21, 2021

If you are wondering what a service mesh is and whether you would benefit from having one, you likely have a mature Kubernetes environment running large cloud-native applications. Kubernetes orchestrates ready-to-run software packages (containers) in pods, which are hosted on nodes (compute instances) that are organized in clusters.

Traffic 250

Traffic DevOps Infrastructure Network 250

Testsigma

JULY 6, 2021

Having a coded approach to test automation has its benefits. It certainly does give you the power to be extra flexible in terms of test case creation. No code automation testing is an alternate approach that might be suitable for you and give you ROI sooner, providing few conditions are met. Too many repetitive regression tests.

Code 108

Code Testing Testing Tools Mobile 108

Testsigma

AUGUST 12, 2021

The Importance of Testing Web Applications. To ensure our web app performs as intended across various devices and browsers — we have to test our web app. Plus, if we’re adding features like live chat, forms, e-commerce integrations, push notifications, and the like, our app should go through some heavy testing.

Testing 102

Testing Testing Tools Mobile Cloud 102

Dynatrace

MARCH 16, 2021

Within the Terraform CLI, users can instrument code to build and run Dynatrace monitoring for the services they’ll deploy from the same CLI. Service metadata, run location of services, response time, or SLO’s). It has now become a parallel exercise in the same CLI. It has now become a parallel exercise in the same CLI.

Code 244

Code Monitoring Best Practices Infrastructure 244

SQL Performance

MARCH 9, 2022

I tested all solutions in this article against the Auctions input table with 100K, 200K, 300K, and 400K rows, and with the following indexes: -- Index to support solution. ID ROWS UNBOUNDED PRECEDING ) AS Running FROM dbo. ID ROWS UNBOUNDED PRECEDING ) AS Running FROM dbo. Running , S. Running , S.

C++ 138

C++ Code Efficiency Performance 138

Testsigma

DECEMBER 12, 2020

Cross browser testing can be a real headache for a software tester. You may have tested your application on the latest versions of Chrome, Firefox, and Edge, but more often than not, some browsers such as Internet Explorer, Opera Mini, UC Browser get missed out. Cross-Browser Testing Abilities. Parallel Test Execution.

Testing Tools 93

Testing Tools Testing Operating System Internet 93

Dynatrace

NOVEMBER 10, 2022

Containers are portable, self-contained operating environments that include applications and the dependencies they need to run, such as databases, middleware, and frameworks. Organizations can shift development, testing, and delivery as needed between teams and geographies. Large applications take time to start and may run slowly.

Cloud 162

Cloud Architecture Serverless Infrastructure 162

Testsigma

SEPTEMBER 8, 2021

If I consider current times, it has become a core concept in development, management, analytics, and also – automation testing. Cloud-based automation testing is a simple concept. We leverage cloud resources to accomplish our automation testing goals in the project. If not, it is recommended to go through this post first.

Cloud 76

Cloud Testing AWS Testing Tools 76

SQL Performance

OCTOBER 4, 2022

Parallelism. Parallelism adds an extra layer of complexity because both lock counts are maintained per thread. There are two underlying reasons for this: Each additional parallel worker thread operates inside a nested sub-transaction with the original transaction as its parent. Test 3—20,000 rows at DOP 4. LockTest AS LT.

Testing 56

Testing Processing Servers Engineering 56

Testsigma

MAY 5, 2021

When we write scripts for one browser, they may not necessarily run on all browsers. For instance, if we design features that run on Safari on Mac OS, those features may not function across other browsers. Let us understand the importance of multi-browser testing before we proceed. Best Multi-browser Testing Tools.

Testing Tools 74

Testing Tools Testing Internet Internet 74

Percona

JULY 6, 2023

Very little can be more annoying and frustrating for users than poor performance, meaning long-running queries and high response times at the front end. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice. Next is the table definition.

Best Practices 92

Best Practices Tuning Database Testing 92

Testsigma

JANUARY 31, 2022

We’re thrilled to announce the launch of Testsigma Community Edition , the first ever open source test automation platform that works out of the box for web and mobile apps, and APIs. This includes an integrated automation engine, test development and test runner modules, and some cool new customization features.

Open Source 81

Open Source Mobile Scalability Testing 81

SQL Performance

MARCH 17, 2020

Test Environment. It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The cost threshold for parallelism is set to 50.

Servers 86

Servers Tuning Database Efficiency 86

Percona

SEPTEMBER 19, 2023

For example: mysql> SET GLOBAL innodb_redo_log_archive_dirs='label1:directory_path1[;label2:directory_path2;…]'; Now, first, we are going to demonstrate to you how we tested the new InnoDB redo log archiving on Percona Server for MySQL 8.0.33-25 Create new directories for storing redo log archives. We will be using version 8.0.34-29

C++ 107

C++ Servers Storage Speed 107

Testsigma

OCTOBER 15, 2021

In general, most websites or web apps run into errors because of a solitary reason: solid cross-browser testing isn’t performed. When you perform cross-browser testing, you validate visual elements and ensure all functional and non-functional aspects of the website are consistent across different browsers.

Testing 52

Testing Testing Tools Analytics Website 52

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). There is a key distinction here between parallelism and concurrency. Database benchmarking in parallel. and the following from TPROC-H.

Programming 67

Programming Benchmarking Virtualization C++ 67

Testsigma

FEBRUARY 11, 2021

Cross Browser Testing also known as cross browser compatibility testing is all about creating a consistent experience for users across all browsers – but the question is how do you do that efficiently? Cross Browser compatibility testing helps us to pin-point compatibility errors which helps the developers to debug them quickly.

Testing Tools 93

Testing Tools Testing Efficiency Cloud 93

The Morning Paper

NOVEMBER 15, 2020

The Full Matcher runs on the CPU, polling a ring buffer populated by the DMA Engine. The FPGA hardware really wants to operate in a highly parallel mode using fixed size data structures. The key insight in Pigasus is that some tests can be done very cheaply in terms of time and memory, while others are more memory intensive.

Servers 128

Servers Hardware Latency Design 128

Percona

SEPTEMBER 15, 2023

In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 mariadb.list # [info] Adding trusted package signing keys. # [info] Running apt-get update… # [info] Done adding trusted package signing keys root@deb11m8m:~# root@deb11m8m:~# apt-get install mariadb-server mariadb-backup Reading package lists.

Servers 103

Servers C++ Processing Testing 103

Percona

OCTOBER 20, 2023

To do this, open a terminal and run the following SQL query: “SELECT version();” This will display the version of Percona PostgreSQL installed on your system. Make sure you run these commands with the “postgres” user, also on all three Percona Distribution for PostgreSQL nodes. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 94

Scalability Database Open Source Operating System 94

Percona

APRIL 26, 2023

A physical restore is essentially copying data files to the target nodes and starting a database with that data catalog, while logical means copying data and running insert operations on the database, which brings overhead on parsing data, building indexes, etc. So we decided to try parallel (concurrent) download. But can we do better?

Speed 81

Speed Storage AWS Azure 81

Testsigma

SEPTEMBER 23, 2021

The whole point of cross-browser testing is to deliver consistent user experiences across various browsers. When we build websites or web apps, some of their features aren’t compatible with some browsers; with cross-browser testing, we can ensure uniform experiences. 3 Top Tools for Automated Cross-browser Testing.

Testing 52

Testing Analytics Testing Tools Website 52