SQL Server According to Bob

JANUARY 31, 2017

Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting and other activities applications may require to gain improved I/O performance. On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048.

Servers 40

Servers Software Engineering Operating System Database 40

Percona

MARCH 20, 2023

MySQL router, after the 2048 connection, could not serve anything more. HAProxy performs better with a low number of connections, while ProxySQL performs better when a high number of connections is in place. That allows it to go a bit further. MySQL Router is the one that has the higher latency no matter what.

Games 125

Games Latency Traffic Cache 125

HammerDB

NOVEMBER 22, 2021

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. This enables the user to compare and contrast performance across different benchmark scenarios. The PostgreSQL performance metrics will automatically start to be populated in the viewer.

Metrics 62

Metrics Benchmarking C++ Database 62

Percona

OCTOBER 2, 2023

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.

Cache 104

Cache Database Virtualization Servers 104

Percona

AUGUST 21, 2023

Even though there is an encrypted session between psql and the Postgres server, there is no encrypted session between Postgres and LDAP as authentication is performed: SSL connection (protocol: TLSv1.3,

C++ 74

C++ Servers Open Source Testing 74

Percona

DECEMBER 27, 2022

Implementing table-level encryption may require additional resources and impact performance, so carefully evaluating the trade-offs between security and performance is essential. This allows for more granular control over data access and improves performance because only the necessary columns are decrypted when querying data.

Database 94

Database Storage Servers Strategy 94

Testsigma

MAY 5, 2021

To ensure the features run uniformly across various browsers and OS versions that our users have, we should perform multi-browser testing. You can also check out our post on the most common issues one can face while performing browser compatibility tests. Let us understand the importance of multi-browser testing before we proceed.

Testing Tools 74

Testing Tools Testing Internet Internet 74

Percona

AUGUST 29, 2023

Reference tables can be replicated to all nodes for joins and foreign keys from distributed tables and for maximum read performance. Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. The same can be said for Citus data sharding. The colors indicate duplicated shards of the table.

C++ 84

C++ Database Storage Testing 84

n0derunner

MARCH 13, 2020

8 Sectors = 4KB 128 Sectors = 64KB 1024 Sectors = 512KB 2048 Sectors = 1024KB (1MB). Take a look at the column “avgrq-sz” (average request size) which will tell you the IO average IO size that is sent to the device. Normally this is reported in “sectors” which are 512bytes in size. Using iostat.

Benchmarking 45

Benchmarking Storage Testing Performance 45

Dean Hume

OCTOBER 24, 2016

We didn’t change any code, or even make any web performance tweaks - we made the switch and noticed the results immediately. If too many requests are made, it can negatively affect the performance of your web page due to the fact that HTTP/1.1 A lot of the web performance hacks that we currently use are no longer needed!

Servers 40

Servers Website Games Cache 40

Dean Hume

OCTOBER 24, 2016

We didn’t change any code, or even make any web performance tweaks - we made the switch and noticed the results immediately. If too many requests are made, it can negatively affect the performance of your web page due to the fact that HTTP/1.1 A lot of the web performance hacks that we currently use are no longer needed!

Servers 40

Servers Website Games Cache 40

Dean Hume

OCTOBER 24, 2016

We didn’t change any code, or even make any web performance tweaks - we made the switch and noticed the results immediately. If too many requests are made, it can negatively affect the performance of your web page due to the fact that HTTP/1.1 A lot of the web performance hacks that we currently use are no longer needed!

Servers 40

Servers Website Games Cache 40

Brendan Gregg

AUGUST 18, 2019

bpftrace is a new open source tracer for Linux for analyzing production performance problems and troubleshooting software. Linux already has many performance tools, but these are often counter-based and have limited visibility. Originally posted at https:/opensource.com/article/19/8/introduction-bpftrace. bashreadline.bt

Latency 57

Latency C++ Cache Programming 57

CSS - Tricks

MAY 15, 2019

You might have to perform a hard reload ( CTRL + Shift + R ) to re-trigger range requests. In contrast to JavaScript lazy-loading libraries, native lazy-loading uses a kind of pre-flight request to get the first 2048?bytes If this column is filled, the browser made a successful range request. The auto (or unset) value. <img

Traffic 58

Traffic Website Network Servers 58

Tim Kadlec

SEPTEMBER 6, 2018

The two results that jump out right away as oddities are The Atlantic and The Verge which managed to get a whopping 293% and 2048% heavier without JavaScript. It’s just one of many tricks in their bag to provide a more performant experience and they appear to be treading carefully when it comes to applying it.

Network 71

Network Testing Cache Google 71

SQL Server According to Bob

JANUARY 11, 2020

​​ This is similar to the ​​ suspend and resume ​​ operations performed by ​​ the operating system. ​​ Performing ​​ safety ​​ checks ​​ of SQL Server and all other system components before production deployment is very important.

Servers 40

Servers Cache Database Media 40