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? In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL.

Database 217

Database Benchmarking Latency Performance 217

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 114

Open Source Traffic Tuning Database 114

Percona

MAY 1, 2023

I’ll show you some MySQL settings to tune to get better performance, and cost savings, with AWS RDS. The innodb_io_capacity_max parameter was set to 2000, so the hardware should be able to deliver that many IOPS without major issues. Want to save money on your AWS RDS bill?

AWS 135

AWS Hardware Storage Tuning 135

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 255

Big Data Government Processing Analytics 255

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 98

Monitoring Entertainment Open Source Tuning 98

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 124

Cache Hardware Servers Benchmarking 124

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 111

Open Source Storage Database Big Data 111