{"id":2958,"date":"2026-10-19T15:00:00","date_gmt":"2026-10-19T12:00:00","guid":{"rendered":"https:\/\/narhost.com\/destek\/?p=2958"},"modified":"2026-10-19T20:59:50","modified_gmt":"2026-10-19T17:59:50","slug":"max-allowed-packet-hatasi","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/max-allowed-packet-hatasi\/","title":{"rendered":"Got a Packet Bigger Than max_allowed_packet Hatas\u0131 Nas\u0131l \u00c7\u00f6z\u00fcl\u00fcr (MySQL)"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Ekim 2026 \u00b7 MariaDB 10.11 sistem de\u011fi\u015fkenleri ve phpMyAdmin resm\u00ee belgelerine g\u00f6re<\/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><strong>Max allowed packet hatas\u0131<\/strong> (<code>Got a packet bigger than 'max_allowed_packet' bytes<\/code>), veritaban\u0131na g\u00f6nderilen tek bir sorgu ya da sat\u0131r\u0131n sunucunun kabul etti\u011fi en b\u00fcy\u00fck paket boyutunu a\u015ft\u0131\u011f\u0131n\u0131 g\u00f6sterir. \u00c7o\u011fu zaman b\u00fcy\u00fck bir yede\u011fi i\u00e7e aktar\u0131rken \u00e7\u0131kar.<\/p>\n<ol>\n<li>Payla\u015f\u0131ml\u0131 hostingte yede\u011fi tek sat\u0131rl\u0131k INSERT&#8217;lerle yeniden al\u0131n ya da dosyay\u0131 par\u00e7alara b\u00f6l\u00fcn.<\/li>\n<li>Hatay\u0131 veren tablo ve sat\u0131r boyutunu not edip destek talebi a\u00e7\u0131n; sunucu de\u011feri hesab\u0131n\u0131zdan de\u011fi\u015ftirilemez.<\/li>\n<li>VPS&#8217;te <code>max_allowed_packet<\/code> de\u011ferini MariaDB yap\u0131land\u0131rma dosyas\u0131nda b\u00fcy\u00fct\u00fcp hizmeti yeniden ba\u015flat\u0131n.<\/li>\n<li>Komut sat\u0131r\u0131ndan i\u00e7e aktar\u0131yorsan\u0131z istemciye de <code>--max-allowed-packet<\/code> verin.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>cPanel (phpMyAdmin); VPS&#8217;te komut sat\u0131r\u0131<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Payla\u015f\u0131ml\u0131 hosting (MariaDB 10.11); Ubuntu 24.04 ve AlmaLinux 9 VPS<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>cPanel kullan\u0131c\u0131s\u0131; VPS&#8217;te root ya da sudo<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/vps-sunucu\" title=\"Narhost VPS Sunucu paketleri\">VPS Sunucu<\/a>, Web Hosting<\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Hata metnini ve hatan\u0131n hangi i\u015flemde \u00e7\u0131kt\u0131\u011f\u0131n\u0131 (i\u00e7e aktarma, eklenti, uygulama) not edin.<\/li>\n<li>\u0130\u00e7e aktaraca\u011f\u0131n\u0131z dosyan\u0131n boyutunu ve en b\u00fcy\u00fck tabloyu \u00f6\u011frenin.<\/li>\n<li>VPS&#8217;te yap\u0131land\u0131rma dosyas\u0131n\u0131 de\u011fi\u015ftirmeden \u00f6nce bir kopyas\u0131n\u0131 al\u0131n.<\/li>\n<\/ul>\n<\/div>\n<h2>Max allowed packet hatas\u0131 neden olur<\/h2>\n<p>MariaDB ve MySQL, istemciyle sunucu aras\u0131ndaki her mesaj\u0131 paketlerle ta\u015f\u0131r. <a href=\"https:\/\/mariadb.com\/docs\/server\/server-management\/variables-and-modes\/server-system-variables\" title=\"MariaDB belgesi \u2014 sunucu sistem de\u011fi\u015fkenleri (max_allowed_packet)\" target=\"_blank\" rel=\"noopener\">MariaDB belgesine<\/a> g\u00f6re <code>max_allowed_packet<\/code> tek bir paketin ya da ara sonucun alabilece\u011fi en b\u00fcy\u00fck boyuttur; varsay\u0131lan de\u011fer sunucuda 16 MB, istemcide 1 GB&#8217;t\u0131r ve de\u011fer en \u00e7ok 1 GB&#8217;a \u00e7\u0131kar\u0131labilir. Bir sorgu bu s\u0131n\u0131r\u0131 a\u015f\u0131nca sunucu ba\u011flant\u0131y\u0131 keser ve max allowed packet hatas\u0131 d\u00f6ner.<\/p>\n<p>En s\u0131k nedenler: binlerce sat\u0131r\u0131 tek bir <code>INSERT<\/code> c\u00fcmlesinde toplayan b\u00fcy\u00fck yedek dosyalar\u0131, veritaban\u0131nda saklanan g\u00f6rsel ya da dosyalar (BLOB), \u00e7ok uzun ayar kay\u0131tlar\u0131 tutan eklentiler ve tek seferde b\u00fcy\u00fck veri g\u00f6nderen uygulama kodu. Ayn\u0131 sorun bazen <a href=\"https:\/\/narhost.com\/destek\/mysql-has-gone-away-hatasi-nasil-cozulur\/\" title=\"MySQL Server Has Gone Away Hatas\u0131 \u2014 Narhost Destek Merkezi\">MySQL server has gone away<\/a> iletisiyle de g\u00f6r\u00fcn\u00fcr.<\/p>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/10\/max-allowed-packet-hatasi-sema-narhost.webp\" alt=\"max allowed packet hatas\u0131 \u00e7\u00f6z\u00fcm \u015femas\u0131 \u2014 sorguyu k\u00fc\u00e7\u00fcltme, dosyay\u0131 b\u00f6lme ve VPS&#x27;te de\u011feri b\u00fcy\u00fctme\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>Payla\u015f\u0131ml\u0131 hostingte sorgu k\u00fc\u00e7\u00fclt\u00fcl\u00fcr; de\u011fer yaln\u0131z VPS&#x27;te de\u011fi\u015ftirilir.<\/figcaption><\/figure>\n<h2>Payla\u015f\u0131ml\u0131 hostingte ad\u0131m ad\u0131m \u00e7\u00f6z\u00fcm<\/h2>\n<p>Payla\u015f\u0131ml\u0131 sunucuda <code>max_allowed_packet<\/code> b\u00fct\u00fcn hesaplar i\u00e7in ortak ayarlan\u0131r ve oturum de\u011feri salt okunurdur; hesab\u0131n\u0131zdan de\u011fi\u015ftirilemez. \u00c7\u00f6z\u00fcm, sorgular\u0131 s\u0131n\u0131ra s\u0131\u011facak h\u00e2le getirmektir.<\/p>\n<ol class=\"kb-adimlar\">\n<li><strong>Yede\u011fi k\u00fc\u00e7\u00fck sorgularla yeniden al\u0131n.<\/strong> Yede\u011fi ald\u0131\u011f\u0131n\u0131z sunucuya komut sat\u0131r\u0131yla eri\u015febiliyorsan\u0131z her sat\u0131r\u0131 ayr\u0131 <code>INSERT<\/code> olarak yazd\u0131r\u0131n:\n<pre><code class=\"language-bash\">mysqldump --skip-extended-insert -u kullanici -p veritabani &gt; yedek.sql<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: dosya b\u00fcy\u00fcr ama hi\u00e7bir sorgu tek sat\u0131rdan uzun olmaz; i\u00e7e aktarma s\u0131n\u0131ra tak\u0131lmaz.<\/p>\n<\/li>\n<li><strong>phpMyAdmin&#8217;de d\u0131\u015fa aktarmay\u0131 \u00f6zel y\u00f6ntemle yap\u0131n.<\/strong> Eski sunucudaki phpMyAdmin&#8217;de <strong>D\u0131\u015fa Aktar<\/strong> sekmesinde <strong>\u00d6zel<\/strong> y\u00f6ntemi se\u00e7in ve veri olu\u015fturma se\u00e7eneklerinde \u00e7oklu sat\u0131r eklemeyi kapat\u0131n. Se\u00e7eneklerin a\u00e7\u0131klamas\u0131 <a href=\"https:\/\/docs.phpmyadmin.net\/en\/latest\/import_export.html\" title=\"phpMyAdmin belgesi \u2014 i\u00e7e ve d\u0131\u015fa aktarma\" target=\"_blank\" rel=\"noopener\">phpMyAdmin belgesinde<\/a>.<\/li>\n<li><strong>B\u00fcy\u00fck dosyay\u0131 par\u00e7alara b\u00f6l\u00fcn.<\/strong> Dosyay\u0131 tablo tablo d\u0131\u015fa aktar\u0131n ve s\u0131rayla i\u00e7e aktar\u0131n. Y\u00f6ntem <a href=\"https:\/\/narhost.com\/destek\/phpmyadmin-ile-buyuk-veritabani-yukleme\/\" title=\"phpMyAdmin ile B\u00fcy\u00fck Veritaban\u0131 Y\u00fckleme \u2014 Narhost Destek Merkezi\">phpMyAdmin ile b\u00fcy\u00fck veritaban\u0131 y\u00fckleme<\/a> kart\u0131nda.<\/li>\n<li><strong>Tek sat\u0131r s\u0131n\u0131r\u0131 a\u015f\u0131yorsa destek talebi a\u00e7\u0131n.<\/strong> Veritaban\u0131nda saklanan b\u00fcy\u00fck bir dosya tek ba\u015f\u0131na s\u0131n\u0131r\u0131 ge\u00e7iyorsa sorgu b\u00f6l\u00fcnemez. Talebe tablo ad\u0131n\u0131 ve en b\u00fcy\u00fck sat\u0131r\u0131n boyutunu yaz\u0131n.<\/li>\n<\/ol>\n<h2>VPS&#8217;te max_allowed_packet nas\u0131l b\u00fcy\u00fct\u00fcl\u00fcr<\/h2>\n<ol class=\"kb-adimlar\">\n<li><strong>G\u00fcncel de\u011feri okuyun.<\/strong>\n<pre><code class=\"language-bash\">mysql -u root -p -e \"SHOW VARIABLES LIKE 'max_allowed_packet';\"<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: varsay\u0131lan kurulumda <code>16777216<\/code> (16 MB) g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<li><strong>Yap\u0131land\u0131rma dosyas\u0131n\u0131 d\u00fczenleyin.<\/strong> Ubuntu&#8217;da <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code>, AlmaLinux&#8217;ta <code>\/etc\/my.cnf.d\/mariadb-server.cnf<\/code> dosyas\u0131nda <code>[mysqld]<\/code> b\u00f6l\u00fcm\u00fcne ekleyin:\n<pre><code class=\"language-bash\">[mysqld]\nmax_allowed_packet = 256M<\/code><\/pre>\n<\/li>\n<li><strong>Hizmeti yeniden ba\u015flat\u0131n.<\/strong>\n<pre><code class=\"language-bash\">sudo systemctl restart mariadb<\/code><\/pre>\n<\/li>\n<li><strong>\u0130stemci taraf\u0131n\u0131 da b\u00fcy\u00fct\u00fcn.<\/strong> Komut sat\u0131r\u0131ndan i\u00e7e aktar\u0131rken ayn\u0131 de\u011feri istemciye verin:\n<pre><code class=\"language-bash\">mysql --max-allowed-packet=256M -u kullanici -p veritabani &lt; yedek.sql<\/code><\/pre>\n<\/li>\n<\/ol>\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>De\u011feri gere\u011finden b\u00fcy\u00fck tutmay\u0131n. Her ba\u011flant\u0131 en \u00e7ok bu kadar bellek ay\u0131rabilir; k\u00fc\u00e7\u00fck bellekli bir sunucuda 1 GB gibi bir de\u011fer, e\u015fzamanl\u0131 ba\u011flant\u0131larda belle\u011fi t\u00fcketebilir. \u00d6nce en b\u00fcy\u00fck sat\u0131ra yetecek de\u011feri se\u00e7in.<\/p>\n<\/div>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p><code>SHOW VARIABLES LIKE 'max_allowed_packet';<\/code> komutu yeni de\u011feri g\u00f6steriyor ve i\u00e7e aktarma hata vermeden bitiyorsa sorun giderilmi\u015ftir. Payla\u015f\u0131ml\u0131 hostingte do\u011frulama, i\u00e7e aktarman\u0131n b\u00fct\u00fcn tablolar\u0131 tamamlamas\u0131d\u0131r; phpMyAdmin&#8217;de tablo say\u0131s\u0131n\u0131 eski veritaban\u0131yla kar\u015f\u0131la\u015ft\u0131r\u0131n.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00e7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>Ba\u011flant\u0131 i\u00e7e aktarma ortas\u0131nda kopuyor.<\/strong> Zaman a\u015f\u0131m\u0131 da devrede olabilir; <a href=\"https:\/\/narhost.com\/destek\/mysql-has-gone-away-hatasi-nasil-cozulur\/\" title=\"MySQL Server Has Gone Away Hatas\u0131 \u2014 Narhost Destek Merkezi\">MySQL server has gone away<\/a> kart\u0131ndaki ad\u0131mlar\u0131 uygulay\u0131n.<\/li>\n<li><strong>Dosya phpMyAdmin&#8217;e y\u00fcklenmiyor.<\/strong> S\u0131n\u0131r veritaban\u0131nda de\u011fil y\u00fckleme boyutundad\u0131r; de\u011ferler <a href=\"https:\/\/narhost.com\/destek\/cpanel-php-ini-ayarlari\/\" title=\"cPanel&#039;de php.ini Ayarlar\u0131 \u2014 Narhost Destek Merkezi\">cPanel php.ini ayarlar\u0131<\/a> kart\u0131ndan b\u00fcy\u00fct\u00fcl\u00fcr.<\/li>\n<li><strong>Uygulama ayn\u0131 anda \u00e7ok ba\u011flant\u0131 a\u00e7\u0131yor.<\/strong> Hata ba\u011flant\u0131 say\u0131s\u0131yla ilgiliyse <a href=\"https:\/\/narhost.com\/destek\/mysql-too-many-connections-hatasi\/\" title=\"MySQL Too Many Connections Hatas\u0131 \u2014 Narhost Destek Merkezi\">Too many connections hatas\u0131<\/a> kart\u0131na bak\u0131n.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Talebe \u015funlar\u0131 ekleyin: veritaban\u0131 ad\u0131, hata metni birebir, i\u00e7e aktar\u0131lan dosyan\u0131n boyutu, hatay\u0131 veren tablo ad\u0131 ve denedi\u011finiz ad\u0131mlar.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi a\u00e7\">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-bazen-acilmiyorsa-ne-yapilmali\/\" title=\"Site A\u00e7\u0131lm\u0131yor \u2014 Ad\u0131m Ad\u0131m Te\u015fhis Rehberi - Narhost Destek\">Site A\u00e7\u0131lm\u0131yor \u2014 Ad\u0131m Ad\u0131m Te\u015fhis Rehberi (konu merkezi)<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/cpanelde-veritabani-yedegi-nasil-alinir\/\" title=\"cPanel&#039;de Veritaban\u0131 Yede\u011fi Nas\u0131l Al\u0131n\u0131r \u2014 Narhost Destek Merkezi\">cPanel&#8217;de veritaban\u0131 yede\u011fi nas\u0131l al\u0131n\u0131r<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/sifirdan-cpanel-mysql-veritabani-nasil-kurulur\/\" title=\"cPanel&#039;de MySQL Veritaban\u0131 Nas\u0131l Kurulur \u2014 Narhost Destek Merkezi\">cPanel&#8217;de MySQL veritaban\u0131 nas\u0131l kurulur<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/phpmyadmin-export-sorunu-nasil-giderilir\/\" title=\"phpMyAdmin D\u0131\u015fa Aktarma Sorunu \u2014 Narhost Destek Merkezi\">phpMyAdmin d\u0131\u015fa aktarma sorunu<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>max_allowed_packet de\u011feri ka\u00e7 olmal\u0131?<\/h3>\n<p>Veritaban\u0131ndaki en b\u00fcy\u00fck sat\u0131ra ya da tek sorguya yetecek kadar. \u00c7o\u011fu WordPress ve e-ticaret sitesi i\u00e7in 64 MB yeterlidir; veritaban\u0131nda b\u00fcy\u00fck dosya saklayan uygulamalarda daha y\u00fcksek de\u011fer gerekir. De\u011fer 1024&#8217;\u00fcn kat\u0131 olmal\u0131 ve 1 GB&#8217;\u0131 ge\u00e7emez.<\/p>\n<h3>SET GLOBAL ile de\u011fi\u015ftirmek kal\u0131c\u0131 olur mu?<\/h3>\n<p>Olmaz. <code>SET GLOBAL<\/code> yaln\u0131z yeni a\u00e7\u0131lan ba\u011flant\u0131lar\u0131 etkiler ve sunucu yeniden ba\u015flay\u0131nca eski de\u011fere d\u00f6ner. Kal\u0131c\u0131 de\u011fi\u015fiklik yap\u0131land\u0131rma dosyas\u0131nda yap\u0131l\u0131r.<\/p>\n<h3>Payla\u015f\u0131ml\u0131 hostingte de\u011feri neden de\u011fi\u015ftiremiyorum?<\/h3>\n<p>De\u011fi\u015fken sunucu genelinde ayarlan\u0131r ve oturum de\u011feri salt okunurdur; bir hesab\u0131n de\u011fi\u015fikli\u011fi b\u00fct\u00fcn hesaplar\u0131 etkilerdi. Bu y\u00fczden \u00e7\u00f6z\u00fcm sorgular\u0131 k\u00fc\u00e7\u00fcltmek ya da gerekiyorsa destek ekibiyle g\u00f6r\u00fc\u015fmektir.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Got a packet bigger than max_allowed_packet hatas\u0131n\u0131n nedeni ve \u00e7\u00f6z\u00fcm\u00fc: payla\u015f\u0131ml\u0131 hostingte yede\u011fi tek sat\u0131rl\u0131k sorgularla alma ve par\u00e7alama, VPS&#8217;te MariaDB yap\u0131land\u0131rmas\u0131nda max_allowed_packet de\u011ferini b\u00fcy\u00fctme ve 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,13],"tags":[172,173],"class_list":["post-2958","post","type-post","status-publish","format-standard","hentry","category-web-hosting","category-vps-server","tag-phpmyadmin","tag-mariadb"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2958","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=2958"}],"version-history":[{"count":1,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2958\/revisions"}],"predecessor-version":[{"id":3026,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2958\/revisions\/3026"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=2958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=2958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=2958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}