{"id":772,"date":"2022-09-05T10:57:09","date_gmt":"2022-09-05T10:57:09","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=772"},"modified":"2022-10-09T19:23:23","modified_gmt":"2022-10-09T19:23:23","slug":"how-to-fix-mysql-error-reading-communication-packets-hatasinin-cozumu","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/how-to-fix-mysql-error-reading-communication-packets-hatasinin-cozumu\/","title":{"rendered":"How To Fix MySQL Error Reading Communication Packets Hatas\u0131n\u0131n \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>Merhabalar,\u00a0<strong>WordPress<\/strong>\u00a0son g\u00fcncellemesiyle birlikte WordPress kullanan bir\u00e7ok sitede veya bir\u00e7ok sunucunun MySQL error kay\u0131tlar\u0131nda &#8220;<strong>MySQL Error Reading Communication Packets<\/strong>&#8221; \u015feklinde hata g\u00f6rebiliriz.<\/p>\n<pre class=\"language-markup\"><code>[Warning] Aborted connection 2619503 to db: 'db_name' user: 'user_name' host: 'webapp_hostname' (Got an error reading communication packets)<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/image.prntscr.com\/image\/VOr4Up7rQmOKTkiNevcPpg.png\" alt=\"[Warning] Aborted connection 2619503 to db:\" width=\"621\" height=\"102\" title=\"\"><\/p>\n<p>Konu ile ilgili olarak MySQL kaynaklar\u0131na g\u00f6re ;<\/p>\n<p>Yanl\u0131\u015f veya \u00e7ok b\u00fcy\u00fck bir sorgu g\u00f6nderirseniz, bu hatalar\u0131 alabilirsiniz. E\u011fer\u00a0<strong>mysql<\/strong>\u00a0\u00e7ok b\u00fcy\u00fck veya s\u0131ra d\u0131\u015f\u0131 bir paket al\u0131rsa, bir \u015feylerin ters gitti\u011fini ve ba\u011flant\u0131y\u0131 kapatt\u0131\u011f\u0131n\u0131 varsayar. B\u00fcy\u00fck sorgulara ihtiyac\u0131n\u0131z varsa (\u00f6rne\u011fin, b\u00fcy\u00fck BLOB s\u00fctunlar\u0131yla \u00e7al\u0131\u015f\u0131yorsan\u0131z), sunucunun varsay\u0131lan 1 MB de\u011ferine sahip\u00a0<strong>max_allowed_packet<\/strong>\u00a0de\u011fi\u015fkenini ayarlayarak sorgu s\u0131n\u0131r\u0131n\u0131 art\u0131rabilirsiniz. \u0130stemci ucundaki maksimum paket boyutunu da art\u0131rman\u0131z gerekebilir. Paket b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc ayarlama hakk\u0131nda daha fazla bilgi,\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/packet-too-large.html\" target=\"_blank\" rel=\"noopener nofollow\">C.5.2.10<\/a>\u00a0b\u00f6l\u00fcm\u00fcnde verilmi\u015ftir . \u00c7ok say\u0131da sat\u0131r ekleyen bir INSERT veya REPLACE ifadesi de bu t\u00fcr hatalara neden olabilir. Bu ifadelerden biri, eklenecek sat\u0131r say\u0131s\u0131ndan ba\u011f\u0131ms\u0131z olarak sunucuya tek bir istek g\u00f6nderir; Bu nedenle, genellikle INSERT veya REPLACE ba\u015f\u0131na g\u00f6nderilen sat\u0131r say\u0131s\u0131n\u0131 azaltarak hatay\u0131 \u00f6nleyebilirsiniz.<\/p>\n<p>Ayr\u0131ca \u00e7\u00f6z\u00fcm i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yapabiliriz.<\/p>\n<pre class=\"language-markup\"><code>nano -w \/etc\/my.cnf<\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"language-javascript\"><code>[mysqld]\r\nmax_allowed_packet=256M<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>Bol Trafikler<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar,\u00a0WordPress\u00a0son g\u00fcncellemesiyle birlikte WordPress kullanan bir\u00e7ok sitede veya bir\u00e7ok sunucunun MySQL error kay\u0131tlar\u0131nda &#8220;MySQL Error Reading Communication Packets&#8221; \u015feklinde hata g\u00f6rebiliriz. [Warning] Aborted connection 2619503 to db: &#8216;db_name&#8217; user: &#8216;user_name&#8217; host: &#8216;webapp_hostname&#8217; (Got an error reading communication packets) Konu ile ilgili olarak MySQL kaynaklar\u0131na g\u00f6re ; Yanl\u0131\u015f veya \u00e7ok b\u00fcy\u00fck bir sorgu g\u00f6nderirseniz, bu hatalar\u0131 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-772","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=772"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/772\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1456"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}