2000, Availability, Database and Servers - Technology Performance Pulse

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

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

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

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

High Memory Usage on ProxySQL Server

Percona

DECEMBER 5, 2022

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. 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.

Servers

Servers Cache C++ Metrics

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

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

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

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

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

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

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.

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. With the reliability pillar of the Well-Architected Framework, organizations must ensure they build resilient and available applications. Figure 5 – Dynatrace measures over 2000 different metrics ready for use as dedicated SLIs. Missing caching layers.

Azure

Azure Monitoring Virtualization Metrics

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

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

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

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 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. For example, being readily available has led to a two-fold increase in active users for Microsoft Teams in the past year. Reputation. Enterprises work on the same philosophy.

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. You also have a premium plan that users can subscribe to so that they can avail themselves of lucrative offers. Most of the applications being developed today have complex requirements.

Testing

Testing Performance Testing Mobile Software

Platform Adjacency Theory

Alex Russell

JUNE 20, 2020

built-in relational SQL database engines. This matters because it is the corpus of attractive content uniquely available through a meta-platform that convinces users to adopt its runtime, and no platform developer can afford to build enough content to be compelling on their own. talking to POP and IMAP servers. floppy/CD/DVD).

Hardware

Hardware Games Java Media

Technology Performance Pulse

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

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

Trending Sources

Dealing With “Too Many Connections” Error in MySQL 8

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

High Memory Usage on ProxySQL Server

Impact of Querying Table Information From information_schema

Why MySQL Could Be Slow With Large Tables

When Do SQL Server Sorts Rewind?

Purging Data When the Table Is Big and Has Children Tables

SQL Server I/O Basics Chapter #1

SQL Server I/O Basics Chapter #2

tempdb Enhancements in SQL Server 2019

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

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

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

Deprecated features to take out of your toolbox – Part 1

How Many Warehouses for the HammerDB TPC-C Test?

How to deploy HammerDB CLI fast with Docker

Workflow Considerations for Using an Image Management Service

How should enterprises execute cross-browser testing?

Integration testing of your Android with Testsigma

Platform Adjacency Theory

Stay Connected