Search

Language:  
Search for:

Available article translations:

[INFO] How disk usage is calculated by Parallels Plesk Panel

APPLIES TO:
  • Parallels Plesk Panel

Question

Disk usage for a domain/webspace is calculated incorrectly by Parallels Plesk Panel (PP). How do I find where the miscalculation occurred?

Answer

The normal condition for disk usage values is as follows:

In CP = in database = on the file system

Let us check the disk usage value in all three places, one by one:

In the control panel:

The disk usage is displayed on the domain's/webspace's 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 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 "" 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.

In 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 PP web interface (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.




56797cefb1efc9130f7c48a7d1db0f0c 49af2da0f2dd4c81e962790bbbd0c2b4

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Desktop Virtualization
- Parallels Desktop 8 for Mac
- Parallels Transporter
- Parallels Desktop Switch to Mac Edition
- Parallels Desktop for Mac Enterprise Edition
- Parallels Management-Mac for Microsoft SCCM
Server Virtualization
- Parallels Cloud Server
- Parallels Containers for Windows 6.0 Beta
- Parallels Virtuozzo Containers
Automation
- Parallels Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Web Presence Builder
- Parallels Plesk Automation
- Parallels Small Business Panel
- Value-added Services for Hosters
- Parallels Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification