article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. It’s easy with anydbver and k3d.

C++ 103
article thumbnail

High Memory Usage on ProxySQL Server

Percona

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 61
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

Stuff The Internet Says On Scalability For February 1st, 2019

High Scalability

The AGC weighed 70 pounds and had 2048 words of RAM in erasable core memory and 36,864 words of ROM in core rope memory. ludovicc : We spent many years to remove stored procedures and put business logic in an application server, why do you want to go back to that? It flew to the moon. Do you like this sort of Stuff? Need cloud?

Internet 146
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

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 104
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++ 71
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

One of my favourite features of HTTP/2 is Server Push. the browser requests a web page, the server sends the HTML in the response, and then it needs to wait for the browser to parse the HTML and issue requests for all of the embedded assets before it can start sending the JavaScript, images and CSS. With HTTP/1.1, Show me the code!

Servers 40