Percona

APRIL 3, 2024

This blog was originally published in June 2020 and was updated in April 2024.One One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket. While this can be caused by a multitude of factors, it is more often than not caused by a bad or slow MySQL […]

Tuning 52

Tuning Database Monitoring Software 52

DZone

JANUARY 13, 2021

At the beginning of 2020, when I used the BCC tools to analyze our database performance bottlenecks, and pulled the code from the GitHub, I accidentally discovered that there was an additional libbpf-tools directory in the BCC project.

Database 179

Database Code Performance Processing 179

Scalegrid

MAY 22, 2020

This way, the load on the master is tremendously reduced, and at the same time, the binlog server serves the binlogs more efficiently to slaves since it does not have to do any other database server processing. mysql> create database d12; Query OK, 1 row affected (3 min 0.01 Rpl_semi_sync_slave_status | OFF |.

Servers 262

Servers Transportation Database Availability 262

DZone

DECEMBER 16, 2019

Surely, 2019 was the year we solved massive security breaches.

Performance 167

Performance Database Cloud Software 167

Percona Community

JUNE 12, 2020

Matt Yonkovit, Chief Experience Officer at Percona, presented a session at this year’s Percona Live ONLINE, sharing initial insights from the Open Source Data Management Survey 2020. The full data will be released later this year with a detailed analysis.

Database 52

Database Infrastructure Open Source Software 52

Dynatrace

MAY 6, 2020

As growth in traffic creates more load on the state government websites , the infrastructure supporting those sites – including everything from network connections to load balancers, web servers, application servers and databases – become s stressed. T hink of it in the same way roads become busier during rush hour. .

Website 215

Website Monitoring Retail Media 215

Scalegrid

JANUARY 9, 2024

Its key emphasis is on data security and ensuring compliance, while still allowing users to maintain control over their database systems and data, even when they are hosted in the public cloud. This ensures the highest level of protection for data stored in these databases on the cloud.

Strategy 130

Strategy Cloud Best Practices Government 130

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. Back in 2020, we set out to learn more about how Percona Monitoring and Management (PMM) was being used in order to provide a better product to the community. One such feature was managed backups.

Open Source 90

Open Source Database Operating System Programming 90

SQL Performance

AUGUST 1, 2022

I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. In this article, I focus on the distinct predicate and the approximate percentile functions. I’ll cover the other improvements in future articles since there’s a lot to say about those. The Distinct Predicate.

Servers 142

Servers Testing C++ Code 142

Dynatrace

APRIL 16, 2020

From figure 5 you can see how errors are impacting the user experience: The front-end UI was designed to not wait for the database activity to complete and would display other content in the UI. SaaS vendor RUM functionality is available for free for new users through September 19, 2020. Click here to learn more about this offer.

Government 201

Government Traffic Database Infrastructure 201

Dynatrace

OCTOBER 6, 2022

Dynatrace has supported OpenTelemetry since 2020. Both methods ingest data, but by using the Dynatrace OneAgent, users can automatically discover additional insights about their infrastructure, applications, processes, services and databases. In this example, we will be using Dynatrace.

Open Source 173

Open Source Metrics Tuning Technology 173

SQL Performance

MAY 24, 2022

I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. 10308 2 2020-09-18 6 88.80 10308 2 2020-09-18 6 88.80

Servers 145

Servers C++ Code Database 145

Percona

APRIL 19, 2023

This work started in 2020 and hopefully will be done soon. Percona Distribution for MySQL is the most complete, stable, scalable, and secure open-source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use!

Open Source 93

Open Source Servers Scalability Database 93

Percona

JUNE 20, 2023

However, this blog is written from the database perspective; hence, I would not prefer to dive into those scenarios as they are very high-level programming concepts. In this section, I will focus on a scenario in the PostgreSQL database that causes segmentation fault. Copyright (C) 2020 Free Software Foundation, Inc.

Programming 83

Programming C++ Database Virtualization 83

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

NOVEMBER 1, 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. This blog was originally published in August of 2021 and updated in November of 2023.

Scalability 58

Scalability Best Practices Servers Database 58

n0derunner

FEBRUARY 7, 2020

level=info ts=2020-02-07T17:26:49.042Z caller=main.go:295 295 msg="no time or size retention was set so using the default time retention" duration=15d level=info ts=2020-02-07T17:26:49.043Z caller=main.go:331 0, branch=HEAD, revision=22a04239c937be61df95fdb60f0661684693cf3b)" level=info ts=2020-02-07T17:26:49.043Z caller=main.go:332

Monitoring 52

Monitoring Metrics Servers Database 52

Percona Community

JUNE 1, 2020

MySQL, arguably the most popular relational database, is used pretty extensively at the popular professional social network LinkedIn.

Database 52

Database Infrastructure Network Performance 52

Smashing Magazine

AUGUST 28, 2020

2020-08-28T07:00:00+00:00. 2020-08-28T12:35:18+00:00. DATABASE is a dictionary that holds access to an external database(or internal like in the case of the default sqlite) like PostgresSQL, MySQL and MongoDB. You can decide to use the default sqlite database, this doesn’t work great for production.

Virtualization 143

Virtualization Database Code Processing 143

SQL Server According to Bob

FEBRUARY 9, 2020

​​ The containedag includes the databases containedag_master and containedag_msdb ​​ (which are commonly hidden from external view.) ​​ Establish a second connection ​​ to the read-only port and query the database on a secondary replica.

Servers 40

Servers Database Availability Azure 40

Dynatrace

AUGUST 26, 2020

Rather, it removes “fully expired” SSTables entirely from disk via a simple file system deletion, which is comparable to partitioning in relational database management systems (DBMS). Our new solution for managing metric storage doesn’t reclaim disk space by data compaction. This is a 50% reduction in required disk space!

Performance 150

Performance Hardware Java Storage 150

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. What is an MPP Database?

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Dynatrace

NOVEMBER 23, 2020

Traces represent causally related distributed events on a distributed system, showing, for example, how a request flows from the user to the database. Kelsey Hightower via Twitter, 2020). For example, traces can show that requests are passed to the application server, the database gets queried, but doesn’t produce a response.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Dotcom-Montior

JUNE 25, 2020

Did you know that around 306 billion emails have been sent globally every day in 2020 and about 45 percent of all emails received are spam. And if the mail server for the user is attached to the DNSBL database, then any emails coming from the list of blacklisted sites could be either flagged or rejected. How does DNS Blacklist work?

Monitoring 86

Monitoring Traffic Website Database 86

Dynatrace

APRIL 30, 2021

According to The State of Performance Engineering 2020 from Neotys and Sogeti (part of CapGemini), 56% of organizations want to implement “zero-touch” performance as a self-service. Not surprisingly, they’re looking for a better approach. Where are the things that are slow? Establishing an SLO-driven culture.

Engineering 200

Engineering Testing Performance Performance Testing 200

Percona

JANUARY 20, 2023

When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate to data on disk. 07-Jan-2020) Filesystem at /dev/nvme1n1 is mounted on /var/lib/kubelet/plugins/kubernetes.io/aws-ebs/mounts/aws/eu-central-1a/vol-0ab0db8ecf0293b2f;

AWS 94

AWS Storage Monitoring Cloud 94

Scalegrid

OCTOBER 14, 2020

October 14, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced the launch of Google Cloud Platform (GCP) hosting through their fully managed DBaaS plans. Google Cloud Platform is the second most popular cloud provider for open source database hosting according to the 2019 Open Source Database Report.

Google 246

Google Database Cloud Open Source 246

Official Blog - World Web Technology

AUGUST 27, 2023

The PHP 8 version launched in 2020 is the latest. You can integrate PHP with many technologies, such as databases, web servers, CMS, etc. Not just websites, you can use PHP for graphical user interface development. PHP was launched 28 years ago, and various new PHP versions have been launched since then.

Development 98

Development Ecommerce Open Source Website 98

SQL Performance

OCTOBER 1, 2020

( @p1 AS [ int ] = /* 1 */ 1 , @p2 datetime = getdate OUTPUT , -- comment, @p3 date = { ts '2020-02-01 13:12:49' } , @p4 dbo. Default: {ts '2020-02-01 13:12:49'}. The eventual goal is to support input from a file, an array of files, a folder, an array of folders, or pulling module definitions from a database.

C++ 57

C++ Code Database Systems 57

Dynatrace

OCTOBER 15, 2021

Cloud databases excel at storing large volumes of information for later reference, and this data often has business value or privacy restrictions. The first beta version was then released in March 2020, and it continues to be the second most active CNCF project after Kubernetes. Span ingestion. OpenTelemetry components.

Open Source 220

Open Source Metrics Cloud Transportation 220

HammerDB

DECEMBER 8, 2020

in summer 2020 to invest the time in rewriting the interface to ensure usability on devices such as PixelSense displays. the plan is to make it available for other databases with future releases. there is no longer any barrier to running database performance presentations and demos from devices with UHD displays. Oracle Metrics.

Scalability 52

Scalability Metrics Tuning C++ 52

MachMetrics

DECEMBER 27, 2019

Obviously this means that there is a ton of work to be done going into 2020 for web performance. As we mentioned in our article Average Page Load Times for 2020 , mobile page speed is a huge deal going forward. TTFB is typically reduced via server-side optimizations, such as enabling caching and database indexes.

Performance 52

Performance Speed Website Mobile 52

High Scalability

JUNE 22, 2018

using them to respond to storage events on s3 or database events or auth events is super easy and powerful. . $40 million : Netflix monthly spend on cloud services; 5% : retention increase can increase profits 25%; 50+% : Facebook's IPv6 traffic from the U.S, they can can be two orders of magnitude faster than FastBitSet.js.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

Dynatrace

JANUARY 13, 2021

Dynatrace’s OneAgent automatically captures PurePaths and analyzes transactions end-to-end across every tier of your application technology stack with no code changes, from the browser all the way down to the code and database level. Automation gives us the ability to create a predictable level of quality at scale with limited resources.

Open Source 139

Open Source Code Monitoring Azure 139

Alex Russell

JUNE 22, 2022

World-class experts in graphics, networking, cryptography, databases, language design, VM implementation, security, usability (particularly usable security), power management, compilers, fonts, high-performance layout, codecs, real-time media, audio and video pipelines, and per- OS specialisation are required. How much does all of this cost?

Engineering 110

Engineering Traffic Government Google 110

O'Reilly

JULY 15, 2020

The survey ran from January 31, 2020 through February 29; we had 1502 respondents from the readers of our mailing lists. The share of adoption for the 12-month period between January of 2019 and January of 2020 likewise suggests that microservices remains a topic of interest to O’Reilly users. Use of a Central, Managed Database.

Database 135

Database Architecture Education Systems 135

O'Reilly

FEBRUARY 18, 2020

Starting with data engineering, the backbone of all data work (the category includes titles covering data management, i.e., relational databases, Spark, Hadoop, SQL, NoSQL, etc.). relational database,” “Oracle database solutions,” “Hive,” “database administration,” “data models,” “Spark”—declined in usage, year-over-year, in 2019.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134