Database storage troubleshooter on Adobe Commerce

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.

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.

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.

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.

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.