Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
E34 : [JPOUG Presents] Oracle Database ã®éš ã•ã‚Œã¦ã„る様々ãªè¬Žã‚’解ãセッション「ãªãƒ¼ã‚“ã§ã ？ã€å†ã³ @ db tec... The document contains details of SQL execution plans and statistics for queries run against tables A and B. It includes the execution plan details showing the operations performed at each step including table access methods and indexes used. It also shows statistics on the performance of the queries such as elapsed ti
MySQLã§Visual Explain
MySQL Workbenchã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹6.0ã®ãƒ™ãƒ¼ã‚¿ç‰ˆãŒå…¬é–‹ã•ã‚ŒãŸã€‚例ã«ã‚ˆã£ã¦MySQLã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€æ–°æ©Ÿèƒ½ãŒæ°—ã«ãªã‚‹äººã¯ã‚²ãƒƒãƒˆã—ã¦è©¦ã—ã¦ã¿ã¦é ‚ããŸã„。見ãŸç›®ãŒè‹¥å¹²ä»Šæµè¡Œã‚Šã®ãƒ•ãƒ©ãƒƒãƒˆãƒ‡ã‚¶ã‚¤ãƒ³ã£ã½ããªã£ã¦ã‚·ãƒ£ãƒ¬ã‚ªãƒ„（笑）ãªæ„Ÿã˜ã«ä»•ä¸ŠãŒã£ã¦ã‚‹ã€‚ ベータ版ãŒå…¬é–‹ã•ã‚ŒãŸã®ã‚’記念ã—ã¦ã€Workbenchã«æ載ã•ã‚Œã¦ã„るナイスãªæ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„。ãã†ã€Visual Explainã 。Visual Explainã¨ã¯èªã‚“ã§å—ã®ã”ã¨ãã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’視覚的ã«è¡¨ç¾ã—ãŸã‚‚ã®ã 。SQLãŒè¤‡é›‘ã«ãªã‚‹ã¨ã€ãã®å®Ÿè¡Œè¨ˆç”»ã¯ç†è§£ã—è¾›ã„ã‚‚ã®ã¨ãªã‚‹ã€‚ 今日ã¯Visual Explain基本的ãªä½¿ã„æ–¹ã¨ã€ãã‚ŒãŒã©ã®ã‚ˆã†ã«è¦‹ãˆã‚‹ã‹ã‚’紹介ã—よã†ã¨æ€ã†ã€‚ Visual Explainを使用ã™ã‚‹ã«ã¯ã€å¯¾è±¡ã®MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒ5.6以上ã§ã‚ã‚Šã€ãªãŠã‹ã¤Workbenchã®ãƒãƒ¼ã‚¸ãƒ§
Pinterest ã®ã‚¹ã‚±ãƒ¼ãƒ«
V 先生ã‹ã‚‰æ•™ãˆã¦é ‚ã„ãŸã®ã§ã€Instagram åŒæ§˜ Django/AWS 構æˆã® Pinterest ã®ã‚¹ã‚±ãƒ¼ãƒ«ã‚’メモ。Pinterest ã¯ã„ã¤ã‚‚ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆåãŒåˆã‚ã¦ å…ˆå– ã•ã‚ŒãŸã‚µãƒ¼ãƒ“スãªã®ã§ã€ä»Šå¾Œä½¿ã‚ãªã„ã¨æ€ã„ã¾ã™ã€‚ 本題ã«å…¥ã‚‹å‰ã«ã€Python ã«ã¯ The Zen of Python (日本語) ã¨ã„ã†æ€æƒ³ãŒã‚ã‚Šã¾ã™ã€‚ç§ã¯ã“ã®æ€æƒ³ã‚’ Python ã§ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã ã‘ã§ãªãã€ã‚¤ãƒ³ãƒ•ãƒ©ã®æ§‹ç¯‰ã®éš›ã‚‚æ„è˜ã™ã‚‹ã‚ˆã†ã«å¿ƒãŒã‘ã¦ã„ã¾ã™ã€‚"Simple is better than complex" ã§ã™ã€‚Instagram ã‚„ Pinterest ã®ã‚¹ã‚±ãƒ¼ãƒ«ã‚’見ã¦ã€ã“ã®æ€æƒ³ãŒã‚‚ã£ã¨å¥½ãã«ãªã‚Šã¾ã—ãŸã€‚ Instagram ã¯ã‚ˆã‚Šã‚·ãƒ³ãƒ—ルãªã‚¤ãƒ³ãƒ•ãƒ©ã«æ›´æ”¹ã—ã¦ã„ãã“ã¨ã§ã€ãŸã スケールã™ã‚‹ã ã‘ã§ãªãã€é‹ç”¨ã‚„変更ã®ã‚³ã‚¹ãƒˆã‚‚最å°é™ã«ãªã‚‹ã‚ˆã†ã«æœ€é©åŒ–ã—ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚çµæžœçš„ã« Android ã‚¢
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹
{{#tags}}- {{label}}
{{/tags}}