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

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++ 105
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

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 60
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 106
article thumbnail

Comparisons of Proxies for MySQL

Percona

MySQL router, after the 2048 connection, could not serve anything more. The Proxy in architectures involving MySQL/Percona Server for MySQL/Percona XtraDB Cluster is a crucial element for the scalability of the cluster, no matter if using K8s or not. That allows it to go a bit further.

Games 126
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

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. SHMMAX / SHMALL. The PostgreSQL documentation contains more information about shared memory configuration.

Tuning 59