{"id":3448,"date":"2019-10-25T10:53:57","date_gmt":"2019-10-25T02:53:57","guid":{"rendered":"https:\/\/www.mondoze.com\/guide\/?post_type=kb&#038;p=3448"},"modified":"2022-10-05T07:58:33","modified_gmt":"2022-10-04T23:58:33","slug":"how-to-find-plesk-domains-exceeding-disk-quota","status":"publish","type":"kb","link":"https:\/\/www.mondoze.com\/guide\/kb\/how-to-find-plesk-domains-exceeding-disk-quota","title":{"rendered":"How to find Plesk domains exceeding disk quota?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3448\" class=\"elementor elementor-3448\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4d0e1925 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4d0e1925\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-177eacf1\" data-id=\"177eacf1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63d8968 elementor-widget elementor-widget-heading\" data-id=\"63d8968\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How To Find Plesk Domains Exceeding Disk Quota<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6baf7920 elementor-widget elementor-widget-text-editor\" data-id=\"6baf7920\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<article id=\"article-body\" class=\"article-body\"><p><strong><span style=\"font-size: medium;\">Applies to :<\/span><\/strong><\/p><ul><li>Plesk 11.x Linux<\/li><\/ul><p><strong><span style=\"font-size: medium;\">Requirements<\/span><\/strong><\/p><p>To perform this task, you need to have :<\/p><ul><li>Knowledge in accessing the server via\u00a0SSH.<\/li><li>IP address or server hostname.<\/li><li>Your server SSH username and password.<\/li><\/ul><p><strong><span style=\"font-size: medium;\">Instructions<\/span><\/strong><\/p><p>1. \u00a0 \u00a0Login via SSH as the root user.<\/p><p>2. \u00a0 \u00a0Access MySQL as the admin user by execute below command on terminal.<\/p><pre>mysql  -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/pre><p>3. \u00a0 \u00a0Tell MySQL you want to use the Plesk Database\u00a0<strong>psa<\/strong>:<\/p><pre>use psa;<\/pre><p>4. \u00a0 \u00a0Execute the following MySQL Query:<\/p><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><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><p>6. \u00a0 \u00a0To quit MySQL simply type exit.<\/p><\/article>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>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\u00a0SSH. IP address or server hostname. Your server SSH username and password. Instructions 1. \u00a0 \u00a0Login via SSH as the root user. 2. \u00a0 \u00a0Access MySQL &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mondoze.com\/guide\/kb\/how-to-find-plesk-domains-exceeding-disk-quota\"> <span class=\"screen-reader-text\">How to find Plesk domains exceeding disk quota?<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[40],"kbtag":[110],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/3448"}],"collection":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/comments?post=3448"}],"version-history":[{"count":6,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/3448\/revisions"}],"predecessor-version":[{"id":19165,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/3448\/revisions\/19165"}],"wp:attachment":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/media?parent=3448"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=3448"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtag?post=3448"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=3448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}