SQL Server According to Bob

JANUARY 31, 2017

On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048. Within LibOS, when we detect a request exceeding 2048 OS pages, we split the request into multiple 2048 page chunks, deemed sub-I/O requests. The buffers must be the operating system page size (4K.)

Servers 40

Servers Software Engineering Operating System Database 40

Percona

OCTOBER 2, 2023

autovacuum_analyze_threshold : 50 autovacuum_freeze_max_age : 200000000 autovacuum_max_workers : 3 autovacuum_multixact_freeze_max_age : 400000000 autovacuum_naptime : 60 autovacuum_vacuum_cost_delay : 2 autovacuum_vacuum_cost_limit : -1 autovacuum_vacuum_insert_scale_factor : 0.2 createrole_self_grant : cursor_tuple_fraction : 0.1

Cache 106

Cache Database Virtualization Servers 106

HammerDB

SEPTEMBER 24, 2024

To use pgSentinel we have installed pg_stat_statements and pgsentinel and added the following to our postgresql.conf. and start the build running.

Benchmarking 68

Benchmarking Performance Metrics Database 68

HammerDB

NOVEMBER 22, 2021

shared_preload_libraries = 'pg_stat_statements,pgsentinel' track_activity_query_size=2048 pg_stat_statements.save=on pg_stat_statements.track=all pgsentinel_pgssh.enable = true pgsentinel_ash.pull_frequency = 1 pgsentinel_ash.max_entries = 1000000. ./ -I/opt/postgresql-14.1/include/server include/server -I/opt/postgresql-14.1/include/internal

Metrics 63

Metrics Benchmarking C++ Database 63

Percona

AUGUST 21, 2023

Once copied into the correct directory, the list of CA certificates is updated, adding the self-signed CA certificate: # # Update list of CA certificate on both # postgres and LDAP servers # update-ca-certificates Generating the LDAP public/private key From here on, it is important to include the fully qualified domain name of the LDAP certificate (..)

C++ 74

C++ Servers Open Source Testing 74

Percona

DECEMBER 27, 2022

To use public-key encryption with pgcrypto, you will need to generate a pair of keys using the pgp_gen_key function: SELECT * FROM pgp_gen_key('my_key', 'rsa', 2048, '', '', 'my@email.com'); This will generate a pair of keys and return them as a record. The public key encrypts the data, and the private key decrypts the data.

Database 94

Database Storage Servers Strategy 94

Testsigma

MAY 5, 2021

Price : $29 upwards monthly, when billed annually. EndTest: EndTest is a scriptless testing tool that supports end-to-end web and mobile testing. Apart from video recording the test results, it lets us schedule our tests, and also sends out API requests in our tests.

Testing Tools 74

Testing Tools Testing Internet Internet 74

Percona

DECEMBER 5, 2022

2) mysql-query_digests_max_digest_length – This is by default set to 2048. If you need, you can enable it. You can reduce it to a minimum of 16. This will result in the queries like: select * from test to select * from te The digest text will be limited to 16 characters counting with space and comments in the query.

Servers 60

Servers Cache C++ Metrics 60

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.

Storage 45

Storage Benchmarking Testing Performance 45

Brendan Gregg

MAY 8, 2021

Hit Ctrl-C to end.

Performance 40

Performance Latency Speed Systems 40

Brendan Gregg

MAY 8, 2021

Hit Ctrl-C to end.

Performance 40

Performance Latency Speed Systems 40

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. In case you’re curious (I was), it’s because they are doing a lot of lazy-loading of images with JavaScript.

Network 71

Network Testing Cache Google 71

Percona

AUGUST 29, 2023

Step three: Check packages Inspecting the nodes confirms Citus has been correctly installed: for u in citus1 citus2 citus3 citus4 citus-coord-01 do echo " = NODE: $u =" lxc exec $u -- su - postgres -c 'psql db01'<<_eof_ select extname, extversion from pg_extension; _eof_ done | less -S = NODE: citus1 = extname | extversion -+ plpgsql | 1.0

C++ 84

C++ Database Storage Testing 84

Dean Hume

OCTOBER 24, 2016

openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt. To test this code locally, I created my own self signed certificates using OpenSSL - you can do this using a one line command in your terminal. Next, fire up your browser and head over to [link].

Servers 40

Servers Website Games Cache 40

Dean Hume

OCTOBER 24, 2016

openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt. To test this code locally, I created my own self signed certificates using OpenSSL - you can do this using a one line command in your terminal. Next, fire up your browser and head over to [link].

Servers 40

Servers Website Games Cache 40

Dean Hume

OCTOBER 24, 2016

openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt. To test this code locally, I created my own self signed certificates using OpenSSL - you can do this using a one line command in your terminal. Next, fire up your browser and head over to [link].

Servers 40

Servers Website Games Cache 40

Brendan Gregg

AUGUST 18, 2019

There are also two modes visible, one between 1 and 2 milliseconds, and another between 8 and 16 milliseconds: this sounds like cache hits and cache misses.

Latency 57

Latency C++ Cache Programming 57

CSS - Tricks

MAY 15, 2019

In contrast to JavaScript lazy-loading libraries, native lazy-loading uses a kind of pre-flight request to get the first 2048?bytes How the loading attribute works. bytes of the image file.

Traffic 58

Traffic Website Network Servers 58

SQL Server According to Bob

JANUARY 11, 2020

​​ Remote mirroring captures writes and duplicates them ​​ remotely.

Servers 40

Servers Cache Database Media 40