This article provides troubleshooting steps when you receive MariaDB alerts for Adobe Commerce in New Relic. The MariaDB alerts monitor high query load as well as excessive Data Manipulation Language (DML) queries. Both can lead to a degraded user experience or even downtime. You can receive four kinds of alerts:
DML Queries Warning
DML Queries Critical
Affected products and versions
Adobe Commerce on cloud infrastructure Pro plan architecture
You will receive a managed alert in New Relic if you have signed up to Managed alerts for Adobe Commerce and one or more of the alert thresholds have been surpassed. These alerts were developed by Adobe to give customers a standard set using insights from Support and Engineering.
Abort any deployment scheduled until this alert is cleared.
End any scripts such as imports that may be the cause of the alert if site performance is impacted.
Run indexers or additional crons which may cause additional stress on MariaDB.
Do any major administrative tasks (i.e., Commerce Admin, data imports / exports).
Clear your cache.
DML Queries (queries that modify the database using UPDATE, INSERT, and DELETE)
If you receive a DML Queries Critical alert start at step one. If you receive a DML Queries Warning alert start at step two.
Check if an Adobe Commerce support ticket exists. For steps, refer to our knowledge base Track your support tickets. Support may have received a New Relic threshold alert, created a ticket and started working on the issue. If no ticket exists, create one. The ticket should have the following information: