c 
Percona
MARCH 8, 2023
Your MySQL connection id is 144 Server version: 8.0.29-21 21 Percona Server (GPL), Release 21, Revision c59f87d2854 Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'c' to clear the current input statement. Commands end with ; or g.
SQL Performance
MARCH 9, 2022
1 D 5.000000 2 D 3.000000 3 D 8.000000 5 D 2.000000 6 D 8.000000 7 D 4.000000 8 D 2.000000 1000 S 8.000000 2000 S 6.000000 3000 S 2.000000 4000 S 2.000000 5000 S 4.000000 6000 S 3.000000 7000 S 2.000000. The idea to use a full outer join based on a predicate that compares the demand and supply running totals is a stroke of genius!
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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.
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
Percona
JANUARY 2, 2024
Two setups running in cluster mode: one in MariaDB+Galera and one with Percona XtraDB Cluster (Percona Server+Galera). For this reason, I’ve set up a server with the following specs: r6a.2xlarge 2xlarge ec2 VM (8 vCPU – 64GB of RAM) 1TB gp2 drive (roughly 3k IOPS) Percona Server 8.0.34-26
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? ” 00000030: 0000 0000 0000 0000 2000 0000 0000 0000. Let ChatGPT try its hand at MySQL administration Let’s see what ChatGPT will say. 00000020: 3000 0000 0000 0000 0300 0000 0000 0000 0.
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. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Expert insights. Personalized for you.
114 
Let's personalize your content