article thumbnail

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

Percona

Restart the PMM agent in the PMM server container: supervisorctl restart pmm-agent Conclusion So, we can see it is possible to fine-tune some hidden settings of Percona Monitoring and Management by getting into its internals, including editing some options after adding a remote MySQL instance without having to remove and re-add the instance.

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. 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 124
Insiders

Sign Up for our Newsletter

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

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. Then you might need to delve into MySQL tuning and replicas. With a little tuning, though, MySQL could hold its own. But WordPress brought MySQL and open source to the masses.

article thumbnail

In-product guidance accelerates Service Level Objectives (SLO) setup for confident deployments

Dynatrace

You can get all the facts about the health of you critical business services with respect to Business and Service-Level Objectives (SLO), Service-Level Agreements (SLAs), and end-user experience: Get more than 2000 different metrics ready for use as dedicated SLIs.

Metrics 158
article thumbnail

Is Thread Pool Plugin the Right Choice for Your Workload?

Percona

This server is not intended to be a perfectly tuned one but just a baseline to compare the behavior under different concurrency configurations. 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

Why MySQL Could Be Slow With Large Tables

Percona

There is a cool blog post from Vadim covering big data sets in MyRocks: MyRocks Use Case: Big Dataset Query tuning: It is common to find applications that at the beginning perform very well, but as data grows the performance starts to decrease. 1 mysql mysql 592K Dec 30 02:48 tb1.ibd ibd -rw-r --. 1 mysql mysql 464K Dec 30 02:48 tb2.ibd

article thumbnail

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

MySQL Configuration Management & Tuning. DigitalOcean. MySQL Version. innodb_buffer_pool_size. innodb_log_file_size. Innodb_io_capacity. innodb_io_capacity_max. binlog_group_commit_sync_delay. DigitalOcean does not allow you to customize your MySQL configurations, which is why they are limited to the default values displayed here.

Database 217