Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. and xtrabackup 2.4

Servers 103

Servers C++ Storage Systems 103

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. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 83

Servers C++ Database Systems 83

Sutter's Mill

MARCH 11, 2024

To talk about C++’s current safety problems and solutions well, I need to include the context of the broad landscape of security and safety threats facing all software. tl;dr: I don’t want C++ to limit what I can express efficiently. tl;dr: I don’t want C++ to limit what I can express efficiently. issues with C++.

C++ 139

C++ Programming Code Java 139

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. is out , I thought it might be time to do a bit of testing myself.

Servers 95

Servers C++ Testing Systems 95

Testlodge

APRIL 14, 2021

Configuration testing is performed to discover the optimum combinations of software and hardware specifications that allow the system to work without flaws. What is Configuration Testing? However, configuration testing is a time-consuming technique, so the team must create a workable plan. Types of Configuration Testing.

Testing 89

Testing Hardware Virtualization Operating System 89

Percona

DECEMBER 5, 2022

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 59

Servers Cache C++ Metrics 59

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. Percona XtraBackup 8.1

C++ 92

C++ Open Source Servers Database 92

HammerDB

DECEMBER 5, 2020

compared to previous releases is that the workload names have changed from TPC-C and TPC-H to TPROC-C and TPROC-H respectively and therefore a key question is how are the v4.0 The simple answer is nothing, the workloads are exactly the same workloads derived from the TPC-C and TPC-H specifications and HammerDB v4.0

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

SEPTEMBER 29, 2023

This is a global and dynamic variable, and we can set this mode when the server is running. Let’s test this. To test this, create a new user, “app_user,” with only the privileges for DDL/DML. If you are killing the connections manually or using pt-kill, you can’t avoid the new connection creation.

C++ 94

C++ Servers Open Source Database 94

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

Percona

MARCH 13, 2023

There is a section in our Documentation ( Introduction to Serverless PostgreSQL ) and a short overview of the primary components: Page Server The storage server with the primary goal of storing all data pages and WAL records Safe Keeper A component to store WAL records in memory (to reduce latency). 6400'" -c "listen_http_addr='0.0.0.0:9898'"

Serverless 118

Serverless C++ Storage Latency 118

Testlodge

MARCH 15, 2023

White box testing is a software testing approach based on an analysis of the internal structure of the component or system. Why is White Box Testing Performed? Testers perform white box testing for several reasons. Suppose developers perform unit testing before delivering code to testers.

Testing 83

Testing Testing Tools Java Programming 83

Percona

SEPTEMBER 19, 2023

This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable. Press ^C to stop.

C++ 104

C++ Servers Storage Speed 104

HammerDB

OCTOBER 17, 2018

For a really quick answer create a schema with 250-500 warehouses per server CPU socket for more details size as follows. . The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive.

C++ 40

C++ Testing Virtualization Cache 40

Testsigma

APRIL 23, 2021

So, there’s a solid reason why mobile app testing is a crucial step in any app development process. To ensure our users get a seamless experience across any device — we perform mobile app testing. . That’s where mobile app automation testing comes into the picture. Best Mobile App Automation Testing Tools.

Testing Tools 86

Testing Tools Mobile Testing Open Source 86

Percona

APRIL 21, 2023

Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 3306 0s ok 5.7.41-44-log 3306 0s ok 5.7.41-44-log

C++ 83

C++ Monitoring Database Open Source 83

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. Let’s proceed to performance testing.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

APRIL 13, 2022

To test the performance of your solution, you’ll need to populate the table with larger volumes of sample data. L0 AS ( SELECT 1 AS c. numgroups AS INT = 1000 , @rowspergroup AS INT = 10000 , -- test with 1000 to 10000 here. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise.

C++ 136

C++ Strategy Testing Servers 136

Dynatrace

JUNE 1, 2022

As a result, C-level executives say that cloud environments have bolstered cybersecurity challenges. Many of these libraries have not been adequately tested before deployment. Log4Shell enables a malicious actor to execute Java code and take control of a target server.

Artificial Intelligence 180

Artificial Intelligence Java Strategy Cloud 180

Alex Podelko

OCTOBER 28, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Quite often the whole area of load testing is reduced to pre-production testing using protocol-level recording/playback. – Cloud.

Performance Testing 100

Performance Testing Technology Technology Testing 100

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. servers.mongodirector.com:27017/test?replicaSet=RS-example-0&ssl=true" default: admin) auth_source: test.

C++ 100

C++ Servers Database Network 100

SQL Performance

MARCH 10, 2021

I’ll do my testing in tempdb, enabling time statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS TIME ON ; Earlier ideas. GetNumsAlanCharlieItzikBatch ( 1 , 100000000 ) ORDER BY n OPTION ( MAXDOP 1 ) ; Here are the time statistics that I got for this test: CPU time = 9328 ms, elapsed time = 9330 ms.

C++ 134

C++ Testing Code Servers 134

HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. these were enhanced to also add Python based scripts, and to include scripts for both TPROC-C and TPROC-H and a driver script for Linux environments. With the HammerDB v4.5 In HammerDB v4.6 With HammerDB v4.7 hammerdbcli auto./scripts/tcl/maria/tprocc/maria_tprocc_buildschema.tcl

C++ 83

C++ Virtualization Benchmarking Database 83

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 87

Database Servers Open Source C++ 87

Percona

FEBRUARY 10, 2023

Percona XtraBackup is an open source hot backup utility for MySQL-based servers. version is affected by this, as per my tests. This feature is available in Percona Server for MySQL 5.6+. So for Percona Server for MySQL 5.7 versions only; Percona Server for MySQL/Percona XtraDB Cluster/MySQL 8.0 Only MySQL 5.7

Storage 100

Storage Engineering Servers Open Source 100

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. This ensures that the statistics collection doesn’t cause any extra load on the server unless desired. Find the updated timestamp on datadir files.

Database 96

Database C++ Servers Open Source 96

Testsigma

JULY 31, 2021

The Shift Left testing approach is not a new term. This testing approach expedites testing and helps detect bugs in the early stages of development. But, First, What’s Shift Left Testing? Shift Left is a testing approach where testing begins right from the software development phase.

Testing 52

Testing Testing Tools Analytics Java 52

SQL Performance

JULY 13, 2022

To test the performance of the solutions, you’ll need a larger set of sample data. L0 AS ( SELECT 1 AS c. GetNums ( 1 , @numrows ) AS N ; Feel free, of course, to test the performance of the solutions with different data loading parameters if you’d like. The frame ends up including six rows in this row’s case.

C++ 112

C++ Code Azure Database 112

SQL Performance

JANUARY 13, 2021

L0 AS ( SELECT 1 AS c. ORDER BY rownum ; I used the following code to test the function with "Discard results after execution" enabled in SSMS: SELECT n FROM dbo. L0 AS ( SELECT 1 AS c. BatchMe ON 1 = 0. Alan Burstein's and Charlie's improvements.

C++ 113

C++ Code Testing Processing 113

Testsigma

JUNE 26, 2021

If we talk about testing itself — automation has taken us several leaps ahead; QA teams have solidified test efficiency and coverage even further. Gone are the days when automation testers had to learn coding to write test scripts. Enter codeless automation testing, which is one of the latest software trends to look out for.

Testing Tools 52

Testing Tools Testing Analytics Mobile 52

Testsigma

APRIL 16, 2021

Android developers and testers perform mobile tests to deliver apps that drive a high user retention rate through a great user interface. While mobile automation tests are performed for Android, iOS, and Windows devices, in this post, we’ll dive into the UI frameworks for Android automation testing. The Importance Of UI Testing.

Testing 52

Testing Open Source Mobile Java 52

HammerDB

OCTOBER 23, 2023

HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. Additionally, reviewing official TPC-C full disclosure reports highlighted that all vendors also use stored procedures.

Benchmarking 62

Benchmarking Database Network C++ 62

HammerDB

NOVEMBER 30, 2022

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. print(z," VU TEST") . print("TEST SEQUENCE COMPLETE"). Vuser 1:Timing test period of 1 in minutes Vuser 2:RUNNING Vuser 2:Initializing xtprof time profiler Vuser 2:Processing 10000000 transactions with output suppressed. >hammerdbcli py.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Percona

SEPTEMBER 15, 2023

At Percona Managed Services , we manage Percona Server for MySQL , Community MySQL, and MariaDB. In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 mariadb-common mariadb-server-10.5

Servers 100

Servers C++ Processing Testing 100

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. Let’s proceed to performance testing.

C++ 61

C++ Servers Testing Processing 61

Percona

FEBRUARY 16, 2023

I asked ChatGPT the question: “C an we backup and then remove the keyring file used for encryption at rest plugin after MySQL starts? ” keyring_file_data=/var/lib/mysql/keyring_file mysql> create database test; mysql> show create schema testG 1. row Database: test Create Database: CREATE DATABASE `test` /*!40100

Database 116

Database Servers Engineering Testing 116

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. pt-summary --user=root [?2004l# virtual = 2.2G

Cache 98

Cache Database Virtualization Servers 98