2000, Database and Open Source - Technology Performance Pulse

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

JUNE 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? higher throughput over DigitalOcean Managed Databases across all thread counts. At a glance – TLDR. Compare Latency.

Database

Database Benchmarking Latency Performance

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

Percona

JUNE 2, 2023

While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. It was simple, easy to deploy, and easy to use, and WordPress had the added benefit of being open source. MySQL was founded in 1995 and went open source in 2000.

Open Source

Open Source Traffic Tuning 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. Figure 5 – Dynatrace measures over 2000 different metrics ready for use as dedicated SLIs. The Dynatrace Application Security module automatically detects, assesses, and remediates open-source and third-party vulnerabilities for Java workloads. Missing caching layers.

Azure

Azure Monitoring Virtualization Metrics

Fixing Misplaced Rows in a Partitioned Table

Percona

MARCH 29, 2023

mysql> SELECT * FROM salaries where emp_no=10001 and from_date='1999-06-23'; + --+ --+ + + | emp_no | salary | from_date | to_date | + --+ --+ + + | 10001 | 84917 | 1999-06-23 | 2000-06-22 | + --+ --+ + + 1 row in set (0.00 sec) But once the data is misplaced, it does not return any rows. Try Percona Distribution for MySQL today!

Engineering

Engineering Open Source Database Scalability

Data Movement in Netflix Studio via Data Mesh

The Netflix TechBlog

JULY 26, 2021

In the initial stage, data consumers set up ETL pipelines directly pulling data from databases. With this batch style approach, several issues have surfaced like data movement is tightly coupled with database tables, database schema is not an exact mapping of business data model, and data being stale given it is not real time etc.

Big Data

Big Data Government Processing Analytics

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

Percona

JULY 19, 2023

Once inside, login to the PostgreSQL database (that’s where PMM keeps some of the settings): psql -U pmm-managed Switch to vertical output for the sake of readability, analog to using G in MySQL at the end of the query or running mysql with -E key, but in PostgreSQL, it is a setting: pmm-managed=> x Expanded display is on.

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. Some of them are: MySQL Cluster: MySQL NDB Cluster is an in-memory database clustering solution developed by Oracle for MySQL.

Open Source

Open Source Storage Database Big Data

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

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 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Your MySQL connection id is 256 Server version: 8.0.32-24.2

Database

Database Performance C++ Engineering

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. You can read some optimization examples in the official doc: [link]. Results for Percona Server for MySQL 8.0 While you are on 5.7, Try Percona Distribution for MySQL today!

Cache

Cache Hardware Servers Benchmarking

Purging Data When the Table Is Big and Has Children Tables

Percona

MARCH 3, 2023

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. The person who tried to run this in production did not do the following: Run some previous backups of the rows to delete. Check if the table had referential integrity, child tables. Check the size of the table.

Testing

Testing Database Servers Open Source

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

Cache

Cache Database Virtualization 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. Conclusion.

Open Source

Open Source C++ Servers Database

HammerDB v4.2 New Features Pt1: MariaDB Build and Test Example with the CLI

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. Checking database library for MariaDB Error: failed to load mariatcl - couldn't load file "/home/HammerDB-4.2/lib/mariatcl0.1/libmariatcl0.1.so":

Testing

Testing C++ Virtualization Tuning

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

Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. bullseye [112 MB] …… (Reading database. deb (Reading database.

Servers

Servers C++ Database Systems

Progress Delayed Is Progress Denied

Alex Russell

APRIL 29, 2021

Apple Corporate is at fault, not Open Source engineers or the line managers who support them. The open, royalty-free codec AV1 has been delivered instead. The data captured by MDN Browser Compatibility Data Respository and the caniuse database is often partial and sometimes incorrect. CSS color().

Media

Media Games Education Engineering

Platform Adjacency Theory

Alex Russell

JUNE 20, 2020

built-in relational SQL database engines. Consider the set of features the circa-2000 web could handle: Starting from a text-only document format in 1990, the web added features at a furious pace in the first decade, but not in a principled way. Other use-cases weren't addressable with early 2000's tech. high-color image raster.

Games

Games Hardware Java Mobile

AVIF for Next-Generation Image Coding

The Netflix TechBlog

FEBRUARY 13, 2020

Using the framework we have open sourced, AVIF compression efficiency can be seen at work and compared against a whole range of image codecs that came before it. The JPEG 2000 format , based on the discrete wavelet transform (DWT), was introduced as a successor to JPEG in the year 2000. 264, a.k.a.

Code

Code Metrics Efficiency Open Source

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

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 the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL. The POC Why this POC?

Traffic

Traffic Scalability Database Servers

Technology Performance Pulse

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

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

Trending Sources

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

Fixing Misplaced Rows in a Partitioned Table

Data Movement in Netflix Studio via Data Mesh

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

Why MySQL Could Be Slow With Large Tables

Dealing With “Too Many Connections” Error in MySQL 8

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Impact of Querying Table Information From information_schema

Purging Data When the Table Is Big and Has Children Tables

Percona Toolkit – A Quick Introduction to Summary

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

HammerDB v4.2 New Features Pt1: MariaDB Build and Test Example with the CLI

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

Progress Delayed Is Progress Denied

Platform Adjacency Theory

AVIF for Next-Generation Image Coding

Bootstrap PostgreSQL on Kubernetes

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

Stay Connected