{"id":864,"date":"2015-01-19T18:16:55","date_gmt":"2015-01-19T16:16:55","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=864"},"modified":"2015-01-19T18:20:44","modified_gmt":"2015-01-19T16:20:44","slug":"mysql-myisamchk-error-myisam_sort_buffer_size-is-too-small-hatasi","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2015\/01\/mysql-myisamchk-error-myisam_sort_buffer_size-is-too-small-hatasi\/","title":{"rendered":"MySQL \u2013 myisamchk: error: myisam_sort_buffer_size is too small hatas\u0131"},"content":{"rendered":"<p>B\u00fcy\u00fck boyutlu myisam tablolar\u0131n\u0131z\u0131 repair ederken ba\u015fl\u0131kta belirtilen hatay\u0131 alabilirsiniz. Sebebi myisam sort buffer size de\u011ferine tak\u0131lman\u0131zd\u0131r. Bunun i\u00e7in tablo repair i\u015flemlerinizi a\u015fa\u011f\u0131daki \u015fekilde yapabilirsiniz.<\/p>\n<p>root@ayhanarda [\/var\/lib\/mysql\/ayhan_testdb]# \/etc\/init.d\/mysql stop<br \/>\nShutting down MySQL&#8230; SUCCESS!<br \/>\nroot@ayhanarda [\/var\/lib\/mysql\/ayhan_testdb]# myisamchk -r -q <strong>ayhan_posts<\/strong>.MYI &#8211;sort_buffer_size=3G<br \/>\n&#8211; check record delete-chain<br \/>\n&#8211; recovering (with sort) MyISAM-table &#8216;<strong>ayhan_posts<\/strong>.MYI&#8217;<br \/>\nData records: 0<br \/>\n&#8211; Fixing index 1<br \/>\n&#8211; Fixing index 2<br \/>\n&#8211; Fixing index 3<br \/>\n&#8211; Fixing index 4<br \/>\n&#8211; Fixing index 5<br \/>\n&#8211; Fixing index 6<br \/>\n&#8211; Fixing index 7<br \/>\nData records: 720336<br \/>\nroot@ayhanarda\u00a0[\/var\/lib\/mysql\/ayhan_testdb]# \/etc\/init.d\/mysql start<br \/>\nStarting MySQL&#8230; SUCCESS!<\/p>\n<p>Ayhan ARDA<\/p>\n<p>Ayr\u0131ca; Mysql error : Can\u2019t create new tempfile: \u2018*.TMD file \u015feklinde bir hata al\u0131rsan\u0131z da ayn\u0131 \u00e7\u00f6z\u00fcm\u00fc kullanabilirsiniz.<\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Pinterest\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"ayhanarda\";var hupso_url_t=\"\";var hupso_title_t=\"MySQL%20%E2%80%93%20myisamchk%3A%20error%3A%20myisam_sort_buffer_size%20is%20too%20small%20hatas%C4%B1\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"B\u00fcy\u00fck boyutlu myisam tablolar\u0131n\u0131z\u0131 repair ederken ba\u015fl\u0131kta belirtilen hatay\u0131 alabilirsiniz. Sebebi myisam sort buffer size de\u011ferine tak\u0131lman\u0131zd\u0131r. Bunun i\u00e7in tablo repair i\u015flemlerinizi a\u015fa\u011f\u0131daki \u015fekilde yapabilirsiniz. root@ayhanarda [\/var\/lib\/mysql\/ayhan_testdb]# \/etc\/init.d\/mysql stop Shutting down MySQL&#8230; SUCCESS! root@ayhanarda [\/var\/lib\/mysql\/ayhan_testdb]# myisamchk -r -q ayhan_posts.MYI &#8211;sort_buffer_size=3G &#8211; check record delete-chain &#8211; recovering (with sort) MyISAM-table &#8216;ayhan_posts.MYI&#8217; Data records: 0 &#8211; Fixing [&hellip;]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[391],"tags":[662,656,659,657,658,660,661],"class_list":["post-864","post","type-post","status-publish","format-standard","hentry","category-mysql-2","tag-cant-create-new-tempfile","tag-myisam","tag-myisam_sort_buffer_size","tag-myisamcheck","tag-myisamchk","tag-myisamchk-error","tag-tmd"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/comments?post=864"}],"version-history":[{"count":4,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/864\/revisions"}],"predecessor-version":[{"id":868,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/864\/revisions\/868"}],"wp:attachment":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/categories?post=864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/tags?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}