[B! mysql] simpleplayã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

simpleplay id:simpleplay

mysqlã«é–¢ã™ã‚‹simpleplayã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

MySQLã«å¤–éƒ¨ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ - ç™ºå£°ç·´ç¿’
5ã€œ6å›žã¯ä¼¼ãŸã‚ˆã†ãªã“ã¨ã§æ¯Žå›žæ•°æ™‚é–“è²»ã‚„ã—ã¦ã„ã‚‹ã€‚ã¨ã‚Šé éŽãŽã‚‹ã€‚ãƒ¡ãƒ¢ã—ãªã„ã¨ãƒ€ãƒ¡ã ï¼ã€‚ ã‚µãƒ¼ãƒãƒ¼å´ç’°å¢ƒ Debian GNU/Linux wheezy ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ï¼†ã€€è¨å®š % sudo aptitude install mysql-serverãƒã‚°ã¯ /var/log/syslog ã«åãå‡ºã•ã‚Œã‚‹ã€‚è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã¯/etc/mysql/my.cnfã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ /var/lib/mysql ä»¥ä¸‹ã€‚ å¤–éƒ¨ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã€‚/etc/myusql/my.cnfã®bind-addressã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã€‚ bind-address = 0.0.0.0/etc/hosts.allowã«ã¦mysqldã‚’ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã€‚ä»®ã« hogehoge.co.jp ã‚’ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ã¨ã™ã‚‹ã€‚ mysqld: hogehoge.co.jp LOCALmysqldã‚’ç«‹ã¡ä¸Šã’ç›´ã™ã€‚ % su
simpleplay 2012/01/15
mysql
ãƒªãƒ³ã‚¯
mysqlæ–‡å—ã‚³ãƒ¼ãƒ‰ã‚¨ãƒ©ãƒ¼ã®è§£æ¶ˆæ³•æ–¹ - yeyue's diary
Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=':ã¨ã‹ã„ã†ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦å›°ã£ãŸã€‚ã¾ãšã¯ã€MySQLã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®å€¤ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ MySQLã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨€èªžãŒ Latin1 ã«è¨å®šã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è¨å®šã—ãªã‹ã£ãŸå ´åˆã¯ Latin1 ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã€my.cnfã®[mysqld]ã«"character-set-server=utf8"ã‚’è¨å®šã—ã€å†èµ·å‹•ã•ã›ãŸã®ã§ä»¥ä¸‹ã®æ§˜ã«è¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ mysql> show variables like '%character%'; +--------------------------+---------------
simpleplay 2012/01/04
mysql

utf8

mysqld
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã€é‹å–¶ã®æœ€å‰ç·šã§å¾—ã‚‰ã‚ŒãŸãƒŽã‚¦ãƒã‚¦ã€€ï½žãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨é‹ç”¨ã€18ã®ãƒã‚¤ãƒ³ãƒˆï½ž
11æœˆ25æ—¥ã€ã€Œmobidec 2011ã€ã«ãŠã„ã¦ã‚³ãƒŠãƒŸãƒ‡ã‚¸ã‚¿ãƒ«ã‚¨ãƒ³ã‚¿ãƒ†ã‚¤ãƒ³ãƒ¡ãƒ³ãƒˆã®ã‚¹ã‚¿ã‚¸ã‚ªITã‚»ãƒ³ã‚¿ãƒ¼é•·ã§ã‚ã‚‹æ£å»¶å…‰å¼˜æ°ã«ã‚ˆã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€Œå¤§ãƒ’ãƒƒãƒˆSNS ã‚²ãƒ¼ãƒ ã€Žãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã€ã‚’æ”¯ãˆã‚‹ã‚³ãƒŠãƒŸã®ã‚¯ãƒ©ã‚¦ãƒ‰æŠ€è¡“ã®æ´»ç”¨ã€ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€GREEã§æä¾›ã•ã‚Œã¦ã„ã‚‹æºå¸¯é›»è©±å‘ã‘ã®ã‚«ãƒ¼ãƒ‰ã‚²ãƒ¼ãƒ ã‚¿ã‚¤ãƒ—ã®RPGã€‚ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¯ã€ã‚¨ãƒªã‚¢ã”ã¨ã«ã‚ã‚‹è¤‡æ•°ã®ã‚¯ã‚¨ã‚¹ãƒˆã‚’ã‚¯ãƒªã‚¢ã—ã¦ã„ãã€ãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼ã‚«ãƒ¼ãƒ‰ã‚„ã€Œç§˜å®ã€ã‚’æ‰‹ã«å…¥ã‚Œã€ã•ã‚‰ã«ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚«ãƒ¼ãƒ‰ã€ã‚’é›†ã‚ã¦ã„ãã¾ã™ã€‚ã¾ãŸã€ã»ã‹ã®ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¨ãƒãƒˆãƒ«ã™ã‚‹ã“ã¨ã§ã‚‚ç§˜å®ã‚’å…¥æ‰‹ã§ãã‚‹ã¨ã„ã†SNSè¦ç´ ã‚‚å–ã‚Šå…¥ã‚Œã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚2010å¹´9æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹å¾Œã€é †èª¿ã«ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼æ•°ã‚’ä¼¸ã°ã—ã€ç¾åœ¨ã§ã¯ç™»éŒ²äººæ•°ãŒ500ä¸‡äººã‚’è¶…ãˆã¦ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹å½“åˆã¯ç¤¾å†…ã§ã‚µãƒ¼ãƒã‚’æ§‹ç¯‰ã—ã€ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã«6å°ã®ã‚µãƒ¼ãƒã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«3å°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã€ãã—ã¦ãƒãƒ¼ãƒ‰ãƒ
simpleplay 2011/12/28
server

mysql
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
simpleplay 2011/12/02
mysql

db
ãƒªãƒ³ã‚¯
How to use long id in Rails applications?
How can I change the (default) type for ActiveRecord's IDs? int is not long enough, I would prefer long. I was surprised that there is no :long for the migrations - does one just use some decimal?
simpleplay 2011/10/24
migrate

bigint

mysql

rails
ãƒªãƒ³ã‚¯
#isucon ã§å„ªå‹ã—ã¦ãã¾ã—ãŸ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
ãªã‚“ã§ã‚‚ã‚ã‚Šã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é«˜é€ŸåŒ–ãƒãƒˆãƒ«ã€#isucon ã«ä¼šç¤¾ã®åŒåƒš @Songmu @sugyan ã¨3äººã§ã€fujiwaraçµ„ã¨ã—ã¦å‚æˆ¦ã—ã¦ãã¾ã—ãŸã€‚çµæžœã€å¹¸ã„ã«ã‚‚å„ªå‹ã‚’å‹ã¡å–ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã—ãŸã€‚ ã“ã‚“ãªã«æ¥½ã—ã„ã‚¤ãƒ™ãƒ³ãƒˆã‚’ä¼ç”»ã€é‹å–¶ã—ã¦ã„ãŸã ã„ãŸ Livedoor ã®çš†æ§˜ã€æœ¬å½“ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ï¼ ã•ã¦ã€ã–ã£ã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ãŸçµŒéŽãªã©ã‚’è¨˜éŒ²ã—ã¦ãŠãã¾ã™ã€‚ [è¿½è¨˜] ã‚‚ã£ã¨è©³ã—ã„ãƒ¬ãƒãƒ¼ãƒˆã‚’ @Songmu ãŒä¸Šã’ã¦ã„ã‚‹ã®ã§ãã¡ã‚‰ã‚‚ã”è¦§ãã ã•ã„ ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…: #isucon ã§å„ªå‹ã•ã›ã¦ã‚‚ã‚‰ã£ã¦ãã¾ã—ãŸ [ã•ã‚‰ã«è¿½è¨˜] #isucon ã§ã¯ã©ã‚“ãªã“ã¨ã‚’è€ƒãˆãªãŒã‚‰ä½œæ¥ã—ã¦ã„ãŸã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— è‡ªåˆ†ã§ã‚‚ã‚‚ã†å°‘ã—è©³ã—ãæŒ¯ã‚Šè¿”ã‚Šã‚¨ãƒ³ãƒˆãƒªæ›¸ãã¾ã—ãŸã€‚ ã¾ãšèª¬æ˜Žã‚’èžã„ã¦ã€ç’°å¢ƒã‚’ä½œã‚‹ã¨ã“ã‚ã‹ã‚‰ã€‚IPã‚¢ãƒ‰ãƒ¬ã‚¹ã§ã¯ä½œæ¥ãŒã—ã«ãã„ã—äº‹æ•…ã‚‚èµ·ã“ã‚Šãã†ãªã®ã§ã€host
simpleplay 2011/08/29
isucon

cache

mysql
ãƒªãƒ³ã‚¯
Androidã®NFCæ©Ÿèƒ½ã§FeliCaã®èªã¿æ›¸ãã‚’ã™ã‚‹ | âˆ’ã‚†ã‚ãƒã‚°âˆ’ | ã‚†ã‚ã¿ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
simpleplay 2011/07/28
mysql

DB
ãƒªãƒ³ã‚¯
DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
simpleplay 2011/07/22
DB

mysql
ãƒªãƒ³ã‚¯
Androidã®NFCæ©Ÿèƒ½ã§FeliCaã®èªã¿æ›¸ãã‚’ã™ã‚‹ | âˆ’ã‚†ã‚ãƒã‚°âˆ’ | ã‚†ã‚ã¿ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
simpleplay 2011/07/10
innodb

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
PGå‚™å¿˜éŒ² Serversmanã®VPS(CentOS)ã«Ruby on Rails3ã‚’å°Žå…¥ã™ã‚‹
Rails3ã®å°Žå…¥è¨˜éŒ² Serversman ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãƒ—ãƒ©ãƒ³ OS Cent OS(32bit) MySQL 5.0.77 Ruby 1.9.2p0 (2010-08-18 revision 29036) gem (Rubyã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚·ã‚¹ãƒ†ãƒ )1.3.7 gccã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum install gcc Ruby(Rails?)ã§ä¾å˜ã™ã‚‹ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum install zlib-devel openssl-devel readline-devel MySQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum install mysql-server ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç¢ºèª yum info mysql-server MySQLè¨å®š vi /etc/my.cnf -------------------------------------------- [mysql]<--è¿½è¨˜ default-char
simpleplay 2011/05/14
mysql

rails

ruby

server
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: PHPã§æš—å·åŒ–ãƒ»å¾©å·åŒ–ã‚ã‚Œã“ã‚Œ
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
simpleplay 2010/08/16
slow_query_logã§æ™‚é–“ã®ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªãŒåˆ†ã‹ã‚‹ã€‚DBé–¢é€£ã€ãœã‚“ãœã‚“åˆ†ã‹ã‚‰ã‚“ãªã‚ã€‚

mysql

server
ãƒªãƒ³ã‚¯
ã€ã‚¤ãƒ³ãƒ•ã‚©ã‚·ãƒ¼ã‚¯ã€‘Infoseek ï¼š æ¥½å¤©ãŒé‹å–¶ã™ã‚‹ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ
æ—¥é ƒã‚ˆã‚Šæ¥½å¤©ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã¨ã“ã‚å¤§å¤‰ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ãŒã€ç¾åœ¨ã€ç·Šæ€¥ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚’è¡Œã‚ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ãŠå®¢æ§˜ã«ã¯ã€ç·Šæ€¥ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«ã‚ˆã‚Šã€ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã—ã¦ãŠã‚Šã€èª ã«ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã€‚ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒçµ‚äº†æ¬¡ç¬¬ã€ã‚µãƒ¼ãƒ“ã‚¹ã‚’å¾©æ—§ã„ãŸã—ã¾ã™ã®ã§ã€ ä»Šã—ã°ã‚‰ããŠå¾…ã¡ã„ãŸã ã‘ã¾ã™ã‚ˆã†ã€ãŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚
simpleplay 2010/07/26
mysqlã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹æ–¹æ³•

mysql
ãƒªãƒ³ã‚¯
1