Grow Your Business Online.
Submit a ticket My Tickets
Welcome
Login  Sign up

How to find Plesk domains exceeding disk quota?

Applies to :

  • Plesk 11.x Linux



Requirements

To perform this task, you need to have :

  • Knowledge in accessing the server via SSH.
  • IP address or server hostname.
  • Your server SSH username and password.



Instructions

1.    Login via SSH as the root user.



2.    Access MySQL as the admin user by execute below command on terminal


mysql  -uadmin -p`cat /etc/psa/.psa.shadow` 



3.    Tell MySQL you want to use the Plesk Database psa:


use psa; 



4.    Execute the following MySQL Query:


SELECT domains.name, domains.real_size, Limits.value FROM domains, Limits WHERE domains.limits_id = Limits.id AND domains.real_size > Limits.value AND limit_name = 'disk_space' AND Limits.value != -1 ORDER BY domains.name ASC; 



5.    You should now get a table output containing a list of all of the domains within Plesk which have


       exceeded the mail quota.



6.    To quit MySQL simply type exit.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.