{"id":2007,"date":"2026-09-12T18:37:14","date_gmt":"2026-09-12T15:37:14","guid":{"rendered":"https:\/\/narhost.com\/destek\/wordpress-veritabani-optimizasyonu-nasil-yapilir\/"},"modified":"2026-09-12T18:38:00","modified_gmt":"2026-09-12T15:38:00","slug":"wordpress-veritabani-optimizasyonu-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/wordpress-veritabani-optimizasyonu-nasil-yapilir\/","title":{"rendered":"WordPress Veritaban\u0131 Nas\u0131l Optimize Edilir"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son do\u011frulama: Eyl\u00fcl 2026 \u00b7 cPanel 136 test hesab\u0131nda denendi<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p>Veritaban\u0131 optimizasyonu i\u00e7in \u00f6nce yedek al\u0131n, sonra cPanel&#8217;de phpMyAdmin&#8217;i a\u00e7\u0131p WordPress veritaban\u0131n\u0131zdaki tablolar\u0131 toplu &#8220;Optimize table&#8221; ile temizleyin ve eski transient kay\u0131tlar\u0131yla yaz\u0131 revizyonlar\u0131n\u0131 silin.<\/p>\n<ol>\n<li>Veritaban\u0131n\u0131z\u0131n yede\u011fini al\u0131n.<\/li>\n<li>cPanel \u2192 Veritabanlar\u0131 \u2192 phpMyAdmin&#8217;i a\u00e7\u0131n.<\/li>\n<li>Tablo listesinde &#8220;Overhead&#8221; g\u00f6steren tablolar\u0131 i\u015faretleyip &#8220;Optimize table&#8221; uygulay\u0131n.<\/li>\n<li>Eski transient ve yaz\u0131 revizyonu kay\u0131tlar\u0131n\u0131 temizleyin.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>cPanel (phpMyAdmin)<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Payla\u015f\u0131ml\u0131 hosting ve WordPress Hosting (CloudLinux, MariaDB)<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>cPanel kullan\u0131c\u0131s\u0131, veritaban\u0131 eri\u015fim bilgisi<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/wordpress-hosting\" title=\"Narhost WordPress Hosting paketleri\">WordPress Hosting<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>cPanel kullan\u0131c\u0131 ad\u0131 ve \u015fifrenize eri\u015fiminiz olmal\u0131.<\/li>\n<li>Veritaban\u0131 ad\u0131n\u0131 bilmiyorsan\u0131z WordPress&#8217;teki <code>wp-config.php<\/code> dosyas\u0131ndan ya da cPanel Veritabanlar\u0131 listesinden bulabilirsiniz.<\/li>\n<li>\u0130\u015flemden \u00f6nce mutlaka bir veritaban\u0131 yede\u011fi al\u0131n; toplu silme ad\u0131mlar\u0131 geri al\u0131namaz.<\/li>\n<li>En az 15-20 dakika ay\u0131r\u0131n; tablo boyutuna g\u00f6re optimizasyon s\u00fcre alabilir.<\/li>\n<\/ul>\n<\/div>\n<h2>Veritaban\u0131 Optimizasyonu WordPress Sitenizi Neden Yava\u015flat\u0131r<\/h2>\n<p>WordPress her yaz\u0131 kayd\u0131nda otomatik revizyon tutar, spam ve \u00e7\u00f6p yorumlar\u0131 hemen silmez, ge\u00e7ici verileri (transient) s\u00fcresi dolsa bile bazen veritaban\u0131nda b\u0131rak\u0131r. Zamanla <code>wp_postmeta<\/code>, <code>wp_options<\/code> ve <code>wp_posts<\/code> tablolar\u0131 gere\u011finden b\u00fcy\u00fcr; InnoDB ve MyISAM tablolar\u0131nda silme ve g\u00fcncelleme i\u015flemleri de bo\u015f alan (&#8220;overhead&#8221;) biriktirir. \u00d6zellikle <code>wp_options<\/code> tablosundaki otomatik y\u00fcklenen (autoload) sat\u0131rlar b\u00fcy\u00fcd\u00fck\u00e7e sitenizin her sayfas\u0131 bu veriyi ba\u015ftan okur ve y\u00fckleme s\u00fcresi uzar.<\/p>\n<p>Veritaban\u0131 optimizasyonu bu birikimi temizleyip tablolar\u0131 yeniden d\u00fczenler; disk alan\u0131 ve sorgu s\u00fcresi normale d\u00f6ner. Bunun i\u00e7in ayr\u0131 bir eklenti kurmak \u015fart de\u011fildir, phpMyAdmin \u00fczerinden ayn\u0131 sonu\u00e7 elle de al\u0131n\u0131r.<\/p>\n<h2>Ad\u0131m Ad\u0131m Veritaban\u0131 Optimizasyonu<\/h2>\n<p>S\u0131ra yedek almadan ba\u015flar, tablo temizli\u011fi ve toplu optimizasyonla devam eder.<\/p>\n<ol class=\"kb-adimlar\">\n<li><strong>Veritaban\u0131n\u0131z\u0131n yede\u011fini al\u0131n.<\/strong> phpMyAdmin&#8217;in &#8220;D\u0131\u015fa Aktar&#8221; sekmesinden ya da cPanel Yedekleme arac\u0131ndan tam bir veritaban\u0131 yede\u011fi \u00e7\u0131kar\u0131n.\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>A\u015fa\u011f\u0131daki silme ve optimizasyon ad\u0131mlar\u0131 geri al\u0131namaz; yedeksiz devam etmeyin.<\/p>\n<\/div>\n<\/li>\n<li><strong>cPanel \u2192 Veritabanlar\u0131 \u2192 phpMyAdmin<\/strong>&#8216;i a\u00e7\u0131n ve WordPress veritaban\u0131n\u0131z\u0131 sol men\u00fcden se\u00e7in.<br \/>\n<figure class=\"kb-ekran\"><img decoding=\"async\" src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/wordpress-veritabani-optimizasyonu-nasil-yapilir-adim-1.webp\" alt=\"Veritaban\u0131 optimizasyonu i\u00e7in cPanel phpMyAdmin tablo listesi ekran\u0131\" width=\"1200\" height=\"833\" loading=\"lazy\"><figcaption>phpMyAdmin&#8217;de WordPress veritaban\u0131n\u0131n tablo listesi; boyut ve overhead s\u00fctunlar\u0131 burada g\u00f6r\u00fcn\u00fcr.<\/figcaption><\/figure>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: veritaban\u0131n\u0131zdaki t\u00fcm tablo listesi, her tablonun boyutu ve varsa &#8220;Overhead&#8221; (fazladan alan) de\u011feri g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<li><strong>Yaz\u0131 revizyonlar\u0131n\u0131 ve \u00e7\u00f6p i\u00e7erikleri temizleyin.<\/strong> WordPress y\u00f6netim panelinden Yorumlar \u2192 Spam\/\u00c7\u00f6p&#8217;\u00fc kal\u0131c\u0131 silin; istersen phpMyAdmin&#8217;in SQL sekmesinden a\u015fa\u011f\u0131daki gibi do\u011frudan da temizleyebilirsiniz. Transient verisinin ne i\u015fe yarad\u0131\u011f\u0131n\u0131 <a href=\"https:\/\/developer.wordpress.org\/apis\/handbook\/transients\/\" title=\"WordPress Transients API resmi dok\u00fcman\u0131\" target=\"_blank\" rel=\"noopener\">WordPress&#8217;in Transients API dok\u00fcman\u0131ndan<\/a> okuyabilirsiniz.\n<pre><code class=\"language-sql\">DELETE FROM wp_posts WHERE post_type = 'revision';DELETE FROM wp_options WHERE option_name LIKE '_transient_timeout_%' OR option_name LIKE '_transient_%';<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: sorgu \u00e7al\u0131\u015ft\u0131ktan sonra etkilenen sat\u0131r say\u0131s\u0131 ekranda g\u00f6r\u00fcn\u00fcr, ilgili tablolar k\u00fc\u00e7\u00fcl\u00fcr.<\/p>\n<\/li>\n<li><strong>Tablolar\u0131 toplu optimize edin.<\/strong> Tablo listesinin alt\u0131ndaki &#8220;T\u00fcm\u00fcn\u00fc se\u00e7&#8221; kutusunu i\u015faretleyip a\u00e7\u0131l\u0131r men\u00fcden &#8220;Optimize table&#8221; se\u00e7ene\u011fini uygulay\u0131n; komutun MariaDB&#8217;de tam olarak ne yapt\u0131\u011f\u0131 <a href=\"https:\/\/mariadb.com\/kb\/en\/optimize-table\/\" title=\"MariaDB Optimize Table resmi dok\u00fcman\u0131\" target=\"_blank\" rel=\"noopener\">MariaDB&#8217;nin resm\u00ee dok\u00fcman\u0131nda<\/a> a\u00e7\u0131klan\u0131r.<br \/>\n<figure class=\"kb-ekran\"><img decoding=\"async\" src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/wordpress-veritabani-optimizasyonu-nasil-yapilir-adim-2.webp\" alt=\"Veritaban\u0131 optimizasyonu i\u00e7in phpMyAdmin'de toplu Optimize table i\u015flemi\" width=\"1200\" height=\"833\" loading=\"lazy\"><figcaption>Tablo listesinin alt\u0131ndaki toplu i\u015flem men\u00fcs\u00fcnde Optimize table se\u00e7ene\u011fi.<\/figcaption><\/figure>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: i\u015flem tamamland\u0131\u011f\u0131nda &#8220;Overhead&#8221; s\u00fctunu bo\u015fal\u0131r ya da belirgin \u015fekilde k\u00fc\u00e7\u00fcl\u00fcr.<\/p>\n<\/li>\n<li><strong>Sonucu kar\u015f\u0131la\u015ft\u0131r\u0131n.<\/strong> phpMyAdmin&#8217;de veritaban\u0131n\u0131n toplam boyutuna tekrar bak\u0131n; i\u015flem \u00f6ncesine g\u00f6re k\u00fc\u00e7\u00fclm\u00fc\u015f olmal\u0131.<\/li>\n<\/ol>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Tablo listesindeki &#8220;Overhead&#8221; s\u00fctunu bo\u015f g\u00f6r\u00fcn\u00fcyor, veritaban\u0131 toplam boyutu k\u00fc\u00e7\u00fclm\u00fc\u015f ve site admin panelindeki yaz\u0131\/yorum listeleri hatas\u0131z a\u00e7\u0131l\u0131yorsa veritaban\u0131 optimizasyonu tamamlanm\u0131\u015f demektir.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00c7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>Optimizasyon sonras\u0131 site h\u00e2l\u00e2 yava\u015f.<\/strong> Yava\u015fl\u0131\u011f\u0131n kayna\u011f\u0131 veritaban\u0131 de\u011fil \u00f6nbellekleme ya da g\u00f6rsel boyutu olabilir; site h\u0131z\u0131n\u0131 art\u0131rma kart\u0131ndaki ad\u0131mlara bak\u0131n.<\/li>\n<li><strong>phpMyAdmin&#8217;e giri\u015f yapam\u0131yorum.<\/strong><a href=\"https:\/\/narhost.com\/destek\/phpmyadmine-nasil-giris-yapilir\/\" title=\"phpMyAdmin&#039;e nas\u0131l giri\u015f yap\u0131l\u0131r \u2014 Narhost Destek\">phpMyAdmin&#8217;e giri\u015f<\/a> kart\u0131ndaki ad\u0131mlar\u0131 izleyin.<\/li>\n<li><strong>\u0130\u015flem sonras\u0131 veritaban\u0131 ba\u011flant\u0131 hatas\u0131 ald\u0131m.<\/strong> Yanl\u0131\u015f tabloya dokunulmu\u015f olabilir; <a href=\"https:\/\/narhost.com\/destek\/wordpress-veritabani-baglantisi-nasil-duzeltilir\/\" title=\"WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 nas\u0131l d\u00fczeltilir \u2014 Narhost Destek\">veritaban\u0131 ba\u011flant\u0131s\u0131<\/a> kart\u0131yla kontrol edip yede\u011finizden geri d\u00f6n\u00fcn.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Talebe \u015funlar\u0131 ekleyin: alan ad\u0131n\u0131z, veritaban\u0131 ad\u0131, hangi tablolar\u0131 optimize etti\u011finiz ve varsa ald\u0131\u011f\u0131n\u0131z hata mesaj\u0131n\u0131n birebir metni.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi olu\u015ftur\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/site-hizi-nasil-artirilir\/\" title=\"Site H\u0131z\u0131 Nas\u0131l Art\u0131r\u0131l\u0131r - Narhost Destek\">Site H\u0131z\u0131 Nas\u0131l Art\u0131r\u0131l\u0131r (konu merkezi)<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/wordpress-sorunlari-ve-cozumleri\/\" title=\"WordPress Y\u00f6netimi ve Sorun Giderme Rehberi \u2014 Narhost Destek\">WordPress y\u00f6netimi ve sorun giderme rehberi<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/phpmyadmine-nasil-giris-yapilir\/\" title=\"phpMyAdmin&#039;e nas\u0131l giri\u015f yap\u0131l\u0131r \u2014 Narhost Destek\">phpMyAdmin&#8217;e nas\u0131l giri\u015f yap\u0131l\u0131r<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/otomatik-yedekleme-nasil-yapilandirilir\/\" title=\"Otomatik yedekleme nas\u0131l yap\u0131land\u0131r\u0131l\u0131r \u2014 Narhost Destek\">Otomatik yedekleme nas\u0131l yap\u0131land\u0131r\u0131l\u0131r<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/wordpress-veritabani-baglantisi-nasil-duzeltilir\/\" title=\"WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 nas\u0131l d\u00fczeltilir \u2014 Narhost Destek\">WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 nas\u0131l d\u00fczeltilir<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a Sorulan Sorular<\/h2>\n<h3>Veritaban\u0131 optimizasyonu WordPress sitesine zarar verir mi?<\/h3>\n<p>Do\u011fru yap\u0131ld\u0131\u011f\u0131nda zarar vermez; ancak yaz\u0131 revizyonu ve transient silme ad\u0131mlar\u0131 geri al\u0131namaz, bu y\u00fczden i\u015flemden \u00f6nce yedek alman\u0131z gerekir.<\/p>\n<h3>Optimize table i\u015flemi ne s\u0131kl\u0131kla yap\u0131lmal\u0131?<\/h3>\n<p>Yo\u011fun i\u00e7erik \u00fcretilen bir sitede birka\u00e7 ayda bir yeterlidir; \u00e7ok say\u0131da yorum ve s\u0131k g\u00fcncellenen sayfas\u0131 olan sitelerde bu s\u00fcre k\u0131salt\u0131labilir.<\/p>\n<h3>phpMyAdmin&#8217;de hangi tablolar\u0131 optimize etmeliyim?<\/h3>\n<p>Tablo listesindeki &#8220;Overhead&#8221; s\u00fctununda de\u011fer g\u00f6steren tablolar\u0131 optimize etmeniz yeterlidir; de\u011feri bo\u015f olan tablolar\u0131n optimizasyona ihtiyac\u0131 yoktur.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Veritaban\u0131 optimizasyonu: yedek alma, phpMyAdmin&#8217;de tablo overhead kontrol\u00fc, transient ve yaz\u0131 revizyonu temizli\u011fi, toplu Optimize table i\u015flemi ve sonucu do\u011frulama.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,7],"tags":[137,172],"class_list":["post-2007","post","type-post","status-publish","format-standard","hentry","category-web-hosting","category-wordpress-hosting","tag-veritabani","tag-phpmyadmin"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=2007"}],"version-history":[{"count":1,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2007\/revisions"}],"predecessor-version":[{"id":2008,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2007\/revisions\/2008"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=2007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=2007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=2007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}