2000, Database, Servers and Testing - Technology Performance Pulse

Dealing With “Too Many Connections” Error in MySQL 8

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++

C++ Database Servers Open Source

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

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

Servers C++ Database Systems

Impact of Querying Table Information From information_schema

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7

Cache

Cache Hardware Servers Benchmarking

Why MySQL Could Be Slow With Large Tables

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. sec) db1 test> CREATE TABLE tb3 (id int auto_increment primary key, test_text tinytext); Query OK, 0 rows affected (0.13

Open Source

Open Source Storage Database Big Data

High Memory Usage on ProxySQL Server

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. Proxysql has a stats database which we can see with an admin login. Explanation. How do we know where the memory is getting used?

Servers

Servers Cache C++ Metrics

Purging Data When the Table Is Big and Has Children Tables

Percona

MARCH 3, 2023

23] (Slave_delay: 0) This means the following: A primary server, with Percona Server for MySQL installed (in Read/Write mode) version 8.0.31-23. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. mysqlserver01=127.0.0.2 [RW] RW] [ver: 8.0.31-23]

Database

Database Testing Servers Open Source

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

Percona

FEBRUARY 16, 2023

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 00000030: 0000 0000 0000 0000 2000 0000 0000 0000. 00000030: 0000 0000 0000 0000 2000 0000 0000 0000.

Database

Database Servers Engineering Testing

Percona Toolkit – A Quick Introduction to Summary

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?! virtual = 2.2G

Cache

Cache Database Virtualization Servers

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers

Servers Cache Database Media

tempdb Enhancements in SQL Server 2019

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. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers

Servers C++ Testing Systems

Bootstrap PostgreSQL on Kubernetes

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. You can find all examples from this blog post in this GitHub repository. Everything is created with postgres admin user. Search for init SQL.

Storage

Storage Database Media Open Source

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: Bob Dorr, Microsoft SQL Server Escalation Published: December, 2004 SUMMARY: Learn the I/O requirements for Microsoft SQL Server database file operations. Then follow the instructions to either download the BOL or browse online.

Servers

Servers Cache Media Hardware

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers

Servers Media Cache Storage

The Different Software Testing Types Explained

Testsigma

FEBRUARY 6, 2020

According to IEEE Std 829-1998, Software Testing is defined as “the process of analyzing a software item to detect the differences between existing and required conditions (i.e. ” With the advent of new technologies and new software being released every day, software testing is gaining more strength and accolades.

Software

Software Software Testing Scalability

Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic

Traffic Scalability Database Servers

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL. sec). . <AUDIT_RECORD

Open Source

Open Source C++ Servers Database

Azure Well-Architected Framework: What it is and how to tame it with AI and automation

Dynatrace

APRIL 21, 2022

Too much data requested from a database. Some principles Microsoft provides to help organizations across this area include: Define and test availability targets such as service level agreements (SLAs) and SLOs. Figure 5 – Dynatrace measures over 2000 different metrics ready for use as dedicated SLIs. Missing caching layers.

Azure

Azure Monitoring Virtualization Metrics

How Many Warehouses for the HammerDB TPC-C Test?

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

C++ Testing Virtualization Cache

How should enterprises execute cross-browser testing?

Testsigma

NOVEMBER 16, 2021

We shall also see how decisions are made in an enterprise and why cross-browser testing is the most important thing in 2021 to sustain a healthy business. Considering this requirement and the website load, enterprises generally set up multiple servers and machines that can talk to each other through a network. Needs of an enterprise.

Testing

Testing Website Small Business Internet

Integration testing of your Android with Testsigma

Testsigma

FEBRUARY 27, 2021

Hence, they need to be tested thoroughly and for each use-case, before they are ready to be deployed in the production server. We all know how important it is to perform unit testing on separate modules or “units of codes”. This is where the need for Android integration testing arises. Let’s consider a simple example.

Testing

Testing Performance Testing Mobile Software

How to deploy HammerDB CLI fast with Docker

HammerDB

DECEMBER 14, 2022

The TPC publishes an official Docker image on Docker Hub to enable the rapid deployment and testing of databases with HammerDB. This image includes example scripts to build schemas and test your databases with a single command. Our Linux test system is running a MariaDB 10.10 Database Configuration.

C++

C++ Virtualization Database Benchmarking

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. The following chart shows the same 1TB database testing. SQL Server. SQL Server 2014.

Hardware

Hardware Cache Servers Software Engineering

Workflow Considerations for Using an Image Management Service

CSS - Tricks

OCTOBER 16, 2019

The images should be uploaded to my own server. But it should go to my server first, then to the service. The most important thing being that the content in my database has fully functional HTML with a src on the image that points to a real image on my real server. Australians get images from servers hosted in Australia.

Media

Media Servers Database Design

Technology Performance Pulse

Dealing With “Too Many Connections” Error in MySQL 8

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Trending Sources

Impact of Querying Table Information From information_schema

Why MySQL Could Be Slow With Large Tables

High Memory Usage on ProxySQL Server

Purging Data When the Table Is Big and Has Children Tables

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

Percona Toolkit – A Quick Introduction to Summary

SQL Server I/O Basics Chapter #2

tempdb Enhancements in SQL Server 2019

Bootstrap PostgreSQL on Kubernetes

SQL Server I/O Basics Chapter #1

SQL Server On Linux: Forced Unit Access (Fua) Internals

The Different Software Testing Types Explained

Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Azure Well-Architected Framework: What it is and how to tame it with AI and automation

How Many Warehouses for the HammerDB TPC-C Test?

How should enterprises execute cross-browser testing?

Integration testing of your Android with Testsigma

How to deploy HammerDB CLI fast with Docker

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

Workflow Considerations for Using an Image Management Service

Stay Connected