Adrian Cockcroft

JUNE 2, 2023

What I learned at GlueCon 2023 — Tipping Points and Generative AI The final slide of my GlueCon keynote featuring a sunset over a pool in Maui — picture by Adrian I’ve presented at GlueCon many times over the last decade or so. It’s big enough to be interesting but not too big (this year had fewer attendees than some in the past).

Social Media 98

Social Media Innovation Open Source Entertainment 98

Percona

SEPTEMBER 12, 2023

In this blog post, I will delve into the most important things to consider while preparing a schema change. sec) Metadata locks There are several blog posts about this locking mechanism and the common problems you may encounter when executing schema changes. How can you define if a table is small, medium, or large?

Database 84

Database Traffic Open Source Monitoring 84

Testsigma

OCTOBER 28, 2021

He has dabbled in software development, testing, and automation, and often shares his learnings in his blog. Let’s find the one tool to solve all of our problems.” Without all three, adopting test automation will just be an uphill battle. Without all three, adopting test automation will just be an uphill battle.

Engineering 96

Engineering Hardware Software Engineering Testing 96

Sutter's Mill

JULY 25, 2019

In addition to summing your votes per-paper, I also spent several hours manually assigning categories to the individual proposals so that we could see votes per-feature area. ’ Bias: I posted the poll on my personal blog, which could bias results in favor of my proposals. The following are some highlights.

C++ 98

C++ Programming Network Efficiency 98

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8. As we approach end of life for MySQL 5.7

Open Source 88

Open Source Best Practices Servers Database 88

Percona

NOVEMBER 3, 2023

We covered these complexities in greater detail in our blog post “ From Proprietary to Open Source: The Complete Guide to Database Migration,” but, in short , you must consider: Pre-migration planning: What are your purposes and objectives? Deployment and rollout: Will you roll out gradually or all at once?

Database 81

Database Open Source Benchmarking Strategy 81

Dynatrace

JUNE 18, 2019

In my colleague Andi Grabner’s recent blog on Automated Deployment and Architectural Validation, he notes that, based on a recent ACM survey , validating deployment still seems to be a semi-automated task for most software delivery teams. My four favorite things about Concourse. Dynatrace news.

Architecture 126

Architecture DevOps Open Source Java 126

Percona

OCTOBER 31, 2023

We received an alert of this kind on PS-primary-2 : Last_SQL_Errno: 1032 Last_SQL_Error: Could not execute Update_rows event on table foo.persons; Can't find record in 'persons', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000360, Starting checksum. Starting checksum. And how can this be possible?

Database 100

Database Servers Efficiency Performance 100

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Loki is a log aggregation tool developed by Grafana Labs. Verify that Loki and Promtail is configured properly.

Monitoring 84

Monitoring Servers Metrics Database 84

Smashing Magazine

JULY 1, 2021

All right, but what does this have to do with testing? In this article, I’ll tell you the pitfalls I’ve run into in my career — some of which were my fault. In this article, I’ll tell you the pitfalls I’ve run into in my career — some of which were my fault. Front-End Testing Traps.

Testing 120

Testing Best Practices Code Design 120

Adrian Cockcroft

JANUARY 29, 2023

A later version of the slides is included in my Microservices Workshop deck from later that year, slides 168–200 ( pdf , keynote are available in GitHub.com/adrianco/slides ). The common way to deal with this is to measure percentiles, and track the 90%, 99% response times for example. Response times are a one sided distribution.

Lambda 98

Lambda Latency Cache C++ 98

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. Assuming that there is already a Secrets object holding all system user passwords, the concept is really simple.

Database 93

Database Performance C++ Engineering 93

Official Blog - World Web Technology

NOVEMBER 16, 2023

Online presence is the need of the hour for all industry sizes, whether small businesses or multinational organizations. Several companies in the market today offer IT services such as design, development, e-marketing, content management, and more. Why hire dedicated web developers for your upcoming project? There’s a difference!

Social Media 59

Social Media Mobile Website Energy 59

Testsigma

JANUARY 29, 2021

That’s not all, the global mobile traffic is expected to increase sevenfold between 2017 and 2022. With a plethora of mobile devices, it becomes a daunting task to offer the best experience on all mobile devices. As per April 2019 data of Statistica[1], the global mobile population accounted for 4 billion unique users.

Website 98

Website Mobile Testing Strategy 98

Percona

MARCH 3, 2023

I tried to run the DELETE command, which gave me this error: Cannot delete or update a parent row: a foreign key constraint fails. At first glance, the error message was obviously clear: the table from which rows were to be deleted had a child table, which prevented the execution of the DELETE directly. What does all this imply?

Database 97

Database Testing Servers Open Source 97

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. docker-entrypoint."

Scalability 57

Scalability Best Practices Servers Database 57

Brendan Gregg

JUNE 3, 2021

I was an independent performance consultant and Sun Microsystems had just released DTrace, a tool that could instrument all software. Perhaps there was some internal project that was consuming all their DTrace expertise? This was going to be big, and would likely blow away my earlier DTrace work. DTraceToolkit v0.96

Open Source 40

Open Source Code Engineering Technology 40

Dynatrace

MARCH 11, 2021

It’s been a while since my last blog article on managing Dynatrace Managed at scale. Sorry for the readers who kept waiting for the next part – thanks for all the feedback and questions I received! Back to my “Swimlane Visualization” of problems and unhealthy situation across all environments: Welcome to the matrix….

Tuning 263

Tuning Architecture Monitoring Big Data 263

Dynatrace

DECEMBER 16, 2021

Therefore, the first three goals/objectives are all related to the mobile app itself including adoption, app store rating, and crashes. Therefore, the first three goals/objectives are all related to the mobile app itself including adoption, app store rating, and crashes. Dynatrace news. Below is an example of such a simple dashboard.

DevOps 204

DevOps Social Media Mobile Metrics 204

SQL Server According to Bob

FEBRUARY 10, 2019

This blog takes you through the debugging journey, refreshing us on old concepts and introducing some new ones. Several event types are included in the health session, some of which include predicates to remove noise from the system health session. RST – TCP connection is reset by client (OS Error: 10054). Reported Symptoms.

Servers 40

Servers Network Database Systems 40

Sutter's Mill

MARCH 25, 2021

Consider these functions, expanded from an article by Andrzej Krzemieński: [1] … How many ways could a caller of each function get the arguments wrong, but that would silently compile without error? There are several ways to break this down. Name as many different ways as you can.

C++ 45

C++ Design Code Systems 45

Dynatrace

OCTOBER 21, 2021

But there is a lack of time for DevOps , SRE , and developers to analyze all this data to identify whether there’s a user impacting problem and if so – what the root cause is to fix it fast. Dynatrace automatically baselines all service endpoints of all deployed workloads in k8s and alerts on abnormal behavior such as a jump in failure rate.

Metrics 217

Metrics DevOps Engineering Strategy 217

O'Reilly

JULY 25, 2023

So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. or “ha look how incompetent it is … it couldn’t even get my simple question right!” This choice also inspired me to call my project Swift Papers.

Programming 98

Programming Code Design Benchmarking 98

Dynatrace

AUGUST 30, 2019

Dynatrace and our local partners helped MAMPU to optimize the digital government experience on several dimensions: Digital Experience: 413% improvement in APDEX, from 0.15 You, my dear reader, can start optimizing your applications as well. Dynatrace news. I was fortunate enough to get invited to our PerformGo! APAC Series.

Cache 197

Cache Database Architecture Government 197

Percona

DECEMBER 18, 2023

Attention : For the sake of brevity, I’ve NOT included the database schema in this blog. Migration environment The migration environment used for this blog is a production MySQL database, version 5, with several hundred tables. Some of the tables have a large number of number of columns with indexes. MYSQL: OS: Ubuntu 16.04

Open Source 119

Open Source Database Architecture Design 119

SQL Server According to Bob

JULY 13, 2016

on my Windows NT 3.1 For the user who wants to install SQL Server Express, SQL Server Developer, and perhaps even the Evaluation Edition of SQL Server, all these choices get a bit frustrating especially for the “core SQL engine” user. So the initial time to run this all depends on your network speed. Go install it”.

Servers 40

Servers Media Engineering Virtualization 40

Dynatrace

SEPTEMBER 2, 2020

It follows the same specification for all languages and has powerful features to trace different types of transactions. Maybe there are external HTTP Calls in several different places, or dozens of different views with their own database calls. runserver, and Autodynatrace has already instrumented several different places of the app.

Monitoring 244

Monitoring Cache Open Source Database 244

Dynatrace

SEPTEMBER 14, 2022

However, as with all software tools, more options that haven’t been integrated carefully usually lead to cluttered interfaces, making them complex and harder to use. As an industry leader, Dynatrace promotes primarily using software and AI to deal with this complexity at scale instead of just putting data on dashboards.

Metrics 228

Metrics Analytics Monitoring Efficiency 228

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. I logged into one and went through some basic CLI tools to get started (my [60s checklist]). These can be invisible to top(8).

Speed 126

Speed Java AWS Virtualization 126

Smashing Magazine

OCTOBER 16, 2023

Solving Markdown Headaches In Gatsby In Gatsby, Markdown files are commonly used to programmatically create pages, such as blog posts. The gatsby-remark-images approach is probably most suited for larger projects since it is more manageable than saving all Markdown images in the /static folder. We never told Gatsby to parse it.

Media 87

Media Website Availability Design 87

Scalegrid

JULY 17, 2020

For the purposes of this blog, when we refer to JSON support in PostgreSQL, we will refer to JSONB going forward. It is an open standard format which organizes data into key/value pairs and arrays detailed in RFC 7159. JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. JSONB Indexes.

Storage 321

Storage Database Efficiency Processing 321

Percona

AUGUST 1, 2023

In this blog, for the sake of simplicity, we are going to use mysqldump, and generate a single table, but the most curious thing is that we are going to create objects which have a certain DEFINER , and it must not be changed. sec) That’s right, that’s all we got. sec) That’s right, that’s all we got.

AWS 68

AWS Servers Engineering Strategy 68

Percona

JANUARY 4, 2023

This blog should make it easier to understand for everyone. You can locate all instruments available in your MySQL version under table setup_instruments. I realized that it is important to understand the insights of the performance schema and how we can make effective use of it. Instruments are the main part of the performance schema.

Performance 98

Performance C++ Monitoring Servers 98

Dynatrace

MAY 6, 2019

As a member of the Platform Extensions practice I am one of the subject matter experts responsible for all services related to expanding the visibility of Dynatrace into technologies which aren’t available out of the box. For this blog post I want to focus on how you can leverage Dynatrace to get a lot of insight into your plugin code.

Code 116

Code Development Metrics Network 116

Adrian Cockcroft

JULY 4, 2023

The rest of this blog post is an edited version of the conversation I had with ChatGPT, that also acts as documentation of the code I’ve open sourced. This work built on my previous blog post —  Percentiles Don’t Work — Analyzing the Distribution of Response Times. The logfile I started with had several minutes of data in it.

Development 52

Development Latency C++ Open Source 52

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. One of the most common problems I faced is the one related to the well-known error “ERROR 1040 (08004): Too many connections”. A lot has been written about this error. No problem!

C++ 91

C++ Database Servers Open Source 91