{"id":1225,"date":"2020-06-04T23:40:11","date_gmt":"2020-06-04T15:40:11","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=1225"},"modified":"2026-01-12T11:48:16","modified_gmt":"2026-01-12T03:48:16","slug":"how-to-find-plesk-domains-exceeding-disk-quota","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/how-to-find-plesk-domains-exceeding-disk-quota","title":{"rendered":"How to find Plesk domains exceeding disk quota?"},"content":{"rendered":"<div class=\"mkb-anchor mkb-clearfix mkb-back-to-top-inline\">\n<h2><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/encrypted-tbn0.gstatic.com\/images?q=tbn:ANd9GcTtlV_PMwlbrP73_0hxxEtOVNqCTRE9aqM-tg&amp;s\" alt=\"How to find Plesk domains exceeding disk quota?\" width=\"349\" height=\"144\" \/><\/h2>\n<h2>How to find Plesk domains exceeding disk quota?<\/h2>\n<h2 class=\"mkb-anchor__title\"><strong>Applies to :<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<\/div>\n<ul>\n<li><a href=\"https:\/\/talk.plesk.com\/forums\/plesk-11-x-for-linux.677\/\" rel=\"nofollow noopener\" target=\"_blank\">Plesk 11.x Linux<\/a><\/li>\n<\/ul>\n<div class=\"mkb-anchor mkb-clearfix mkb-back-to-top-inline\">\n<h2 class=\"mkb-anchor__title\"><strong>Requirements<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<\/div>\n<p>To perform this task, you need to have :<\/p>\n<ul>\n<li>Knowledge in accessing the server via\u00a0SSH.<\/li>\n<li>IP address or server hostname.<\/li>\n<li>Your server SSH username and password.<\/li>\n<\/ul>\n<div class=\"mkb-anchor mkb-clearfix mkb-back-to-top-inline\">\n<h2 class=\"mkb-anchor__title\"><strong>Instructions<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<\/div>\n<p>1. \u00a0 \u00a0Login via SSH as the root user.<\/p>\n<p>2. \u00a0 \u00a0Access MySQL as the admin user by execute below command on terminal<\/p>\n<pre>mysql  -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/pre>\n<p>3. \u00a0 \u00a0Tell MySQL you want to use the Plesk Database\u00a0<strong>psa<\/strong>:<\/p>\n<pre>use psa;<\/pre>\n<p>4. \u00a0 \u00a0Execute the following MySQL Query:<\/p>\n<pre>SELECT domains.name, domains.real_size, Limits.value FROM domains, Limits WHERE domains.limits_id = Limits.id AND domains.real_size &gt; Limits.value AND limit_name = 'disk_space' AND Limits.value != -1 ORDER BY domains.name ASC;<\/pre>\n<p>5. \u00a0 \u00a0You should now get a table output containing a list of all of the domains within Plesk which have exceeded the mail quota.<\/p>\n<p>6. \u00a0 \u00a0To quit MySQL simply type exit.<\/p>\n<p>&nbsp;<\/p>\n<p><span data-sheets-root=\"1\">Please refer to the following article to know more.<br \/>\nKnowledge Base: <a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/plesk-backup-manager-guide-to-safeguarding-your-server-data\">Plesk Backup Manager: Guide to Safeguarding Your Server Data<\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to find Plesk domains exceeding disk quota? Applies to : &nbsp; Plesk 11.x Linux Requirements &nbsp; To perform this task, you need to have : Knowledge in accessing the server via\u00a0SSH. IP address or server hostname. Your server SSH username and password. Instructions &nbsp; 1. \u00a0 \u00a0Login via SSH as the root user. 2. \u00a0 \u00a0Access MySQL as the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[36],"kbtag":[1525,1137],"class_list":["post-1225","kb","type-kb","status-publish","hentry","kbtopic-plesk","kbtag-disk-quota","kbtag-plesk"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/1225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=1225"}],"version-history":[{"count":4,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/1225\/revisions"}],"predecessor-version":[{"id":5884,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/1225\/revisions\/5884"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=1225"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=1225"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=1225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}