Remove 2048 Remove Database Remove Testing
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 141
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 114
Insiders

Sign Up for our Newsletter

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

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++ 98
article thumbnail

How to analyze PostgreSQL benchmark performance with HammerDB

HammerDB

How Postgres Workload Reports Help Optimize Database Operations The EnterpriseDB blog post can be found here, How Postgres Workload Reports Help Optimize Database Operations. An active session history allows us to look back at a database workload and see the workload being run over time. and start the build running.

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++ 98
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 60
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