¥Ï¡¼¥É¥Ç¥£¥¹¥¯¥á¥ó¥Æ¥Ê¥ó¥¹

¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Î¿ÇÃÇ¡¢ÊªÍý¥Õ¥©¡¼¥Þ¥Ã¥È¡¢ÀŲ»²½¡¢Linux¡¢¥µ¡¼¥Ð¡¼¡¢MySQL¤Ê¤É¤¬¥á¥¤¥ó¤À¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢¤½¤Î¸å¹­¤¬¤ê¡¢¥«¥á¥é¤ä¥Ï¡¼¥É¥¦¥§¥¢¤ÎÅê¹Æ¤âÁý¤¨¤Æ¤­¤Þ¤·¤¿¡£ ¥â¥Ð¥¤¥ë¥Ç¥Ð¥¤¥¹¤Ï¡¢MacBookAir(13·¿)¡¢iPad Air2¡¢¥Ý¥á¥é DM100(¥­¥ó¥°¥¸¥à)¡¢OLYMPUS STYLUS XZ-2¤Ê¤É¡£ ¤³¤ì¤é¤ò»È¤¤¤Ê¤¬¤é¡¢¥Ö¥í¥°¤ò¹¹¿·¤·¤Æ¤¤¤Þ¤¹¡£

¥«¥Æ¥´¥ê¡§ Linux



¥í¡¼¥«¥ë»ª(Apache,PHP,MySQL¤Ê¤É)¤È¤·¤Æ»È¤Ã¤Æ¤¤¤¿CF-R6(¾¾²¼¤Î¥Î¡¼¥ÈPC)¤¬¸Å¤ð¤·Ç®¤ð¤·ÃÙ¤ð¥ó¤Ç¡¢

CF-R6

»ÈÍÑÉÑÅÙ¤ÎÄ㤤MacBook Air(13-inch Mid 2011)¤ò»È¤¦¥³¥È¤Ë¤¹¤ë¡£

MBAMacBookAir13·¿2011-Mid

Linux(Ubuntu)¤«¤émacOS¤Ø¤Î°Ü¹Ô¤Ê¥ó¤Ç¡¢´Ä¶­¥Å¥¯¥ê¤¬¥á¥Æ¥£¥¢¥¯¥Æ¥£¥¢ÌÌÅÝ¿ùÅÄ¡£

¹½ÃÛ¼ê½ç¤Ï°Ê²¼¤Ë½ñ¤¤¤¿¡£

´ØÏ¢¡§Mac¤Ç¥µ¡¼¥Ð¡¼(Apache,PHP,MySQL,WordPress)¤òºî¤ë

# ¤ñ¡©MAMP¤Ç¥¤¥Ã¥Ñ¥Ä¡©¤À¤¬¥·¥Ê¥¤(ȾÅç)¡ª

# MAMP¤È¤Ï¡ÖMacintosh + Apache + MySQL + PHP¡×¤Ç¤¢¤ë¤¬WindowsÈǤ⤢¤ë¡£

´ØÏ¢¡§MAMP

MacBook Air(13-inch Mid 2011)¤Ï´û¤Ë¥¢¥Ã¥Á·Ï¤Î¼ÒĹ¢ö¤ËÀÚ¤ê¼Î¤Æ¤é¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢10.14 Mojave(2018ǯ9·î)¤ä10.15 Catalina(2019ǯ½©Í½Äê)¤ÏÆþ¤é¥Ø¥ó¡ª

¥Ä¥Þ¥ê¡¢Mac(10.13 High Sierra,üâ»àòÔ)»ß¤Þ¤ê¤Ç¤¢¤ë¡£

üâ»àòÔ(High Sierra) 10.13.6

´ØÏ¢¡§MacBook Air(13·¿,Mid 2011)¤ÏÂоݳ°¡ªmacOS 10.14 Mojave

Mojave(¥â¥Ï¥Ù)¤Ã¤Æ²¿¤«¥Å¥£¥ô¥¡¥¯·Ï¤Î̾Á°¥Ã¤Ý¤ð¤·¡¢üâ»àòԤΤ褦¤Ë¥Õ¥­¥Ä¤Ê´Á»ú¤Çɽ¤»¥Ê¤ð¤«¤é¡¢¤½¤ÎÅÀ¤ÇHigh Sierra¤¬Å¬¤·¤Æ¤¤¤ë¤·¡¢¥½¥à¥©¥½¥à¥©Mac¤Ï¤Û¤È¤ó¤É»È¤ï¤Ê¤¤¤Î¤Ç²¿¤éÌäÂê¤Ï¥Ê¤ð(¾Ð)¡£

Core i7(1.8GHz,2¥³¥¢4¥¹¥ì¥Ã¥É)¤ÇRAM¤Ï4GB¡¢¥¹¥È¥ì¡¼¥¸¤ÏSSD¤Ê¤Î¤Ç¡¢¥í¡¼¥«¥ë»ª¤È¤·¤Æ¤Î¥¹¥Ú¥Ã¥¯¤ÏÌäÂê¤Ê¤¤¡£

2677M_MacBookAir_13·¿

¤Ç¡¢PHP¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°Û¤Ê¤ë¥³¥È¤Ëµ¤ÉÕ¤¯¡£

# PHP¤Î¥Ð¡¼¥¸¥ç¥ó³Îǧ
# php -v

¼ÂºÝ¤Ë¥¦¥´¤¤¤Æ¤¤¤ë¤Î¤Ï 7.1.23 ¤Ç¡¢php -v¤À¤È 7.3.7 ¤È¤Ê¤Ã¤Æ¤¤¤ë¡£

PHP_on_Mac

7.1.23 ¤ÏMac¤Î¥Ç¥Õ¥©¥ë¥È¤Î¥ä¥Ä¤Ç¡¢7.3.7 ¤ÏHomebrew(macOSÍѤΥѥ屡¼¥¸¥Þ¥Í¡¼¥¸¥ã¡¼)¤ÇÆþ¤ì¤¿¥ä¥Ä¤«¤Ï¥·¥é¥ó(SILANE)¡£

# brew install php@7.3

»ª¤òºÆµ¯Æ°¤·¤Æ¤â 7.1.23 ¤Î¥à¥¡¥à¥¡¡£

¥à¥¡¡¢5.x¤À¤Ã¤¿¤é¥¢¥ì¤À¤±¤É(6.x¤ÏÇË´þ¤È¤Ê¤ê·çÈÖ)¡¢7.x¤À¤Ã¤¿¤éÂ礷¤ÆÊѤï¤é¥ó¤È»×¤¦¤«¤éÊüÃÖ£÷£÷£÷£÷£÷

´ØÏ¢¡§¡ÚHomebrew¡ÛPHP¤ÎÀßÄê¤ËÃí°Õ¡ªHomebrew/php¤ÎÇÑ»ß (ËÜ·ï¤Ë¶á¤¤¤±¤É¥Á¥ã¥¦)

httpd.conf¤ÎLoadModule¤Î»ØÄê¤òÊѤ¨¤ë¤ÈHomebrew¤ÎPHP¤È¤Ê¤Ã¤¿¡£

# PHP7 of Mac
#LoadModule php7_module libexec/apache2/libphp7.so

# PHP7 of Homebrew
LoadModule php7_module /usr/local/opt/php/lib/httpd/modules/libphp7.so

Mac¤ÎÊý¤ò¥³¥á¥ó¥È¥¢¥¦¥È(#)¤·¡¢Homebrew¤ÎÊý¤ò»ØÄꤷ¡¢Apache¤òºÆµ¯Æ°¤¹¤ë¤È¡¢Homebrew¤ÎPHP¤È¤Ê¤ë¡£

ºÆµ¯Æ°
sudo apachectl restart

¤Ê¤ª¡¢

brew upgrade php

¤ÇHomebrew¤ÎPHP¤Î¥¢¥Ã¥×¥Ç¡¼¥È¤¬²Äǽ¤Ç¡¢2019ǯ8·î»þÅÀ¤Ç¤Ï7.3.8¤Ç¤¢¤Ã¤¿¡£

Mac¤ÎPHP¤Ç¤Ï¤Ç¤­¤Ê¤«¤Ã¤¿¤¬¡¢Homebrew¤ÎPHP¤Ç¤Ïmecab¤äcabocha¤¬Í­¸ú¤Ë¤Ç¤­¤¿(phpinfo¤Ç½Ð¤ë)¤Î¤Ç¡¢¥¤¥í¥¤¥í¤È¥ä¥Ã¤Æ¤ß¤è¤¦¤È»×¤¦¡£

»ä¤ÏMAMP¤Ç¤Ï¥Ê¤ð¤¬¡¢°Ê²¼¤Î¥µ¥¤¥È¤¬»²¹Í¤Ë¤Ê¤Ã¤¿¡£

´ØÏ¢¡§CaboCha ¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ MAMP ¤Î PHP ¤Ç»È¤¦

´ØÏ¢¡§MAMP¤ÎPHP¤Ëphp-mecab¤òƳÆþ¤¹¤ë

´ØÏ¢¡§macOS ¤Ë PHP ¤Î `php-mecab` ³ÈÄ¥¥â¥¸¥å¡¼¥ë¤ò¥Ó¥ë¥É&¥¤¥ó¥¹¥È¡¼¥ë

¾åµ­¤Ë¤âÅöÊý¤Î´Ä¶­¤È¤ÎÉÔ°ìÃפä¸í¤ê¤¬¤¢¤ë¤Î¤Ç¡¢³Æ¥µ¥¤¥È¤Î¾ðÊó¤òÁȤ߹ç¤ï¤»¤Ê¤¬¤éºÆ»î¹Ô¤¹¤ë¥³¥È¤Ë¤Ê¤ë¤¬¥â¥Î¥´¥ÄÌÌÅÝ¿ùή¥ï¡¢¥É¥¡¥ô¥©¡ª¡ª

# --with-php-config¤Î¥Ï¥¤¥Õ¥ó¤Ï2ËÜ

À¸À®¤µ¤ì¤¿mecab.so¤Ècabocha.so¤Ï°Ê²¼¤ËÆþ¤Ã¤Æ¤¤¤ë¡£

/usr/local/Cellar/php/7.3.8/pecl/20180731/

mecab -v
cabocha -v

¤Ç¥Ð¡¼¥¸¥ç¥ó¤¬É½¼¨¤µ¤ì¤ë¡£

PHP¤Ç»È¤¦¤¿¤á¤Ë¤Ï¡¢php.ini¤ÎDynamic Extensions¤ÇÆɤ߹þ¤ß¤ò»ØÄꤹ¤ëɬÍפ¬¤¢¤ë¡£

extension=mecab.so
extension=cabocha.so

php.ini¤Ï

/usr/local/etc/php/7.3/php.ini (Homebrew)
/private/etc/php.ini (Mac)

¤Î2¤Ä¤¬¤¢¤ë¤Î¤Ç¡¢»È¤Ã¤Æ¤¤¤ëÊý¤Ë½ñ¤­²Ã¤¨¤ë¡£

Apache¤òºÆµ¯Æ°¡£

PHPÆâ¤Ç

$cabocha = cabocha_new() ;
$tree = cabocha_parse($cabocha,"¥¢¥ä¤·¤ð¡ÖÕóÌçÍŸì¡×¤ò»È¥Ã¤Æ²òÀ⥹¥ë¡ª") ;
print_r($tree) ;

¤È½ñ¤ð¤Æ¼Â¹Ô¤¹¤ë¤È¡¢¥½¥ì¥é¥·¤ð¥â¥Î¤¬¥Ä¥é¥Ä¥é¤È½Ð¤Æ¥¯¥ë¡ª

¥°¥¡¡¢ÅöÊý¤Î¡ÖÕóÌçÍŸì¡×¤ÏÆüì¸À¸ì¤Ê¤Î¤Ç¡¢Àµ¾ï¤Ë¤ÏȽÊÌÉÔ²Äǽ¤ÊÌÏÍÍ£÷£÷£÷£÷£÷

´ØÏ¢¡§Mac¤Ç¥µ¡¼¥Ð¡¼(Apache,PHP,MySQL,WordPress)¤òºî¤ë

´ØÏ¢¡§Ubuntu 18.04.2 LTS¤Î32¥Ó¥Ã¥ÈÈÇ

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



Windows¤ò»È¤Ã¤Æ¤¤¤ë¤È¡¢Mac¤Ï¥á¥Æ¥£¥¢¥¯¥Æ¥£¥¢»È¤¤¤Ë¤¯¤¤¡ª

¥µ¥¹¥¬¡¢¼ÒŤ¬¥¢¥Ã¥Á·Ï¢ö¤À¤±¤Î¥³¥È¤Ï¤¢¤ë£÷£÷£÷£÷£÷

¤Ê¥ó¤Ç¡¢Mac¤ò»ª¤È¥¹¥ë¥¬(³Ø)¡¢Windows¤«¤éÁàºî¥·¤Æ¤ð¥¯ÊýË¡¡£

ÀµÄ¾¡¢Â¾¤Ç»ª¤òºî¤ë¤è¤êÌÌÅÝ¡ªMac¤Ï¥¯¥Å¥©¡ª¡ª

¤ñ¡©

MAMP¤ò»È¤ñ¡©

»È¤¤¤Þ¥»¥ó£÷£÷£÷£÷£÷

´ØÏ¢¡§[Mac] PHP¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°Û¤Ê¤ëÌäÂê [HighSierra]

¡ãMac¡ä

üâ»àòÔ(High Sierra) 10.13.6

üâ»àòÔ(High Sierra) 10.13.6

¸ÇÄêIP(192.168.0.xx)

°Ê²¼¡¢LANÆâ¤Ë±÷¤ð¤Æ¡¢¤Â¤Ö¥ó¤À¤±¤Ç»È¤¦ÍÑÅӤʥó¤Ç¡¢¥»¥­¥å¥ê¥Æ¥£¡¼¤ÎÇÛθ¤Ï¥·¥È¥é¥ó¤«¤é¡¢ÍÄÃî/ÍÅÃî/Í×Ãí°Õ£÷£÷£÷£÷£÷

ÍÅÃî

¡ãApache¡ä

Mac¤Ë¤ÏApache¤¬Æþ¤Ã¤Æ¤¤¤ë¤¬µ¯Æ°¤·¤Æ¤¤¤Ê¤¤¤Î¤Ç

sudo apachectl start

¤Çµ¯Æ°¤¹¤ë¡£

Windowsµ¡¤«¤é http://192.168.0.xx/ ¤Ç¥¢¥¯¥»¥¹¤¹¤ë¤È¡¢

¡ÖIt works!¡×

¤Èɽ¼¨¤µ¤ì¤ë¥Ï¥Å¡£

¥³¥ì¤Ï¡¢

/Library/WebServer/Documents/index.html.en

¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤ÎÆâÍƤǤ¢¤ë¡£

¤¬¡¢¤³¤ó¤Ê¥ï¥±¤Îʬ¤«¤é¤Ê¤¤¾ì½ê¤ò»È¤¦¤Î¤Ï¥ô¥¡¥¯¥¡¿ùή¤Î¤Ç¡¢Êѹ¹¤¹¤ë¡£

httpd.conf¤òÊÔ½¸¤¹¤ë¤Î¤À¤¬¡¢¸«¤¨¤Ê¤¤¤Î¤Ç¡¢°Ê²¼¤Ç°ÜÆ°¡£

Finder¡ä¥Õ¥©¥ë¥À¤Ø°ÜÆ°¡ä/etc

/etc¡äapache2¡ähttpd.conf

¥¢¥¯¥»¥¹¸¢¤ÇÊݸ¤Ç¤­¤Ê¤¤¤Î¤Ç¡¢¿Æ¤Îapache2¤ähttpd.conf¤Î¥¢¥¯¥»¥¹¸¢¤òÊѹ¹(±¦¥¯¥ê¥Ã¥¯¡ä¾ðÊó¤ò¸«¤ë¡äºÇ²¼Éô)¡£

ÊÔ½¸¤Ë¤Ï¥ï¥±¤Îʬ¤«¤é¤Ê¤¤vi¤Ï»ÈÍѤ»¥Å¡¢Mac¤ËÆþ¤Ã¤Æ¤¤¤ë¡Ö¥Æ¥­¥¹¥È¥¨¥Ç¥£¥Ã¥È¡×¤ò»È¤¦¥³¥È¡£

244¹ÔÌÜÉÕ¶á¤Ë¤¢¤ë

DocumentRoot "/Library/WebServer/Documents"
¡ãDirectory "/Library/WebServer/Documents"¡ä

¤ò

DocumentRoot "/users/www"
¡ãDirectory "/users/www"¡ä

¤È½ñ¤­´¹¤¨¤ë¡£

»ØÄꤷ¤¿/users/www¤Ë²¿¤«½ñ¤¤¤¿¥Õ¥¡¥¤¥ë¤òindex.html¤È¤·¤ÆÃÖ¤¤¤Æ¤ª¤¯¡£

Apache¤òºÆµ¯Æ°¡£

sudo apachectl restart

Windowsµ¡¤«¤é http://192.168.0.xx/ ¤Ç¥¢¥¯¥»¥¹¤·¤Æ¤½¤ÎÆâÍƤ¬¸«¤ì¤ë¤«³Îǧ¤¹¤ë¡£

¤Ê¤ª¡¢Apache¤Ï¼«Æ°µ¯Æ°¤µ¤ì¤Ê¤¤¤Î¤Ç¡¢¼«Æ°µ¯Æ°¤È¤¹¤ë¾ì¹ç¤Ï(¸å½Ò)¡£

¾å½Ò¤Î¸«¤¨¤Ê¤¤¥â¥Î(etc¤ävar¤Ê¤É)¤Ï¡¢

defaults write com.apple.finder AppleShowAllFiles -boolean true

¤Î¸å¤Ë

killall Finder

¤ÇÇöɽ¼¨¤Ç¤Ï¤¢¤ë¤¬Finder¤Ç¸«¤¨¤ë¤è¤¦¤Ë¤Ê¤ë¡£

¸å½Ò¤Î¥Õ¥¡¥¤¥ë¶¦Í­¤Ë¤è¤ê¡¢Windowsµ¡¤«¤é¤â¸«¤¨¤ë¤¬¡¢¥·¥ç¡¼¥È¥«¥Ã¥ÈŪ¤Ê¥¢¥¤¥³¥ó¤È¤Ê¤Ã¤Æ¤ª¤ê¡¢¥À¥Ö¥ë¥¯¥ê¥Ã¥¯¤Ç¤Ï³«¤±¤Ê¤¤¤Î¤Ç¡¢±¦¥¯¥ê¥Ã¥¯¡ä¥Õ¥¡¥¤¥ë¤Î¾ì½ê¤ò³«¤¯¤Ç¿Ê¤á¤ë¡£

¡ãmod_rewrite¡ä

/etc¡äapache2¡ähttpd.conf ¤Î

#LoadModule rewrite_module libexec/apache2/mod_rewrite.so

¤Î¥³¥á¥ó¥È(#)¤ò³°¤·¤Æ¡¢Apache¤òºÆµ¯Æ°¡£

mod_rewrite(URL½ñ¤­´¹¤¨)¤òÍ­¸ú¤Ë¤·¤Ê¤¤¤ÈWordPress¤Ç¤Î¥Ñ¡¼¥Þ¥ê¥ó¥¯ÀßÄê¤Ç¥³¥±¤Æ¤·¤Þ¤¦(Not Found)¡£

Í­¸ú¤Ë¤·¤Æ¤â¥³¥±¤ë¾ì¹ç¤Ï¡¢WordPress¤Î¥ë¡¼¥È¤Ë¤¢¤ë¡Ö.htaccess¡×¤Ërewrite¤Îµ­ºÜ¤¬¤¢¤ë¤«¤ò³Îǧ¤¹¤ë¥³¥È¡£

# BEGIN WordPress
¡ãIfModule mod_rewrite.c¡ä
RewriteEngine On
RewriteBase /wordpress/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /wordpress/index.php [L]
¡ã/IfModule¡ä

# END WordPress

¥½¥ì¤Ç¤âNot Found¤Ë¤Ê¤ë¤Î¤Ï

/etc¡äapache2¡ähttpd.conf ¤Î

AllowOverride None

¤ò

AllowOverride ALL

¤Ë¤·¡¢Apache¤òºÆµ¯Æ°¡£

¤³¤Îµ­ºÜ¤Ï¡¢¾å½Ò¤ÎDocumentRoot¤ÎÈÏ°ÏÆâ¤Ë¤¢¤ë¥Ï¥º¡£

¡ãDirectory "/users/www"¡ä¡Á¡ã/Directory¡ä

¥Ä¥Þ¥êwwwÆâ¤Ë±÷¤¤¤Æ¤Î¤ßÍ­¸ú¤Ê¥ó¤Ç¡¢ALL¤Ç°ÂÁ´¤Ê¥ó¤«¤Ï¥·¥é¥ó(SILANE)¡£

¡ã¥Õ¥¡¥¤¥ë¥¢¥Ã¥×¥í¡¼¥É¾å¸Â¡ä

WordPress¤Ç¥ª¥ª¥­¥á¤Î²èÁü¤òUP¤·¤è¤¦¤È¤¹¤ë¤È

¡Ö¤³¤Î¥µ¥¤¥È¤Î¥¢¥Ã¥×¥í¡¼¥É¥µ¥¤¥º¾å¸Â¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£¡×

¤È¤·¤ÆµñÈݤµ¤ì¥¦¥Å¥¡¤ð¥ó¤Ç¡¢°Ê²¼¤Î3¹Ô¤òÄɲá¢

¡ãDirectory "/users/www"¡ä
php_value memory_limit 128M
php_value post_max_size 64M
php_value upload_max_filesize 32M
¡ã/Directory¡ä

Apache¤òºÆµ¯Æ°¡£

Apache¤À¤±¤Ç¤Ê¤¯PHP¦¤â¥«¥é¤ß¡¢½èÍý»þ´Ö¤ÎÌäÂê¤â¤¢¤ë¥ó¤Ç¡¢¾ÜºÙ¤Ï°Ê²¼¤¬»²¹Í¤Ë¤Ê¤ë¡£

´ØÏ¢¡§php¤ÎÂçÍÆÎÌ¥Õ¥¡¥¤¥ë¥¢¥Ã¥×¥í¡¼¥É(¥ê¥¯¥¨¥¹¥È)¤Î¥µ¥¤¥ººÇÂçÃͤÎÀ©¸Â²ò½ü (³°Éô¥µ¥¤¥È)

¡ã¥Õ¥¡¥¤¥ë¶¦Í­¡ä

¥·¥¹¥Æ¥à´Ä¶­ÀßÄê¡ä¶¦Í­¡ä¥Õ¥¡¥¤¥ë¶¦Í­ ¤Ë¥Á¥§¥Ã¥¯¤òÆþ¤ì¡¢

¥Õ¥¡¥¤¥ë¶¦Í­_Mac

¤µ¤é¤Ë¥ª¥×¥·¥ç¥ó¤È¿Ê¤ß¡¢

SMB¤ò»ÈÍѤ·¤Æ¥Õ¥¡¥¤¥ë¤ä¥Õ¥©¥ë¥À¤ò¶¦Í­

¤È

Windows¥Õ¥¡¥¤¥ë¶¦Í­¤Î¥¢¥«¥¦¥ó¥È¤Ë¥Á¥§¥Ã¥¯¤òÆþ¤ì¤ë¡£

Windows¥Õ¥¡¥¤¥ë¶¦Í­_Mac

´ØÏ¢¡§Mac¤Ç¥Õ¥¡¥¤¥ë¶¦Í­¤òÀßÄꤹ¤ë (support.apple.com)

Windowsµ¡¤Ç¤Ï \\192.168.0.xx ¤ÇMac¤Ë¥¢¥¯¥»¥¹²Äǽ¡£

¥³¥ì¤ÇWindowsµ¡¤«¤é¥Õ¥¡¥¤¥ë¤¬ÊÔ½¸²Äǽ¤È¤Ê¤ê¡¢¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼¤â¤Ç¤­¤ë¡£

⤷¡¢¥¢¥¯¥»¥¹¸¢¤Ë¤ÏÃí°Õ¡£

¡ÖÆɤß/½ñ¤­¡×¤À¤ÈÊÔ½¸²Äǽ¤À¤¬¡¢¡ÖÆɤ߽Ф·¤Î¤ß¡×¤À¤ÈÆɤá¤Æ¤âÊÔ½¸¤Ç¤­¥Å¡¢¡Ö¥¢¥¯¥»¥¹ÉԲġפÀ¤ÈÆɤߥ¹¥é¤Ç¤­¤Ê¤¤¡£

¥ê¥â¡¼¥È¥í¥°¥¤¥ó¤Çchmod¤¹¤ë¤«¡¢Mac¤Ç ±¦¥¯¥ê¥Ã¥¯¡ä¾ðÊó¤ò¸«¤ë¡äºÇ²¼Éô ¤Ç¥¢¥¯¥»¥¹¸¢¤òÊѹ¹¤¹¤ë¤³¤È¡£

Î㡧chmod -R 777 www

¼«Ê¬¤ÏÆɤ߽ñ¤­¤Ç¤­¤Æ¤â¡¢PHP¤Ê¤É¤Î¥×¥í¥°¥é¥à¤Ç¤Ï¥¢¥¯¥»¥¹¤Ç¤­¤Ê¤¤¤È¤¤¤¦¾ì¹ç¤â¤¢¤ë¡£

¤Þ¤¿¡¢¥×¥í¥°¥é¥à¤¬½ñ¤­½Ð¤·¤¿¥Õ¥¡¥¤¥ë¤¬¡¢Windowsµ¡¤«¤é³«¤±¤Ê¤¤/ÊÔ½¸¤Ç¤­¤Ê¤¤¤È¤¤¤¦¾ì¹ç¤â¤¢¤ë¡£

¥×¥í¥°¥é¥à¤Î¥æ¡¼¥¶¡¼¤ÈWindows¤Î¥æ¡¼¥¶¡¼¤Ï°Û¤Ê¤ë¤¿¤á¤À¡£

ËÜ·ï¤Ç½Ð¸½¤·¤½¤¦¤Ê¥æ¡¼¥¶¡¼(̾Á°)¤Ï¡¢°Ê²¼¤ÎÄ̤ꡣ

¡¦temp(¼«Ê¬)
¡¦admin
¡¦everyone
¡¦_www

¤³¤Î¥¢¥¯¥»¥¹¸¢¤ÎÌäÂê¤Ë¤Ï¡¢±ä¡¹¤È¥¯¥ë¥·¥á¥é¥ë¥§¥ë¤³¤È¤Ë¤Ê¤ë¤Î¤Ç¡¢¥½¥ì¤¬ÌÌÅݤǥ¢¥ë¥Ê¥é¡¢¥½¥¯¥Å¥¡¤ËËܷ狼¤é¼ê¤ò°ú¤­¡¢¥É¥«¥¿¡¢ÌîµåÁª¼ê¡¢¥×¥í¥ì¥¹¥é¡¼¡¢·Ý¿Í¤Ë¤Ç¤â¤Ê¤ë¥³¥È¤ò¥ª¥¹¥¹¥á¤¹¤ë¡£

¡ã¥ê¥â¡¼¥È¥í¥°¥¤¥ó(SSH)¡ä

¥·¥¹¥Æ¥à´Ä¶­ÀßÄê¡ä¶¦Í­¡ä¥ê¥â¡¼¥È¥í¥°¥¤¥ó

¥ê¥â¡¼¥È¥í¥°¥¤¥ó_Mac

Tera Term¤È¤«¤Ç±ó³ÖÁàºî¤¬²Äǽ¤Ë¤Ê¤ë¡£

°Ê¾å¤Ë¤è¤ê¡¢Windowsµ¡¤Ç¥Õ¥¡¥¤¥ëÊÔ½¸¡¢¥ê¥â¡¼¥È¥í¥°¥¤¥ó(¥Æ¥­¥¹¥ÈÁàºî)¤ÇApache¤ÎºÆµ¯Æ°¤Ê¤É¤¬¤Ç¤­¤ë¤Î¤Ç¡¢¥ï¥±¤Îʬ¤«¤é¤Ê¤¤Mac¤òÁàºî¤¹¤ëɬÍפʥʥ¯¥Ê¥ë¡£

¡ãPHP¤ò»È¤¦¡ä

httpd.conf¤Î176¹ÔÌÜÉÕ¶á¤Ë¤¢¤ë

#LoadModule php7_module libexec/apache2/lib7.so

¤Î¥³¥á¥ó¥È(#)¤ò³°¤·¤ÆÊݸ¡¢Apache¤òºÆµ¯Æ°¡£

(¸Å¤¤¾ì¹ç¤Ïlibphp5.so¤È¤Ê¤Ã¤Æ¤¤¤ë¾ì¹ç¤â¤¢¤ë¤Î¤Ç¡¢¡Öphp¡×¤Ç¸¡º÷¡£)

PHP¤¬Æ°¤¤¤Æ¤¤¤ë¤«¤Î³Îǧ¤Ï

¡ã?php
phpinfo() ;
?¡ä

¤Ç¥è¥«¥í¥¦¡£

ÀIJèÌ̤ˡÖPHP Version 7.1.23¡×¤Ê¤É¤Èɽ¼¨¤µ¤ì¤ë¥Ï¥º¡£

¡ãApache¤Î¼«Æ°µ¯Æ°¡ä

¾å½Ò¤Î¤è¤¦¤Ë¡¢Apache¤Ï¼«Æ°µ¯Æ°¤µ¤ì¤Ê¤¤¡£

Mac¤Îµ¯Æ°¤ÈƱ»þ¤ËApache¤âµ¯Æ°¤µ¤»¤¿¤¤¾ì¹ç¤Ï¡¢

sudo launchctl load -w /System/Library/LaunchDaemons/org.apache.httpd.plist

¤ò¼Â¹Ô¤¹¤ë¡£


Mac¤¬µ¯Æ°¤¹¤ì¤Ð¡¢¥í¥°¥¤¥ó¤·¤Ê¤¯¤Æ¤â¡¢Apache¤Ïµ¯Æ°¤·¤Æ¤¤¤ë¡£

µ¯Æ°
sudo apachectl start

Ää»ß
sudo apachectl stop

ºÆµ¯Æ°
sudo apachectl restart

¡ãMySQL¡ä

¥Þ¥Å¡¢°Ê²¼¤òŽ¤êÉÕ¤±¡£

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

´ØÏ¢¡§Homebrew(macOS Íѥѥ屡¼¥¸¥Þ¥Í¡¼¥¸¥ã¡¼)

²«¿§Ê¸»úÅù¤Î¸å¡¢

brew install mysql

MySQL¤Îµ¯Æ°

mysql.server start

¡ÖSUCCESS!¡×¤Èɽ¼¨¤µ¤ì¤ë¡£

MySQL¤Î¥æ¡¼¥¶¡¼(root)¤Î¥Ñ¥¹¥ï¡¼¥É¤¬¤Ê¤¤¤Î¤ÇÀßÄꤹ¤ë¡£

mysql_secure_installation

¥Ñ¥¹¥ï¡¼¥É¤ò²¾¤Ë¡ÖWeSe@123456789¡×¤È¤¹¤ë¡£

¥í¥°¥¤¥ó¸å¤Ë¥Ñ¥¹¥ï¡¼¥É¤òÊѹ¹¤¹¤ë¾ì¹ç¤Ï¡¢

mysql¤Ë¥í¥°¥¤¥ó

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'WeSe@123456789';

¥«¥ó¥¿¥ó¤Ê¥Ñ¥¹¥ï¡¼¥É¤À¤È°Ê²¼¤¬ÅǤ«¤ìǧ¤á¤é¤ì¤Ê¤¤¡£

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

exit¤ÇÈ´¤±¤ë¡£

Ää»ß
mysql.server stop

ºÆµ¯Æ°
mysql.server restart

MySQL¤ÏMac¤Îµ¯Æ°»þ¤Ë¼«Æ°µ¯Æ°¤µ¤ì¤Ê¤¤¤Î¤Ç¡¢

brew tap homebrew/services

brew services start mysql

¤Ç¼«Æ°µ¯Æ°¡£

¤Î¥Ï¥Å¤¬¡¢

Error: Failure while executing; `/bin/launchctl enable gui/501/homebrew.mxcl.mysql` exited with 112. ¤ÇÉԲġ£

Mac¤Ë¸þ¤«¤Ã¤Æ¥í¥°¥¤¥ó¤·¤Ê¤¤¤ÈMySQL¤Ïµ¯Æ°¤·¤Ê¤¤¡£

¡¦Apache¡§¥í¥°¥¤¥óÉÔÍ×
¡¦PHP¡§¥í¥°¥¤¥óÉÔÍ×
¡¦MySQL¡§¥í¥°¥¤¥óɬÍ× (¥Ç¡¼¥¿¥Ù¡¼¥¹Àܳ³ÎΩ¥¨¥é¡¼)

¼«Æ°µ¯Æ°¤ò»ß¤á¤ë¾ì¹ç¤Ï

brew services stop mysql

¤Ç¤¢¤ë¡£

brew services list

Status¤Î¹àÌܤ¬started¤Ç¤¢¤ì¤ÐÍ­¸ú²½¡¢stopped¤Ç¤¢¤ì¤Ð̵¸ú²½¤µ¤ì¤Æ¤¤¤ë¡£

php¤¬stopped¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤¬²¿¸Î¤«Macµ¯Æ°»þ¤ËΩ¤Á¾å¤¬¤ë¡£

¡ãphpMyAdmin¡ä

brew install phpmyadmin

phpMyAdmin¤Î¥À¥¦¥ó¥í¡¼¥É

phpMyAdmin-4.9.0.1-all-languages.zip

¤ò²òÅà¸å¡¢phpmyadmin¤È¥ê¥Í¡¼¥à¤·¤Æwww¤Ë°ÜÆ°¡£

¤½¤Î¤Þ¤Þ¤À¤È Forbidden ¤Ë¤Ê¤ë¤Î¤Ç¡¢

chmod -R 775 phpmyadmin

¤È¤¹¤ë¡£

phpmyadminÆâ¤Ë¤¢¤ëconfig.sample.inc.php¤òconfig.inc.php¤Ë¥ê¥Í¡¼¥à¡£

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
¢­½ñ¤­´¹¤¨¢­
$cfg['blowfish_secret'] = 'ABCDEFG-ABCDEFG-ABCDEFG-ABCDEFG-ABCDEFG-ABCDEFG-ABCDEFG-ABCDEFG';

¢¬Ã»¤¯¤Æ¤âÆ°¤¯¤¬¥¨¥é¡¼¤¬¾ï¤Ëɽ¼¨¤µ¤ì¥¦¥Å¥¡¤ð¡£

$cfg['Servers'][$i]['host'] = 'localhost';
¢­½ñ¤­´¹¤¨¢­
$cfg['Servers'][$i]['host'] = '127.0.0.1';

¢¬¤³¤¦¤·¤Ê¤¤¤ÈphpMyAdmin¤Ë¥í¥°¥¤¥ó¤Ç¤­¤Ê¤¤¡£

°Ê²¼¤Ë¥¢¥¯¥»¥¹¤·¡¢

http://192.168.0.xx/phpmyadmin/

root/WeSe@123456789 ¤Ç¥í¥°¥¤¥ó¡£

$cfg['TempDir'] (./tmp/) ¤Ë¥¢¥¯¥»¥¹¤Ç¤­¤Þ¤»¤ó¡£
phpMyAdmin ¤Ï¥Æ¥ó¥×¥ì¡¼¥È¤ò¥­¥ã¥Ã¥·¥å¤¹¤ë¤³¤È¤¬¤Ç¤­¤Ê¤¤¤¿¤á¡¢Ä㮤ˤʤê¤Þ¤¹¡£


¤È¤¤¤¦¥¨¥é¡¼¤¬¥¦¥Å¥¡¤ð¾ì¹ç¤Ï¡¢

phpmyadmin¤Ëtmp(¥Õ¥©¥ë¥À)¤òºîÀ®¤·¡¢tmp¤Î¥¢¥¯¥»¥¹¸¢¤òÊѹ¹(±¦¥¯¥ê¥Ã¥¯¡ä¾ðÊó¤ò¸«¤ë¡äºÇ²¼Éô¡äeveryone¤ËÆɤß/½ñ¤­)

¡ãWordPress¡ä

WordPress¤Î¸ø¼°¤«¤é

wordpress-5.2.2-ja.zip

¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤Æ²òÅà¡¢www¤Î²¼¤Ëwordpress¤òÆþ¤ì¤ë¡£

Apache,PHP,MySQL¤¬µ¯Æ°¤·¤¿¾õÂ֤ǡ¢

phpMyAdmin¤Ç¡Öwordpress¡×¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤·¤Æ¤ª¤¯¡£

http://192.168.0.xx/wordpress/

¤Ë¥¢¥¯¥»¥¹¡£

Forbidden¤Ê¤Î¤Ç

chmod -R 777 wordpress

WordPress¤Î¥»¥Ã¥È¥¢¥Ã¥×²èÌÌ¡£

WordPress¤ÎÀßÄ곫»Ï²èÌÌ_001

¾ðÊó¤òÆþÎÏ¡£

WordPress¤ÎÀßÄ곫»Ï²èÌÌ_002

¢¬¥Û¥¹¥È̾¤ËÃí°Õ¡ªlocalhost

¥Õ¥¡¥¤¥ë wp-config.php ¤Ë½ñ¤­¹þ¤á¤Þ¤»¤ó¤Ç¤·¤¿¡£

¤È¤Ê¤ë¾ì¹ç¤Ï¡¢wordpressÆâ¤Ëwp-config.php¤òºîÀ®¤·¡¢¼¨¤µ¤ì¤¿ÆâÍƤòŽ¤ë¡£

wp-config.php¤Ë½ñ¤­¹þ¤á¤Þ¤»¤ó¤Ç¤·¤¿

¾å½Ò¤Î chmod -R 777 wordpress ¤ò¹Ô¤Ã¤Æ¤¤¤ì¤Ð½Ð¤Ê¤¤¥Ï¥º¡£

¤·¤«¤·¡¢¥Æ¡¼¥Þ¤ä¥×¥é¥°¥¤¥ó¤Î¥¤¥ó¥¹¥È¡¼¥ë¤äºï½ü¤Ê¤É¤¬¤Ç¤­¤Ê¤¤(FTP±¾¡¹¤¬½Ð¤ë)¤Î¤Ç¡¢

wp-config.php¤ÎºÇ¸å¤Ë°Ê²¼¤Î1¹Ô¤òÄɲ乤롣

define('FS_METHOD','direct') ;

¡ã¥¢¥¯¥»¥¹¸¢¡ä

www¤ò chmod -R 777 wordpress ¤È¤·¤Æ¤·¤Þ¤¦¤È¡¢Á´°÷¥Õ¥ë¥¢¥¯¥»¥¹¤Ç³Ú¤Ë¤Ê¤ë¤È»×¤¨¤ë¤¬phpMyAdmin¤Ç·Ù¹ð¤¬½Ð¤Æ»È¤¨¤Ê¤¯¤Ê¤ë¡£

°Ê¾å¡£

ÀµÄ¾¡¢Â¾¤Ç»ª¤òºî¤ë¤è¤êÌÌÅÝ¡ªMac¤Ï¥¯¥Å¥©¡ª¡ª

´ØÏ¢¡§[Mac] PHP¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°Û¤Ê¤ëÌäÂê [HighSierra]

´ØÏ¢¡§Ubuntu 18.04.2 LTS¤Î32¥Ó¥Ã¥ÈÈÇ

[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



2Ëü±ß°Ê²¼¤Î·ã°Â¥µ¡¼¥Ð¡¼¤ò¾Ò²ð¤·¤è¤¦¡£

ÉÙ»ÎÄÌ PRIMERGY MX130 S2

PRIMERGY MX130 S2

19,800±ß¤¬¡¢2,000±ß°ú¤­¥¯¡¼¥Ý¥ó»ÈÍѤÇ17,800±ß¡ª¡ª

ºß¸Ë¶Ï¾¯¡ª

OS¥ì¥¹¥¿¥¤¥×¤À¤¬¡¢¼«Ê¬¤ÇLinuxÆþ¤ì¤ë¤«¤éÉÔÍפÀ¤·¤Í¡£

CPU¤â¥á¥â¥ê¡¼¤â¥Ï¡¼¥É¥Ç¥£¥¹¥¯(250GB)¤âDVD-ROM¥É¥é¥¤¥Ö¤âºÜ¤Ã¤Æ¤¤¤ë¤«¤é¡¢¤¢¤È¤ÏLinux¤ò¾Æ¤¤¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤À¤±¡£

·ã°Â¥µ¡¼¥Ð¡¼¤Ï¥¿¥ï¡¼·¿¤¬ÂçȾ¤À¤¬¡¢¤É¤¦¤·¤Æ¤â¼ÙËâ¤Ë¤Ê¤ë¡£

¤½¤ó¤ÊÃæ¡¢¥¹¥ê¥à·¿½ÄÃÖ¤­²Äǽ¤Ê¥µ¡¼¥Ð¡¼¤Ï¥¤¥¤¤Í¡£

¸«¤¿Ìܤ¬NASÉ÷¤Î¥µ¡¼¥Ð¡¼¤â¤¢¤ë¤è¡£

HP ProLiant MicroServer Turion II NEO N5

HP ProLiant MicroServer Turion II NEO N5

16,980±ß¤¬¡¢1,000±ß°ú¤­¥¯¡¼¥Ý¥ó»ÈÍѤÇ15,980±ß¡ª¡ª

¤³¤Á¤é¤âºß¸Ë¶Ï¾¯¡ª

¤³¤Á¤é¤ÏCPU¡¢¥á¥â¥ê¡¼¡¢¥Ï¡¼¥É¥Ç¥£¥¹¥¯(500GB)¤Ï¤¢¤ë¤¬¡¢¸÷³Ø¥É¥é¥¤¥Ö¤¬¤Ê¤¤¤Î¤ÇÍÑ°Õ¤¹¤ë¤«¡¢USB¥á¥â¥ê¡¼¤«¤é¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ì¤Ð¤è¤¤¡£

Linux¤òÆþ¤ì¤Æ¥Õ¥¡¥¤¥ë¥µ¡¼¥Ð¡¼¤Ë¤·¤Æ¤â¥è¥·¡¢MySQL¤òÆþ¤ì¤ÆDB¤Î³Ø½¬ÍѤˤ·¤Æ¤â¥è¥·¡ª

¥µ¡¼¥Ð¡¼¤Î´ÉÍý¤Ï¡¢¥Ï¡¼¥É¤ò´Þ¤á¤¿Ã챤¬É¬ÍפǤ¢¤ë¤È¡¢»ä¤Ï¹Í¤¨¤Æ¤¤¤ë¡£

¤½¤ì¤Ê¤é¤Ð¡¢¤ä¤Ï¤ê¼Âµ¡¤À¡£



MySQLÁ´µ¡Ç½¥Ð¥¤¥Ö¥ë ~¸½¾ì¤ÇÌòΩ¤ÄAtoZ~
ÎëÌÚ ·¼½¤
µ»½ÑɾÏÀ¼Ò
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 61,578


¼ÂÁ©¥Ï¥¤¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹MySQL Âè3ÈÇ
Baron Schwartz Peter Zaitsev Vadim Tkachenko
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 112,943


[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



Debian¤Î¥ß¥é¡¼¤ÎÊÒÊý¤ËÉÔÎÉ¥»¥¯¥¿¤¬È¯À¸¤·¤¿(ÂåÂؽèÍýÂÔ¤Á¤Î¥»¥¯¥¿)¡£

Current Pending Sector Count

ÂåÂؽèÍýÂÔ¤Á¤Î¥»¥¯¥¿¤Î¿ô¤Ç¤¹¡£

ÂåÂؽèÍýÂÔ¤Á¤Î¥»¥¯¥¿¤Î¿ô¤Ç¤¹¡£

ÂåÂؽèÍýÂÔ¤Á¤Î¥»¥¯¥¿¤¬·ë²ÌŪ¤ËÆɤ߹þ¤ß¤Þ¤¿¤Ï½ñ¤­¹þ¤ß¤ËÀ®¸ù¤·¤¿¾ì¹ç¡¢¤³¤ÎÃͤϸº¤ê¥»¥¯¥¿¤ÏÂåÂؽèÍý¤µ¤ì¤Þ¤»¤ó¡£
¥»¥¯¥¿¤ÎÆɤ߼è¤ê¥¨¥é¡¼¤Ï¥»¥¯¥¿¤òÂåÂؽèÍý¤·¤Þ¤»¤ó¡£
½ñ¤­¹þ¤ß¤Ë¼ºÇÔ¤·¤¿¾ì¹ç¤Î¤ßÂåÂؽèÍý¤µ¤ì¤Þ¤¹¡£


ÆÍÁ³¤Î¥Ð¥Ã¥É¥»¥¯¥¿¤ÎȯÀ¸¡£

¸¶°ø¤ÏÇ®¤«¤Ê¡©

»ä¤Ï¡Ö¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤ÏÇ®¤Ë¼å¤¤¡×¤È¤¤¤¦Ç§¼±¤ò»ý¤Ã¤Æ¤ª¤ê¡¢¼ÂºÝ¤½¤¦¤À¤È»×¤¦¡£

¤¬¡¢°·¤Ã¤¿Âæ¿ô¤¬¾¯¤Ê¤¯(É´Âæ°Ê¾å¤Ï¤¢¤ë¤¬ÀéÂæ¤Ï¤ª¤½¤é¤¯¤Ê¤¤)¡¢¾ÜºÙ¤Ë¥Ç¡¼¥¿¤ò¼è¤Ã¤¿¤ï¤±¤Ç¤Ï¤Ê¤¤¤·¡¢¥á¡¼¥«¡¼¤Ë¤è¤Ã¤Æ¤â°Û¤Ê¤ë¤À¤í¤¦¡£

Google¤ò»Ù¤¨¤ëµ»½Ñ¤ÎÂè5¾Ï5(224¥Ú¡¼¥¸)¤Ë¡Ö¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Ï¤¤¤Ä²õ¤ì¤ë¤«¡×¤È¤¤¤¦ÆâÍƤ¬¤¢¤ë¡£

¤½¤ì¤Ë¤è¤ë¤È¡¢

¡¦Ä¹¤¯»È¤¦¤È²õ¤ì¤ä¤¹¤¯¤Ê¤ë¤ï¤±¤Ç¤Ï¤Ê¤¤¡£

¡¦¤è¤¯»È¤¦¤È²õ¤ì¤ä¤¹¤¯¤Ê¤ë¤È¤â¸Â¤é¤Ê¤¤¡£

¤È¤¤¤¦Í½ÁÛ¤ËÈ¿¤¹¤ë·ë²Ì¤¬½ñ¤«¤ì¤Æ¤¤¤ë¡£

¤½¤ÎÃæ¤Ë¤Ï¡¢

¡¦²¹ÅÙ¤¬¹â¤¤¤Û¤É²õ¤ì¤ä¤¹¤¤¤È¤¤¤¦¤³¤È¤â¤Ê¤¤¡£

¤È¤¤¤¦¶Ã¤¯¤Ù¤­(ÄÌÀâ¤ËÈ¿¤¹¤ë)ÆâÍƤ⡣

Failure Trends in a Large Disk Drive Population

S.M.A.R.T.¤Ë´Ø·¸¤Ê¤¯(²¿¤ÎÁ°¿¨¤ì¤â¤Ê¤¯)¸Î¾ã¤¹¤ë¤Î¤â¤è¤¯¤¢¤ë¤³¤È¤Ê¤Î¤Ç¡¢S.M.A.R.T.¤ò²á¿®¤·¤Ê¤¤¤è¤¦¤Ë¡£

¤·¤«¤·¡¢S.M.A.R.T.¤ÎÃͤϤ¢¤Æ¤Ë¤Ê¤é¤Ê¤¤¤«¤â¤·¤ì¤Ê¤¤¤¬¡¢²¿¤«¤·¤é¤ÎÌäÂ꤬À¸¤¸¤Æ¤¤¤ë¤³¤È¤òÃΤë¤Î¤ÏɬÍפÀ¤í¤¦¡£

¤Ê¤ª¡¢Linux¤Ç¤Ï¿¤¯¤Î¾ì¹çɸ½à¤ÇS.M.A.R.T.¤ò¼èÆÀ¤Ç¤­¤ë¤¬¡¢Windows¤Ç¤Ï¼èÆÀ¤Ç¤­¤Ê¤¤¡£

ȯÀ¸¤·¤ä¤¹¤¤¤Î¤Ï

05¡§ÂåÂؽèÍýºÑ¤Î¥»¥¯¥¿¿ô
C5¡§ÂåÂؽèÍýÊÝαÃæ¤Î¥»¥¯¥¿¿ô
C6¡§²óÉüÉÔ²Äǽ¥»¥¯¥¿¿ô

¤Î°Û¾ï¤Ç¤¢¤ë¡£

´ØÏ¢¡§¥í¡¼¥ì¥Ù¥ë¥Õ¥©¡¼¥Þ¥Ã¥È¤Ë¤è¤ëS.M.A.R.T.¤ÎÊѲ½(ÂåÂؽèÍýÊÝαÃæ¤Î¥»¥¯¥¿¿ô,ÂåÂؽèÍýÊÝαÃæ¤Î¥»¥¯¥¿¿ô,²óÉüÉÔ²Äǽ¥»¥¯¥¿¿ô)

Ãͤ¬°­²½¤¹¤ë¤À¤±¤Ç¤Ê¤¯¡¢²þÁ±¤¹¤ëÊѲ½¤â¤¢¤ë¡£

¤¬¡¢°ìÅÙÉÔÎɤ¬½Ð¤¿¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Ï¡¢°Ê¸å»ÈÍѤ¹¤Ù¤­¤Ç¤Ï¤Ê¤¤¤À¤í¤¦¡£

¤Þ¤¿¡¢¿·ÉÊ¡á°Û¾ï¥Ê¥·¤È¤Ï¸Â¤é¤Ê¤¤¤Î¤Ç¡¢¿·ÉʤΥϡ¼¥É¥Ç¥£¥¹¥¯¤ò¹ØÆþ¤·¤¿¤È¤·¤Æ¤â¡¢S.M.A.R.T.¤ÎÃͤÏÄ´¤Ù¤Æ¤ª¤³¤¦¡£

S.M.A.R.T.¤Ë¤Ï°Û¾ï¤¬¤Ê¤¯¤Æ¤âÆ°ºî¤¬ÉÔ²º¤Ê¥Ç¥£¥¹¥¯¤¬¤¢¤ë¤Î¤ÇÃí°Õ¡£

¤¤¤º¤ì¤Ë¤·¤Æ¤â¡¢¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Ï¾ÃÌ×ÉʤǤ¢¤ê¤¤¤Ä¤«¤Ï¸Î¾ã¤¹¤ë¤Î¤Ç¡¢¥ß¥é¡¼¥ê¥ó¥°¤Ïɬ¿Ü¤À¤í¤¦¡£

´ØÏ¢¡§¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Ï¾ÃÌ×ÉÊ

¥ß¥é¡¼¥ê¥ó¥°¤Î¾å¡¢¥Ð¥Ã¥¯¥¢¥Ã¥×¤ò¡£

¥ß¥é¡¼¥ê¥ó¥°¤Ï¡Ö¶À¡×¤Ê¤Î¤Ç¡¢¸í¤Ã¤Æ¾Ã¤·¤¿¥Ç¡¼¥¿¤ÏÌá¤é¤Ê¤¤¡£


[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç½ÅÍפÊindex¤Ç¤¢¤ë¤¬¡¢Á´¤Æ¤Îfield¤Ëindex¤òÄêµÁ¤¹¤ë¤Î¤Ï¡¢Â¿¤¯¤Î¾ì¹ç¤Ï̵Â̤Ǥ¢¤ë¡£

ÄêµÁ¤·¤Æ¤â¡¢¤½¤ì¤¬»ÈÍѤµ¤ì¤Ê¤±¤ì¤Ð°ÕÌ£¤¬¤Ê¤¤¡£

index¤òÄêµÁ¤¹¤ë¤³¤È¤Ï¡¢field¤Î¥³¥Ô¡¼¤òºî¤ë¤³¤È¤Ë¶á¤¯¡¢¹¹¿·À­Ç½¤ÎÄã²¼¤ò¾·¤¯¡£

Á´¤Æ¤Îfield¤Ëindex¤òÄɲ乤ì¤Ð¡¢¥Æ¡¼¥Ö¥ë¤¬2¤Ä¤¢¤ë¤Î¤ÈƱ¤¸¤À¡£

½ñ¹þ¤¬È¯À¸¤¹¤ë¤È¡¢Î¾Êý¤Ë½ñ¤­¹þ¤Þ¤Í¤Ð¤Ê¤é¤Ê¤¤(¹¹¿·¤âƱÍÍ)¡£

index¤¬ÌòΩ¤Ä¤«Ê¬¤«¤é¤Ê¤¤¤Î¤Ë¡¢Á´¤Æ¤Îfield¤ËÂФ·¤Æindex¤òÀßÄꤹ¤ë¤Î¤Ï̵ÂÌ¡£

Æɼ褬¥á¥¤¥ó¤Î¾ì¹ç¤Ï¡¢¤Ê¤¤¤è¤ê¤Ï¥Þ¥·¤À¤í¤¦¤¬...

index¤òÀßÄꤷ¤Æ¤âÁ´¤¯»È¤ï¤Ê¤¤¤À¤í¤¦field¤Ï¡¢¤½¤ì¤Û¤É¹Í¤¨¤Ê¤¯¤Æ¤âʬ¤«¤ë¤Ï¤º¤À¡£

¤è¤¯¸«¤ë¤Î¤¬¡¢¼ç¥­¡¼¤Ë¤Ï´û¤Ëindex¤¬¤¢¤ë¤Î¤Ë¡¢¤½¤ì¤È¤ÏÊ̤Ëindex¤òÄêµÁ¤·¤Æ¤¤¤ë¥Ñ¥¿¡¼¥ó¡£

¾éŤÇ̵Â̤Ǥ¢¤ë¡£

¤Ê¤ª¡¢SQL¤Ë¤è¤Ã¤Æ¤Ï¡¢index¤¬Ìò¤ËΩ¤¿¤Ê¤¤(»È¤ï¤ì¤Ê¤¤)¾ì¹ç¤â¤¢¤ë¡£

À«Ì¾¤ÎÀ«¤¬¡ü¤Ï¡¢»æ¤ÎÅÅÏÃÄ¢¤Çõ¤»¤ë¡£

»æ¤ÎÅÅÏÃÄ¢¤Ë¤Ï¡¢À«¤Î½ç¤Çʤó¤Ç¤¤¤ë¤«¤é¤À¡£

¤·¤«¤·¡¢Ì¾¤¬¡ü¤Î¾ì¹ç¤Ï¡¢¤³¤ì¤¬»È¤¨¤Ê¤¤¡£

Á´¤Æ¤ÎÀ«¤ËÂФ·¤Æ¡¢Ì¾¤¬¡ü¤Ç¤¢¤ë²ÄǽÀ­¤¬¤¢¤ë¤«¤é¤À¡£

Ê£¹çindex¤òÀ«(sei),̾(mei)¤Î½ç¤ÇÀßÄꤷ¤Æ¤â¡¢Ì¾¤Ç¤ÎSELECT»þ¤Ë¤ÏÌò¤ËΩ¤¿¤Ê¤¤¡£

ƱÍͤˡ¢Ì¾¤òÂè°ì´ð½à¤Ë¤¹¤ëORDER BY»þ¤Ë¤âÌò¤ËΩ¤¿¤Ê¤¤¡£

SELECT * FROM `user` ORDER BY `mei`,`sei` ;

¤Þ¤¿¡¢LIKE¤Ç'%¡ü'¤ÈÁ°¤Ë%¤òÆþ¤ì¤¿¾ì¹ç(¸åÊý°ìÃ×)¤â¡¢Á´¤Æ¤Ë°ìÃפ¹¤ë²ÄǽÀ­¤¬¤¢¤ë¤Î¤Çindex¤¬ÌòΩ¤¿¤Ê¤¤¡£

'%¡ü%'¤È¶´¤ó¤ÀÃæ´Ö°ìÃפâƱÍÍ¡£

±é»»¤·¤Æ¤ÎÈæ³Ó¤Ê¤É¤â¡¢index¤ÏÌò¤ËΩ¤¿¤Ê¤¤¡£

WHERE `price` * 1.08 > 1000 ;

¤Î¤è¤¦¤Ê¾ì¹ç¡£

index¤Ë¤¢¤ë¥Ç¡¼¥¿¤Ï`price`¤Ç¤¢¤Ã¤Æ`price` * 1.08¤Ç¤Ï¤Ê¤¤¤«¤é¤À¡£

¤³¤ì¤Ï¡¢Î¾ÊÕ¤ò1.08¤Ç³ä¤Ã¤Æ

WHERE `price` > 1000/1.08 ;

¤È¤¹¤ë¤È¡¢index¤¬»ÈÍѤǤ­¤ë¤è¤¦¤Ë¤Ê¤ë¡£

ÈÝÄê·Á(¡ã¡ä)¤ä¡¢IS NULL¡¢OR¤â¡¢index¤¬ÍøÍѤǤ­¤Ê¤¤¡£

⤷¡¢OR¤ÏIN¤Ç½ñ¤­´¹¤¨¤ë¤È¡¢index¤ò»ÈÍѤǤ­¤ë¤è¤¦¤Ë¤Ê¤ë¡£

EXPLAIN¤Ç¡¢ÀßÄꤷ¤¿index¤¬possible_keys¤Ë´Þ¤Þ¤ì¤Æ¤ª¤ê¡¢key¤Ç¼ÂºÝ¤·»ÈÍѤµ¤ì¤Æ¤¤¤ë¤«³Îǧ¤·¤Æ¤ª¤¯¡£



°Ê²¼¤ÎSQL¥¢¥ó¥Á¥Ñ¥¿¡¼¥ó¤Ï¤ª¤¹¤¹¤á¡£

°­Îã¤òÄ󼨤·¤Æ²òÀ⤷¤Æ¤¢¤ë¡£

¤¢¡¼¡¢¤³¤ì¤³¤ì¡¢¤¢¤ë¤¢¤ë¡ª¤ß¤¿¤¤¤Ê£÷£÷£÷£÷£÷

ÌäÂê¤Ê¤¯Æ°¤¤¤Æ¤¤¤ë¤«¤é¡¢¤È¤¤¤¦SQL¤Î½ñ¤­Êý¤ò¤·¤Æ¤¤¤ë¤È¡¢¥ì¥³¡¼¥É¤¬Áý¤¨¤ë¤È½Å¤¯¤Ê¤Ã¤¿¤ê¤·¤Ê¤¤¡©

¤¢¤È¤Î¤³¤È¤ò¹Í¤¨¤Æ¤¤¤Ê¤¤¤Î¤Í¡£

¤Þ¤¿¡¢Í½ÁÛ¤·¤¿·ë²Ì¤¬SELECT¤µ¤ì¤Æ¤¤¤ë¤«¤éOK¡ª¤ÈȽÃǤ·¤¿¤ê¤·¤Æ¤Ê¤¤¡©

ÍÍ¡¹¤Ê¥ì¥³¡¼¥É¤¬Áý¤¨¤Æ¤­¤¿¾ì¹ç¡¢Í½´ü¤·¤Ê¤¤·ë²Ì¤òÊÖ¤·¤Æ¤³¤Ê¤¤¡©

SQL¥¢¥ó¥Á¥Ñ¥¿¡¼¥ó
Bill Karwin
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 7,908


SQLÃæ¤Ç·¿¤ÎÊÑ´¹¤ò¡Ö°Õ¼±¤»¤º¤Ë¡×¤·¤Æ¤·¤Þ¤¤¡¢¤¢¤ì¡©index»ÈÍѤ·¤Æ¤Ê¤¤¡©¤È¤«£÷£÷£÷
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯

¤³¤Î¥Ú¡¼¥¸¤Î¥È¥Ã¥×¥Ø