article thumbnail

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

Percona

In the example, we run PMM server in a docker container. ” Let’s roll up our sleeves and do it safely without breaking the toy. Below is an example of an alternative approach to re-adding the instance.

article thumbnail

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

Percona

MySQL was founded in 1995 and went open source in 2000. MySQL was the database for phpWebLog, for example, way back in 2000. But, for a long time, you needed to be comfortable with mysqldump or other backup / restore methods to move servers or providers. Then you might need to delve into MySQL tuning and replicas.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

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

Percona

I’ll show you some MySQL settings to tune to get better performance, and cost savings, with AWS RDS. After some time of receiving these messages, eventually, they hit performance issues to the point that the server becomes unresponsive for a few minutes. This was exactly what was happening on this server.

AWS 120
article thumbnail

Is Thread Pool Plugin the Right Choice for Your Workload?

Percona

Two setups running in cluster mode: one in MariaDB+Galera and one with Percona XtraDB Cluster (Percona Server+Galera). For this reason, I’ve set up a server with the following specs: r6a.2xlarge 2xlarge ec2 VM (8 vCPU – 64GB of RAM) 1TB gp2 drive (roughly 3k IOPS) Percona Server 8.0.34-26

article thumbnail

Impact of Querying Table Information From information_schema

Percona

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 102
article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

Sharding: Sharding is the concept of splitting data horizontally, i.e. by distributing data into multiple servers (shards), meaning that the different portions of data for a given table, may be stored on many different servers. This can help to split large data sets into smaller ones stored in multiple servers. ibd -rw-r --.

article thumbnail

KeyCDN Launches POP in Helsinki

KeyCDN

With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. However, now with the Helsinki edge server in production, this helps further close the gap between visitors who live in Finland and the nearest KeyCDN POP they have access to. As of 2016, there were just over 5.1