Percona

OCTOBER 4, 2023

As a result, both A and C directly inherit permissions from B and indirectly from D. As a result, both A and C directly inherit permissions from B and indirectly from D. In simpler language, we can view A and C as indirect descendants of D within the role hierarchy. Download Percona Distribution for PostgreSQL Today!

C++ 107

C++ Open Source Tuning Database 107

Adrian Cockcroft

FEBRUARY 9, 2023

The next layer is defined by the languages you want to use, Java, Python, Go, , Javascript, Rust etc, and the ecosystem of library functions you bought from a vendor or downloaded. Open source tools which have an open development model that allows your team to make contributions may be a better approach.

Engineering 137

Engineering Serverless Lambda AWS 137

Percona

DECEMBER 15, 2023

In PostgreSQL 15 and older versions postgres=#CREATE ROLE Alice CREATEROLE LOGIN; CREATE ROLE postgres=# CREATE role bob; CREATE ROLE postgres=# du bob List of roles Role name | Attributes | Member of --+ --+ -- bob | Cannot login | {} postgres=# c postgres alice You are now connected to database "postgres" as user "alice".

C++ 100

C++ Database Open Source Systems 100

Percona

APRIL 3, 2023

oid_test" SET WITHOUT OIDS; ALTER TABLE postgres=# c abs_test You are now connected to database "abs_test" as user "postgres". craft" SET WITHOUT OIDS; ALTER TABLE "public"."ports" ALTER TABLE "public"."oid_test" oid_test" SET WITHOUT OIDS; (1 row) Now we can execute the DDL to ALTER these tables. postgres=# ALTER TABLE "public"."oid_test"

C++ 109

C++ Database Cache Storage 109

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. respectively.

C++ 100

C++ Servers Open Source Database 100

Percona

SEPTEMBER 29, 2023

50642 | NULL | Binlog Dump | 2129 | Source has sent all binlog to replica; waiting for more updates | NULL | 2129291 | 0 | 0 | | 14 | bhuvan | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 | 0 | + -+ --+ + + -+ + --+ + + --+ + 3 rows in set (0.01 Download Percona Monitoring and Management Today

C++ 102

C++ Servers Open Source Database 102

Percona

NOVEMBER 3, 2023

And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty. The default number of shards generated for a given table is 32. psql pgbench <<_eof1_ qecho adding node citus3. psql pgbench <<_eof1_ qecho adding node citus3.

Database 110

Database Benchmarking Latency C++ 110

The Netflix TechBlog

JUNE 25, 2021

In this blog post, we are thrilled to share that we are open-sourcing one such tool: the Netflix Data Explorer. The Explore mode supports full CRUD of records and allows you to export result sets to CSV or download them as CQL insert statements. As you submit queries, they will be saved in the Recent Queries view as well?—?handy

Metrics 158

Metrics Best Practices Strategy Design 158

Percona

JUNE 5, 2023

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Download Percona Distribution for PostgreSQL Today! 22 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:5432 5432 0.0.0.0:* LISTEN tcp 0 0 127.0.0.53:53

Database 126

Database Open Source Servers C++ 126

Percona

DECEMBER 22, 2022

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Download Percona Distribution for PostgreSQL Today!

C++ 78

C++ Database Open Source Monitoring 78

Testsigma

APRIL 23, 2021

Appium: Appium is one of the most preferred testing tools, especially by the open-source community. It also supports the testing of native, hybrid, and mobile web apps across various programming languages like Java, Ruby, C#, Javascript, PHP, Python. Being open-source, it also has a rich community! .

Testing Tools 86

Testing Tools Mobile Testing Open Source 86

Percona

JULY 19, 2023

Well, “easy” if you know just a tiny bit of C++. Our function will implement a ULID generator using a C++ library from ChrisBove/ulid. Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ Plugin compiled.

C++ 85

C++ Servers Benchmarking Best Practices 85

The Netflix TechBlog

JANUARY 24, 2022

Regressive build is above alert threshold Subsequent build is easily below alert threshold c) Performance tests against PRs, which had been almost constantly red (because the probability of at least one static threshold being breached was always high), are now mostly green. Their utility extends well beyond performance analysis.

Performance 210

Performance Performance Testing Metrics Testing 210

HammerDB

JUNE 27, 2022

As the TPC makes its specifications available for free, the need was seen for an open source benchmarking application that could leverage the standards written by the TPC yet implemented quickly, easily and at low cost by anyone. HammerDB maintains a web page under the stats link where the number of downloads can be tracked.

Benchmarking 63

Benchmarking Open Source C++ Cache 63

Percona

DECEMBER 26, 2023

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Download Percona Distribution for PostgreSQL Today! tps, lat 11.718 ms stddev 3.951 progress: 4440.0 Happy monitoring!

Benchmarking 127

Benchmarking Metrics C++ Database 127

Percona

MARCH 28, 2023

wt list -c WiredTigerCheckpoint.33: Download Percona Distribution for MongoDB Today! These checkpoints are stored in WiredTiger.wt The above diagram shows the information present in a checkpoint, while the below output shows how it looks when listed using the “wt” utility. $

Hardware 94

Hardware C++ Storage Cache 94

Percona

MAY 8, 2023

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Download Percona Distribution for PostgreSQL Today! Step 4: Pause replication on replica2::10.0.0.40

C++ 106

C++ Servers Database Open Source 106

Percona

JUNE 26, 2023

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together. Download Percona Distribution for PostgreSQL Today!

Hardware 80

Hardware C++ Database Open Source 80

Percona

JANUARY 25, 2023

sudo grep Schema: /var/lib/mysql/mysql-slow.log| awk -F' ' '{print $4 $5}' | sort | uniq -c 2717 Schema:mytestdb 123 Schema:percona 762238 Schema:sbtest Example for 8.0 Download Percona Distribution for MySQL Today Now parse the output table_usage.log using the below command to identify unique database objects. $

Database 103

Database C++ Servers Open Source 103

Percona

FEBRUARY 23, 2023

join('n')") $ for i in $mycolls; do mongoexport -d $mydb -c $i |zstd| s3cmd put - s3://mbackups/$ts/$mydb/$i.json.zst; done 2023-02-07T19:30:37.163+0100 connected to: mongodb://localhost/ 2023-02-07T19:30:38.164+0100 [#######.] Download Percona Distribution for MongoDB today! ts=$(date +%Y-%m-%d.%H-%M) eu-central-2.wasabisys.com"}})

AWS 125

AWS Storage Database Open Source 125

Percona

DECEMBER 5, 2022

This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. 22 Percona Server (GPL), Release '22', Revision '7e301439b65' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'help;' or 'h' for help.

Open Source 70

Open Source C++ Servers Database 70

Testsigma

APRIL 28, 2021

million apps available for download There are 2.87 million apps available for download on the Google Play Store 21% of Millennials open an app 50+ times per day. We understand that Selendroid and Appium are open-source automation tools. It is open-source, hence free to use. Test Management.

Mobile 69

Mobile Testing Open Source Java 69

Percona

JUNE 15, 2023

Download specific Percona Server for MySQL 8 tarball packages and install them manually. Install the curl download utility $ sudo apt install curl Reading package lists. Install the curl download utility $ sudo apt install curl Reading package lists. Type 'c' to clear the current input statement. Setting up curl (7.74.0-1.3+deb11u7).

Servers 88

Servers C++ Database Systems 88

Percona

DECEMBER 19, 2023

This, with some additional information, is what gets stored in the.tde file: hexdump -C /tmp/tdedata/postgresql/data/base/5/16397.tde This is open source software, and the old adage about having many eyeballs on the code to ensure its quality is applicable here, as Percona wants your input.

Open Source 89

Open Source Storage Database C++ 89

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

Smashing Magazine

JUNE 1, 2022

The data may have some limitations, though — the only data that can be collected is what the APIs support, and C ross O rigin R esource S haring ( CORS ) restrictions in the browsers limit some details, especially around third-party resource requests. Other blocking effects. A third-party font request could cause render-blocking.

Website 133

Website Design Network Testing 133

Percona

JUNE 28, 2023

postgres=# create database d1; CREATE DATABASE postgres=# postgres=# c d1 You are now connected to database "d1" as user "postgres". link] [link] Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together.

Transportation 77

Transportation Database Open Source C++ 77

Percona

SEPTEMBER 27, 2023

PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community. Download Percona Distribution for PostgreSQL Today! pg_partman creates and manages both time-based and serial-based table partition sets.

Storage 106

Storage Open Source Database Efficiency 106

Percona

OCTOBER 17, 2023

Percona Distribution for MongoDB is a freely available MongoDB database alternative, giving you a single solution that combines the best and most important enterprise components from the open source community, designed and tested to work together. Download Percona Distribution for MongoDB Today!

Metrics 108

Metrics C++ Database Storage 108

Percona

AUGUST 2, 2023

while true; do if [ -f /proc/<RESTORE_PID>/io ] then bytes_progress=$(cat /proc/<RESTORE_PID>/io | awk '/^rchar/ {print $2}') bytes_total=$(cat <BACKUP_FILE> | wc -c) progress=$(awk "BEGIN {printf "%.2f", Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Database 87

Database Monitoring C++ Speed 87

Percona

NOVEMBER 9, 2023

For generating load, we used pgbench with the following commands: shell> pgbench -i -s 100 sbtest shell> pgbench -c 8 -j 3 -T $((60*60*4)) -N -S -P 1 sbtest Creating a custom query collector Note: This step will not be needed with soon-to-come postgresql_exporter PMM versions! Download Percona Monitoring and Management Today

Monitoring 96

Monitoring Tuning Metrics Servers 96

Percona

AUGUST 21, 2023

Download Percona Distribution for PostgreSQL Today! 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

Smashing Magazine

JULY 18, 2022

There was something he wanted to C."; If users have a slow network or a slow computer, they will see an ugly loader while their joke is being downloaded. Contrary to cloud proxies such as AWS Gateway or open source tools such as Nginx, middlewares are written in JavaScript, using Web standards, namely the fetch API.

Cache 118

Cache Website Servers Energy 118

Percona

DECEMBER 29, 2023

The point forgotten is that c onnections are owned by clients but maintained by a database. age=236s) 2023-11-14 16:17:40.533 UTC [4630] LOG C-0x10af130: postgres/pgbtestapp@[::1]:39470 closing because: server conn crashed? Download Percona Distribution for PostgreSQL Today! It’s like a bank account.

Servers 86

Servers Database C++ Airlines 86

KeyCDN

JUNE 25, 2020

Vim was made available in 1991 and is a free, open source software. If you're used to using keyboard shortcuts like Ctrl + C and Ctrl + S , you shouldn't have too much difficulty getting used to the way that Vim works.

Games 125

Games Open Source Availability C++ 125

Percona

DECEMBER 5, 2023

p 5432 -S slot_logical_upgrade -R -c fast -Xs -P -D /data/PG12_new -C 32610/32610 kB (100%), 1/1 tablespace 8. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together.

Database 82

Database Traffic C++ Servers 82

Percona

AUGUST 30, 2023

psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8) postgres=# select name,setting,source,context from pg_settings where name='synchronous_commit'; name | setting | source | context --+ --+ --+ synchronous_commit | off | client | user (1 row) 10. Type "help" for help.

Database 109

Database Servers Open Source Tuning 109