{"id":507,"date":"2022-01-18T11:58:10","date_gmt":"2022-01-18T02:58:10","guid":{"rendered":"https:\/\/centos.ihavenomoney.co.kr\/?page_id=507"},"modified":"2022-01-18T12:00:28","modified_gmt":"2022-01-18T03:00:28","slug":"mysql-out-of-sort-memory","status":"publish","type":"page","link":"https:\/\/centos.ihavenomoney.co.kr\/?page_id=507","title":{"rendered":"mysql  Out of sort memory"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Remark : mysql  memory increase <\/h3>\n\n\n\n<p>Warning : mysqli_query(): (HY001\/1038):  Out of sort memory, consider increasing server sort buffer size in \/var\/&#8230;&#8230;.. <\/p>\n\n\n\n<p>sort_buffer_size \uc8fc\uc11d\uc81c\uac70 \ubc0f \ud544\uc694\uc2dc 5M \ub85c \uc124\uc815<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" title=\"sort_buffer_size\">sudo vi  \/etc\/my.cnf\n\n\n# Remove leading # to set options mainly useful for reporting servers.\n# The server defaults are faster for transactions and fast SELECTs.\n# Adjust sizes as needed, experiment to find the optimal values.\n# join_buffer_size = 128M\n  sort_buffer_size = 2M  # \uc8fc\uc11d\uc81c\uac70  \n# read_rnd_buffer_size = 2M\n<\/pre><\/div>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" title=\"restart \" >systemctl restart mysqld<\/pre><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Remark : mysql memory increase Warning : mysqli_query(): (HY001\/1038): Out of sort memory, consider increasing server sort buffer size in \/var\/&#8230;&#8230;.. sort_buffer_size \uc8fc\uc11d\uc81c\uac70 \ubc0f \ud544\uc694\uc2dc 5M \ub85c \uc124\uc815<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-507","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=507"}],"version-history":[{"count":2,"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/507\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/507\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/centos.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}