How disk usage is calculated by Plesk

Created:

2016-11-16 13:17:16 UTC

Modified:

2017-08-16 16:59:13 UTC

1

Was this article helpful?


Have more questions?

Submit a request

How disk usage is calculated by Plesk

Applicable to:

  • Plesk for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows

Question

Disk usage for a domain/webspace is calculated incorrectly by Plesk. How to find where the miscalculation is occurred?

Answer

The normal condition for disk usage values is as follows:

In CP = in database = on the file system

Check the disk usage value in all three places, one by one:

In the control panel:

The disk usage is displayed on the domain/webspace Statistics page.

It is the value of the disk usage parameter stored in the domains table of the PSA database:

mysql> SELECT SUM(real_size) FROM domains d WHERE d.id = <DOMAIN_ID/WEBSPACE_ID> OR d.webspace_id = <DOMAIN_ID/WEBSPACE_ID> ;
+----------------+
| SUM(real_size) |
+----------------+
| 204771328 |
+----------------+

Note: Replace <DOMAIN_ID/WEBSPACE_ID> with the actual domain/webspace ID.

In the database:

  1. Here, disk usage is divided into four groups of services:

    • Web (httpdocs, httpsdocs, subdomains, web_users, webapps)
    • Mail (mailboxes, maillists)
    • Databases (databases)
    • Other (anonftp, logs, domaindumps, configs, chroot)
  2. Information about the size of the four services mentioned above is stored in the “disk_usage” table of the PSA database. You may use the following query to see it:

    SELECT SUM(httpdocs) + SUM(httpsdocs) + SUM(subdomains) + SUM(web_users) + SUM(webapps) AS `web`, 0 + SUM(mailboxes) + SUM(maillists) AS `mail`, 0 + SUM(dbases) AS `databases`, SUM(anonftp) + SUM(logs) + SUM(domaindumps) + SUM(configs) + SUM(chroot) AS `other` FROM `disk_usage` AS `disk_usage` INNER JOIN `domains` AS `domains` ON domains.id = disk_usage.dom_id WHERE (dom_id = '<DOMAIN_ID/WEBSPACE_ID>') or webspace_id = <DOMAIN_ID/WEBSPACE_ID>;
    +-----------+-------+-----------+----------+
    | web | mail | databases | other |
    +-----------+-------+-----------+----------+
    | 137875456 | 331776| 1568768| 65019904 |
    +-----------+-------+-----------+----------+

    Note: Replace <DOMAIN_ID/WEBSPACE_ID> with the actual domain/webspace ID.

    But those are not the final values.

  3. Check what is included in the disk space usage calculation in the PP web interface:

    Tools & Settings (or Tools) -> Server Settings

    Modify the above queries based on what is selected, i.e., exclude + SUM(mailboxes) from the query if the Mailboxes check-box is not selected.

  4. Run the modified queries. Normally, the sum of the four values should equal the value in the control panel. If this is the case, proceed to the file system stage.

On the file system:

Here, you should manually calculate the size of the needed folders:

  • Web (httpdocs, httpsdocs, subdomains, web_users, webapps)
  • Mail (mailboxes, maillists)
  • Databases (databases)
  • Other (anonftp, logs, domaindumps, configs, chroot)

Note:

  1. Again, check what is included in the disk space usage calculation in the Plesk GUI (Tools & Settings (or Tools) -> Server Settings) and exclude the needed folders from the calculation.

  2. Files with owner’s uid < 100 and those owned by apache should not be calculated.

Have more questions? Submit a request
Please sign in to leave a comment.