2000 and Servers - Technology Performance Pulse

Dealing With “Too Many Connections” Error in MySQL 8

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.

C++

C++ Database Servers Open Source

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

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

Servers C++ Database Systems

High Memory Usage on ProxySQL Server

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.

Servers

Servers Cache C++ Metrics

Matching Supply With Demand — Solutions, Part 3

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!

C++

C++ Code Efficiency Performance

tempdb Enhancements in SQL Server 2019

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

Servers C++ Testing Systems

Is Thread Pool Plugin the Right Choice for Your Workload?

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

Benchmarking

Benchmarking Servers Tuning C++

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers

Servers Cache Database Media

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Percona

DECEMBER 5, 2022

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. Percona Server for MySQL is a drop-in replacement for MySQL. Type 'c' to clear the current input statement.

Open Source

Open Source C++ Servers Database

How Many Warehouses for the HammerDB TPC-C Test?

HammerDB

OCTOBER 17, 2018

For a really quick answer create a schema with 250-500 warehouses per server CPU socket for more details size as follows. . The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive.

C++

C++ Testing Virtualization Cache

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

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.

Database

Database Servers Engineering Testing

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers

Servers Media Cache Storage

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

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. Commands end with ; or g. Other names may be trademarks of their respective owners.

Database

Database Performance C++ Engineering

Percona Toolkit – A Quick Introduction to Summary

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. pt-summary --user=root [?2004l# virtual = 2.2G

Cache

Cache Database Virtualization Servers

How to deploy HammerDB CLI fast with Docker

HammerDB

DECEMBER 14, 2022

Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database /tmp/hammer.DB my.cnf --user=hammerdb 2022-12-14 12:14:05 0 [Note] bin/mysqld (server 10.10.2-MariaDB) Copyright (C) 2003-2022 Steve Shaw. Benchmark set to TPC-C for MariaDB. Use a different Browser. hammerdbcli.

C++

C++ Virtualization Database Benchmarking

Web Performance Bookshelf

Rigor

JANUARY 13, 2020

Steve Souders, plus Dion Almaer, Doug Crockford, Ben Galbraith, Tony Gentilcore, Dylan Schiemann, Stoyan Stefanov, Nicole Sullivan, Nicholas C. Podjarny presents a series of increasingly larger-scope solutions to each issue, including client-side techniques and RESS (Responsive + Server Side). ” – Andy King, 2003.

Performance

Performance Social Media Website Website Performance

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

OCTOBER 8, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C

C++

C++ Virtualization Programming Latency

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

OCTOBER 7, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C

C++

C++ Virtualization Programming Latency

Platform Adjacency Theory

Alex Russell

JUNE 20, 2020

3] Oh, and it should be imperatively programmed with Lisp-in-C's-clothing. Absent compelling content and attentive security and performance focus, it soon retreated to the server. [6]. talking to POP and IMAP servers. Other use-cases weren't addressable with early 2000's tech. high-color image raster. microphones.

Hardware

Hardware Games Java Media

Technology Performance Pulse

Dealing With “Too Many Connections” Error in MySQL 8

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Trending Sources

High Memory Usage on ProxySQL Server

Matching Supply With Demand — Solutions, Part 3

tempdb Enhancements in SQL Server 2019

Is Thread Pool Plugin the Right Choice for Your Workload?

SQL Server I/O Basics Chapter #2

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

How Many Warehouses for the HammerDB TPC-C Test?

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

SQL Server On Linux: Forced Unit Access (Fua) Internals

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona Toolkit – A Quick Introduction to Summary

How to deploy HammerDB CLI fast with Docker

Web Performance Bookshelf

bpftrace (DTrace 2.0) for Linux 2018

bpftrace (DTrace 2.0) for Linux 2018

Platform Adjacency Theory

Stay Connected