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 69

Open Source C++ Servers Database 69

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Download specific Percona Server for MySQL 8 tarball packages and install them manually. Let’s start and test on Debian 11. Type 'c' to clear the current input statement.

Servers 84

Servers C++ Database Systems 84

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License.

Open Source 52

Open Source Servers Storage Scalability 52

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 92

Monitoring Tuning Metrics Servers 92

Percona

JANUARY 25, 2023

During our tests, we observed that the above methods helped us identify the active databases; however, we sometimes had to use two or more ways to get the best result. 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

Database 98

Database C++ Servers Open Source 98

Percona

APRIL 17, 2023

DD_SITE="datadoghq.eu" bash -c "$(curl -L [link] After execution, I can see the logs of Datadog agent installation and configuration and at the end: Installed: datadog-agent.x86_64 1:7.43.1-1 So the federated URL for exposing “*_up” metrics will be [link] I can test in on my PMM while being logged into it. 1 Complete!

Monitoring 71

Monitoring Metrics Database Open Source 71

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16

Testing 48

Testing Tuning Latency Storage 48

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. And did I mention they are open source?!

Cache 100

Cache Database Virtualization Servers 100

Percona

SEPTEMBER 13, 2018

Download the slow log(s) that match the time that you are interested to investigate, and optionally concatenate them. Run pt-query-digest on the downloaded logs and check the results. Download the log file. Depending on the size of the chosen log file, the above command will take some time to complete the download.

C++ 42

C++ AWS Open Source Testing 42

Testsigma

APRIL 28, 2021

Selenium is a tremendously popular automated testing tool for desktop, web applications. Testing on mobile devices is a major requirement that has grown exponentially in recent years. Why has the mobile testing requirement grown so much? million apps available for download There are 2.87 Test Management.

Mobile 69

Mobile Testing Open Source Java 69

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 62

Benchmarking Open Source C++ Cache 62

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

C++ Database Open Source Systems 95

HammerDB

MAY 26, 2022

Do you need to build from source? Before building from source, the first question should be, do you need to? HammerDB already provides pre-compiled packages from the download page so if you want to run HammerDB without building it then these packages are all you need. WHY build from source? Download HAMMERDB SOURCE.

C++ 113

C++ Database Open Source Servers 113

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

C++ Database Cache Storage 103

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

C++ Open Source Tuning Database 101

Percona

AUGUST 16, 2023

pgFormatter is an open source utility that takes SQL code as input and outputs beautifully formatted, indented, and aligned SQL code following a set of predefined rules. Download Percona Distribution for PostgreSQL Today! A powerful tool designed to beautify and standardize SQL code is pgFormatter. What is pgFormatter?

Code 78

Code Best Practices Open Source C++ 78

Percona

JUNE 26, 2023

If we have a table-level logical backup, then we can restore the “test” table backup, and our database will be in good shape. 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.

Hardware 76

Hardware C++ Database Open Source 76

Percona

DECEMBER 19, 2023

Since our previous blog post, Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test , it received new features such as TOAST data encryption and HashiCorp Vault support for key storage. deb package, or as source code on github. Download Percona Distribution for PostgreSQL Today!

Open Source 84

Open Source Storage Database C++ 84

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

C++ Database Open Source Monitoring 76

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 89

Hardware C++ Storage Cache 89

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

C++ Servers Database Open Source 101

Percona

DECEMBER 26, 2023

Although the default configuration simulates loading based loosely upon TPC-B, it is nevertheless easy to test other use cases by writing one’s own transaction script files. /bin/bash Download Percona Distribution for PostgreSQL Today! tps, lat 11.718 ms stddev 3.951 progress: 4440.0 Happy monitoring!

Benchmarking 122

Benchmarking Metrics C++ Database 122

The Netflix TechBlog

JANUARY 24, 2022

Why do we run Performance Tests on commits? By running performance tests against every commit (pre- and post-merge), we can detect potentially regressive commits earlier. What are the Performance Tests? There are roughly 50 performance tests, each one designed to reproduce an aspect of member engagement.

Performance 199

Performance Metrics Performance Testing Testing 199

Percona

DECEMBER 29, 2023

The point forgotten is that c onnections are owned by clients but maintained by a database. Most of the applications may not be designed and tested for handling such surprises. So unless the application is designed, developed, and tested for handling unexpected connection drops, it won’t be able to handle this.

Servers 81

Servers Database C++ Airlines 81

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

C++ Servers Open Source Testing 70

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. In fact all of this source code is also included in readable form with each and every release. These bin and lib directories are not included with the source code.

Architecture 40

Architecture Virtualization Open Source C++ 40

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 77

Database Traffic C++ Servers 77

Percona

JUNE 7, 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!

Database 76

Database Best Practices Open Source C++ 76

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 83

Database Monitoring C++ Speed 83

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 73

Transportation Database Open Source C++ 73

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

C++ Database Storage Testing 80

Percona

MARCH 27, 2023

limit(1) { "op" : "c", "ns" : "london.$cmd", Why go with a manual process when PBM is open source, does not require any license, and can handle it automatically? We also recommend checking out our blog MongoDB: Why Pay for Enterprise When Open Source Has You Covered? rs.metadata.json -rw-r--r-- 1 root root 1.1K

Games 95

Games Database Open Source C++ 95

Smashing Magazine

JULY 18, 2022

There are many use cases: personalization, internationalization, theming, multi-tenancy, A/B tests…. 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. Congratulations On Your New Job. Wow, you just got promoted! middlewares.

Cache 116

Cache Website Energy Servers 116

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 104

Database Servers Open Source Tuning 104

Percona

OCTOBER 17, 2023

As a final note, either upgrading or downgrading, It is always recommended to test the procedure in a lower/QA environment that mirrors the production environment, allowing you to get used to the process and clearing any doubts you may have. Download Percona Distribution for MongoDB Today! Conclusion MongoDB 7.0

Metrics 103

Metrics C++ Storage Database 103

Percona

FEBRUARY 23, 2023

I used Wasabi in my tests as it offers very easy registration for a trial and takes just a few minutes to get started if you want to test the service. Examples I believe real-case examples are best if you wish to test something similar, so here they are. Download Percona Distribution for MongoDB today! eu-central-2.wasabisys.com"}})

AWS 121

AWS Storage Database Open Source 121

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

Database 121

Database Open Source Servers C++ 121