Remove c
article thumbnail

Matching Supply With Demand — Solutions, Part 3

SQL Performance

The tricky part about this solution is its performance degrades as the largest interval length increases. 1 D 5.000000 2 D 3.000000 3 D 8.000000 5 D 2.000000 6 D 8.000000 7 D 4.000000 8 D 2.000000 1000 S 8.000000 2000 S 6.000000 3000 S 2.000000 4000 S 2.000000 5000 S 4.000000 6000 S 3.000000 7000 S 2.000000. seconds to complete.

C++ 138
article thumbnail

Matching Supply With Demand Challenge

SQL Performance

It's a pretty common need in real life; it's simple to describe, and it's quite easy to solve with reasonable performance using a cursor-based solution. When Peter sends me a puzzle, I typically respond with a suggested solution, and he usually comes up with a better-performing, brilliant solution. L0 AS ( SELECT 1 AS c.

C++ 133
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

Performing an operation is always challenging when dealing with K8s. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async replication is in use, perform changes on replicas and failover. You can just connect to the MySQL service POD and perform the ALTER. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

article thumbnail

Dealing With “Too Many Connections” Error in MySQL 8

Percona

21 Percona Server (GPL), Release 21, Revision c59f87d2854 Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement.

C++ 90
article thumbnail

AIOps and digital transformation modernize BT

Dynatrace

Data indicates that increasingly C-level executives recognize the importance of joining AIOps and digital transformation. According to an IDC report, for example, 90% of global 2000 CIOs will use AIOps technologies and automated remediation to improve cost and performance metrics as well as resiliency and agility.

Cloud 206
article thumbnail

Is Thread Pool Plugin the Right Choice for Your Workload?

Percona

TL&DR : Depending on the workload, the thread pool plugin can cause serious performance drops. In each situation, I’ve seen huge drops in the performance where the QPS were going to almost zero. After removing the thread pool plugin from the clusters, the performance was more steady, even when running these queries.

article thumbnail

Web Performance Bookshelf

Rigor

Reading time 1 min Why share the library of the web performance books while there’s a substantial collection of fantastic websites and articles on the net? High Performance Browser Networking. This book is about performance problems and the various technologies created to fight them. High Performance Websites.