Remove 2000 Remove Open Source Remove Servers Remove Software
article thumbnail

Update Percona Monitoring and Management Agent Settings for Already-Added Instances

Percona

In the example, we run PMM server in a docker container. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. ” Let’s roll up our sleeves and do it safely without breaking the toy. Below is an example of an alternative approach to re-adding the instance.

article thumbnail

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

Percona

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 83
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

Sharding: Sharding is the concept of splitting data horizontally, i.e. by distributing data into multiple servers (shards), meaning that the different portions of data for a given table, may be stored on many different servers. This can help to split large data sets into smaller ones stored in multiple servers. ibd -rw-r --.

article thumbnail

Impact of Querying Table Information From information_schema

Percona

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 101
article thumbnail

Purging Data When the Table Is Big and Has Children Tables

Percona

23] (Slave_delay: 0) This means the following: A primary server, with Percona Server for MySQL installed (in Read/Write mode) version 8.0.31-23. One replica with the same software version (in Read-Only and Super-Read-Only mode). sec) Finally, we show you below the topology presented by the client in question: 1.

article thumbnail

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

Percona

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. Commands end with ; or g.

article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

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. And did I mention they are open source?!

Cache 98