[B! MySQL] molinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

molin id:molin

MySQLã«é–¢ã™ã‚‹molinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼ŸÂ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚ˆãæ¯”è¼ƒã•ã‚Œã‚‹PostgreSQLã¨MySQLã€‚ã©ã‚“ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼ŸÂ ãã‚Œãžã‚Œã®å°‚é–€å®¶ã«ã‚ˆã‚‹å¯¾è«‡ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨å¿…ãšç›´é¢ã™ã‚‹æ‚©ã¿ã€‚ãã‚Œã¯ã€ã€Œã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDBï¼‰ã‚’é¸ã¶ã®ãŒæœ€å–„ãªã®ã‹ï¼Ÿã€ã§ã™ã€‚ RDBã”ã¨ã«é•·æ‰€ã¨çŸæ‰€ã¯ç•°ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚è‡ªç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«ãƒžãƒƒãƒã—ãªã„RDBã‚’é¸ã‚“ã§ã—ã¾ã†ã¨ã€ãã‚ŒãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šé–‹ç™ºãƒ»é‹ç”¨ã«ãƒˆãƒ©ãƒ–ãƒ«ãŒç”Ÿã˜ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‹ã§ã‚‚ã‚ˆãæ¯”è¼ƒæ¤œè¨Žã•ã‚Œã‚‹ã®ãŒã€PostgreSQLã¨MySQLã€‚ã¨ã‚‚ã«ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„æ€§èƒ½ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ã
molin 2017/09/06
postgresql

MySQL

RDB
ãƒªãƒ³ã‚¯
éº»è±†å½±è§†æ–‡åŒ–ä¼ åª’appä¸‹è½½tâ…´ å®˜ç½‘è¿›å…¥_éº»è±†å½±è§†æ–‡åŒ–ä¼ åª’å®˜ç½‘è¿›å…¥_éº»è±†å½±è§†ä¸‹è½½_éº»è±†å½±é™¢
éº»è±†å½±è§†æ–‡åŒ–ä¼ åª’appä¸‹è½½tâ…´ å®˜ç½‘è¿›å…¥,éº»è±†å½±è§†æ–‡åŒ–ä¼ åª’å®˜ç½‘è¿›å…¥,éº»è±†å½±è§†ä¸‹è½½,éº»è±†å½±é™¢æ˜¯ä¸€æ¬¾ç”µå½±èµ„è®¯æ‰‹æœºAPPï¼Œæä¾›iosè‹¹æžœä¸‹è½½/å®‰å“ä¸‹è½½ã€‚ç‰‡æºä¸°å¯Œï¼Œé«˜æ½®è¿èµ·ï¼
molin 2016/11/20
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚¦ãƒã®ç›£è¦–ã‚·ã‚¹ãƒ†ãƒ ã®å¤‰é·ã«ã¤ã„ã¦æ›¸ã | Ore no homepage
ä»Šã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§ã¯ä¼‘æš‡ä¸ã§ãƒ•ãƒ©ãƒ³ã‚¯ãƒ•ãƒ«ãƒˆçµŒç”±ãƒ™ãƒ«ãƒªãƒ³è¡Œãã®é£›è¡Œæ©Ÿã®ä¸ã«ã„ã‚‹ã€‚æš‡ã™ãŽã‚‹ã€‚ã†ã¡ã®ä¼šç¤¾ã€ã£ã¦ã‹ãƒˆãƒ¬ã‚¿ã®ç›£è¦–ç³»ã®å¤‰é·ã«ã¤ã„ã¦æ›¸ãã€‚ã§ã‚‚çµµã‚’æãæ°—åŠ›ã¯ãªã„ã®ã§æ–‡å—ã®ã¿ã€‚ ä»Šã®çŠ¶æ³ã§ã™ ãƒ«ãƒ•ãƒˆãƒãƒ³ã‚¶ã¯æ—¥æœ¬ç·šã¯è»½é£Ÿã®æ™‚é–“ã« ONIGIRI ãŒå‡ºã¦ãã‚‹ã®ã§çµæ§‹å¥½ããªèˆªç©ºä¼šç¤¾ã§ã™ã€‚ä¼‘æš‡ä¸ãªã®ã«ãƒ©ãƒƒãƒ—ãƒˆãƒƒãƒ—æŒã£ã¦ãã®ã¯ãƒ—ãƒç¤¾ç•œã®è¨¼ã€‚ã¾ã‚ä»Šä¼šç¤¾ã§è£å´è¦‹ã¦ã‚‹ã®ãŒä¿ºã—ã‹ã„ãªã„ã®ã§ã€ã‚¨ã‚¨â€¦ã€‚ã—ã‹ã—ä¸–ã®ä¸ãƒ›ãƒ³ãƒˆä¾¿åˆ©ã«ä¾¿åˆ©ã«ãªã£ã¦ã‚‹ã€‚ç©ºã®ä¸Šã§ã‚‚ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆãŒã§ãã‚‹ã€‚è¨€ã„æ–¹ã‚’å¤‰ãˆã‚‹ã¨ç©ºã®ä¸Šã§ã‚‚ã‚¢ãƒ©ãƒ¼ãƒˆãŒå±Šãã£ã¦ã„ã†â€¦ã€‚é£›è¡Œæ©Ÿã®ä¸ã¯æš‡ã™ãŽã‚‹ã‘ã©ã•ã™ãŒã«ä»•äº‹ã¯ã—ãŸããªã„ãã€‚ã¨ã„ã†ã‹ã“ã®æ—…è¡Œä¸ã¯ä»•äº‹ã‚’å¿˜ã‚ŒãŸã„ã€‚ 2014/10ä»¥å‰ ä¿ºãŒå…¥ç¤¾ã™ã‚‹å‰ã€‚ ã‚³ã‚¢æ©Ÿèƒ½ï¼šEngineyard(OS: gentoo)ã€‚ ãƒ—ãƒã‚»ã‚¹ç•°å¸¸ç›£è¦–ã€é–¾å€¤ç›£è¦–ãªã©ï¼šmonit ã‚¨ãƒ©ãƒ¼ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã€SQLï¼šNewReli
molin 2015/10/18
MySQL

cloud

SSH

ã‚¤ãƒ³ãƒ•ãƒ©

storage
ãƒªãƒ³ã‚¯
æ›¸ç±å‡ºç‰ˆã®ãŠçŸ¥ã‚‰ã›ï¼šç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQL
æ¥ã‚‹2æœˆ27æ—¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–°æ›¸ç±ã‚’ç™ºå£²ã•ã›ã¦é ‚ãã“ã¨ã«ãªã£ãŸã€‚ã‚¿ã‚¤ãƒˆãƒ«ã¯ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQLã€ã¨ãªã£ã¦ã„ã‚‹ã€‚å˜ã«ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨æ›¸ã„ã¦ã‚ã‚‹ãŒã€RDBãŒãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒžã®æ›¸ç±ã§ã‚ã‚‹ã€‚ å¤šãã®äººãŒæœªã ã«RDBã‚’ä½¿ã„ã“ãªã›ã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ã€‚RDBã®ä½¿ã„æ–¹ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ã«ã¯ä½•ãŒå¿…è¦ãªã®ã‹ã€‚ãã‚ŒãŒã“ã“æ•°å¹´ç§ãŒè¿½ã£ã¦ããŸãƒ†ãƒ¼ãƒžã§ã‚ã‚Šã€ã“ã®æ›¸ç±ã‚’å‡ºã™ã“ã¨ã«ãªã£ãŸå‹•æ©Ÿã§ã‚ã‚‹ã€‚ ã‚ã¾ã‚Šã«ã‚‚é…·ã„DBè¨è¨ˆã€ã‚ã¾ã‚Šã«ã‚‚ã‚¹ãƒ‘ã‚²ãƒ†ã‚£ãªã‚¯ã‚¨ãƒªã€ã‚ã¾ã‚Šã«ã‚‚å¸Œè–„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¸ã®ç†è§£ã€‚ãã†ã„ã£ãŸå•é¡Œã¯ã©ã“ã‹ã‚‰ç”Ÿã¿å‡ºã•ã‚Œã‚‹ã®ã‹ã€‚ãã®ã²ã¨ã¤ã®çµè«–ã¨ã—ã¦ãŸã©ã‚Šç€ã„ãŸã®ãŒã€ã€Œãã‚‚ãã‚‚RDBã®ä½¿ã„æ–¹ãŒã‚ã¾ã‚Šç†è§£ã•ã‚Œã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ã€ã¨ã„ã†ã“ã¨ã ã£ãŸã€‚åè‘—ã€SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã¯ã€Œã‚„ã£ã¦ã¯ã„ã‘ãªã„ã‚±ãƒ¼ã‚¹ã€ã«ã¤ã„ã¦å¦ã¶ã“ã¨ãŒã§ãã‚‹ãŒã€ãã®åå¯¾ã®ãƒ†ãƒ¼ãƒžã€ã¤ã¾ã‚Šæœ¬æ¥ã©ã®
molin 2015/02/03
database

RDB

mysql

sql

design

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
èª°ã‚‚æ•™ãˆã¦ãã‚Œãªã‹ã£ãŸMySQLã®éšœå®³è§£æžæ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
molin 2014/07/13
MySQL

ã‚·ã‚¹ãƒ†ãƒ

ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨

ã‚µãƒ¼ãƒç®¡ç†

éšœå®³

mysql ï¾„ï¾—ï¾Œï¾žï¾™
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
PostgreSQLã®ãƒãƒ¼ãƒ«ç®¡ç†ã¨ãã®æ³¨æ„ç‚¹ï¼ˆOpen Source Conference 2022 Online/Osaka ç™ºè¡¨è³‡æ–™ï¼‰NTT DATA Techno logy & Innovation
molin 2013/11/16
db

mysql

postgresql

database

DBA

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
molin 2013/09/20
MySQL

mariadb

database

db

sql
ãƒªãƒ³ã‚¯
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚·ã‚¹ãƒ†ãƒ ç·¨ï¼‰ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚·ã‚¹ãƒ†ãƒ ç·¨ï¼‰ ã“ã‚“ã«ã¡ã¯ nob ã§ã™ã€‚ å‰ç·¨ã€€ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ã€€ã®è¨˜äº‹ã‹ã‚‰ï¼‘å¹´åŠãŒçµŒéŽã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ã¡ã‚‡ã£ã¨é•·ã„ãŠä¼‘ã¿ã§ã—ãŸãŒã€ãã®é–“ã«è“„ãˆãŸ MySQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®å®Ÿæˆ¦çµŒé¨“ã‚’ï¼ˆã‚·ã‚¹ãƒ†ãƒ ç·¨ï¼‰ã¨ã—ã¦ãŠå±Šã‘ã„ãŸã—ã¾ã™ï¼ ä»Šå›žã®ï¼ˆã‚·ã‚¹ãƒ†ãƒ ç·¨ï¼‰ã§ç´¹ä»‹ã™ã‚‹ãƒ„ãƒœã¯ 4 ã¤ã§ã™ã€‚ï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ã®ãƒ„ãƒœã«åŠ ãˆã¦ã€ã“ã®4ã¤ã«æ³¨ç›®ã—ã¦é ‚ã‘ã‚Œã° MySQL ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã‚‚ãƒãƒƒãƒãƒªã§ã™ã€‚ ï¼ˆãƒ„ãƒœï¼‘ï¼‰Load Average < (1 + (cpuæ•°-1)/3) ï¼ˆãƒ„ãƒœï¼’ï¼‰Checkpoint Age ãŒæ°´å¹³ç·šã«ãªã£ãŸã‚‰è¦æ³¨æ„ ï¼ˆãƒ„ãƒœï¼“ï¼‰MyISAM ã¯ç„¡ã„ã‚ˆãç›£è¦– ï¼ˆãƒ„ãƒœï¼”ï¼‰ä¸‡èƒ½é¸æ‰‹ã‚¹ãƒãƒ¼ãƒã‚° ãªãŠå‰ç·¨ã¨åŒæ§˜ã“ã®è¨˜äº‹ã§ã¯ç›£è¦–ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦Â Cacti ã¨ Percona MySQL
molin 2013/08/21
MySQL

ç›£è¦–

Cacti

disk

monitoring

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
ã€Œå†™çµŒã€ã‹ã‚‰å§‹ã‚ã‚‹Chefã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã®ä½œæˆ
æ–Žè—¤ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ Chef ã®è©±é¡ŒãŒã‚¢ãƒ„ããªã£ã¦ã„ã‚‹ä»Šæ—¥ã“ã®é ƒã€ã¿ãªã•ã¾ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ï¼ŸChefã®è§£èª¬æœ¬ã‚‚å‡ºã¤ã¤ã‚ã‚‹ä»Šæ—¥ã“ã®é ƒã§ã¯ã‚ã‚Šã¾ã™ãŒã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãã®ã‚‚ã®ã«æ…£ã‚Œãªã„ã†ã¡ã¯ãã‚Œã•ãˆèªã‚€ã®ã‚‚ã¡ã‚‡ã£ã¨å¤§å¤‰ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ãã“ã§ä»Šå›žã¯ã€ Chef ã®ãƒ¬ã‚·ãƒ”ï¼‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç”¨ã„ã¦ã€MySQLã®è¨å®šã®è‡ªå‹•åŒ–ã‚’è©¦ã—ã¾ã™ã€‚ã„ã‚ã‚†ã‚‹ã€Œå†™çµŒã€ã‹ã‚‰å§‹ã‚ã¦ã¿ã¦ã€å°‘ã—ãšã¤ã€Œæ‰‹å‹•ã€ã‹ã‚‰ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’é€šã˜ãŸã€Œè‡ªå‹•åŒ–ã€ã«ãƒãƒ£ãƒ¬ãƒ³ã‚¸ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ â€»Chef 11.04.0, knife-solo 0.2.0, Ruby 1.9.3p327, CentOS 6.3 ã§æ¤œè¨¼ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®ãŠé¡Œ MySQLã‚µãƒ¼ãƒã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã¾ã™ã€‚ITã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ§‹ç¯‰ãƒ»é‹ç”¨ã—ã¦ã„ã‚‹æ–¹ãªã‚‰ã”å˜çŸ¥ã‹ã¨æ€ã„ã¾ã™ãŒã€MySQLã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã ã‘ã§ãªãmy.cnfã®è¨å®šã¾ã§ãŒä½œæ¥ã§ã™ã€‚ãã®éš›ã«innodb_buffer_
molin 2013/03/28
MySQL

linux

chef
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
2. è‡ªå·±ç´¹ä»‹ ï® MySQL/Linuxå‘¨ã‚Šã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆ ï¬ 2006å¹´9æœˆã‹ã‚‰2010å¹´8æœˆã¾ã§MySQL æœ¬å®¶(MySQL/Sun/Oracle)ã§ APAC/USåœã®MySQL ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«å¾“äº‹ ï¬ ä¸»ãªè‘—æ›¸ã«ã€Œç¾å ´ã§ä½¿ãˆã‚‹MySQLã€ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/ é‹ç”¨å…¥é–€ã€ã€ŒJavaãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ã€ ï® DeNAã§ã®ä¸»ãªå½¹å‰² ï¬ å®‰å®šåŒ–/ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹/é‹ç”¨å‘¨ã‚Šã®ä¸é•·æœŸçš„ãªæ”¹å–„æ´»å‹• ï¬ L3ã‚µãƒãƒ¼ãƒˆ/é‹ç”¨/ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° â€“ é›£åº¦ã®é«˜ã„MySQLå‘¨ã‚Šã®å•é¡Œã®æ ¹æœ¬åŽŸå› ã®ç‰¹å®šã¨è§£æ±º ï¬ å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ”¯æ´ ï¬ ç¤¾å†…å‹‰å¼·ä¼š/ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚° â€“ MySQLã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç¤¾å†…ã§å…±æœ‰ã—ã€ æŠ€è¡“ã‚¹ã‚ãƒ«ã‚’åº•ä¸Šã’ã™ã‚‹ ï¬ æŠ€è¡“ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚° â€“ å›½å†…å¤–ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã€æŠ€è¡“é›‘èªŒç‰
molin 2011/01/16
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

DB

MySQL
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚¤ãƒ³ãƒ•ãƒ©ã®ç›£è¦–ã‚·ã‚¹ãƒ†ãƒ | GREE Engineers' Blog
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¤ãƒ³ãƒ•ãƒ©ãƒãƒ¼ãƒ ã® ebisawa ã§ã™ã€‚ ä»Šå›žã¯ã‚°ãƒªãƒ¼ã®ã‚¤ãƒ³ãƒ•ãƒ©ã«ãŠã‘ã‚‹å„ç¨®æ©Ÿå™¨ã®ç›£è¦–ãŒã©ã®ã‚ˆã†ã«è¡Œã‚ã‚Œã¦ã„ã‚‹ã®ã‹ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ä¸€èˆ¬ã«ã‚µãƒ¼ãƒã®ç›£è¦–ã¨ã„ã†ã¨ã€ã‚·ã‚¹ãƒ†ãƒ ãƒ€ã‚¦ãƒ³ã‚’æ¤œå‡ºã™ã‚‹ãŸã‚ã®æ»æ´»ç›£è¦–ã‚’æ„å‘³ã™ã‚‹å ´åˆã¨ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ç‰ã®ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã®ã“ã¨ã‚’æ„å‘³ã™ã‚‹å ´åˆã¨ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã®ç›£è¦–ã¯ç‰¹ã«å¾Œè€…ã«ã¤ã„ã¦ã®ãŠè©±ã§ã™ã€‚å¤§è¦æ¨¡ãªã‚¤ãƒ³ãƒ•ãƒ©ã®ç›£è¦–ã«ã¯ã€ã‚„ã¯ã‚Šç‰¹æœ‰ã®èª²é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã©ã‚“ãªãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã‹ ã‚°ãƒªãƒ¼ã§ã¯ã‚µãƒ¼ãƒã®å„ç¨®ãƒªã‚½ãƒ¼ã‚¹ä½¿ç”¨çŠ¶æ³ã‚’ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã—ã¦ã‚°ãƒ©ãƒ•åŒ–ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€Cacti ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚Cacti ã¯ã€å¤§å¤‰æœ‰åãªãƒ„ãƒ¼ãƒ«ãªã®ã§çš†æ§˜ã”å˜çŸ¥ã‹ã¨æ€ã„ã¾ã™ãŒã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã® RRDtool ã§ä½œæˆã—ãŸã‚°ãƒ©ãƒ•ã‚’é–²è¦§ã™ã‚‹ãŸã‚ã®ä½¿ã„ã‚„ã™ã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ http://www.cacti.net/ ãƒ„ãƒ¼ãƒ«ã®ä½¿
molin 2010/10/09
ã‚¤ãƒ³ãƒ•ãƒ©

ç›£è¦–

MySQL

gree

network

ãƒ„ãƒ¼ãƒ«

ã‚°ãƒ©ãƒ•

Cacti
ãƒªãƒ³ã‚¯
æœˆé–“57å„„PVã€300å°ã®ã‚µãƒ¼ãƒã‚’é‹ç”¨ã™ã‚‹ãƒŸãƒ„ãƒãƒãƒ¯ãƒ¼ã‚¯ã‚¹ãŒç·¨ã¿å‡ºã—ãŸã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“
ãƒŸãƒ„ãƒãƒãƒ¯ãƒ¼ã‚¯ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã€ã€Œæœˆé–“57å„„PVã€ã¨ã„ã†å·¨å¤§ãªãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’ã•ã°ããŸã‚ã€ã•ã¾ã–ã¾ãªæŠ€è¡“ã‚’é§†ä½¿ã—ã¦ã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ§‹ç¯‰ã—ã¦ã„ã‚‹ã€‚ä¸»ã¨å‰¯ã®2æœ¬ç«‹ã¦ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é‹ç”¨ã—ã€300å°ã®ã‚µãƒ¼ãƒã‚’ä½¿ã„ãªãŒã‚‰ã€Œè² è·ã®é™ç•Œã€ã«æŒ‘ã‚€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã€æŠ€è¡“ãƒŽã‚¦ãƒã‚¦ã‚’èžãã€‚ ãƒŸãƒ„ãƒãƒãƒ¯ãƒ¼ã‚¯ã‚¹ãŒé‹å–¶ã™ã‚‹ã‚±ãƒ¼ã‚¿ã‚¤ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€ŒDECOLOGã€ã¯ã€ç•°è‰²ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€‚10ä»£å¾ŒåŠã‹ã‚‰20ä»£å‰åŠã®å¥³æ€§ã«æœ€ã‚‚äººæ°—ã®ã‚ã‚‹ã‚±ãƒ¼ã‚¿ã‚¤ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã§ã€ã€Œãƒ‡ã‚³ãƒ¡ãƒ¼ãƒ«ã€ãªã©ã‚’åˆ©ç”¨ã—ã¦ã€ã‹ã‚ã„ãã‚«ãƒ©ãƒ•ãƒ«ãªãƒ–ãƒã‚°ã‚’ä½œæˆã§ãã‚‹ã€‚åºƒå‘ŠåŸºæº–ã‚’åŽ³ã—ãã™ã‚‹ã“ã¨ã§å¥³æ€§ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã‚‚ä¸å®‰ãªãä½¿ã£ã¦ã‚‚ã‚‰ãˆã‚‹ã‚ˆã†ãªå®‰å¿ƒæ„Ÿã‚’ä½œã‚Šå‡ºã—ã€å£ã‚³ãƒŸã ã‘ã§ã˜ã‚ã˜ã‚ã¨ã‚¢ã‚¯ã‚»ã‚¹æ•°ã‚’ä¼¸ã°ã—ã¦ããŸã€‚ çµæžœã€2010å¹´7æœˆå®Ÿç¸¾ã§æœˆé–“57å„„PVï¼ˆãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼‰è¶…ã€æƒ³å®š800ä¸‡UUï¼ˆãƒ¦ãƒ‹ãƒ¼ã‚¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼‰ã€ä¼šå“¡ç™»éŒ²è€…æ•°180ä¸‡ä»¶ã¨ã€ã‚±ãƒ¼ã‚¿ã‚¤ãƒ–ãƒã‚°ã‚µã‚¤ãƒˆã§ã¯å›½å†…æœ€å¤§ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—
molin 2010/09/04
ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯

MySQL

server

è² è·åˆ†æ•£

é‹ç”¨

ã‚µãƒ¼ãƒ“ã‚¹

ã‚¤ãƒ³ãƒ•ãƒ©

ã‚µãƒ¼ãƒ

PHP
ãƒªãƒ³ã‚¯
Amazon.co.jpï¼š ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¢ãƒƒãƒ—ã®æ•™ç§‘æ›¸ åŸºæœ¬åŽŸç†ç·¨: ã‚¨ãƒ³ã‚³ã‚¢ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°: æœ¬
molin 2009/08/07
db

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

Oracle

MySQL
ãƒªãƒ³ã‚¯
1