[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] shayashã®ãƒ

shayash id:shayash

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹shayashã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (21)

${{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}}

Apacheãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ï¼ˆApache2.4, preforkï¼‰ - Qiita
ã¯ã˜ã‚ã« Apacheã«ã‚ˆã‚‹Webã‚µãƒ¼ãƒãƒ¼ã‚’å…¬é–‹ã™ã‚‹éš›ã«ã€å…¬é–‹ç¯„å›²ã‚„è¦æ¨¡ã«ã‚ˆã£ã¦Apacheã®è¨å®šã‚‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã¯ã€preforkã§ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã®ä¸€ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ preforkã¨ã¯ï¼Ÿï¼Ÿ Apacheã®ãƒ—ãƒã‚»ã‚¹ã®æŒ™å‹•ã®æ–¹å¼ã®ä¸€ã¤ ã‚¹ãƒ¬ãƒƒãƒ‰ã‚’ä½¿ã‚ãšã«ã€forkï¼ˆè‡ªåˆ†è‡ªèº«ã®ã‚³ãƒ”ãƒ¼ï¼‰ã‚’è¡Œã†ï¼prefork ã‚ã‚‰ã‹ã˜ã‚ï¼ˆpreï¼‰Apacheã®åãƒ—ãƒã‚»ã‚¹ã‚’ã‚³ãƒ”ãƒ¼ï¼ˆforkï¼‰ã—ã¦ãŠãã€forkã®å¾…ã¡æ™‚é–“ã‚’æ¸›ã‚‰ã™ã“ã¨ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸Šã’ã¦ã„ã‚‹ forkã•ã‚ŒãŸåãƒ—ãƒã‚»ã‚¹ä¸€ã¤ä¸€ã¤ãŒé€šä¿¡ã‚’å—ã‘æŒã¤ ä»–ã®åãƒ—ãƒã‚»ã‚¹ãŒãŠã‹ã—ãªæŒ™å‹•ã‚’ã—ã¦ã‚‚ã€ä»–ã®åãƒ—ãƒã‚»ã‚¹ã«ã¯å½±éŸ¿ãŒãªã„ãŸã‚ã€å®‰å®šã—ãŸé€šä¿¡ãŒå¯èƒ½ preforkã§å¤šæ•°ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’è£ãã«ã¯ã€å¤šæ•°ã®ãƒ¡ãƒ¢ãƒªãƒ»CPUã‚’ä½¿ç”¨ã™ã‚‹ å‰æ CentOS7.2 Apache2.4 ã‚µã‚¤ã‚¸ãƒ³ã‚°æ¸ˆã¿ï¼ˆæƒ³å®šã•ã‚Œã‚‹ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã€ä½¿ç”¨ãƒ¡ãƒ¢ãƒªã€CPUã¯è¨ˆç®—æ¸ˆ
shayash 2018/12/03
apache2.4

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®innodb_log_file_sizeã‚’å¤‰æ›´ã—ãŸã‚‰MySQLãŒèµ·å‹•ã—ãªããªã£ãŸ - /dev/null
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªãŠè©±ã€‚ /etc/my.cnfã« innodb_log_file_size= ã¨ã„ã†ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒã‚ã‚Šã¾ã™ã€‚ ãƒã‚°ã®ã‚µã‚¤ã‚ºãªã‚“ã‚„ã‚ï¼Ÿåˆ¥ã«å¤§ãããªãã¦ã‚‚ã„ã„ã‚“ã˜ã‚ƒãï¼Ÿï¼Ÿï¼Ÿï¼Ÿã¨æ€ã„ã¾ã—ãŸãŒã€InnoDBã®ãƒã‚°ã¯ãŸã ã®ãƒã‚°ã«ã‚ã‚‰ãšã€‚ InnoDBã®ãƒã‚°ã¯æ‰€è¬‚WALãƒã‚°ã§ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ã®insert æ“ä½œ â†“ Innodb_logã«ä¸€æ—¦æ›¸ãè¾¼ã¿ â†“ ã‚³ãƒŸãƒƒãƒˆ â†“ è½ã¡ç€ã„ãŸã‚‰DBã«æ›¸ãè¾¼ã¿ ã¨ã„ã†æµã‚Œã€‚ ãªã®ã§InnoDBãƒã‚°ã‚’å®‰æ˜“ã«æ¶ˆã™ã¨ã€æ›¸ãè¾¼ã‚€äºˆå®šã®ãƒ‡ãƒ¼ã‚¿ãŒãªããªã‚Šã¾ã™ã—ã€ã“ã®ã‚µã‚¤ã‚ºãŒå°ã•ã„ã¨ä¸€æ™‚ã‚¹ãƒšãƒ¼ã‚¹ãŒå°ã•ã„ã®ã¨åŒã˜ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªããªã‚Šã¾ã™ã€‚ ã¨ã„ã†ã‚ã‘ã§å¤§ãã‚ã«ã«ã—ã‚ˆã†ã€ã¨ã„ã†ã®ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€‚ï¼ˆå¤§ãããªã‚Šã™ãŽã¦ã‚‚ãƒªã‚«ãƒãƒªã«æ™‚é–“ã‹ã‹ã‚‹ã‚“ã§ã‚¢ãƒ¬ãªã®ã§å…¼ãåˆã„ï¼‰ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯5MBã½ã£ã¡ãªã®ã§128MBã¨ã‹ã«ã—ã‚ˆã†ã¨è€ƒãˆã¾ã™ã€‚ ãã“ã§ innodb_log_fi
shayash 2018/11/13
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã¨ã‹ã‚‚ã€‘ - Qiita
å‚ç…§ãƒ¡ã‚¤ãƒ³ã®WordPressã•ã‚“ã§RDS(for MySQL)ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ãŸã€‚ ä»¥å‰ã«å‚ç…§ãƒ¡ã‚¤ãƒ³ã®Wordpressã®å ´åˆã¯MySQLã®ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã¨å¹¸ã›ã«ãªã‚‹ã‹ã‚‚ã—ã‚Œãªã„ ã§ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’å°Žå…¥ã—ãŸã®ã§ã™ãŒã€ä»Šå›žã¯ã©ã®ç¨‹åº¦ã®å‰²åˆã§ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’å…¥ã‚Œã‚‹ã¨ ã‚ˆã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ãªã‚‹ã®ã‹ï¼Ÿã‚’èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ç’°å¢ƒ wordpress 4.5.3 RDS for MySQL 5.6.29 å‚è€ƒæƒ…å ± MySQL ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ ã‚µãƒ¼ãƒãƒ¼ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°#statvar_Qcache_free_blocks MySQL ã‚¯ã‚¨ãƒªãƒ¼ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ã‚’SQLã§æ±‚ã‚ã‚‹æ–¹æ³• ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã¯ãªã‚“ãžã‚„??? MySQLãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚ˆã‚Š ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«é€ä¿¡ã•ã‚ŒãŸå¯¾å¿œã™ã‚‹çµæžœã¨ã¨ã‚‚ã«ã€SELECT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®ãƒ†ã‚ã‚¹ãƒˆãŒæ ¼ç´ã•ã‚Œã¾ã™ã€‚ã‚ã¨ã§åŒ
shayash 2018/11/13
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° -my.cnfã®è¦‹ç›´ã—- - Qiita
â€»RDSã¯ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ è² è·ã‚’è¦‹ã¦ã¿ã‚‹ DBã‚µãƒ¼ãƒãƒ¼ã®è² è·çŠ¶æ³ã‚’è¦‹ã¦ã¿ã¾ã™ã€‚ å½“æ™‚ã®ç›£è¦–ãƒ„ãƒ¼ãƒ«ã®ç”»åƒãŒãªã„ã®ã§ã™ãŒã€ä»¥ä¸‹ã®çŠ¶æ³ã§ã—ãŸã€‚ LA(Load Average)ãŒçªãæŠœã‘ã¦ã„ã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã¯ã€Œå¸¸è˜çš„ã«è€ƒãˆã¦ã€ãã‚Œã»ã©ã§ã‚‚ãªã„ ãƒ¡ãƒ¢ãƒªã®ä½¿ç”¨é‡ã«ã‚ã¾ã‚Šå¤‰åŒ–ãŒãªã„ swapã¯ã—ã¦ã„ãªã„ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å®¹é‡ã‚’çµæ§‹é£Ÿã£ã¦ã„ã‚‹ WEBã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰è¦‹ã‚Œã°ã€å‡¦ç†å¾…ã¡ã®ã¾ã¾ãƒ—ãƒã‚»ã‚¹ãŒå‡¦ç†ã•ã‚Œã¦ã„ãªã„å…¸åž‹çš„ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã ã£ãŸã¨æ€ã„ã¾ã™ã€‚ DBã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦ã¯ã€LAã«å¯¾ã—ã€ãƒ¡ãƒ¢ãƒªã®ä½¿ç”¨é‡ãŒã‚ã£ã¦ã„ãªã„ã‚ˆã†ã«æ€ã‚ã‚Œã¾ã—ãŸã€‚ ä»®èª¬ ä¸Šè¨˜ã®çŠ¶æ…‹ã‹ã‚‰ã€ä»®èª¬ã‚’ç«‹ã¦ã¾ã™ã€‚ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª ãŒé »ç™ºã—ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ ãƒ¡ãƒ¢ãƒª ãŒæ£ã—ãå‰²ã‚Šå½“ã¦ã‚‰ã‚Œã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ å„ç¨®ãƒã‚° ã®è¨å®šãŒé©åˆ‡ã§ã¯ãªã„ã®ã§ã¯ãªã„ã‹ ä»®èª¬ã‚’æ¤œè¨¼ã™ã‚‹ã“ã¨ã§ã€å¯¾ç–ã‚’ã—ã¦ã„ãã¾ã™ã€‚ è¨å®šã‚’è¦‹ç›´ã™ ä¸Šè¨˜ã®ä»®èª¬ã®è¨å®šã¯ã€MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã§ã‚ã‚‹ã€Œ
shayash 2018/11/12
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
é–‹ç™ºç’°å¢ƒç”¨æœ€ä½Žé™ã®MySQL / MariaDBè¨å®š
å„ã€…ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒé–‹ç™ºã«ä½¿ç”¨ã™ã‚‹Dockerã‚„Vagrantç‰å†…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã£ã¦ã€ã‚ã¾ã‚Šãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚Šã—ã¾ã™ã‚ˆãã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚Œã¦ã„ã‚‹ã‚µãƒ¼ãƒãƒ¼ã¯ã€ã‚«ãƒ¼ãƒãƒ«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿å«ã‚å¤šãã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒèª¿æ•´ã•ã‚Œã¦ã„ã‚‹ã®ã§ä½•ãŒä¸»è¦ãªãƒã‚¤ãƒ³ãƒˆã‹åˆ†ã‹ã‚‰ãªã„ã€‚ è€éšœå®³æ€§ã‚’æ¨ã¦ã¦ã§ã‚‚é–‹ç™ºç’°å¢ƒã¯é€Ÿãã€‚ ãã‚“ãªæ–¹ã®ãŸã‚ã®é–‹ç™ºç’°å¢ƒç”¨ç°¡æ˜“ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¨˜äº‹ã§ã™ã€‚ MariaDBã¯10.1(10.xç³»)ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ â€»ã¡ãªã¿ã«ç†è€…ã¯ä¾¡æ ¼ã®äº‹ã‚’æ£šã«ä¸Šã’ã‚Œã°SQLServer(MSSQL)ã‚„ PostgreSQLã‚‚9.4ä»¥é™(ç‰¹ã«9.5)ãªã‚‰å¥½ãã§ã™ã—ã€MariaDBã¯Galera ClusterãŒã‚ã‚‹ã‹ã‚‰å¥½ãã§ã™ã€‚ ä»•äº‹ã§ã¯AWSã‚’æ‰±ã†æ©Ÿä¼šãŒéžå¸¸ã«å¤šã„ã®ã§Amazon Auroraã¯å¤–ã›ã¾ã›ã‚“ã€‚ è¨å®šä¾‹ãƒ¡ãƒ¢ãƒª1Gã»ã©ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å‰²ã‚Šå½“ã¦ã‚‹ä¾‹ã§ã™ã€‚ [mysqld] skip-name-resolve
shayash 2018/09/21
mysql

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

explain

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°äº‹ä¾‹ - Qiita
äº‹å‰æƒ…å ± m3.xlargeã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ 15GB ãƒ¡ãƒ¢ãƒª 13 ECU = 3.25ECU(2.6GHz) * ä»®æƒ³4ã‚³ã‚¢ DBã‚µã‚¤ã‚º 3.38 GB è¨å®šå€¤ max_connections = 100 shared_buffers = 3GB # å®Ÿãƒ¡ãƒ¢ãƒªã®20% # ã“ã“ã‚‰ã¸ã‚“ã®ã¯ã¨ã‚Šã‚ãˆãšã“ã®ãã‚‰ã„ã§ã€‚å°ã•ã™ãŽã‚‹åˆ†ã«ã¯log_temp_filesã®è¨å®šã§æ›¸ãå‡ºã•ã‚Œã‚‹ã®ã§å¾Œã§æ°—ã¥ã„ã¦èª¿æ•´ã§ãã‚‹ã€‚ temp_buffers = 32MB work_mem = 32MB maintenance_work_mem = 128MB wal_buffers = 16MB # è¿·ã„ã©ã“ã‚ã‚‚ãªã16MB checkpoint_segments = 16 # HDã¸ã®ãƒ•ãƒ©ãƒƒã‚·ãƒ¥å›žæ•°ã‚’æ¸›ã‚‰ã™ effective_cache_size = 7GB # planerã®ãŸã‚ã€‚å®Ÿãƒ¡ãƒ¢ãƒªã®åŠåˆ†ãã‚‰ã„ãŒã„ã„ã‚‰ã—ã„
shayash 2015/06/18
postgresql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
PostgreSQLã®è¨å®š ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° â€” ãã“ã¯ã‹ã¨ãªãæ›¸ãã‚ˆã‚“ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
PostgreSQLã®è¨å®š ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Â¶ PostgreSQL when it is not your job - Christophe Pettus çµŒç”±ã§ DjangoCon Europe 2012 ã§ç™ºè¡¨ã•ã‚ŒãŸ ã“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ ã‚’çŸ¥ã£ãŸã®ã§ã€ ãƒ¡ãƒ¢ä»£ã‚ã‚Šã«æ®‹ã—ã¦ã¿ã‚‹ã€‚ä»¶ã®blogã¯æŠœç²‹ãªã®ã§ã€ã“ã“ã§ã¯å¯èƒ½ãªé™ã‚Šå…¨éƒ¨è¼‰ ã›ã¾ã™ã€‚ æœ€åˆã«Â¶ æ°—ã‚’ã¤ã‘ã‚‹è¨å®šã¯ã“ã‚Œã ã‘ã€‚ ãƒã‚° ãƒ¡ãƒ¢ãƒª ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆ ãƒ—ãƒ©ãƒ³ãƒŠãƒ¼ ãƒã‚°Â¶ ãƒã‚°ã«å¯¾ã—ã¦å¯›å®¹ã«ãªã‚‹ã“ã¨ã€‚ã‚·ã‚¹ãƒ†ãƒ ã¸ã®å½±éŸ¿ã¯å°‘ãªã„ã€‚ ãƒã‚°ã¯æ€§èƒ½å•é¡Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã®ä¸€ç•ªã„ã„æƒ…å ±ã€‚ ã©ã“ã«ãƒã‚°ã‚’å‡ºã™ï¼ŸÂ¶ syslog: ã™ã§ã«syslogã‚’ä½¿ã†ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¦ã‚‹ãªã‚‰ã“ã‚ŒãŒã„ã„ã§ã—ã‚‡ã† æ¨™æº–å½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«: æ¨™æº–å½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã†ãƒ„ãƒ¼ãƒ«ã‚’ã™ã§ã«ä½¿ã£ã¦ã„ã‚Œã°ã“ã‚Œã€‚ ãã†ã§ãªã‘ã‚Œã° CSVãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ ã‚ã¨ã®è¨å®šã¯ã“ã‚Œã€‚ log_destination
shayash 2015/06/18
postgresql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° : ç”¨é€”ã¨åˆ©ç‚¹ â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ æ¿åž£ è²´è£• ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡æ•°ã«åˆ†å‰²ã—ã¦æ ¼ç´ã™ã‚‹ã“ã¨ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†å‰²ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€æ€§èƒ½ã‚„é‹ç”¨æ€§ãŒå‘ä¸Šã—ã€æ•…éšœã®å½±éŸ¿ã‚’å±€æ‰€åŒ–ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚å·¨å¤§ãªãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†å ´åˆã«ã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚‚æ¤œè¨Žã—ã¦ã¿ã¦ãã ã•ã„ã€‚ ã“ã®è¨˜äº‹ã§ã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®æ¦‚è¦ã¨ç”¨é€”ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚PostgreSQL ã§ã®å…·ä½“çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦ã¯ã€Žãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° : ä½¿ã„æ–¹ã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®ç”¨é€” ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã«ã¯å¤§ããåˆ†ã‘ã¦ã€Œãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®åˆ†å‰²ã€ã€ŒãƒŽãƒ¼ãƒ‰é–“ã®åˆ†å‰²ã€ã®2ã¤ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ä¸»ã«ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®åˆ†å‰²ã‚’æ‰±ã„ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®åˆ†å‰² å·¨å¤§ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åˆ†å‰²ã—ã¾ã™ã€‚å˜ç´”ã«è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åˆ†ã‘ã¦æ ¼ç´ã™ã‚‹ã ã‘ã§ã‚‚åŠ¹æžœã¯ã‚ã‚Šã¾ã™ãŒã€PostgreSQL ã¯è¤‡æ•°ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’1ã¤
shayash 2011/11/07
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡æ•°ã«åˆ†å‰²ã—ã¦æ ¼ç´ã™ã‚‹ã“ã¨

postgresql

tips

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: Apache MPM ã®åŸºç¤Žã‚’ã—ã£ã‹ã‚Šã¨ç†è§£ã—ã‚ˆã†ï¼
naoya ã§ã™ã€‚æœ€è¿‘ã€ã¨ã†ã¨ã†èŠ±ç²‰ç—‡ã®å£ç¯€ã«å…¥ã£ãŸã®ã§ã€ç”Ÿã¾ã‚Œã¦åˆã‚ã¦ç©ºæ°—æ¸…æµ„æ©Ÿã‚’è³¼å…¥ã—ã¾ã—ãŸã€‚ ã•ã¦ã€ä»Šæ—¥ã¯ Apache HTTP ã‚µãƒ¼ãƒã® MPM (Multi Processing Module) ã«ã¤ã„ã¦è§£èª¬ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚æ™®æ®µã€ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã‚’æ§‹ç¯‰ã™ã‚‹ã¨ãã€Apache HTTP ã‚µãƒ¼ãƒã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€Apache HTTP ã‚µãƒ¼ãƒã‚’ä½¿ã†ä¸Šã§ MPM ã«ã¤ã„ã¦ç†è§£ã—ã¦ãŠãã“ã¨ã¯å¤§äº‹ã§ã™ã€‚ ã“ã® MPM ã§ã™ãŒã€Apache HTTP ã‚µãƒ¼ãƒã§ã¯ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã™ã‚‹éƒ¨åˆ†ã®ã“ã¨ã‚’ã•ã—ã¾ã™ã€‚MPM ã¯ã€Apache HTTP ã‚µãƒ¼ãƒ 2.0 ç³»ã‹ã‚‰æŽ¡ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚Apache HTTP ã‚µãƒ¼ãƒã® MPM ã«ã¯ã€æ¬¡ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ prefork worker perchild winnt ãã‚Œãžã‚Œã® MPM ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã¾ãšã¯ã€ä¸€ç•ªä»£è¡¨çš„ãª prefork
shayash 2009/09/22
apache

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

tips
ãƒªãƒ³ã‚¯
Apache Bench ã§æ€§èƒ½æ¸¬å®šã - ITé©å‘½ï½ž
æƒ…å ±æŠ€è¡“(ã‚¢ã‚¤ãƒ†ã‚£ãƒ¼)é©å‘½ã§ã¯ãªãã‚¤ãƒƒãƒˆé©å‘½ï¼ITåŒ–æŽ¨é€²ã«å½¹ç«‹ã¤ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„Webåˆ¶ä½œã«é–¢ã™ã‚‹ãƒã‚¿ã‚’æ‰±ã„ã¾ã™ã€‚ Apache ã«ä»˜å±žã—ã¦ã„ã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚½ãƒ•ãƒˆã‚’ä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ Apacheã«ã¯ã€æ¨™æº–ã§ã€Œabã€(Apache Bench) ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒä»˜å±žã—ã¦ã„ã¾ã™ã€‚ åŒæ™‚æŽ¥ç¶šæ•°ã¨ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã¨URLã‚’æŒ‡å®šã™ã‚Œã°ã€æ€§èƒ½ãŒæ¸¬å®šã§ãã¾ã™ã€‚ ab ã‚³ãƒžãƒ³ãƒ‰ã«ã‚ˆã£ã¦ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’ç™ºç”Ÿã•ã›ã€æŽ¥ç¶šæ™‚é–“ãƒ»å‡¦ç†æ™‚é–“ãƒ»å¾…ã¡æ™‚é–“ãªã©ã®çµ±è¨ˆã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¾‹ãˆã°ã€åŒæ™‚æŽ¥ç¶šæ•°ãŒ 100ã§ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•° 1,000 ã«ãªã‚‹ã¾ã§ã€http://example.com/index.html ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãªã‚‰ã° ab -n 1000 -c 100 http://example.com/index.html èªè¨¼ãŒå¿…è¦ãªãƒšãƒ¼ã‚¸ã«ã¯ã€-A ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ -n æ•°å€¤ï¼šãƒ†ã‚¹ãƒˆã§ç™ºè¡Œã™ã‚‹ãƒªã‚¯ã‚¨ã‚¹ãƒˆã®å›ž
shayash 2009/09/18
apache

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

tips
ãƒªãƒ³ã‚¯
Apacheãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ
ç¾çŠ¶ã®æ¸¬å®šï¼ˆãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ï¼‰ã¨çµæžœã®ç€çœ¼ç‚¹ ã“ã“ã‹ã‚‰ã¯Apacheã«ç€ç›®ã—ã¦ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®æº–å‚™ã‚’è¡Œã†ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã«å½“ãŸã£ã¦ã€ã¾ãšç¾çŠ¶ã‚’ååˆ†ã«åˆ†æžã—ã€å…·ä½“çš„ãªç›®æ¨™ã‚’å®šã‚ã‚‹ã“ã¨ã‹ã‚‰å§‹ã‚ãŸã„ã€‚ç›®æ¨™ã‚’ã©ã‚Œã ã‘å…·ä½“åŒ–ã™ã‚‹ã‹ã¯ã¨ã‚‚ã‹ãã¨ã—ã¦ã‚‚ã€ç¾çŠ¶ã‚’æ•°å€¤çš„ã«çŸ¥ã‚Šã‚‚ã›ãšã«ã€æ¼ ç„¶ã¨ã€Œé…ã„é…ã„ã€ã¨é¨’ã„ã§ã„ã¦ã‚‚ä»•æ–¹ãŒãªã„ã€‚ ç¾çŠ¶ã‚’æ•°å€¤çš„ã«ã¨ã‚‰ãˆã‚‹ã«ã¯ãƒ„ãƒ¼ãƒ«ãŒå¿…è¦ã¨ãªã‚‹ã€‚ã„ã‚ã‚†ã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ»ãƒ„ãƒ¼ãƒ«ã ã€‚Apacheã«ã¯ã€æ¨™æº–ã§ã€Œabã€ï¼ˆApache Benchï¼‰ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒä»˜å±žã—ã¦ã„ã‚‹ã€‚abã®æ§‹æ–‡ã¯ã€
shayash 2009/09/18
apache

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

tips
ãƒªãƒ³ã‚¯
mod_cache - Apache HTTP ã‚µãƒ¼ãƒ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 2.2
Please note This document refers to the 2.2 version of Apache httpd, which is no longer maintained. The active release is documented here. If you have not already upgraded, please follow this link for more information. You may follow this link to go to the current version of this document.
shayash 2009/05/25
apache

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

tips
ãƒªãƒ³ã‚¯
mod_cacheã¨ã‹mod_disk_cacheã¨ã‹mod_mem_cacheã¨ã‹ï½œãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¨ã‹ï½œé–‹ç™ºè€…ãƒ–ãƒã‚°
[PR]ä¸Šè¨˜ã®åºƒå‘Šã¯3ãƒ¶æœˆä»¥ä¸Šæ–°è¦è¨˜äº‹æŠ•ç¨¿ã®ãªã„ãƒ–ãƒã‚°ã«è¡¨ç¤ºã•ã‚Œã¦ã„ã¾ã™ã€‚æ–°ã—ã„è¨˜äº‹ã‚’æ›¸ãäº‹ã§åºƒå‘ŠãŒæ¶ˆãˆã¾ã™ã€‚ ã“ã‚“ã°ã‚“ã‚ã€‚misneyã§ã™ã€‚ åœŸæ›œæ—¥ã¯ãŠä¼‘ã¿ã§ã—ãŸã€‚ é‡‘æ›œæ—¥ã«Gã•ã‚“ã¨Ð¯YUã•ã‚“ã€Big Buddhaã•ã‚“ã€aluã•ã‚“ã€J2xCã•ã‚“ã‚‰ã¨é£²ã¿ã«è¡Œãã€çµæ§‹é…ãã¾ã§é£²ã‚“ã§ã„ãŸã›ã„ã‹å¤•æ–¹ã¾ã§å¯ã¦ã¾ã—ãŸã€‚ ã•ã¦ã€ã“ã®é–“ã®ä¼‘ã¿ã‚‚ãã†ã ã£ãŸã‚“ã§ã™ãŒå¯ã™ãŽã§å¯ã‚Œã¾ã›ã‚“ã€‚ ã“ã®æ™‚é–“ã«å¯ã‚Œãªã„ã¨æš‡ã§ä»•æ–¹ãªã„ã®ã§ã™ã€‚ ã¨ã€ã„ã†ã“ã¨ã§ä»Šæ—¥ã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã¤ã„ã¦è©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒå¤§å¥½ããªä»¶ åƒ•ã¯ã“ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨è¨€ã†ã®ãŒå¤§å¥½ãã§ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒ ã§æ‰±ã†ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚‚ã€çµ¦æ–™æ—¥å¾Œã«å¢—ãˆã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚‚ã€‚ æ™®æ®µãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãæ™‚ã«ã€ãªã‚‹ã¹ãåŠ¹çŽ‡ã®è‰¯ã„ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’è€ƒãˆãªãŒã‚‰ä½œã‚‹ã®ã§ã™ã€‚ ãƒ»ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚µã‚¤ãƒ‰ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ è¨ªå•è€…ã®PCã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã•ã›ã¦ã„ãŸã ã ãƒ»ãƒšãƒ¼ã‚¸ã‚ãƒ£ãƒƒã‚·ãƒ¥ URLæ¯Žã«ç”Ÿæˆã•ã‚Œã‚‹H
shayash 2009/05/25
apache

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

tips
ãƒªãƒ³ã‚¯
Apache 2.2ã§Webã‚µã‚¤ãƒˆã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¢ãƒƒãƒ—ï¼ï¼ˆ2/3ï¼‰ ï¼ ï¼ IT
Apache 2.2ã§Webã‚µã‚¤ãƒˆã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¢ãƒƒãƒ—ï¼ ï¼ æœ€æ–°Apacheã®æ©Ÿèƒ½ã¨è¨å®šæ–¹æ³•æ•™ãˆã¾ã™ ï¼ é¶´é•· éŽ®ä¸€ï¼ˆ[email protected]ï¼‰ 2006/3/14 å¼·åŒ–ã•ã‚ŒãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚ãƒ£ãƒƒã‚·ãƒ¥æ©Ÿèƒ½ã‚’ä½¿ã† ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚ãƒ£ãƒƒã‚·ãƒ¥æ©Ÿèƒ½ã‚’å°Žå…¥ã™ã‚‹ã¨ã€Apacheã®å¿œç”æ€§ã‚’å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å¾“æ¥ã®Apache 2.0ã§ã‚‚ã€mod_file_cacheãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§é€šå¸¸ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ãŸã ã—ã€mod_file_cacheã®ä»•çµ„ã¿ã¯Apacheã®èµ·å‹•æ™‚ã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ¡ãƒ¢ãƒªã«èªã¿è¾¼ã¾ã›ã‚‹ã¨ã„ã†ã‚‚ã®ã§ã€ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«å¤‰æ›´ãŒã‚ã£ãŸå ´åˆã¯å†èµ·å‹•ãŒå¿…è¦ã«ãªã‚‹ãªã©ã€å‹•çš„ãªã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã«ã¯å¯¾å¿œã—ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ Apache 2.2ã§ã¯ã€RFC 2616ã«æº–æ‹ ã—ãŸHTTPã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒå¯èƒ½ã«ãªã‚Šã¾ã—ãŸã€‚Cache-Controlãƒ˜ãƒƒ
shayash 2009/05/25
apache

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

tips
ãƒªãƒ³ã‚¯
ã€ŒiPhone 11/11 Pro/11 Pro Maxã€ã¯è¦‹ãŸç›®ãŒã©ã†é€²åŒ–ã—ãŸã®ã‹å‰ãƒ¢ãƒ‡ãƒ«ã‚‚å«ã‚ã¦å¾¹åº•æ¯”è¼ƒ - GIGAZINE
è¿‘å¹´ã§ã¯Googleã®ã€ŒGemini Nanoã€ã‚„Appleã®ã€ŒApple Intelligenceã€ãªã©ã€å¤§è¦æ¨¡è¨€èªžãƒ¢ãƒ‡ãƒ«ã‚„ãƒ‘ãƒ¼ã‚½ãƒŠãƒ«AIã‚’ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã«çµ±åˆã™ã‚‹å‹•ããŒå¼·ã¾ã£ã¦ãŠã‚Šã€ã“ã‚Œã«ä¼´ã£ã¦ãƒ‡ãƒã‚¤ã‚¹ã®å„ªã‚ŒãŸå†·å´æŠ€è¡“ã«å¯¾ã™ã‚‹éœ€è¦ã‚‚é«˜ã¾ã£ã¦ã„ã¾ã™ã€‚ã‚¢ãƒ¡ãƒªã‚«ã®åŠå°Žä½“é–‹ç™ºä¼æ¥ã®xMEMSãŒã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚„ã‚¿ãƒ–ãƒ¬ãƒƒãƒˆãªã©ã®ãƒ‡ãƒã‚¤ã‚¹ã«æè¼‰å¯èƒ½ãªå†·å´ãƒãƒƒãƒ—ã‚’é–‹ç™ºã—ã¾ã—ãŸã€‚ xMEMS | Active Micro Cooling | XMC-2400 https://xmems.com/products/microcooling/ xMEMS XMC-2400: The Worldâ€™s First 1mm-Thin Active Micro Cooling Fan on a Chip - YouTube 1st-of-its-kind 'cooling chip' could prevent
shayash 2007/11/12
php

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šå…±æœ‰ãƒãƒƒãƒ•ã‚¡ã§ã©ã‚Œã ã‘å¤‰ã‚ã‚‹ï¼Ÿ (1/4)
PostgreSQLã¨ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã§ã™ã€‚èª°ã§ã‚‚ã©ã®ã‚ˆã†ãªç›®çš„ã«ã‚‚ç„¡æ–™ã§ä½¿ãˆã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚æœ€è¿‘ã§ã¯ã™ã£ã‹ã‚ŠçŸ¥ååº¦ã‚‚ä¸ŠãŒã‚Šã€éžå¸¸ã«å¤šãã®æ–¹ãŒPostgreSQLã‚’åˆ©ç”¨ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ã“ã‚Œã»ã©æ™®åŠã—ã¦ãã‚‹ã¨åˆ©ç”¨ã•ã‚Œã‚‹æ–¹ã®æŠ€è¡“ãƒ¬ãƒ™ãƒ«ã‚‚æ§˜ã€…ã§ã€é•·ã‚‰ãå•†ç”¨RDBMSã§ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’ã•ã‚Œã¦ããŸæ–¹ã‚‚ã„ã‚Œã°ã€RDBMSã‚’æ‰±ã†ã®ã¯PostgreSQLãŒã¯ã˜ã‚ã¦ã¨ã„ã†æ–¹ã‚‚ã„ã¾ã™ã€‚å½“ç„¶PostgreSQLã®ä½¿ã‚ã‚Œæ–¹ã‚‚æ§˜ã€…ã§ã€PostgreSQLã®æ€§èƒ½ã‚’é™ç•Œã¾ã§å¼•ãå‡ºã™ã‚ˆã†ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ–½ã—ã¦ã„ã‚‹æ–¹ã‚‚ã„ã‚Œã°ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¾ã¾ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã®ã¾ã¾ã§ä½¿ã£ã¦ã„ã‚‹æ–¹ã‚‚ã„ã¾ã™ã€‚ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã‚’ã€Œé–‹ç™ºè€…ã®æŽ¨å¥¨è¨å®šã€ã¨æ‰ãˆã‚‹æ–¹ãŒã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ã€‚ã—ã‹ã—æ®‹å¿µãªãŒã‚‰PostgreSQLã«ãŠã„ã¦ã¯æˆã‚Šç«‹ã¡ã¾ã›ã‚“ã€‚ãã‚Œã§ã¯PostgreS
shayash 2007/10/23
postgresql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
postgresql ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã“ã®ã‚µã‚¤ãƒˆã¯ã€ã‚‚ã¨ã‚‚ã¨ä½œè€…ã®è‡ªåˆ†ç”¨ãƒ¡ãƒ¢ã¨ã—ã¦æ›¸ãå§‹ã‚ãŸã‚‚ã®ã§ã™ã€‚æ›¸ã„ã¦ã‚ã‚‹ã“ã¨ãŒå…¨ã¦æ£ã—ã„ã¨ã¯é™ã‚Šã¾ã›ã‚“ã€‚ä»–ã®æ–‡çŒ®ã€ã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ãªã‚µã‚¤ãƒˆã‚‚ç¢ºèªã—ã¦ã€è‡ªå·±è²¬ä»»ã«ã¦åˆ©ç”¨ã—ã¦ãã ã•ã„ã€‚ æ•°åä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŒã¤å¤§è¦æ¨¡ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ‰±ã†ã‚ˆã†ã«ãªã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã«ã‚ˆã£ã¦ã¯å›žç”ãŒå¾—ã‚‰ã‚Œã‚‹ã¾ã§ã«æ•°ç§’ã‹ã‹ã‚‹ã‚±ãƒ¼ã‚¹ã‚‚å‡ºã¦ãã‚‹ã€‚ã“ã‚Œã¯ã€ã‚ˆã‚Šå¤šãã®ãƒ¡ãƒ¢ãƒªã‚„ãƒ‡ã‚£ã‚¹ã‚¯ã®ä½¿ç”¨ã‚’ PostgreSQL ã«è¨±ã™ã“ã¨ã§æ”¹å–„ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒé«˜ã„ã€‚ãŸã ã—ã€æ‰±ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå°ã•ã„æ™‚ã«ã¯å¤§ã—ãŸåŠ¹æžœã¯æœ›ã‚ãªã„ã€‚ã¾ãŸã€ãã‚‚ãã‚‚ã®å®Ÿè£…ãƒ¡ãƒ¢ãƒªãŒ 256M ã¨ã‹ 128M ã¨ã„ã†è²§å¼±ãªçŠ¶æ…‹ã§ã¯ã€èª¿æ•´ã®ä½™åœ°ã•ãˆãªãã€å˜ãªã‚‹æ‚ªã‚ãŒãã ã€‚ä»¥ä¸‹ã¯æè¼‰ãƒ¡ãƒ¢ãƒª 1 ã‚®ã‚¬ã‚’ç›®å®‰ã«æ›¸ã„ã¦ã„ã‚‹ã€‚æ›´ã«ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç´ æ€§ã¨ã‚¯ã‚¨ãƒªãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚ˆã£ã¦ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«è‡ªä½“ã®ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ãŒåŠ é€Ÿã‚’ä¸Šä¹—ã›ã—ã¦ãã‚Œã‚‹ã‹ã‚‚ã—ã‚Œãªã„ -- ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã‚„é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ã€ãƒ¡
shayash 2007/06/08
shared_buffers ã®è¨ˆç®—æ–¹æ³•

postgresql

tips

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: PHPã§æ›¸ã‹ã‚ŒãŸwebã‚µãƒ¼ãƒ“ã‚¹ã‚’é«˜é€ŸåŒ–ã™ã‚‹
å°¾è—¤æ£äººã§ã™ã€‚ ã‚¢ã‚¯ã‚»ã‚¹æ•°ã®å¤šã„ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã® web ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€å‡¦ç†é€Ÿåº¦ãŒã‹ãªã‚Šé‡è¦ã«ãªã£ã¦ãã¾ã™ã€‚ å¿œç”é€Ÿåº¦ãŒé…ã„ã¨ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ã«ã¨ã£ã¦ã‚¹ãƒˆãƒ¬ã‚¹ã«ãªã‚Šã¾ã™ã—ã€ å‡¦ç†ã«æ™‚é–“ãŒã‹ã‹ã‚Œã°ã‚µãƒ¼ãƒã«å¯¾ã™ã‚‹è² è·ã‚‚é«˜ããªã‚Šã¾ã™(åŽ³å¯†ã«è¨€ã†ã¨é•ã†)ã€‚ ãã“ã§ã‚¦ãƒŽã‚¦ã§ã¯ã„ã‚ã„ã‚ãªå·¥å¤«ã‚’ã—ã¦å‡¦ç†é€Ÿåº¦ã®é«˜é€ŸåŒ–ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ä¸€å£ã«é«˜é€ŸåŒ–ã¨ã„ã£ã¦ã‚‚ã„ã‚ã„ã‚ãªè¦ç´ ãŒã‚ã‚Šã¾ã™ãŒã€å¤§ããåˆ†ã‘ã¦3ã¤ã®æ®µéšŽãŒã‚ã‚Šã¾ã™ã€‚ ãƒ»ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«ã‚ˆã‚‹é«˜é€ŸåŒ– ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«ã‚ˆã‚‹é«˜é€ŸåŒ– ãƒ»ãƒ—ãƒã‚°ãƒ©ãƒ ã®å·¥å¤«ã«ã‚ˆã‚‹é«˜é€ŸåŒ– ã—ã‹ã—ã€ã“ã‚Œã‚‰3ã¤ã¯ç‹¬ç«‹ã§ã¯ãªãã€äº’ã„ã«å½±éŸ¿ã—ã‚ã£ã¦ã„ã‚‹ã®ã§å®Œå…¨ã«åˆ†ã‘ã¦è€ƒãˆã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“ã€‚ ãã‚Œãžã‚ŒãŒã©ã®ã‚ˆã†ãªéƒ¨åˆ†ã«å½±éŸ¿ã‚’ä¸Žãˆã¦ã„ã‚‹ã®ã‹ã€ã¡ã‚ƒã‚“ã¨ç†è§£ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒå¤§äº‹ã§ã™ã€‚ ãŸã ã—ã€é«˜é€ŸåŒ–ã™ã‚‹ã¨ãã«å¿˜ã‚Œã¦ã„ã‘ãªã„ã®ãŒã€é«˜å¯ç”¨æ€§ã§ã™ã€‚ ã„ãã‚‰é«˜é€Ÿã«å‹•ä½œã—ã¦ã‚‚å®‰å®šã—ã¦å‹•ä½œã—
shayash 2007/02/11
ã€Žãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã« ext3 ã‚’"ä½¿ã‚ãªã„"ã€ã€Ž.htaccessã‚’ä½¿ã‚ãªã„ã€ã€Žapacheã¯preforkã§å‹•ä½œã•ã›ã‚‹ã€ãªã©

php

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

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
hail2u.net - Weblog - åœ§ç¸®ãƒ•ã‚©ãƒ«ãƒ€ã‚’ä½¿ã‚ãªã„ã‚ˆã†ã«ã™ã‚‹ã¨ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ãŒã‚ãƒ“ã‚ãƒ“å‹•ã
Windows XPã®åœ§ç¸®ãƒ•ã‚©ãƒ«ãƒ€ã¨ã„ã†ã»ã¨ã‚“ã©ã®äººãŒä½¿ã£ã¦ã„ãªã„ã¨æ€ã‚ã‚Œã‚‹æ©Ÿèƒ½(ç§è¦‹)ã‚’è§£é™¤ã—ãŸã‚‰ã€ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ãŒã‚ãƒ“ã‚ãƒ“å‹•ãã‚ˆã†ã«ãªã£ãŸæ°—ãŒã™ã‚‹ã€‚ã¨ã„ã†ã‚ˆã†ãªã“ã¨ã‚’æŸæ‰€ã§è¨€ã£ãŸã‚‰ã€è©¦ã—ãŸäººãŒã€Œã™ã’ã‡ã‹ã‚‹ããªã£ãŸ kyo++ã€ã¨ã‹ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ã¦ãã‚ŒãŸã®ã§ã€ã‚¨ãƒ³ãƒˆãƒªã«ã—ã¦ãŠã“ã†ã¨ã‹ã€‚ åœ§ç¸®ãƒ•ã‚©ãƒ«ãƒ€æ©Ÿèƒ½ã®è§£é™¤ã®æ–¹æ³•ã¯ã€ã‚³ãƒžãƒ³ãƒ‰ ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã€ regsvr32 /u zipfldr.dll regsvr32 /u cabview.dll ã¨ã€å…¥åŠ›ã—ã¦ã‚„ã‚‹ã ã‘ã€‚å¤šåˆ†å†èµ·å‹•ã¯å¿…è¦ãªã„ã€‚ ã“ã‚Œã«ã‚ˆã‚Šç‰¹ã«ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ã®ãƒ„ãƒªãƒ¼è¡¨ç¤ºãªã‚“ã‹ãŒé«˜é€ŸåŒ–ã™ã‚‹æ°—ãŒã™ã‚‹ã€‚ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ä»¥å¤–ã§ã¯ãƒ•ã‚¡ã‚¤ãƒ©ãƒ¼ã£ã½ã„ã®ã§ç‰¹ã«é«˜é€ŸåŒ–ã™ã‚‹æ„Ÿã˜ã§ã€åƒ•ã®ç’°å¢ƒã§ã¯ACDSeeã®ãƒ„ãƒªãƒ¼è¡¨ç¤ºãŒã¨ã‚“ã§ã‚‚ãªãé«˜é€ŸåŒ–ã—ãŸã€‚ ã¾ãŸã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ¤œç´¢æ©Ÿèƒ½ãŒåœ§ç¸®ãƒ•ã‚©ãƒ«ãƒ€å†…ã‚’æŽ¢ã•ãªããªã‚‹ãŸã‚é«˜é€ŸåŒ–ã—ã€ã„ã¤ã¾ã§ãŸã£ã¦ã‚‚çµ‚ã‚ã‚‰ãªã„ã¨ã„ã†ã“ã¨ã¯å°‘ãª
shayash 2006/09/13
ã“ã‚Œã ã‘æ³¨ç›®ã•ã‚Œã‚‹ã£ã¦ã“ã¨ã¯ã€ãã‚Œã ã‘ä¸æº€ãªã®ï¼Ÿ

windows

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸