---
name: databases-for-mysql-learn-performance
title: Performance
description: IBM Cloud&reg; Databases for MySQL deployments can be manually scaled to your usage or configured to autoscale under certain resource conditions. There are a few factors to consider when you are tuning the performance of your deployment.
last-updated: 2025-03-28
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/databases-for-mysql?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

# Performance
{: #performance}

IBM Cloud&reg; Databases for MySQL deployments can be manually [scaled to your usage](https://cloud.ibm.com/docs/databases-for-mysql?topic=databases-for-mysql-resources-scaling&format=markdown#resources-scaling-consider) or configured to [autoscale](https://cloud.ibm.com/docs/databases-for-mysql?topic=databases-for-mysql-autoscaling-mysql&interface=cli&format=markdown) under certain resource conditions. There are a few factors to consider when you are tuning the performance of your deployment.

## Monitoring your deployment
{: #monitor-deployment}

Databases for MySQL deployments offer an integration with the [IBM Cloud&reg; Monitoring service](https://cloud.ibm.com/docs/cloud-databases?topic=cloud-databases-monitoring&format=markdown) for basic monitoring of resource usage on your deployment. Many of the available metrics, like disk usage and IOPS, are presented to help you configure [autoscaling](https://cloud.ibm.com/docs/databases-for-mysql?topic=databases-for-mysql-autoscaling-mysql&interface=cli&format=markdown) on your deployment. Observing trends in your usage and configuring the autoscaling to respond to them can help alleviate performance problems before your databases become unstable due to resource exhaustion.

## Disk IOPS
{: #disk-iops}

The number of input/output operations per second (IOPS) is limited by the type of storage volume. Storage volumes for Databases for MySQL deployments are provisioned on [Block Storage Endurance Volumes in the 10 IOPS per GB tier](https://cloud.ibm.com/docs/BlockStorage?topic=BlockStorage-orderingBlockStorage&interface=ui&format=markdown). If your operational load saturates or exceeds the IOPS limit, database requests and operations are delayed until the disk can catch up. Extended periods of heavy-load can cause your deployment to be unable to process queries and become effectively unavailable. If you experience delayed responses and failing operations, you might be exceeding the disk's IOPS limit. You can increase the number IOPS available to your deployment by increasing disk space.

## Connection Limits
{: #connection-limits-performance}

Databases for MySQL sets the maximum number of connections to your MySQL database to **200**. Leave some connections available, as a number of them are reserved internally to maintain the state and integrity of your database. After the connection limit is reached, any attempts at starting a new connection results in an error. To prevent overwhelming your deployment with connections, use connection pooling, or scale your deployment and increase its connection limit. For more information, see the [Managing MySQL Connections](https://cloud.ibm.com/docs/databases-for-mysql?topic=databases-for-mysql-managing-mysql-connections&format=markdown) page.