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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Increase Courier-IMAP connections on Linux server within plesk

Applies to : All Plesk version Linux Overview By default, in a Linux email server installed...

How to delete messages with a specific pattern in the subject line from the queue?

Applies to : All Plesk version Linux RequirementsTo perform this task, you need to have :...

Create a phpinfo page

Applies to : All Plesk Linux server All Plesk Windows server Requirements To perform this...

Export and import database from linux terminal (SSH)

Applies to : All Linux server RequirementsTo perform this task, you need to have : Knowledge...

SSL Certificate warning when visiting Plesk login page

Applies to : All Plesk version Linux All Plesk version Windows Overview When you visit Plesk...