2000, Database and Servers - 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

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Percona

JUNE 2, 2023

WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source. MySQL was founded in 1995 and went open source in 2000. MySQL was the database for phpWebLog, for example, way back in 2000.

Open Source

Open Source Traffic Tuning Database

Save Money in AWS RDS: Don’t Trust the Defaults

Percona

MAY 1, 2023

After some time of receiving these messages, eventually, they hit performance issues to the point that the server becomes unresponsive for a few minutes. The innodb_io_capacity_max parameter was set to 2000, so the hardware should be able to deliver that many IOPS without major issues. After that, things went back to normal.

AWS

AWS Hardware Storage Tuning

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 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache

Cache Hardware Servers Benchmarking

When Do SQL Server Sorts Rewind?

SQL Performance

OCTOBER 7, 2020

If you’re interested in table-valued function rewinds, please see my Q & A on Database Administrators Stack Exchange. The Sort operator’s rewind behaviour may seem strange, but it has been this way from (at least) SQL Server 2000 to SQL Server 2019 inclusive (as well as Azure SQL Database). Sort Rewinds.

Servers

Servers Cache Azure Performance

Update Percona Monitoring and Management Agent Settings for Already-Added Instances

Percona

JULY 19, 2023

In the example, we run PMM server in a docker container. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. It helps you reduce complexity, optimize performance, and improve the security of your business-critical database environments, no matter where they are located or deployed.

Monitoring

Monitoring Entertainment Open Source Tuning

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. This can help to split large data sets into smaller ones stored in multiple servers. 1 mysql mysql 592K Dec 30 02:48 tb1.ibd

Open Source

Open Source Storage Database Big Data

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

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

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Commands end with ; or g. Type 'help;' or 'h' for help. copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database

Database Performance C++ Engineering

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

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]

Testing

Testing Database Servers Open Source

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. Figure 5 – Dynatrace measures over 2000 different metrics ready for use as dedicated SLIs. Serverless – Deploy OneAgent via ARM templates or Site Extensions for Azure App Server or Azure Functions to get code level insights. Missing caching layers.

Azure

Azure Monitoring Virtualization Metrics

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

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

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

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

Quick Data Archival in MySQL Using Partitions

Percona

JANUARY 5, 2023

In this blog, I will share a solution to remove this space and remove rows from tables in a few seconds regardless of the size of a table without causing any additional load on the database using table partitions. The first approach that comes to anyone’s mind for deleting the row is using a DELETE query in SQL. What is partitioning?

Traffic

Traffic Engineering Speed Storage

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

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 Servers Cache Software Engineering

The Different Software Testing Types Explained

Testsigma

FEBRUARY 6, 2020

How well the application will perform under stressful conditions of Database, Users, Data Load etc. Volume Testing- Aim of this testing is to ascertain how well the system behaves when a large volume of data or data operations are handled by Database. Will the database be able to store and process a huge volume of data?

Software

Software Software Testing Scalability

Deprecated features to take out of your toolbox – Part 1

SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency

Latency Servers Monitoring Systems

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. . However most people use HammerDB with keying and thinking time disabled and therefore each virtual user can approximately drive the CPU resources of one CPU core on the database server.

C++

C++ Testing Virtualization Cache

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

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. hammerdb>librarycheck Checking database library for Oracle Success. Database Configuration.

C++

C++ Virtualization Database Benchmarking

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. There are high chances of encountering errors in the interface between the software modules and databases. Most of the applications being developed today have complex requirements.

Testing

Testing Performance Testing Mobile Software

How should enterprises execute cross-browser testing?

Testsigma

NOVEMBER 16, 2021

Considering this requirement and the website load, enterprises generally set up multiple servers and machines that can talk to each other through a network. This includes the design principles, server communications or data transfers and storage. This increases the accessibility of test cases for all the teams related to a project.

Testing

Testing Website Small Business Internet

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

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

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

Platform Adjacency Theory

Alex Russell

JUNE 20, 2020

built-in relational SQL database engines. Absent compelling content and attentive security and performance focus, it soon retreated to the server. [6]. talking to POP and IMAP servers. Other use-cases weren't addressable with early 2000's tech. high-color image raster. vector rendering and graphics filter APIs.

Games

Games Hardware Java Mobile

Technology Performance Pulse

Dealing With “Too Many Connections” Error in MySQL 8

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Trending Sources

Save Money in AWS RDS: Don’t Trust the Defaults

Impact of Querying Table Information From information_schema

When Do SQL Server Sorts Rewind?

Update Percona Monitoring and Management Agent Settings for Already-Added Instances

Why MySQL Could Be Slow With Large Tables

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

tempdb Enhancements in SQL Server 2019

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

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

Purging Data When the Table Is Big and Has Children Tables

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

Percona Toolkit – A Quick Introduction to Summary

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

High Memory Usage on ProxySQL Server

SQL Server I/O Basics Chapter #1

Quick Data Archival in MySQL Using Partitions

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

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

The Different Software Testing Types Explained

Deprecated features to take out of your toolbox – Part 1

How Many Warehouses for the HammerDB TPC-C Test?

Workflow Considerations for Using an Image Management Service

How to deploy HammerDB CLI fast with Docker

Integration testing of your Android with Testsigma

How should enterprises execute cross-browser testing?

SQL Server I/O Basics Chapter #2

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

Bootstrap PostgreSQL on Kubernetes

Platform Adjacency Theory

Stay Connected