{"id":9774,"date":"2026-06-07T14:48:50","date_gmt":"2026-06-07T12:48:50","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=9774"},"modified":"2026-06-07T14:48:51","modified_gmt":"2026-06-07T12:48:51","slug":"optimizare-wordpress-eliminarea-metadatelor-din-postarile-sterse","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/","title":{"rendered":"Optimizare WordPress - Eliminarea metadatelor din post\u0103rile \u0219terse"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">WordPress stocheaz\u0103 informa\u021bii suplimentare legate de articole, pagini \u0219i tipuri de con\u021binut personalizate \u00eentr-un tabel separat al bazei de date numit <code>wp_postmeta<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Acest tabel con\u021bine metadate utilizate de:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Func\u021bionalit\u0103\u021bile de baz\u0103 ale WordPress<\/li>\n\n\n\n<li>Teme<\/li>\n\n\n\n<li>Pluginuri<\/li>\n\n\n\n<li>C\u00e2mpuri personalizate<\/li>\n\n\n\n<li>Extensii de comer\u021b electronic<\/li>\n\n\n\n<li>Generatoare de pagini<\/li>\n<\/ul>\n\n\n\n<\/div>\n\n<div id=\"mybox-736795860\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">Atunci c\u00e2nd articolele sau paginile sunt \u0219terse, metadatele asociate pot r\u0103m\u00e2ne uneori \u00een baza de date. \u00cen timp, aceste \u00eenregistr\u0103ri \"orfane\" se pot acumula \u0219i pot m\u0103ri inutil dimensiunea bazei de date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Acest ghid explic\u0103 cum s\u0103 identifica\u021bi \u0219i s\u0103 elimina\u021bi \u00eenregistr\u0103rile de metadate care nu mai apar\u021bin post\u0103rilor existente.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Important<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Acest ghid este destinat utilizatorilor cu cuno\u0219tin\u021be de baz\u0103 \u00een administrarea bazelor de date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cenainte de a executa orice interog\u0103ri SQL:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Crea\u021bi o copie de rezerv\u0103 complet\u0103 a bazei de date.<\/li>\n\n\n\n<li>Verifica\u021bi dac\u0103 a\u021bi selectat baza de date corect\u0103.<\/li>\n\n\n\n<li>Testa\u021bi site-ul web dup\u0103 efectuarea oric\u0103ror opera\u021biuni de cur\u0103\u021bare.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u0218tergerea incorect\u0103 a datelor poate duce la probleme de func\u021bionalitate a site-ului web.<\/p>\n<\/blockquote>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Cuprins<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Access_phpMyAdmin\">Accesare phpMyAdmin<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Log_In_to_the_Database\">Conectare la baza de date<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/optimizarea-WordPress-eliminarea-metadatelor-din-post\u0103rile-\u0219terse\/#Deschide\u021bi_editorul_de_interog\u0103ri_SQL\">Deschide\u021bi editorul de interog\u0103ri SQL<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Remove_Orphaned_Metadata\">Elimina\u021bi metadatele orfane<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#What_Does_This_Query_Do\">Ce face aceast\u0103 interogare?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Beneficiile_elimin\u0103rii_metadatelor_orfane\">Beneficiile elimin\u0103rii metadatelor orfane<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Check_Before_Deleting_Optional\">Verifica\u021bi \u00eenainte de \u0219tergere (op\u021bional)<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Alternative_Cleanup_Methods\">Metode alternative de cur\u0103\u021bare<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/wordpress-optimization-removing-metadata-from-deleted-posts\/#Summary\">Rezumat<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Access_phpMyAdmin\"><\/span>Accesare phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Conecta\u021bi-v\u0103 la panoul mybox.<\/li>\n\n\n\n<li>Accesa\u021bi:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Baze de date\n<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Face\u021bi clic pe:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>phpMyAdmin\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Se va deschide o nou\u0103 fil\u0103 a browserului cu ecranul de autentificare \u00een baza de date.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Log_In_to_the_Database\"><\/span>Autentifica\u021bi-v\u0103 \u00een baza de date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Utiliza\u021bi datele de autentificare pentru baza de date asociate site-ului dvs. WordPress.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 nu cunoa\u0219te\u021bi datele de autentificare pentru baza de date, le pute\u021bi g\u0103si \u00een fi\u0219ierul <code>wp-config.php<\/code> situat \u00een directorul r\u0103d\u0103cin\u0103 al instal\u0103rii dvs. WordPress.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exemplu:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define('DB_NAME', 'database_name');\ndefine('DB_USER', 'database_user');\ndefine('DB_PASSWORD', 'database_password');\ndefine('DB_HOST', \"database_host\");\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Fi\u0219ierul se afl\u0103 de obicei \u00een:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>public_html\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Open_the_SQL_Query_Editor\"><\/span>Deschide\u021bi Editorul de interog\u0103ri SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dup\u0103 autentificare:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Selecta\u021bi baza de date WordPress din meniul din st\u00e2nga.<\/li>\n\n\n\n<li>Face\u021bi clic pe:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">fila din partea de sus a paginii.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aceasta va deschide editorul de interog\u0103ri.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Remove_Orphaned_Metadata\"><\/span>Eliminare metadate orfane<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Introduce\u021bi urm\u0103toarea interogare SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE pm\nFROM wp_postmeta pm\nLEFT JOIN wp_posts wp ON wp.ID = pm.post_id\nWHERE wp.ID IS NULL;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Face\u021bi clic pe:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Executare\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">pentru a rula interogarea.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ce_face_aceast\u0103_interogare\"><\/span>Ce face aceast\u0103 interogare?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Interogarea caut\u0103 intr\u0103ri \u00een tabelul <code>wp_postmeta<\/code> ale c\u0103ror post\u0103ri asociate nu mai exist\u0103 \u00een tabelul <code>wp_posts<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aceste \u00eenregistr\u0103ri sunt considerate metadate orfane.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Interogarea elimin\u0103 metadatele legate de:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Post\u0103ri \u0219terse<\/li>\n\n\n\n<li>Pagini \u0219terse<\/li>\n\n\n\n<li>Tipuri de post\u0103ri personalizate \u0219terse<\/li>\n\n\n\n<li>Con\u021binut eliminat de pluginuri<\/li>\n\n\n\n<li>Alt con\u021binut WordPress inexistent<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Benefits_of_Removing_Orphaned_Metadata\"><\/span>Avantajele elimin\u0103rii metadatelor orfane<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cur\u0103\u021barea metadatelor neutilizate poate oferi mai multe beneficii:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Dimensiune redus\u0103 a bazei de date.<\/li>\n\n\n\n<li>Backupuri mai rapide ale bazei de date.<\/li>\n\n\n\n<li>Performan\u021b\u0103 \u00eembun\u0103t\u0103\u021bit\u0103 a interog\u0103rilor.<\/li>\n\n\n\n<li>Consum redus de spa\u021biu de stocare.<\/li>\n\n\n\n<li>Performan\u021b\u0103 general\u0103 \u00eembun\u0103t\u0103\u021bit\u0103 a WordPress.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Impactul este vizibil mai ales pe site-urile care:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Func\u021bioneaz\u0103 de mult timp.<\/li>\n\n\n\n<li>\u0218terg sau actualizeaz\u0103 frecvent con\u021binutul.<\/li>\n\n\n\n<li>Utilizeaz\u0103 multe pluginuri.<\/li>\n\n\n\n<li>Au importat sau migrat con\u021binutul de mai multe ori.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Check_Before_Deleting_Optional\"><\/span>Verifica\u021bi \u00eenainte de \u0219tergere (op\u021bional)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 dori\u021bi s\u0103 verifica\u021bi \u00eenregistr\u0103rile \u00eenainte de a le \u0219terge, rula\u021bi:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT pm.*\nFROM wp_postmeta pm\nLEFT JOIN wp_posts wp ON wp.ID = pm.post_id\nWHERE wp.ID IS NULL;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Aceast\u0103 interogare afi\u0219eaz\u0103 metadatele orfane f\u0103r\u0103 a le elimina.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dup\u0103 ce examina\u021bi rezultatele, pute\u021bi decide dac\u0103 dori\u021bi s\u0103 continua\u021bi cu cur\u0103\u021barea.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Alternative_Cleanup_Methods\"><\/span>Metode alternative de cur\u0103\u021bare<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 prefera\u021bi s\u0103 nu executa\u021bi manual comenzi SQL, mai multe pluginuri de optimizare WordPress pot efectua aceast\u0103 cur\u0103\u021bare automat, printre care:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WP-Optimize<\/li>\n\n\n\n<li>Advanced Database Cleaner<\/li>\n\n\n\n<li>LiteSpeed Cache<\/li>\n\n\n\n<li>WP Rocket<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Aceste pluginuri pot identifica \u0219i elimina metadatele orfane direct din panoul de control WordPress.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Rezumat<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen timp, WordPress poate acumula intr\u0103ri de metadate asociate cu post\u0103ri care nu mai exist\u0103. Aceste \u00eenregistr\u0103ri orfane ocup\u0103 spa\u021biu \u0219i pot contribui la supra\u00eenc\u0103rcarea bazei de date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a le elimina:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Deschide\u021bi phpMyAdmin.<\/li>\n\n\n\n<li>Selecta\u021bi baza de date WordPress.<\/li>\n\n\n\n<li>Deschide\u021bi fila SQL.<\/li>\n\n\n\n<li>Executa\u021bi:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE pm\nFROM wp_postmeta pm\nLEFT JOIN wp_posts wp ON wp.ID = pm.post_id\nWHERE wp.ID IS NULL;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Crea\u021bi \u00eentotdeauna o copie de rezerv\u0103 a bazei de date \u00eenainte de a efectua opera\u021biuni de cur\u0103\u021bare \u0219i verifica\u021bi dac\u0103 site-ul dvs. func\u021bioneaz\u0103 corect dup\u0103 aceea.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[11462,11440,11503,58,11391,11408],"manual_kb_tag":[389,2146,2147,2750,4835,4836,4837,4838,4839,190],"class_list":["post-9774","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-database-performance-troubleshooting","manualknowledgebasecat-performance-optimization","manualknowledgebasecat-database-creation-management","manualknowledgebasecat-cms-web-applications","manualknowledgebasecat-databases-mysql","manualknowledgebasecat-wordpress","manual_kb_tag-database-backup","manual_kb_tag-phpmyadmin","manual_kb_tag-database-optimization","manual_kb_tag-database-cleanup","manual_kb_tag-wp-postmeta","manual_kb_tag-wp-posts","manual_kb_tag-orphaned-metadata","manual_kb_tag-remove-orphaned-metadata","manual_kb_tag-postmeta-cleanup","manual_kb_tag-wordpress"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9774\/revisions"}],"predecessor-version":[{"id":9775,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9774\/revisions\/9775"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=9774"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=9774"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=9774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}