article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

You can get summaries of your database servers, or you verify replication lag on MySQL and PostgreSQL servers. You get thirty-eight scripts that can do any manner of actions, and you will find them very valuable in your regular database work. And did I mention they are open source?! 25 Buffer Pool Size | 128.0M

Cache 96
article thumbnail

High Memory Usage on ProxySQL Server

Percona

Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning. 2) mysql-query_digests_max_digest_length – This is by default set to 2048. Explanation. How do we know where the memory is getting used?

Servers 58
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

Comparisons of Proxies for MySQL

Percona

In short, each cluster is, in reality, a single database with high availability and other functionalities built in. micro) The tests We will have very simple test cases. The second test will define how well the increasing load is served inside the previously identified range. Anyhow, we are here to talk about Proxies.

Games 119
article thumbnail

Configuring PostgreSQL and LDAP Using StartTLS

Percona

Although the installation of LDAP includes setting the password, which will be admin, by executing the following command, one can reset the password at will: # Select "No" when asked to configure the database with dbconfig-common. # Set the domain name for your LDAP server, for example, "example.com". #

C++ 70
article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Extension citus has been created in database db01. Now let’s stretch our imagination and consider a second method of high availability, ala Citus.

C++ 79
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40