Database storage troubleshooter on Adobe Commerce

This article is a troubleshooter tool for customers on Adobe Commerce having issues with databases. Click on each question to reveal the answer in each step of the troubleshooter. Depending on your symptoms and configuration, the troubleshooter will explain how to troubleshoot space and configuration issues with databases.

Step 1 - Identify the directory with a space issue step-1

Do you have a /tmp issue caused by a lack of space?

This can be indicated by a range of symptoms including the /tmp mount being full, site down, or not being able to SSH into a node. You may also be experiencing errors like No space left on device (28). For a list of errors resulting from /tmp being full, review /tmp mount full.

Or do you have a /data/mysql issue caused by a lack of space? This can also be indicated by a variety of symptoms including site outage, customers unable to add products to cart, connection failure to database, and Galeria errors like SQLSTATE[08S01]: Communication link failure: 1047 WSREP. For a list of errors resulting from low MySQL disk space, refer to MySQL disk space is low on Adobe Commerce on cloud infrastructure.

If you are unsure if you have a disk space issue and you have a New Relic account, go to the New Relic Infrastructure monitoring Hosts page. From there, click on the Storage tab, change the Chart Shows drop down from 5 to 20 results, and look in the table for high disk use in the Disk Used % chart or table. For more detailed steps, refer to [New Relic Infrastructure Monitoring > Storage tab]https://docs.newrelic.com/docs/infrastructure/infrastructure-ui-pages/infra-hosts-ui-page/#storage).

If you have any of the symptoms described above, check the state of your inodes to make sure this is not being caused by a file number issues. To do so run the following command in the CLI/Terminal:
df -ih

Is IUse% > 90%?

a. YES – This is caused by having too many files. Review the steps to remove files safely in Safely delete files when out of disk space, Adobe Commerce on cloud infrastructure. Proceed to Step 2 after you have completed these steps. If you want to request more space, submit a support ticket.
b. NO – Check space. Run df -h | grep mysql and then df -h | grep tmp in the CLI/Terminal to check disk space usage in the /tmp and /data/mysql directories. Proceed to Step 3.

Step 2 - Check disk space step-2

Check disk space usage?

Once you have reduced the number of files, run df -h | grep mysql and then df -h | grep tmp in the CLI/Terminal to check disk space usage in /tmp and /data/mysql. Is greater than 70% used for /tmp or /data/mysql?

a. YES – Proceed to Step 3.
b. NO – Queries may be exhausting the available storage. This may crash the node, killing the query and removing the tmp files. Examine the output of the SHOW PROCESSLIST; in the MySQL CLI for queries that may be the cause of the problem. Submit a support ticket, requesting more space.

Step 3 - Identify directory with high usage step-3

Which directory has greater than 70% used?

Which directory has greater than 70% used? /tmp or /data/mysql?

note note
NOTE
By default database tmpdir writes to /tmp. To check your database configuration is still on this default, run the following command in MySQL CLI: SHOW VARIABLES LIKE "TMPDIR"; If the database tmpdir is still writing to /tmp, you will see /tmp in the Value column.

a. /tmp – Proceed to Step 4.
b. /data/mysql – Proceed to Step 5.

Step 4 - Troubleshoot /tmp mount full step-4

Troubleshoot /tmp mount full

Troubleshoot /tmp mount full for Adobe Commerce, scroll down the article and try the solutions and best practices. Then run df -h | grep mysql and then df -h | grep tmp in the CLI/Terminal to check disk space usage in /tmp and /data/mysql directories
  < 70% used?

note note
NOTE
The solutions in Troubleshoot /tmp mount full for Adobe Commerce are designed for merchants who have not changed the variables for database tmpdir, which by default writes to /tmp. If you have changed the tmpdir value, the instructions in Troubleshoot /tmp mount full for Adobe Commerce will not help.

a. YES – You have solved the issue.
b. NO – Submit a support ticket, requesting more space.

Step 5 - Check default step-5

Check default

Your database configuration may no longer be at the original default. Find the database tmpdir config by running in the MySQL CLI: SELECT @@DATADIR;. If /data/mysql/ is outputted, the database tmpdir is now writing to /data/mysql/. Try to increase space in this directory by following the steps in MySQL disk space is low on Adobe Commerce on our cloud infrastructure. Then run df -h | grep mysql and then df -h | grep tmp in the CLI/Terminal to check disk space usage in /data/mysql and /tmp.
  < 70% used?

a. YES – You have solved the issue.
b. NO – Submit a support ticket, requesting more space.

Back to Step 1

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a