SQL Shack

AUGUST 23, 2021

In this article, we will go through some details about SQL Server statistics. The first step into SQL Server statistics The query plan is a set of instructions that describes how a query will be executed by the database engine. The query plans are created by the query optimizer in SQL Server and it requires […].

Servers 109

Servers Database Engineering Performance 109

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend.

Database 83

Database Serverless Tuning Cloud 83

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

SQL Shack

APRIL 16, 2021

In this article, we will learn how to interpret an execution plan of a SQL Server insert statement. Introduction When we execute an insert statement, the database engine performs tons of work in the background. Consequently, […].

Servers 89

Servers Database Engineering Performance 89

SQL Shack

DECEMBER 10, 2020

The SQL Server execution plan (query plan) is a set of instructions that describes which process steps are performed while a query is executed by the database engine. The query plans are generated by the query optimizer and its essential goal is to generate the most efficient (optimum) and economical query plan.

Servers 109

Servers Efficiency Database Engineering 109

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 _authors_new OK.

Database 97

Database Performance C++ Engineering 97

Dynatrace

JANUARY 23, 2024

In May 2023 the critical vulnerability CVE-2020-36641 in the Java library aXMLRPC was published in the National Vulnerability Database (NVD). XML external entity (XXE) exploit The aXMLRPC library allows its users to connect to a server and perform RPC calls using the XML-RPC protocol over HTTP.

Java 208

Java Servers Code Software 208

Dynatrace

MAY 27, 2022

This automatic analysis enables engineers to spend more time innovating and improving business operations. An IT organization is often unaware a critical server has gone down until a user reports it. The script then restarts the web service and checks the server’s health. An example of the self-healing web.

Artificial Intelligence 189

Artificial Intelligence Innovation Servers Database 189

Percona

JUNE 1, 2023

Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem. In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. Simple, right?

Servers 74

Servers Database Testing Open Source 74

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Most Kubernetes clusters in the cloud (73%) are built on top of managed distributions from the hyperscalers like AWS Elastic Kubernetes Service (EKS), Azure Kubernetes Service (AKS), or Google Kubernetes Engine (GKE). Java, Go, and Node.js

Open Source 345

Open Source Java Operating System Programming 345

SQL Shack

JULY 28, 2020

The storage subsystem is one of the key performance factors for SQL Server because SQL Server storage engine stores database objects, tables, and indexes on the physical files. Therefore, the storage engine always interacts with the disk subsystem because of […].

Storage 82

Storage Servers Testing Engineering 82

The Netflix TechBlog

JUNE 12, 2023

To be a client systems engineer is to take joy in small endpoint automations that make your fellow employees’ day a little better. In its typical configuration the Crypt agent enforces FileVault upon login and escrows the resulting recovery key to a corresponding Crypt server. We call this new tool Escrow Buddy.

Open Source 194

Open Source Database Servers Storage 194

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources. million AI server units annually by 2027, consuming 75.4+

Cache 206

Cache Azure Infrastructure Monitoring 206

Percona

JUNE 23, 2023

If you want to go fast, a top fuel dragster will set you back close to a million dollars by the time you buy the chassis, spare engines, tooling, and transporter. Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system.

Database 121

Database Transportation Servers Cloud 121

DZone

MAY 19, 2023

Examples of logs include business logs (such as user activity logs) and Operation and Maintenance logs of servers, databases, and network or IoT devices. On the one hand, they provide system risk alerts and help engineers quickly locate root causes in troubleshooting. Logs are the guardian angel of business.

IoT 130

IoT Analytics Network Database 130

Percona

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns.

Database 94

Database Systems Open Source Engineering 94

SQL Server According to Bob

SEPTEMBER 9, 2019

A handful of lock types (Database, Metadata, LOGIN_STATS, …) are eligible for lock partitioning. For example: When ‘use database’ takes place the session acquires a shared lock on database. Only distinct changes require an exclusive database lock, for example a drop database.

Servers 103

Servers Database Scalability Tuning 103

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 105

Servers C++ Storage Systems 105

High Scalability

JANUARY 11, 2022

Machine Learning Engineer at Amazon and has led several machine-learning initiatives across the Amazon ecosystem. When the server receives a request for an action (post, like etc.) We will use a graph database such as Neo4j to store the information. Sample Queries supported by Graph Database. High Level Design.

Design 334

Design Media Storage Logistics 334

Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. It is also important to monitor your server’s memory usage regularly to ensure that it is not being exhausted by the buffer pool.

Social Media 123

Social Media Database Servers Cache 123

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The database is also widely loved for PostgreSQL extensions which enable users to extend the functionality of their database. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. Compared to MySQL 5.7,

Servers 112

Servers Storage Database Open Source 112

Scalegrid

OCTOBER 31, 2019

In these blogs, we dove deep into how the frameworks work, their setup requirements, pros and cons, and how they performed in standby server tests, primary server tests and network isolation tests (split brain scenario) to help you determine the best framework to improve the uptime for your PostgreSQL-powered applications.

Availability 187

Availability Azure AWS DevOps 187

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. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.

Servers 63

Servers Database Testing Efficiency 63

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 101

Database Engineering Best Practices Open Source 101

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. Engineers are woken from their beds to start a full blown fire fighting operation.

Analytics 185

Analytics Storage Database Systems 185

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database.

Database 116

Database Open Source Engineering Efficiency 116

Percona

OCTOBER 13, 2023

MySQL writes a.sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality. Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. sdi -rw-r --.

Storage 95

Storage Database Engineering Open Source 95

SQL Performance

SEPTEMBER 16, 2021

To finish up my short series of articles on latches, this time I’m going to discuss a few other latches in SQL Server you might see occasionally but don’t merit a complete article by themselves. The post SQL Server Latches – Other Latches To Know About appeared first on SQLPerformance.com. The LOG_MANAGER Latch.

Servers 57

Servers Storage Efficiency Database 57

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 138

Traffic Performance Database Metrics 138

Dynatrace

APRIL 15, 2022

The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud. “We used Dynatrace to monitor that large increase in servers. We started out by instrumenting 2,000 servers overnight.

Cloud 179

Cloud Infrastructure Innovation Monitoring 179

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 105

Performance Monitoring Traffic Database 105

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

FEBRUARY 16, 2023

keyring_file_data=/var/lib/mysql/keyring_file mysql> create database test; mysql> show create schema testG 1. row Database: test Create Database: CREATE DATABASE `test` /*!40100 ec2-user@ip-172-31-32-242 ~]$ cat /etc/my.cnf #encryption at rest early-plugin-load=keyring_file.so

Database 119

Database Servers Engineering Testing 119

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Pedro makes it his mission to help customers with SQL Server Performance.

Engineering 40

Engineering Azure Best Practices Servers 40

Dynatrace

JANUARY 19, 2020

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. No ABAP code instrumentation or injection is performed.

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154