SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Rewrite some or all of the stored data to match the new definition. Improvements in SQL Server 2016. You get these undocumented improvements for free. ( SELECT.

Servers 63

Servers Database Testing Efficiency 63

SQL Performance

JULY 19, 2022

The simplest definition of a log record: it describes a single change to a database. You can read a bit more about rollbacks in my article A Complete Introduction to SQL Server Transactions on the SentryOne blog, and I’ll cover them in depth in the next article. What Are Log Records? Log Record Types.

Servers 94

Servers Database Storage Engineering 94

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. is out , I thought it might be time to do a bit of testing myself.

Servers 95

Servers C++ Testing Systems 95

Dynatrace

MAY 12, 2022

The title size of a tile has been moved from the dashboard definition to the dashboard metadata definition and included in the advanced settings UI for dashboards. Fixed an issue with “500 Internal Server Error” response of Anomaly detection – Disk events API. (APM-370270). Dashboards. Dynatrace API.

Tuning 198

Tuning Metrics Cloud Mobile 198

Smashing Magazine

AUGUST 10, 2023

Running A Page Speed Test: Monitoring vs. Measuring Running A Page Speed Test: Monitoring vs. Measuring Geoff Graham 2023-08-10T08:00:00+00:00 2023-08-10T12:35:05+00:00 This article is sponsored by DebugBear There is no shortage of ways to measure the speed of a webpage. That’s where a tool like DebugBear makes a lot of sense.

Speed 81

Speed Monitoring Testing Network 81

Testsigma

JULY 23, 2020

Let’s briefly describe the basic definitions of each of them first and then describe in detail the underlying differences that make them fall apart in certifying the quality of each of them. By just updating the application on the remote server, all the users can have access to the updated application.

Testing 63

Testing Internet Internet Latency 63

Percona

JULY 19, 2023

I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server. Retrieve the admin password to log in using the CLI: argocd admin initial-password -n argocd Login to the server. Server Side sync Percona relies on OpenAPI v3.0 Server Side sync Percona relies on OpenAPI v3.0

Servers 77

Servers Best Practices DevOps Open Source 77

Testsigma

MAY 14, 2021

Cloud-based testing has become quite integral these days. Most businesses have already done the shift towards cloud-based testing. The traditional testing that was done on the software installed on local servers is now slowly fading away. Cloud-based testing comprises cloud-based test automation as well.

Cloud 67

Cloud Testing Testing Tools Internet 67

The Netflix TechBlog

JUNE 13, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 2 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Picture yourself enthralled by the latest episode of your beloved Netflix series, delighting in an uninterrupted, high-definition streaming experience. This is where large-scale system migrations come into play.

Traffic 279

Traffic Metrics Systems Strategy 279

Testsigma

SEPTEMBER 23, 2021

Cross-browser testing is performed to be sure that your product is working as expected on the various device, platform, and browser (and their versions) combinations that your customers might be using. However, the pain and efforts associated can be reduced, if the cross-browser testing is cloud-based. Reference: [link].

Cloud 96

Cloud Testing Infrastructure Internet 96

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. So, given a table_id, how do you get the table schema/definition? ibd in the test directory.

Cache 84

Cache Benchmarking Servers Design 84

The Netflix TechBlog

MAY 19, 2023

Netflix application identities are fundamentally attribute based: e.g. an instance of the Data Processor runs in eu-west-1 in the test environment with a public shard. The community’s excitement and interest became apparent through comments, reactions, and conversations on the SpiceDB Discord server. with which to experiment.

Cache 249

Cache Google Open Source Systems 249

SQL Performance

SEPTEMBER 29, 2021

A common requirement in ETL and various reporting scenarios is to quietly load a SQL Server staging table in the background, so users querying the data aren’t impacted by the writes and vice-versa. Refreshing Tables in SQL Server. SQL Server Partition Switching Example. definition , 500 ) FROM sys. session_id , o.

Servers 55

Servers Games Database Processing 55

Percona

OCTOBER 13, 2023

Let’s test it with InnoDB using the ibd2sdi tool. root@db3-node test]# ibd2sdi transaction_processing_flag.ibd -d transaction_processing_flag.sdi [root@db3-node test]# ls -lrth | grep transaction_processing_flag -rw-r --. 1 mysql mysql 0 Sep 18 08:15 test_table.MYD [root@db3-node test]# RocksDb also supports SDI.

Storage 91

Storage Database Engineering Open Source 91

Percona

SEPTEMBER 6, 2023

Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is. MySQL’s definition is a little more convoluted, stating that in MySQL versions 8.0.13 Well, there is always a drawback to having the server do something complicated for you.

Speed 80

Speed Virtualization Storage Open Source 80

Alex Podelko

OCTOBER 18, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. While agile development / DevOps become mainstream nowadays, their integration with performance testing is just making first steps. – Cloud.

Performance Testing 100

Performance Testing Testing Performance DevOps 100

The Netflix TechBlog

JULY 30, 2019

This allows us to proactively push changes to the open source version while ensuring that the changes are fully functional and well-tested. Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix. The ability to dynamically create and execute workflows removes this friction.

Lambda 189

Lambda Media Open Source Metrics 189

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. The same tests have been executed in Percona Server for MySQL 5.7 Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 98

Cache Hardware Servers Benchmarking 98

Alex Podelko

OCTOBER 28, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Quite often the whole area of load testing is reduced to pre-production testing using protocol-level recording/playback. – Cloud.

Performance Testing 100

Performance Testing Technology Technology Testing 100

The Netflix TechBlog

FEBRUARY 3, 2021

Instead, the schema gets generated at runtime based on definitions in code. Another key feature is support for lightweight query tests. These tests allow you to execute queries without the need to work with the HTTP endpoint. The tests look and feel like plain JUnit tests.

Open Source 246

Open Source Java Architecture Metrics 246

The Netflix TechBlog

OCTOBER 7, 2021

At Netflix, we have significant investments in ensuring new versions of our applications are well tested. However, Netflix is available for streaming on thousands of types of devices and it is powered by hundreds of micro-services which are deployed independently, making it extremely challenging to comprehensively test internally.

Metrics 197

Metrics Mobile Testing Strategy 197

Percona

SEPTEMBER 19, 2023

The effort has definitely paid off, as we can release shortly after upstream. To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. We’re hoping to share some good news in this regard and provide an MVP for all of you to try and test by the end of this year.

Availability 106

Availability Open Source Database Servers 106

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Another major trend is using multiple third-party components and services, which may be not easy to properly incorporate into testing. – Cloud.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Percona

JULY 25, 2023

You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. When testing the speed of XtraBackup streaming, we can see a limitation of around 1.8 When it comes to backups, there are several options for saving backup files. FIFO ( 8 pipes) – Utilized 1.15

Storage 76

Storage Speed Open Source Servers 76

CSS Wizardry

DECEMBER 9, 2023

Once you’ve run a test, you can head to a Connection View of the waterfall which shows a diagram comprising entries per origin, not per response: Note that some connections are actually shared across more than one domain: this is HTTP2’s connection coalescence , available when origins share the same IP address and certificates.

Speed 234

Speed Network Analytics Availability 234

Percona

APRIL 4, 2023

” While this is definitely a valid use case, I hadn’t personally come across an issue in the wild where the application fix wasn’t trivial. To quickly set up the environment, ProxySQL was installed locally on the host running pt-archiver and set up with a single backend (the target testbed server). OR (`id` = ?

Open Source 104

Open Source Servers Engineering Scalability 104

Dynatrace

AUGUST 16, 2019

As microservices and automation continue to drive API usage, most organizations have either already introduced, or plan to introduce, an API testing process. With Dynatrace Synthetic you can easily create API tests with synthetic monitors. Now we’re making it easier for you to test APIs that are secured by OAuth 2.0!

Monitoring 157

Monitoring Tuning Google Cloud 157

Testsigma

APRIL 23, 2021

With the increased usage of smartphones in recent years, enterprises and the software industry now have to cater their applications to mobile devices for web testing in addition to desktops. and are deployed using a web server. Now, the developer has developed a new complex feature and tests the application again.

Mobile 52

Mobile Testing Testing Tools Programming 52

Scalegrid

JANUARY 20, 2020

This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application performance for MongoDB , MySQL and PostgreSQL. The ‘follower’ system is writable, so you can use it as a staging environment to test your application changes. Data Analytics.

Analytics 185

Analytics Storage Database Systems 185

The Netflix TechBlog

AUGUST 22, 2019

Artisan Crafted Images In the Netflix full cycle DevOps culture the team responsible for building a service is also responsible for deploying, testing, infrastructure, and operation of that service. The configuration file, referenced scripts, and artifact dependency definitions all live in an internal git repository.

DevOps 207

DevOps AWS Tuning Infrastructure 207

MachMetrics

JUNE 1, 2020

In fact, failing to run a mobile page speed test is the number 1 speed testing mistake we see our users make! We’ll show you how to run a mobile page speed test with MachMetrics.com, and how to make improvements based on your results. We encourage you to test your site out on slower connection speeds as well!

Speed 67

Speed Mobile Testing Google 67

Smashing Magazine

JULY 18, 2022

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. Segmented Rendering is a new pattern for the Jamstack that lets you personalize content statically, without any sort of client-side rendering or per-request Server-Side Rendering.

Cache 115

Cache Website Energy Servers 115

Testsigma

FEBRUARY 3, 2021

Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? To answer all these questions we need exhaustive mobile testing in place. Let us have a look at the most popular types of mobile testing for applications and hardware. Functional Testing. Usability Testing.

Mobile 82

Mobile Testing Hardware C++ 82

SQL Performance

FEBRUARY 10, 2021

I’ll do my testing in tempdb, enabling IO and TIME statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS IO , TIME ON ; The fastest solution from last month applies a join with a dummy table that has a columnstore index to get batch processing. Fastest solution so far. Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo.

C++ 124

C++ Servers Testing Code 124

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

Dynatrace

MAY 28, 2020

Keptn uses SLO definitions to automatically configure Dynatrace or Prometheus alerting rules. After a new build gets deployed and automated tests executed, SLIs are evaluated against their SLOs and, depending on that result, a build is considered good (promoted) or bad (rolled back). “ This is what this blog is all about.

Engineering 195

Engineering Performance Metrics Best Practices 195