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++ 96

C++ Database Servers Open Source 96

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 85

Servers C++ Database Systems 85

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. Type 'c' to clear the current input statement. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02

Database 98

Database Performance C++ Engineering 98

Percona

DECEMBER 5, 2022

There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it. Proxysql has a stats database which we can see with an admin login. Type 'c' to clear the current input statement. Explanation.

Servers 60

Servers Cache C++ Metrics 60

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 OrderID , c.

Servers 95

Servers C++ Testing Systems 95

Percona

FEBRUARY 16, 2023

I asked ChatGPT the question: “C an we backup and then remove the keyring file used for encryption at rest plugin after MySQL starts? ” 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

Database 119

Database Servers Engineering Testing 119

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 69

Open Source C++ Servers Database 69