Percona

MARCH 17, 2023

2022 was an exciting year for Percona Monitoring and Management (PMM). These updates are designed to keep databases running at peak performance and simplify database operations. Planning for resources of a PMM Server host instance can be tricky because the numbers can change depending on the DB instances being monitored by PMM.

Monitoring 103

Monitoring Scalability Cache Database 103

Percona

DECEMBER 2, 2022

It is also unfortunate that PostgreSQL documentation gives an unsafe command string, employing a combination of the test and cp commands as an example: archive_command = 'test ! -f 2022-11-24 11:24:31.330 UTC [2323] ERROR: could not create file "/home/postgres/arch2/archtemp.00000001000000000000007B.2323.1669289071330":

Servers 88

Servers Systems Processing Database 88

Percona

DECEMBER 23, 2022

Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. This is one of the most used backup tool used for PostgreSQL databases. In this blog, we will integrate both of these tools and understand how they can work together to reduce the server load. 0 md5 - host replication all 0.0.0.0/0

Open Source 64

Open Source Servers Database Availability 64

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL.

Open Source 70

Open Source C++ Servers Database 70

SQL Performance

OCTOBER 18, 2022

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions.

Servers 144

Servers Code Best Practices Database 144

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. . <commandline> This happens for both a schema build and running a test.

Virtualization 57

Virtualization C++ Storage Database 57

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. To test the performance of the solutions, you’ll need a larger set of sample data. The sample row’s order date is 2022-01-11, so the first delimiter is 2022-01-09.

C++ 112

C++ Code Azure Database 112

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 80

Open Source Healthcare Social Media Database 80

HammerDB

NOVEMBER 30, 2022

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. print(z," VU TEST") . print("TEST SEQUENCE COMPLETE"). Vuser 1:Timing test period of 1 in minutes Vuser 2:RUNNING Vuser 2:Initializing xtprof time profiler Vuser 2:Processing 10000000 transactions with output suppressed. >hammerdbcli py.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Percona

DECEMBER 14, 2023

I don’t know, but certainly, the launching of ChatGPT at the end of 2022 sparked a huge hype explosion around that technology throughout this year. I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time.

Database 90

Database Artificial Intelligence Servers Operating System 90

SQL Performance

APRIL 22, 2020

First, I created a view that would expose the important bits from the Extended Events session data, and put it in the utility database that exists on every instance: CREATE VIEW dbo. FROM src ; Now, when someone wants to review recent file size change events on any server, they run: SELECT < cols > FROM UtilityDatabase.

Database 55

Database Servers Availability Monitoring 55

Percona

DECEMBER 12, 2022

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since November 28, 2022. was released on December 8, 2022.

Open Source 64

Open Source Azure Database Servers 64

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 111

Availability Database Open Source Hardware 111

Percona

DECEMBER 27, 2022

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since December 12, 2022. was released on December 19, 2022.

Monitoring 52

Monitoring Open Source Database Servers 52

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 97

C++ Database Servers Open Source 97

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 116

Open Source Database Software Software 116

HammerDB

DECEMBER 14, 2022

The TPC publishes an official Docker image on Docker Hub to enable the rapid deployment and testing of databases with HammerDB. This image includes example scripts to build schemas and test your databases with a single command. Our Linux test system is running a MariaDB 10.10 Database Configuration.

C++ 62

C++ Virtualization Database Benchmarking 62

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

HammerDB

MAY 26, 2022

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. The build has been tested on x64 Red Hat 8.X The build has been tested on x64 Windows 10 and 11. x86_64/bin.

C++ 113

C++ Database Open Source Servers 113

Percona

JANUARY 30, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. This update to the release of Percona Distribution for MySQL using the Percona Server for MySQL includes a new version of Percona Toolkit 3.5.1

Open Source 87

Open Source Storage AWS Cloud 87

Percona

APRIL 4, 2023

When executing the query, Perl was trying to quote an empty string instead of the bit representation of 0, causing the tool to fail (note this is output from the locally reproduced dummy schema/data): 2022-10-18T14:19:02 0 0 DBD::mysql::st execute failed: Truncated incorrect DOUBLE value: '' [for Statement "DELETE FROM `myd_test`.`gerald`

Open Source 110

Open Source Servers Engineering Scalability 110

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. The global default can be set at server startup. This variable has global and session values and can be changed at runtime.

Efficiency 107

Efficiency Database Open Source Performance 107

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. The obvious answer is this: To achieve high availability.

Architecture 100

Architecture Availability Open Source Healthcare 100

Percona

JULY 3, 2023

Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 84

Storage Database Performance Open Source 84

Percona

APRIL 10, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona Distribution for MySQL (Percona Server for MySQL-based variation) 8.0.32 It’s time for the release roundup!

Open Source 80

Open Source Servers AWS Database 80

Dynatrace

APRIL 21, 2022

Starting with April 2022, Dynatrace is retiring TLS 1.0 Now you can extend your observability into data acquired from an Oracle Database using SQL queries. High memory usage or potential OutOfMemory if the server is running without Elasticsearch connection for a prolonged time. (APM-362484). Dynatrace news. Announcements.

Azure 216

Azure Metrics AWS Monitoring 216

Dynatrace

MAY 23, 2022

Shifting from monolith to microservices makes it easier to test, develop, and release innovative features more rapidly. IDC predicted, by 2022, 90% of all applications will feature microservices architectures that improve the ability to design, debug, update, and use third-party code. Server-side application. Easier to test.

Architecture 195

Architecture DevOps Monitoring Programming 195

Percona

MARCH 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. Take a look!

Open Source 79

Open Source Servers Scalability Cache 79

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Check out this blog here !

Virtualization 80

Virtualization Speed Database Efficiency 80

Smashing Magazine

MAY 12, 2022

2022-05-12T09:30:00+00:00. 2022-05-12T10:16:36+00:00. CrUX is a cloud-based database into which Real User Measurements (RUM) are collected from live Chrome browser sessions. _developit) February 11, 2022. How To Use Google CrUX To Analyze And Compare The Performance Of JS Frameworks. Dan Shappir. — Jason Miller ???

Google 127

Google Performance Website Mobile 127

O'Reilly

NOVEMBER 28, 2023

Unexpected outcomes, security, safety, fairness and bias, and privacy are the biggest risks for which adopters are testing. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” 16% of respondents working with AI are using open source models.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

SQL Performance

JUNE 8, 2022

When the parser allows simple parameterization to continue, SQL Server® increments the Auto-Param Attempts/sec counter of the SQL Statistics object. As in previous parts, code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo.

Cache 54

Cache Servers Database Processing 54

O'Reilly

MARCH 23, 2023

ChatGPT, or something built on ChatGPT, or something that’s like ChatGPT, has been in the news almost constantly since ChatGPT was opened to the public in November 2022. It’s clear that ChatGPT is not your run-of-the-mill automated chat server. What is it, how does it work, what can it do, and what are the risks of using it?

Google 104

Google Open Source Programming Code 104

Dotcom-Montior

FEBRUARY 19, 2022

A typical SRE is busy automating, cleaning up code, upgrading servers, and continually monitoring dashboards for performance, etc., For that reason, the tools and platforms that an SRE uses can vary greatly from organization to organization, especially in 2022. so they are going to see more tools in that toolbelt.

Engineering 52

Engineering Open Source Programming Monitoring 52

O'Reilly

OCTOBER 11, 2022

Gartner has anointed “Hyperautomation” one of the top 10 trends for 2022. Selenium , the first tool for automated browser testing (2004), could be programmed to find fields on a web page, click on them or insert text, click “submit,” scrape the resulting web page, and collect results. Should it be? What’s required?

Games 116

Games Healthcare Processing Retail 116

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. using “22” for the year 2022). ChatGPT suggested two libraries for me: Moment.js

Programming 98

Programming Code Design Benchmarking 98