{"id":2721,"date":"2021-10-16T23:36:35","date_gmt":"2021-10-16T14:36:35","guid":{"rendered":"https:\/\/www.d0web.com\/blog\/?p=2721"},"modified":"2021-10-16T23:36:36","modified_gmt":"2021-10-16T14:36:36","slug":"%e6%97%a5%e5%a0%b1-2021-10-07","status":"publish","type":"post","link":"https:\/\/www.d0web.com\/blog\/archives\/2721","title":{"rendered":"\u65e5\u5831 2021.10.07"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>\u305d\u308d\u305d\u308dOracle Cloud\u30c8\u30e9\u30a4\u30a2\u30eb\u671f\u9593\u304c\u7d42\u4e86\u3057\u3066A1\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u5f37\u5236\u7d42\u4e86\u306e\u6642\u671f\u304c\u8feb\u3063\u3066\u308b\u306e\u3067\u4e00\u65e6\u30af\u30bd\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u3063\u3066\u74b0\u5883\u5168\u90e8\u305d\u3063\u3061\u306b\u907f\u96e3\u3055\u305b\u305f\u3002\u4e00\u5fdc\u7d99\u7d9a\u3057\u3066\u5f53\u30d6\u30ed\u30b0\u306f\u898b\u3089\u308c\u3066\u308b\u306f\u305a\u3002<\/p>\n\n\n\n<p>RAM\u30b5\u30a4\u30ba\u304c\u5c11\u306a\u3044\u3068WordPress\u304c\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u78ba\u7acb\u30a8\u30e9\u30fc\u300d\u3067\u843d\u3061\u308b\u3053\u3068\u304c\u3042\u308b\u306e\u3067\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u4f5c\u6210\u3068innodb_buffer_pool_size\u306e\u30b5\u30a4\u30ba\u5909\u66f4\u3067\u5bfe\u51e6\u3057\u3066\u304a\u304f\u3002<\/p>\n\n\n\n<p>1GB\u306e\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u306e\u4f5c\u6210<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-add-swap-space-on-ubuntu-20-04-ja\">Ubuntu 20.04\u306b\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5 | DigitalOcean<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>\u30d0\u30c3\u30d5\u30a1\u30b5\u30a4\u30ba(innodb_buffer_pool_size)\u3092512MB\u5909\u66f4<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/soudan.hatenablog.jp\/entry\/mysql-bufferpoolsize\">innodb_buffer_pool_size\u304c\u539f\u56e0\u3067mysql\u304c\u843d\u3061\u308b &#8211; \u73fe\u5f79\u30d7\u30ed\u30b0\u30e9\u30de\u306eWordPress\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u76f8\u8ac7<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>innodb_buffer_pool_size\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u30b5\u30a4\u30ba\u3092\u307e\u305a\u78ba\u8a8d\u3057\u3066\u304a\u304f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mariadb<\/code><\/pre>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:sh decode:true \">MariaDB [(none)]&gt; SHOW VARIABLES LIKE \"innodb_%_size\";\n+----------------------------------+-----------+\n| Variable_name                    | Value     |\n+----------------------------------+-----------+\n| innodb_buffer_pool_chunk_size    | 134217728 |\n| innodb_buffer_pool_size          | 134217728 |\n| innodb_change_buffer_max_size    | 25        |\n| innodb_ft_cache_size             | 8000000   |\n| innodb_ft_max_token_size         | 84        |\n| innodb_ft_min_token_size         | 3         |\n| innodb_ft_total_cache_size       | 640000000 |\n| innodb_log_buffer_size           | 16777216  |\n| innodb_log_file_size             | 50331648  |\n| innodb_log_write_ahead_size      | 8192      |\n| innodb_max_undo_log_size         | 10485760  |\n| innodb_online_alter_log_max_size | 134217728 |\n| innodb_page_size                 | 16384     |\n| innodb_purge_batch_size          | 300       |\n| innodb_sort_buffer_size          | 1048576   |\n| innodb_sync_array_size           | 1         |\n+----------------------------------+-----------+\n16 rows in set (0.001 sec)<\/pre><\/div>\n\n\n\n<p>innodb_buffer_pool_size\u3092512MB\u306b\u5909\u66f4\u3059\u308b\u3002<\/p>\n\n\n\n<p>ubuntu 20.04LTS\u306eMariaDB\u306e\u5834\u5408\u306f\u3001<code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code>\u306e<code>[mysqld]<\/code>\u30bb\u30af\u30b7\u30e7\u30f3\u5185\u306b<code>innodb_buffer_pool_size = 512M<\/code> \u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:ini decode:true \">[mysqld]\ninnodb_buffer_pool_size = 512M<\/pre><\/div>\n\n\n\n<p>\u4fdd\u5b58\u3057\u3066MariaDB\u3092\u518d\u8d77\u52d5\u3057\u3066\u518d\u5ea6\u30b5\u30a4\u30ba\u78ba\u8a8d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl restart mariadb<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>mariadb<\/code><\/pre>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:sh decode:true \">MariaDB [(none)]&gt; SHOW VARIABLES LIKE \"innodb_%_size\";\n+----------------------------------+-----------+\n| Variable_name                    | Value     |\n+----------------------------------+-----------+\n| innodb_buffer_pool_chunk_size    | 134217728 |\n| innodb_buffer_pool_size          | 536870912 |\n| innodb_change_buffer_max_size    | 25        |\n| innodb_ft_cache_size             | 8000000   |\n| innodb_ft_max_token_size         | 84        |\n| innodb_ft_min_token_size         | 3         |\n| innodb_ft_total_cache_size       | 640000000 |\n| innodb_log_buffer_size           | 16777216  |\n| innodb_log_file_size             | 50331648  |\n| innodb_log_write_ahead_size      | 8192      |\n| innodb_max_undo_log_size         | 10485760  |\n| innodb_online_alter_log_max_size | 134217728 |\n| innodb_page_size                 | 16384     |\n| innodb_purge_batch_size          | 300       |\n| innodb_sort_buffer_size          | 1048576   |\n| innodb_sync_array_size           | 1         |\n+----------------------------------+-----------+<\/pre><\/div>\n\n\n\n<p><code>536870912<\/code> \u3068\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3002\u6570\u65e5\u904b\u7528\u3057\u3066\u843d\u3061\u306a\u3051\u308c\u3070OK\u304b\u306a\u3002\u3042\u3068\u306fA1\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u6b7b\u4ea1\u3092\u5f85\u3064\u306e\u307f\u3002<\/p>\n\n\n\n<p> \u3082\u306a\u304b\u304f\u3093\u306ePC\u3092\u9903\u5b50\u30c7\u30d0\u30c3\u30b0\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u7d50\u5c40Colorful\u3068\u304b\u3044\u3046\u8b0e\u30e1\u30fc\u30ab\u30fc\u306eSSD\u304c\u30a4\u30c3\u305f\u3063\u307d\u304f\u3066\u3001\u4ee3\u66ffSSD\u306b\u5dee\u3057\u66ff\u3048\u3067\u306a\u3093\u3068\u304b\u306a\u308a\u307e\u3057\u305f\u3002\u306a\u3093\u3068\u304b\u306a\u3089\u306a\u304b\u3063\u305f\u306e\u306f\u3001\u3044\u308d\u3044\u308d\u3084\u3063\u3066\u308b\u3046\u3061\u306b\u30cf\u30fc\u30c9\u30a6\u30a7\u30a2RAID\u306e\u8a2d\u5b9a\u3092\u3044\u3058\u3063\u3066\u3057\u307e\u3063\u305f\u307d\u304f\u3066\u539f\u56e0\u304c\u3069\u3053\u306b\u3042\u308b\u304b\u4e0d\u660e\u72b6\u614b\u306b\u306a\u3063\u3066\u305f\u611f\u3058\u3002<\/p>\n\n\n\n<p>\u7d50\u8ad6\u3001\u300c\u9903\u5b50\u3092\u713c\u3051\u3070PC\u304c\u76f4\u308b\u300d\u3002<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061.jpg\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061-1024x576.jpg\" alt=\"\" data-id=\"2999\" data-full-url=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061.jpg\" data-link=\"https:\/\/www.d0web.com\/blog\/?attachment_id=2999\" class=\"wp-image-2999\" srcset=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061-1024x576.jpg 1024w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061-300x169.jpg 300w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061-455x256.jpg 455w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061-768x432.jpg 768w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061-1536x864.jpg 1536w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061.jpg 1723w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060.jpg\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060-1024x576.jpg\" alt=\"\" data-id=\"3000\" data-full-url=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060.jpg\" data-link=\"https:\/\/www.d0web.com\/blog\/?attachment_id=3000\" class=\"wp-image-3000\" srcset=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060-1024x576.jpg 1024w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060-300x169.jpg 300w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060-455x256.jpg 455w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060-768x432.jpg 768w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060-1536x864.jpg 1536w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0060.jpg 1723w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>\u304a\u6e80\u5dde\u9903\u5b50\u306f\u65e8\u3044\u3051\u3069\u306a\u3093\u304b\u30ad\u30e0\u30c1\u304c\u50b7\u3093\u3067\u308b\u306e\u304b\u3081\u3061\u3083\u304f\u3061\u3083\u5fae\u5999\u306a\u5473\u304c\u3057\u305f\u3002\uff12\u56de\u3053\u306e\u5473\u306a\u3089\u30ea\u30d4\u6a5f\u904b\u7121\u3057\u3002<\/p>\n\n\n\n<p>\u304a\u793c\u306b\u30ab\u30ec\u30fc\u3082\u3089\u3063\u305f\u3001\u982d\u304c\u60aa\u3044\u306e\u3067\u300c\u305f\u307e\u306d\u304e\u300d\u304b\u3068\u601d\u3063\u305f\u3089\u300c\u305f\u307e\u304b\u305a\u3089\u300d\u3063\u307d\u3044\u3002\u30d0\u30fc\u306e\u30ab\u30ec\u30fc\u3089\u3057\u3044\u306e\u3067\u30ef\u30b7\u306f\uff11\u4eba\u3058\u3083\u7d76\u5bfe\u306b\u5165\u5e97\u3067\u304d\u306a\u3044\u306e\u3067\u52a9\u304b\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-thumbnail\"><a href=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063.jpg\"><img decoding=\"async\" width=\"455\" height=\"256\" src=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063-455x256.jpg\" alt=\"\" class=\"wp-image-3001\" srcset=\"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063-455x256.jpg 455w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063-300x169.jpg 300w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063-1024x576.jpg 1024w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063-768x432.jpg 768w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063-1536x864.jpg 1536w, https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0063.jpg 1723w\" sizes=\"(max-width: 455px) 100vw, 455px\" \/><\/a><\/figure>\n\n\n\n<p>\u304a\u308f\u3044<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u305d\u308d\u305d\u308dOracle Cloud\u30c8\u30e9\u30a4\u30a2\u30eb\u671f\u9593\u304c\u7d42\u4e86\u3057\u3066A1\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u5f37\u5236\u7d42\u4e86\u306e\u6642\u671f\u304c\u8feb\u3063\u3066\u308b\u306e\u3067\u4e00\u65e6\u30af\u30bd\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":2999,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-d0"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/www.d0web.com\/blog\/wp-content\/uploads\/2021\/10\/DSC_0061.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/posts\/2721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/comments?post=2721"}],"version-history":[{"count":19,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/posts\/2721\/revisions"}],"predecessor-version":[{"id":3013,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/posts\/2721\/revisions\/3013"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/media\/2999"}],"wp:attachment":[{"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/media?parent=2721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/categories?post=2721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.d0web.com\/blog\/wp-json\/wp\/v2\/tags?post=2721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}