{"id":57,"date":"2016-10-11T21:34:26","date_gmt":"2016-10-11T12:34:26","guid":{"rendered":"http:\/\/testengine.co.jp\/engine\/?p=57"},"modified":"2017-02-04T16:15:07","modified_gmt":"2017-02-04T07:15:07","slug":"redis-%e5%a4%a7%e9%87%8f%e6%9b%b8%e8%be%bc%e3%81%bf%e3%83%87%e3%83%bc%e3%82%bf%e7%94%9f%e6%88%90","status":"publish","type":"post","link":"https:\/\/testengine.co.jp\/engine\/2016\/10\/11\/redis-%e5%a4%a7%e9%87%8f%e6%9b%b8%e8%be%bc%e3%81%bf%e3%83%87%e3%83%bc%e3%82%bf%e7%94%9f%e6%88%90\/","title":{"rendered":"redis \u5927\u91cf\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u30c7\u30fc\u30bf\u751f\u6210"},"content":{"rendered":"<div id=\"dslc-theme-content\"><div id=\"dslc-theme-content-inner\"><h3>redis \u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u30b5\u30f3\u30d7\u30eb<\/h3>\n<pre>\u4f7f\u3044\u65b9\r\nawk\u3092\u4f7f\u7528\u3057\u3066\u3001redis\u3078\u306e\u5927\u91cfset\u3092\u5b9f\u884c\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002\r\n\r\n\u4f8b\uff09redis.csv\u306e\u5143\u30cd\u30bf1\u884c\u304b\u3089\u30011000\u884c\u751f\u6210\u3057\u3066redis\u306b\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3059\u308b\r\nawk -f scriptbuilder.awk redis.csv|redis-cli\r\nok\r\nok\r\nok\r\n.\r\n.\r\n.\r\n.\r\nok\r\n(redis\u3078\u306e\u30bb\u30c3\u30c8\u3054\u3068\u306b\u3001redis\u304b\u3089\u306eok\u304c\u5e30\u308b:\u3053\u306e\u4f8b\u306f1000\u56de\uff09\r\nredis.csv\u306e\u4e2d\u8eab \u4e88\u7d04\u8a9e\u306f[]\u3067\u56f2\u3093\u3067\u6307\u5b9a\u3059\u308b\r\n[loop 1000]\r\nhmset key_test01[lineNum03] item01 value01[lineNum05] item02 value02[lineNum1] input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\n[sleep 0.0001]\r\n[loopEnd]\r\n\r\n\r\n\u8aac\u660e\r\n# 1.loop\u51e6\u7406\u3092\u958b\u59cb\u3059\u308b\r\n#\u00a0\u00a0 \u3053\u306e\u4f8b\u3067\u306f1000\u56de\u7e70\u308a\u8fd4\u3057\u3059\u308b\u3053\u3068\u306e\u958b\u59cb\u306e\u5ba3\u8a00\r\n[loop 1000]\r\n# 2.script\u751f\u6210\u306e\u5143\u30cd\u30bf1\u884c\u76ee\u3092\u4e0e\u3048\u51fa\u529b\u3059\u308b\r\n#\u00a0\u00a0 [lineNum03]\u306f\u5b9f\u884c\u56de\u6570\u3054\u3068\u306b\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u756a\u53f7\u3092\u4ed8\u4e0e\u3057\u307e\u3059\r\n#\u00a0\u00a0 03\u306e\u610f\u5473\u306fprintf()\u6587\u306e\u66f8\u5f0f\u6587\u5b57\u5217[%03d]\u306e03\u3068\u540c\u3058\u610f\u5473\u3001\u524d\u30bc\u30ed\uff13\u6841\u51e6\u7406\u3057\u307e\u3059\r\n#\u00a0\u00a0 [lineNum1]\u306f\u524d\u30bc\u30ed\u306a\u3057\u306e\u30b7\u30fc\u30b1\u30f3\u30b9\u756a\u53f7\u3092\u4ed8\u4e0e\u3057\u307e\u3059\r\nhmset key_test01[lineNum03] item01 value01[lineNum05] item02 value02[lineNum1] input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\n\r\n# \u51fa\u529b\u4f8b\r\nhmset key_test01001 item01 value0100001 item02 value021 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01002 item01 value0100002 item02 value022 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01003 item01 value0100003 item02 value023 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01004 item01 value0100004 item02 value024 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01005 item01 value0100005 item02 value025 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01006 item01 value0100006 item02 value026 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01007 item01 value0100007 item02 value027 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01008 item01 value0100008 item02 value028 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01009 item01 value0100009 item02 value029 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\nhmset key_test01010 item01 value0100010 item02 value0210 input_time '2016-10-11 12:00:00.000' update_time '2016-10-11 12:00:00.000'\r\n\r\n\r\n# 3.sleep\u30920.0001\u79d2(0.1\u30df\u30ea\u79d2)\u3059\u308b\r\n#\u00a0\u00a0 loop\u51e6\u7406\u3092\u3059\u308b\u969b\u306bcpu\u3092\u5360\u6709\u3057\u306a\u3044\u3088\u3046\u306b\u3059\u308b\r\n#\u00a0\u00a0 \u3053\u306eScriptBuilder\u3092multi process\u3067\u52d5\u4f5c\u3059\u308b\u3068\u304d\u306e\u305f\u3081\u306e\u5bfe\u5fdc\u7b56\r\n[sleep 0.0001]\r\n# 4.loop\u51e6\u7406\u306e\u7d42\u4e86 loop\u3092n\u56de\u3001loopEnd\u307e\u3067\u7e70\u308a\u8fd4\u3059\r\n#\u00a0\u00a0 \u3053\u306e\u4f8b\u3067\u306f\u30012.\u304b\u30894.\u307e\u3067\u30921000\u56de\u7e70\u308a\u8fd4\u3059\r\n[loopEnd]\r\n\r\n\r\n\r\n# shell script\u3067\u4e0b\u8a18\u306e\u3088\u3046\u306b\u3059\u308b\u3068\u3001\u8907\u6570\u30d7\u30ed\u30bb\u30b9\u304b\u3089\u975e\u540c\u671f\u306e\u66f8\u8fbc\u307f\u304c\u3067\u304d\u307e\u3059\r\n#!\/bin\/sh\r\nawk -f scriptbuilder.awk redis.csv|redis-cli -p 6379\r\n\r\n# redisSet6379.sh\u3067\u4f5c\u6210\u3057\u3001\u5b9f\u884c\u6a29\u3092\u4e0e\u3048\u308b\r\n\r\n#redisLoop.sh\u3092\u4e0b\u8a18\u306e\u3088\u3046\u306b\u4f5c\u6210 10\u30d7\u30ed\u30bb\u30b9\u540c\u6642\u5b9f\u884c\r\n#!\/bin\/sh\r\nfor i in {0..10};\\\r\ndo \\\r\n\u00a0 echo $i;\\\r\n\u00a0 .\/redisSet6379.sh &amp; \\\r\ndone;<\/pre>\n<p>&nbsp;<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>redis \u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u30b5\u30f3\u30d7\u30eb \u4f7f\u3044\u65b9 awk\u3092\u4f7f\u7528\u3057\u3066\u3001 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[18,17,19,21,20,16],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-4","tag-hmset","tag-redis","tag-19","tag-21","tag-20","tag-16","clearfix"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7t6nl-V","jetpack-related-posts":[{"id":48,"url":"https:\/\/testengine.co.jp\/engine\/2016\/10\/02\/scriptbuilder-awk-%e5%a4%a7%e9%87%8f%e3%83%86%e3%82%b9%e3%83%88%e3%83%87%e3%83%bc%e3%82%bf%e7%94%9f%e6%88%90\/","url_meta":{"origin":57,"position":0},"title":"scriptbuilder.awk \u5927\u91cf\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u751f\u6210","author":"\u52aa\u82e5\u677e","date":"2016\u5e7410\u67082\u65e5","format":false,"excerpt":"ScriptBuilder \u4f7f\u3044\u65b9\u3000redis\u3078\u306e\u66f8\u8fbc\u307f\u3092\u5927\u91cf\u306b\u751f\u6210\u3057\u305f\u3044\u3001SQL\u306einset\u6587\u3092\u5927\u2026","rel":"","context":"\u6280\u8853\u306e\u5c0f\u90e8\u5c4b","block_context":{"text":"\u6280\u8853\u306e\u5c0f\u90e8\u5c4b","link":"https:\/\/testengine.co.jp\/engine\/category\/%e6%8a%80%e8%a1%93%e3%81%ae%e5%b0%8f%e9%83%a8%e5%b1%8b\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/PzwguQWnd2Y\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":3,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":67,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts\/57\/revisions\/67"}],"wp:attachment":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}