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 91

Storage Database Engineering Open Source 91

Percona

APRIL 20, 2023

TDE is a database encryption technique that encrypts data at the column or table level, as opposed to full-disk encryption (FDE), which encrypts the entire database. To enable the encryption of the storage in Kubernetes, you need to modify the StorageClass resource. apiVersion: storage.k8s.io/v1

Storage 118

Storage AWS Cloud Database 118

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. 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.

Analytics 185

Analytics Storage Database Systems 185

Percona

JANUARY 17, 2023

This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. In terms of storage, internal pages are no different than the root page; they also store pointers to other internal pages. Introduction.

Database 116

Database Hardware Storage Programming 116

n0derunner

NOVEMBER 24, 2021

My opinions are likely biased, but that also gives me a decent amount of context when it comes to the performance of Nutanix storage over time. We already have a lot of customers running database … The post Nutanix Performance for Database Workloads appeared first on n0derunner.

Database 52

Database Performance Storage Engineering 52

n0derunner

NOVEMBER 24, 2021

My opinions are likely biased, but that also gives me a decent amount of context when it comes to the performance of Nutanix storage over time. We already have a lot of customers running database … The post Nutanix Performance for Database Workloads appeared first on n0derunner.

Database 52

Database Performance Storage Engineering 52

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Of the organizations in the Kubernetes survey, 71% run databases and caches in Kubernetes, representing a +48% year-over-year increase. Java, Go, and Node.js

Open Source 345

Open Source Java Operating System Programming 345

Percona

NOVEMBER 2, 2023

On October 24th, the Percona Kubernetes Squad held the first Ask-me-Anything (AMA) session to address inquiries regarding the utilization of Kubernetes for database deployment. Q1: When is it appropriate to use Kubernetes for databases, and when is it not recommended? ” This talk covers this topic exactly.

Open Source 83

Open Source Hardware Storage Database 83

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Unfortunately, my excitement was short lived for a couple of reasons.

Azure 96

Azure Database Tuning Network 96

Testsigma

DECEMBER 4, 2020

To ensure quality, mobile app testing is essential. In this blog, we will discuss a step-by-step mobile app testing checklist. This is where cross-platform testing comes into the picture. Since the mobile apps have limited storage space and power supply, test for memory utilization as well as battery usage.

Mobile 65

Mobile Testing Operating System Storage 65

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. Understanding distributed storage is imperative as data volumes and the need for robust storage solutions rise.

Storage 130

Storage Systems Big Data Azure 130

Percona

MARCH 7, 2023

The goal is to simplify the provisioning and management of database capacity. One approach is to separate compute and storage to allow for independent scaling. By separating storage and compute, Neon replaces the PostgreSQL storage layer with data nodes, and compute nodes are distributed across a cluster of nodes.

Serverless 108

Serverless Storage Open Source Architecture 108

The Netflix TechBlog

OCTOBER 19, 2020

Our distributed tracing infrastructure is grouped into three sections: tracer library instrumentation, stream processing, and storage. An additional implication of a lenient sampling policy is the need for scalable stream processing and storage infrastructure fleets to handle increased data volume. Storage: don’t break the bank!

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Percona

AUGUST 1, 2023

In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, After changing the VARCHAR column size to 200, the following is the storage requirement. However, there are caveats.

Storage 77

Storage Database Open Source Engineering 77

Percona

APRIL 26, 2023

When you do a database restore, you want to have it done as soon as possible. And the database is unusable until the restore is done. Our tests showed physical database restores up to 5x faster than the logical ones. We aim to port it to Azure Blob and FileSystem storage types in subsequent releases.

Speed 77

Speed Storage AWS Azure 77

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 97

Monitoring Scalability Cache Database 97

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

Testsigma

MAY 7, 2020

IBM Big Data and Analytics Hub website cited a case study, where a US insurance company was estimating 15% of their testing efforts to be just test data collection for the backend system and the frontend system. The test data management for the company had become a big problem and had to be solved. What is test data?

Testing 60

Testing Storage Database Processing 60

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. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 103

Performance Monitoring Traffic Database 103

O'Reilly Software

JUNE 12, 2018

This meant a lot of time was spent on things like cycle time analysis, build pipeline design, test automation, and infrastructure automation. Back then, the most common pattern I saw for service-based systems was sharing a database among multiple services. But I kept hitting up against some fundamental issues.

Database 72

Database Cache Architecture Latency 72

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. For storage, FIO is generally used. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 76

Open Source Healthcare Social Media Database 76

Percona

MARCH 21, 2023

In that situation, implementing the upstream changes in a more constrained security context is beneficial to organizations needing privilege-controlled aggregate data from multiple separate databases. When require_row_format is set to ON, MySQL will require that all tables that use the InnoDB storage engine use the ROW format.

Storage 84

Storage Open Source Database Engineering 84

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. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 109

Servers Storage Database Open Source 109

Percona

FEBRUARY 10, 2023

To take consistent and hot backup, it uses various locking methods, especially for non-transactional storage engine tables. version is affected by this, as per my tests. Locking is only done for MyISAM storage engine tables and other non-InnoDB tables after Percona XtraBackup finishes backing up all InnoDB/XtraDB data and logs.

Storage 99

Storage Engineering Open Source Servers 99

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. sec) db1 test> CREATE TABLE tb3 (id int auto_increment primary key, test_text tinytext); Query OK, 0 rows affected (0.13

Open Source 86

Open Source Storage Database Big Data 86

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Percona

AUGUST 18, 2023

I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

Open Source 65

Open Source Database Storage Engineering 65

Dynatrace

AUGUST 26, 2020

Optimal metric storage management strategy. Dynatrace Managed metric storage management is reliable and delivers high performance. Our new solution for managing metric storage doesn’t reclaim disk space by data compaction. Unlike our competition, Dynatrace Managed processes all the data sent by OneAgent without sampling.

Performance 150

Performance Hardware Java Storage 150

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MySQL (PS- based variant) 8.1.0 Percona Server for MySQL 8.1.0-1

Open Source 78

Open Source Azure Servers Programming 78

Dynatrace

AUGUST 5, 2022

Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them. Developers can easily modify applications by adding or swapping out microservices, and testing requirements are reduced because microservices are isolated and often pre-tested.

Monitoring 202

Monitoring Serverless Programming Speed 202

Dynatrace

AUGUST 5, 2022

Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them. Developers can easily modify applications by adding or swapping out microservices, and testing requirements are reduced because microservices are isolated and often pre-tested.

Monitoring 201

Monitoring Serverless Programming Speed 201

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. in the directory storage/innobase/ut the following section has UT_RELAX_CPU defined to call the PAUSE instruction on x86.

Testing 48

Testing Tuning Latency Storage 48

HammerDB

DECEMBER 1, 2022

In particular, after a running a test it would be ideal to have a repository where we could verify the configuration of the workload that was run, the results and any timing or transaction count data generated to bring all the log output into a central location. Jobs Configuration and Storage. HammerDB v4.6 Use a different Browser.

Virtualization 57

Virtualization C++ Storage Database 57