Remove 2048 Remove Servers Remove Systems
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 79
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. pt-summary --user=root [?2004l# virtual = 2.2G

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

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

If my memory serves me correctly SQL Server started using the ReadFileScatter and WriteFileGather APIs in SQL Server 6.5 On Linux the capabilities are called “ Vectored I/O.” – Example writev SQL Server on Linux takes full advantage of vectored I/O, retaining the performance and design benefits.

Servers 40
article thumbnail

Configuring PostgreSQL and LDAP Using StartTLS

Percona

While trying to be as complete yet succinct as possible, I’m detailing how to enable TLS between a PostgreSQL and the OpenLDAP server. Username accounts, but not passwords, are created on the Postgres server. Both username accounts and passwords are configured on the LDAP server. 0 ldap ldapserver=127.0.0.1

C++ 98
article thumbnail

Transparent Data Encryption (TDE)

Percona

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. Cluster-level encryption is a security measure that encrypts data stored in a cluster of servers or storage devices. . Database-level encryption. Table-level encryption.

article thumbnail

How to analyze PostgreSQL benchmark performance with HammerDB

HammerDB

The key findings of the article were as follows: This server had a HammerDB benchmark running against it. One possibility – and in this case, the most probable conclusion – is that the client test machine was overwhelmed and could not respond to the server fast enough. and start the build running.

article thumbnail

What are the best multi-browser testing tools?

Testsigma

Plus, there are multiple versions of operating systems and screen resolutions that our users browse content on. . This is connected to a cloud-based lab that comes equipped with browsers like Chrome, Firefox, Safari, and Edge, and while testing, you can choose the device, operating system, and screen resolutions on the test suites.