{"id":123,"date":"2018-03-21T00:37:11","date_gmt":"2018-03-20T15:37:11","guid":{"rendered":"http:\/\/www7390uo.sakura.ne.jp\/wordpress\/?p=123"},"modified":"2022-05-22T02:17:14","modified_gmt":"2022-05-21T17:17:14","slug":"raspbian%e3%81%ae%e3%82%b9%e3%83%af%e3%83%83%e3%83%97%e9%a0%98%e5%9f%9f%e3%82%92%e6%8b%a1%e5%bc%b5%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/archives\/123","title":{"rendered":"Raspbian\u306e\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u3092\u62e1\u5f35\u3059\u308b"},"content":{"rendered":"\n<p>Raspberry Pi 3 Model B<br>OS: Raspbian stretch lite November 2017<br>MySQL 5.7.21<\/p>\n\n\n\n<p>OS\u306bRaspbian\u3092\u5c0e\u5165\u3057\u305fRaspberry Pi 3\u3067MySQL\u306e\u30d3\u30eb\u30c9\u3092\u3053\u306a\u3057\u3066\u3044\u305f\u3089\u9053\u534a\u3070\u3067\u6253\u3061\u5207\u308a\u306e\u6182\u304d\u76ee\u306b\u906d\u3063\u305f\u3002\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u3088\u308c\u3070cc1plus\u304c\u6bba\u5bb3\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ make\n(snip)\n[ 50%] Building CXX object sql\/CMakeFiles\/sql.dir\/item_geofunc_setops.cc.o\n<strong class=\"orange\">c++: internal compiler error: Killed (program cc1plus)<\/strong><\/pre>\n\n\n\n<p>dmesg\u304b\u3089\u624b\u304c\u304b\u308a\u3092\u63a2\u308b\u3068\u3001\u3069\u3046\u3082Out of memory killer\u306b\u3088\u3063\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u5208\u308a\u53d6\u3089\u308c\u305f\u6a21\u69d8\u3067\u3042\u308b\u3002Raspberry Pi 3 Model B\u306e\u30e1\u30e2\u30ea\u642d\u8f09\u91cf1GB\u306b\u5bfe\u3057\u3066\u305d\u306e8\u5272\u3092\u8d85\u3048\u308b\u30e1\u30e2\u30ea\u3092\u6d88\u8cbb\u3059\u308c\u3070\u304a\u548e\u3081\u306e\u5bfe\u8c61\u3068\u306a\u308b\u306e\u3082\u5b9c\u306a\u308b\u304b\u306a\u3068\u3044\u3046\u3068\u3053\u308d\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ dmesg\n(snip)\n[16075.666040] Out of memory: Kill process 11885 (cc1plus) score 853 or sacrifice child\n<strong class=\"orange\">[16075.666059] Killed process 11885 (cc1plus) total-vm:919780kB, anon-rss:842300kB, file-rss:0kB, shmem-rss:0kB<\/strong>\n[16076.103693] oom_reaper: reaped process 11885 (cc1plus), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB<\/pre>\n\n\n\n<p>\u30d3\u30eb\u30c9\u306b\u8cbb\u3084\u3057\u305f\u9014\u65b9\u3082\u306a\u3044\u5f85\u3061\u6642\u9593\u304c\u3075\u3044\u306b\u306a\u308a\u8aa0\u306b\u907a\u61be\u3067\u3042\u308b\u3002\u3055\u308a\u3068\u3066OOM-Killer\u3092\u7121\u52b9\u306b\u3059\u308b\u3068\u30e1\u30e2\u30ea\u306e\u6255\u5e95\u3092\u5dee\u3057\u6b62\u3081\u3089\u308c\u305a\u306b\u30b7\u30b9\u30c6\u30e0\u304c\u6df7\u4e71\u306b\u9665\u308b\u60e7\u308c\u304c\u3042\u308b\u3002\u3060\u304b\u3089\u3053\u306e\u5ea6\u306f\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u3092\u62e1\u5f35\u3059\u308b\u306e\u304c\u9069\u5f53\u306b\u304a\u3082\u3046\u3002<\/p>\n\n\n\n<p>\u5b9f\u969bRaspbian\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u306b100MB\u306e\u5272\u308a\u5f53\u3066\u3057\u304b\u306a\u304f\u3001\u8fd1\u9803\u306eMySQL\u3092\u30d3\u30eb\u30c9\u3059\u308b\u306b\u306f\u5230\u5e95\u9593\u306b\u5408\u308f\u306a\u3044\u3002\u3053\u308c\u30922GB\u3078\u5f15\u304d\u4e0a\u3052\u308b\u3002Raspbian\u306f<code>\/etc\/dphys-swapfile<\/code>\u306e<code>CONF_SWAPSIZE<\/code>\u3067\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u3092\u8a2d\u5b9a\u3059\u308b\u3088\u3046\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/dphys-swapfile\n#CONF_SWAPSIZE=100\n<strong class=\"orange\">CONF_SWAPSIZE=2048<\/strong>\n\n$ sudo dphys-swapfile install\nwant \/var\/swap=2048MByte, checking existing: deleting wrong size file (104857600), generating swapfile ... of 2048MBytes\n\n$ sudo dphys-swapfile swapon<\/pre>\n\n\n\n<p>\u3053\u308c\u3067\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u304c2GB\u306b\u62e1\u5f35\u3055\u308c\u305f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ free -m\n          total       used        free      shared  buff\/cache   available\nMem:        927         76         455          12         395         787\n<strong class=\"orange\">Swap:      2047          0        2047<\/strong><\/pre>\n\n\n\n<p>\u6539\u3081\u3066MySQL\u306e\u30d3\u30eb\u30c9\u3092\u8a66\u307f\u305f\u3068\u3053\u308d450\u5206\u7a0b\u5ea6\u3092\u8cbb\u3084\u3057\u3066\u6059\u7121\u304f\u5b8c\u4e86\u3057\u305f\u3002<\/p>\n\n\n\n<h3 class=\"link\">\u53c2\u8003:<\/h3>\n<ul>\n <li>$ man dphys-swapfile<\/li>\n <li><a href=\"https:\/\/www.raspberrypi.org\/forums\/viewtopic.php?t=46472\">Increase size of existing swap file<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Raspberry Pi 3 Model BOS: Raspbian stretch lite November 2017MySQL 5.7.21 OS\u306bRaspbian\u3092\u5c0e\u5165\u3057\u305fRaspberry Pi 3\u3067MySQL\u306e\u30d3\u30eb\u30c9\u3092\u3053\u306a\u3057\u3066\u3044\u305f\u3089\u9053\u534a\u3070\u3067\u6253\u3061\u5207\u308a\u306e\u6182\u304d\u76ee\u306b\u906d\u3063\u305f\u3002\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u3088\u308c\u3070cc1plus\u304c\u6bba\u5bb3\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3067\u3042\u308b\u3002 $ make (snip) [ 50%] Buildi &#8230; <a title=\"Raspbian\u306e\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u3092\u62e1\u5f35\u3059\u308b\" class=\"read-more\" href=\"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/archives\/123\" aria-label=\"Raspbian\u306e\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u3092\u62e1\u5f35\u3059\u308b \u306b\u3064\u3044\u3066\u3055\u3089\u306b\u8aad\u3080\">\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":972,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[166],"tags":[167],"class_list":["post-123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-raspberry-pi","tag-swap"],"views":6931,"_links":{"self":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":0,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/media\/972"}],"wp:attachment":[{"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}