Loading
{"id":22763,"type":0,"block_id":"1336442407","theme_id":32,"user_id":11138,"path":"703723955/1336442407","title":"insight","pubtitle":null,"tags":"","public":true,"publicAccess":true,"private_link_enabled":0,"thumb":"https://s3-eu-west-1.amazonaws.com/infogram-thumbs-200/1336442407.jpg","width":674,"copyright":null,"properties":{"whitelabel":false,"embed_button":"enabled","title_link":"infogram","custom_logo":"none","user_embed_button_text":"Share","decimal_separator":".,"},"elements":[{"type":"particle","particle_id":10447441,"object_id":"7dc14373-e9c2-11e4-a037-7b5f270fdca9","particle_type":"maintitle","picture":null,"text":"insight","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":4376,"object_id":"1336442945","particle_type":"bodytitle","picture":null,"text":"application status","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7208,"object_id":"1336962798","particle_type":"bodytext","picture":null,"text":"APサーバ単体では非常に健康な状態を保っており、スケールも可能な状態","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7209,"object_id":"1336962876","particle_type":"bodytext","picture":null,"text":"ブラウザ版レンダリング効率には改善の余地あり","content_type":"","title":null,"shrink":null},{"type":"chart","chart_id":24683,"object_id":"1336442407","chart_type_nr":6,"data":[[["","2/15","3/1","3/15","4/1","4/15","5/1"],["Traffic","1.48","0.75","1.3","1.5","1.1","0.75"],["LoadAverage","0.2","1.2","0.3","0.3","0.6","0.2"]]],"custom":{"legacyTransposeDone":true,"switchRowsColumns":true},"colors":["#aa126b","#f340a9","#dfdfdf"],"dimensions":[],"modifier":0,"sheetnames":null,"sheets_settings":[]},{"type":"particle","particle_id":4386,"object_id":"1336443953","particle_type":"bodytitle","picture":null,"text":"Database status","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7210,"object_id":"1336963144","particle_type":"bodytext","picture":null,"text":"アクセス数ではなくデータの蓄積と共に負荷が向上しており、かつボトルネックが最強クエリに含まれる group by に起因するため、現状の構成ではスケールしない。システム上最大のリスクであり、サービス成長を維持するために最重要改善ポイントとなる。","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7211,"object_id":"1336963221","particle_type":"bodytext","picture":null,"text":"タイムライン取得処理がもっとも高負荷。この機能を MySQL から分離させ、かつNoSQL による新設計を導入することで、負荷軽減とスケーラビリティの担保を狙う。","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7212,"object_id":"1336963675","particle_type":"bodytext","picture":null,"text":"その他非効率的なクエリについては順次見直し、廃止機能についてはタイミングをみてテーブルの参照を落としていく","content_type":"","title":null,"shrink":null},{"type":"chart","chart_id":24699,"object_id":"1336443982","chart_type_nr":6,"data":[[["","2/15","3/1","3/15","4/1","4/15","5/1"],["LoadAverage","2","4","5","6","9","8"],["MasterQuery","1","4","6","5","30","29"],["MasterThreads","3","15","21","20","23","19"]]],"custom":{"legacyTransposeDone":true,"switchRowsColumns":true},"colors":[],"dimensions":[],"modifier":0,"sheetnames":null,"sheets_settings":[]},{"type":"particle","particle_id":4403,"object_id":"1336454322","particle_type":"bodytitle","picture":null,"text":"This is a dummy text","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8274,"object_id":"1337078212","particle_type":"bodytitle","picture":null,"text":"This is a dummy text","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7215,"object_id":"1336966415","particle_type":"bodytext","picture":null,"text":"This is a dummy text","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8284,"object_id":"1337078667","particle_type":"bodytitle","picture":null,"text":"slow functions","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":7217,"object_id":"1337079211","particle_type":"bodytext","picture":null,"text":"レスポンスに一秒以上かかった機能 トップ 5","content_type":"","title":null,"shrink":null},{"type":"chart","chart_id":29813,"object_id":"1337078585","chart_type_nr":1,"data":[[["","1810"],["/api/v2/activity/latest.json","7182"],["/activity/show/{id}","1844"],["/api/v2/activity/comment/new.json","1060"],["[top]","956"],["/api/v2/activity/photo/upload.json","699"]]],"custom":{},"colors":[],"dimensions":[],"modifier":0,"sheetnames":null,"sheets_settings":[]},{"type":"particle","particle_id":7218,"object_id":"1337079250","particle_type":"bodytext","picture":null,"text":"1 : [API] ホームタイムライン","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8292,"object_id":"1337079290","particle_type":"bodytext","picture":null,"text":"2 : [PC] アクティビティ詳細","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8293,"object_id":"1337079335","particle_type":"bodytext","picture":null,"text":"3 : [API] 画像つきコメント投稿","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8294,"object_id":"1337079377","particle_type":"bodytext","picture":null,"text":"4 : [PC] トップページ表示","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8295,"object_id":"1337079405","particle_type":"bodytext","picture":null,"text":"5: [API] 画像投稿","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":8296,"object_id":"1337139793","particle_type":"bodytext","picture":null,"text":"This is a dummy text","content_type":"","title":null,"shrink":null},{"type":"chart","chart_id":87662,"object_id":"1338458012","chart_type_nr":6,"data":[],"custom":{"legacyTransposeDone":true,"switchRowsColumns":true},"colors":[],"dimensions":[],"modifier":0,"sheetnames":null,"sheets_settings":[]}],"theme":{"createdAt":"2016-04-22 07:54:07","updatedAt":"2016-09-02 09:19:10","logoImages":[""],"charts":{"table":{"shapeFill":"e84f2c","headerColor":"#6f6f6f","cellColor":"#6f6f6f","headerBackground":"#eeeeee","cellBackground":"#ffffff"},"treemap":{"labels":{"name":{"fontFamily":"PT Sans Narrow","fontWeight":"700"},"value":{"fontFamily":"PT Sans Narrow"}}},"wordcloud":{"labels":{"fontFamily":"Arial","fontWeight":"700"}}},"color":{"bg":"#ffffff","text":"#000000","chart":{"bg":"transparent","text":"#7d7d7d"},"element":{"bg":"transparent","text":"#000000"}},"colorPresets":[],"localFonts":[],"font":{"common":{"fontFamily":"PT Sans Narrow","fontWeight":"400","fontStyle":"normal","fontSize":"16","textAlign":"initial"},"label":{"fontWeight":400,"fontSize":16},"legend":{"fontWeight":"400","fontSize":"16"}},"fontPresets":[],"fontFamilies":["PT Sans Narrow","Verdana","PT Serif","PT Sans"],"id":32,"title":"Asketic-new","usergroup":"archived","picture":"/i/templates/L/asketic.png","thumb":"/i/templates/S/asketic.png","order":25,"public":0,"width":550,"fonts":"PT+Sans+Narrow:400,700;PT+Sans:400,700;PT+Serif:400italic","colors":["#e84f2c","#e31307","#e37900","#e4ba51","#e3b786","#825846","#59392a","#564c30","#897d6e","#627c82","#93af8a","#a0ba5e","#63ba5e","#5ebab2","#6596b7","#b477ba","#473057","#bc416e","#c896af"],"logocolor":"000","logoUrl":"","showLogo":"","showEmbed":"","embedButtonText":"Share","top":50,"padding":20,"spacing":20,"shrinkMargin":20,"shrinkPadding":20,"spacingElementMin":null,"spacingElementMax":null,"css":".igc-sheets .igc-sheet .igc-sheet-ico,\n.igc-sheets .igc-sheet:hover .igc-sheet-ico {\n\tborder-color: #7d7d7d;\n}\n.igc-sheets .igc-sheet .igc-sheet-label,\n.igc-sheets .igc-sheet:hover .igc-sheet-label,\n.igc-sheets .igc-sheet.active .igc-sheet-label {\n\tcolor: #7d7d7d;\n}\n.igc-sheet .igc-sheet-ico,\n.igc-sheet.active .igc-sheet-ico {\n\tbackground: transparent;\n}\n.igc-sheets .igc-sheet.active .igc-sheet-ico::after,\n.igc-sheets .igc-sheet:hover .igc-sheet-ico::after {\n\theight: 14px;\n\twidth: 14px;\n\tleft: 2px;\n\ttop: 2px;\n\tbackground: #7d7d7d;\n}\n.igc-textual-figure {\n\tfont-size: 45px;\n}\n.igc-table-scroll {\n\tbackground: #eee;\n}\n.igc-table .igc-table-cell {\n\tfont-size: 16px;\n\tfont-family: PT Sans Narrow;\n\tfont-weight: 700;\n}\n.igc-table .igc-table-header {\n\tfont-size: 16px;\n\tfont-family: PT Sans Narrow;\n\tfont-weight: 700;\n}\n#madewith a,\n#madewith a:link,\n#madewith a:hover,\n#madewith a:visited,\n#madewith a:active {\n\tcolor: #000 !important;\n}\n.ig-copyright {\n\tcolor: #000;\n}\n.sep {\n\twidth: 100%;\n\tbackground-image: url(/i/asketic01/sturis-2.png), url(/i/asketic01/sturis-3.png);\n\tbackground-position: 0 0%, right 0%;\n\tbackground-repeat: no-repeat;\n\theight: 24px;\n}\n.sep .inner {\n\theight: 11px;\n\tborder-bottom: 1px dashed #464646;\n\tmargin-top: 10px;\n\tmargin-left: 20px;\n\tmargin-right: 20px;\n}\n.ig-container {\n\tbackground: url(/i/templates/32/background-light.png);\n}\n.ig-items {\n\tpadding-bottom: 20px;\n\tpadding-left: 20px;\n\tpadding-right: 20px;\n\tmargin: 20px;\n\tbackground: #fff;\n}\n.ig-items:before {\n\tcontent: '';\n\theight: 8px;\n\twidth: 100%;\n\tposition: absolute;\n\tleft: 0px;\n\ttop: 0px;\n\tbackground: #e8e5da url(/i/templates/32/curve-fff.svg) center top repeat-x;\n}\n.ig-items:after,\n.ig-container:after {\n\tcontent: '' !important;\n\tdisplay: block !important;\n\tposition: absolute;\n\tright: 21px;\n\ttop: 26px;\n\tbackground: #e8e5da;\n\twidth: 15px;\n\theight: 15px;\n\tborder-radius: 20px;\n}\n.ig-container:after {\n\tleft: 41px;\n\ttop: 47px;\n\tright: auto;\n}\n.headline {\n\tfont-family: PT Sans Narrow;\n\tfont-weight: 700;\n\tfont-size: 55px;\n\ttext-transform: uppercase;\n\tcolor: #000000;\n\tborder-bottom: 8px solid #000;\n\tline-height: 65px;\n}\n.chart-title {\n\tfont-family: PT Sans Narrow;\n\tfont-weight: 700;\n\tfont-size: 36px;\n\tcolor: #000000;\n\tborder-bottom: 4px solid #000;\n}\n.bodytext {\n\tfont-family: Verdana;\n\tfont-weight: 400;\n\tfont-size: 14px;\n\tcolor: #000000;\n}\n.quote {\n\tpadding: 20px;\n\tfont-family: PT Serif;\n\tfont-style: italic;\n\tfont-size: 30px;\n\tcolor: #ffffff;\n\ttext-align: center;\n\tbackground: #000;\n}\n.quotetitle {\n\tfont-size: 24px;\n}\n.quote:after {\n\tcontent: '';\n\tposition: absolute;\n\tleft: 0%;\n\ttop: 50%;\n\tmargin-top: -13px;\n\twidth: 13px;\n\theight: 27px;\n\tbackground: url(/i/templates/32/left-fff.svg);\n}\n.quote:before {\n\tcontent: '';\n\tbackground: url(/i/templates/32/right-fff.svg);\n\tposition: absolute;\n\ttop: 50%;\n\tmargin-top: -13px;\n\twidth: 13px;\n\theight: 27px;\n\tright: 0%;\n}\n.headline.active:hover {\n\tcolor: #e84f2c;\n}\n#madewith.active a:hover {\n\tcolor: #e84f2c !important;\n}\n.titlepopup1,\n.titlepopup2 {\n\tborder-color: #e84f2c;\n}\n.shrink .chart > .inner {\n\tpadding-left: 10px;\n\tpadding-right: 10px;\n}\n.ig-separator-line {\n\tbackground: rgba(125, 125, 125, 0.5);\n}\n.heatmap-legend {\n\tbackground: rgba(255, 255, 255, 0.7);\n}\n.heatmap-legend-item,\n.heatmap-label {\n\tcolor: #7d7d7d;\n\tfont-size: 11px;\n\tfont-family: PT Sans;\n}\n.igc-graph-pie-piece {\n\tstroke: rgba(255, 255, 255, 0.7);\n}\n.igc-tabs .igc-tab-active {\n background: #ffffff;\n }\n .igc-tabs .igc-tab .igc-tab-content,\n .igc-tabs .igc-tab.icon-down:after {\n font-family: PT Sans Narrow;\n color: #000000;\n font-weight: 400;\n }\n .igc-tabs .igc-tab,\n .igc-tab-switcher {\n color: #000000;\n } .igc-tabs.igc-tabs-dropdown .igc-tab-name {\n font-family: PT Sans Narrow;\n color: #000000;\n font-weight: 400;\n }","chartOptions":{"progress":{"backgroundInactive":{"fill":"#e1e1e1"}},"map":{"showLegend":false,"countryStroke":"#e1e1e1","countryFill":"#e1e1e1","canvasFill":"transparent"},"candle":{"colors":"e31307 63ba5e","blankfill":"url(//jifo.co/i/templates/29/chart-background.png)"},"waterfall":{"colors":"6596b7 5ebab2 e84f2c"},"common":{"backgroundStyle":{"stroke-opacity":0,"stroke-width":0},"_gridOptions":{"marginLineStyle":{"stroke-width":0,"stroke":"transparent"},"fontStyle":{"font-family":"PT Sans","font-size":11,"text-anchor":"start","fill":"#7d7d7d","cursor":"default"},"lineStyle":{"stroke-width":1,"stroke":"#7d7d7d","fill":"none","stroke-dasharray":"."}},"legendOptions":{"font-size":16,"font-family":"PT Sans Narrow","font-weight":300},"tooltipOptions":{"nameFontStyle":{"font-family":"PT Sans Narrow","text-anchor":"start","font-weight":700,"font-size":16,"fill":"#ffffff"},"valueFontStyle":{"font-family":"PT Sans Narrow","text-anchor":"start","font-size":16,"fill":"#fff"},"containerStyle":{"stroke":"#464646","fill":"#464646"}}}},"version":1,"archived":true,"tabs":null,"zeroPaddingEmbed":true,"created_at":"2016-04-22 07:54:07","updated_at":"2016-09-02 09:19:10"},"embed":"<script id=\"infogram_0_703723955/1336442407\" title=\"insight\" src=\"//e.infogr.am/js/embed.js?ur2\" type=\"text/javascript\"></script><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a target=\"_blank\" href=\"https://infogr.am/703723955/1336442407\" style=\"color:#989898!important;text-decoration:none!important;\">insight</a><br><a style=\"color:#989898!important;text-decoration:none!important;\" href=\"https://infogr.am\" target=\"_blank\">Create your own infographics</a></div>","embedAsync":"<div class=\"infogram-embed\" data-id=\"703723955/1336442407\" data-type=\"interactive\" data-title=\"insight\"></div><script>!function(e,t,n,s){var i=\"InfogramEmbeds\",o=e.getElementsByTagName(t),d=o[0],a=/^http:/.test(e.location)?\"http:\":\"https:\";if(/^\\/{2}/.test(s)&&(s=a+s),window[i]&&window[i].initialized)window[i].process&&window[i].process();else if(!e.getElementById(n)){var r=e.createElement(t);r.async=1,r.id=n,r.src=s,d.parentNode.insertBefore(r,d)}}(document,\"script\",\"infogram-async\",\"//e.infogr.am/js/dist/embed-loader-min.js\");</script><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a target=\"_blank\" href=\"https://infogr.am/703723955/1336442407\" style=\"color:#989898!important;text-decoration:none!important;\">insight</a><br><a style=\"color:#989898!important;text-decoration:none!important;\" href=\"https://infogr.am\" target=\"_blank\">Create your own infographics</a></div>","embedIframe":"<iframe src=\"//e.infogr.am/703723955/1336442407?src=embed\" title=\"insight\" width=\"674\" height=\"\" scrolling=\"no\" frameborder=\"0\" style=\"border:none;\"></iframe><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a target=\"_blank\" href=\"https://infogr.am/703723955/1336442407\" style=\"color:#989898!important;text-decoration:none!important;\">insight</a><br><a style=\"color:#989898!important;text-decoration:none!important;\" href=\"https://infogr.am\" target=\"_blank\">Create your own infographics</a></div>","embedImageAsync":"<div class=\"infogram-embed\" data-id=\"703723955/1336442407\" data-type=\"image\" data-title=\"insight\"></div><script>!function(e,t,n,s){var i=\"InfogramEmbeds\",o=e.getElementsByTagName(t),d=o[0],a=/^http:/.test(e.location)?\"http:\":\"https:\";if(/^\\/{2}/.test(s)&&(s=a+s),window[i]&&window[i].initialized)window[i].process&&window[i].process();else if(!e.getElementById(n)){var r=e.createElement(t);r.async=1,r.id=n,r.src=s,d.parentNode.insertBefore(r,d)}}(document,\"script\",\"infogram-async\",\"//e.infogr.am/js/dist/embed-loader-min.js\");</script><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a target=\"_blank\" href=\"https://infogr.am/703723955/1336442407\" style=\"color:#989898!important;text-decoration:none!important;\">insight</a><br><a style=\"color:#989898!important;text-decoration:none!important;\" href=\"https://infogr.am\" target=\"_blank\">Create your own infographics</a></div>","embedWordpress":"[infogram id=\"703723955/1336442407\" prefix=\"JoX\" format=\"interactive\" title=\"insight\"]","embedWordpressImage":"[infogram id=\"703723955/1336442407\" prefix=\"jwC\" format=\"image\" title=\"insight\"]"}