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

am_eto id:am_eto

mysqlã«é–¢ã™ã‚‹am_etoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

çµæ§‹ä½¿ãˆã‚‹MySQLã®Triggeræ©Ÿèƒ½ï¼
çš†ã•ã‚“ã€ã”ç„¡æ²™æ±°ã—ã¦ãŠã‚Šã¾ã™ã€‚ ãƒ‘ã‚½ã‚³ãƒ³å‘¨è¾ºæ©Ÿå™¨ã«ãŠé‡‘ã‚’ã‹ã‘ã¯ã˜ã‚ã¦ã„ã‚‹ç¬¹äº€ã§ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ãƒ‘ã‚½ã‚³ãƒ³ãŒå•†å£²é“å…·ãªã®ã§ã€ ã‚„ã¯ã‚Šä½¿ã„ã‚„ã™ã„ç‰©ã‚’ä½¿ã„ãŸããªã‚‹ã®ã¯è‡ªç„¶ãªäº‹ã§ã™ãã€‚ ã”å‚è€ƒã¾ã§ã«ã€‚ã€‚ã€‚ ãƒžã‚¦ã‚¹ã€€ã€€ï¼šLogicool MX Revolutionï¼ˆãƒ“ãƒƒã‚¯ã‚«ãƒ¡ãƒ©ã§ãƒã‚¤ãƒ³ãƒˆã§è³¼å…¥ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ï¼šBluetooth Macç”¨ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ï¼ˆä¼šç¤¾ã®äººã‹ã‚‰å£²ã£ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸw ä»Šå›žã¯Triggerã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ãŸã„ã¨ãŠã‚‚ã„ã¾ã™ã€‚ Triggerã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®å¤‰æ›´ãªã©ã®ã‚¤ãƒ™ãƒ³ãƒˆã«ã‚ˆã£ã¦ã‚ã‚‰ã‹ã˜ã‚æŒ‡å®šã—ãŸå‡¦ç†ã‚’è‡ªå‹•çš„ã«å®Ÿè¡Œã™ã‚‹æ©Ÿèƒ½ã§ã™ã€‚ æœ€è¿‘ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯å¿…ãšå‚™ãˆã¦ã‚ã‚‹æ©Ÿèƒ½ã§ã™ã€‚ Oracle,Postgres,MySQLã§ã‚‚å½“ãŸã‚Šå‰ã®ã‚ˆã†ã«ã‚ã‚Šã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã©ã®ã‚ˆã†ãªã¨ãã«ä½¿ç”¨ã™ã‚‹ã‚‚ã®ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãƒ»ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã®å‡¦ç†ã®ãƒã‚°ã‚’ã¨ã‚‹ãŸã‚ ãƒ»ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’
am_eto 2011/06/08
mysql

tips

trigger
ãƒªãƒ³ã‚¯
brianmario/mysql2: A modern, simple and very fast Mysql library for Ruby - binding to libmysql
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
am_eto 2011/04/06
mysql

library

ruby

database
ãƒªãƒ³ã‚¯
MySQLã®RANGEãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½¿ã† | æ‘å¼æµ ã‚¤ãƒƒãƒ‘ã‚·ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¸ã®é“
MySQLã®RANGEãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®ãŠè©±ã§ã™ã€‚ MySQL5.1ã‹ã‚‰ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã§ã™ãŒã€ãƒã‚°ãƒ†ãƒ¼ãƒ–ãƒ«ç‰ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šããªã‚ŠãŒã¡ãªãƒ†ãƒ¼ãƒ–ãƒ«ã«æ—¥ä»˜ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã—ã¦ã¾ã™ã€‚ æœ€åˆã‹ã‚‰é ã„æœªæ¥ã¾ã§ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’åˆ‡ã‚‹ã®ã¯æ°—æŒã¡æ‚ªã„ã—ã€é•·ãé‹ç”¨ã•ã‚Œã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã¯å¿˜ã‚Œã‚‹å¯èƒ½æ€§ã‚‚ã‚ã‚‹ã®ã§ãƒãƒƒãƒã‚’å›žã™ã®ãŒã„ã„ã¨æ€ã„ã¾ã™ãŒè¿½åŠ ã™ã‚‹å ´åˆã®æ‰‹é †ã¨æ³¨æ„ç‚¹ã§ã™ã€‚ ãƒ»ã¾ãšã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½œæˆ CREATE TABLE `mura`.`test1` ( `date` DATE NOT NULL , `name` VARCHAR( 40 ) NOT NULL , `contents` VARCHAR( 255 ) NOT NULL , `created_at` DATETIME NOT NULL ) ENGINE = InnoDB PARTITION BY RANGE (TO_
am_eto 2011/03/01
mysql

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

database

é–‹ç™º

tips
ãƒªãƒ³ã‚¯
HugeDomains.com
clover-studio.com is for sale Please prove you're not a robot
am_eto 2010/09/02
CakePHP

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

ç®¡ç†

mysql

ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ãƒ¼
ãƒªãƒ³ã‚¯
okuhitonã®æ—¥è¨˜
iphone4sã«ä¹—ã‚Šæ›ãˆãŸ ã‚¢ãƒ‰ãƒ¬ã‚¹å¸³ã®çš†æ§˜ã«softbank.ne.jpã¨i.softbank.jpã®ã©ã¡ã‚‰ã‚’å‘ŠçŸ¥ã™ã‚‹ã‹ã¡ã‚‡ã£ã¨è¿·ã£ãŸã€‚ ã„ã‚ã„ã‚ã¨èª¿ã¹ã¦ã€æ„å¤–ã¨ã“ã¡ã‚‰ã®ãƒ–ãƒã‚°ã§ãªã‚“ã‹ç´å¾—ã—ãŸ ç¢ºã‹ã«ãƒ‡ã‚³ãƒ¡ä½¿ãˆãªã„ã®ã¯çµæ§‹ã§ã‹ã„ã€‚ãŸã„ã—ã¦ãƒ¡ãƒ¼ãƒ«ã‚’ã‚„ã‚Šå–ã‚Šã™ã‚‹äººã‚‚ã€ãƒ‡ã‚³ãƒ¡ã§æ¥ã‚‹äººã‚‚ã„ãªã„ãŒã€0ã§ã¯ãªã„ã€‚ å‘¨ã‚Šã‚‚ä»Šã ã«DocomoãŒå¤§åŠãªã®ã¯äº‹å®Ÿã€‚softbankä½¿ã£ã¦ã‚‹äººã¯iphoneãŒã»ã¨ã‚“ã©ã ã€‚ ãã®ã¸ã‚“ã‚’ã¾ã‚“ã¹ã‚“ãªãæ•‘ã†ãªã‚‰ã€å‘ŠçŸ¥ã¯i.softbank.jpã€‚å‹¢ã„ã‚ˆãã‚„ã‚Šã¨ã‚Šã™ã‚‹ç‰¹å®šã®ãƒ¡ãƒ³ãƒ(å¦»ã€ã»ã‚“ã¨ä»²ã„ã„iphoneã®äºº)ã ã‘softbank.ne.jpã‚’ã‚ã¨ã‹ã‚‰åˆ¥ã§æ•™ãˆã‚‹ã€‚ã§è½ã¡ç€ã„ãŸã€‚ãã£ã¨30å‰å¾Œãã‚‰ã„ã®iphoneãƒ¦ãƒ¼ã‚¶ã®ãƒªã‚¢ãƒ«ãªè½ã¨ã—ã©ã“ã‚ã˜ã‚ƒãªã„ã‹ã¨ã€‚ MMS:softbank.ne.jp ãƒ¡ãƒªãƒƒãƒˆ ãƒ—ãƒƒã‚·ãƒ¥ã§å³åº§ã«ã€é€£ç¶šã§ã‚„ã‚Šå–ã‚Šã§ãã‚‹ã€‚ãƒãƒ£ãƒƒãƒˆæ„Ÿè¦šã€‚ ãƒ¡ã‚¢ãƒ‰ãŒç¢º
am_eto 2010/08/26
DB

mysql

Maatkit

Cassandra

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
dfltweb1.onamae.com â€“ ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚
ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ ãŠåå‰.com ã‹ã‚‰å–å¾—ã•ã‚Œã¾ã—ãŸã€‚ ãŠåå‰.com ã¯ GMOã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚°ãƒ«ãƒ¼ãƒ—(æ ª) ãŒé‹å–¶ã™ã‚‹å›½å†…ã‚·ã‚§ã‚¢No.1ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ â€»è¡¨ç¤ºä¾¡æ ¼ã¯ã€å…¨ã¦ç¨Žè¾¼ã§ã™ã€‚ â€»ã‚µãƒ¼ãƒ“ã‚¹å“è³ªç¶æŒã®ãŸã‚ã€ä¸€æ™‚çš„ã«å¯¾è±¡ã¨ãªã‚‹æ–™é‡‘ã¸ä¸€å®šå‰²åˆã®ã€Œã‚µãƒ¼ãƒ“ã‚¹ç¶æŒèª¿æ•´è²»ã€ã‚’åŠ ç®—ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ â€»1 ã€Œå›½å†…ã‚·ã‚§ã‚¢ã€ã¯ã€ICANN(ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ‰ãƒ¡ã‚¤ãƒ³åãªã©ã®è³‡æºã‚’ç®¡ç†ã™ã‚‹éžå–¶åˆ©å›£ä½“)ã®å…¬è¡¨æ•°å€¤ã‚’ã‚‚ã¨ã«é›†è¨ˆã€‚gTLDãŒé›†è¨ˆã®å¯¾è±¡ã€‚ æ—¥æœ¬ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²æ¥è€…(ãƒ¬ã‚¸ã‚¹ãƒˆãƒ©)ï¼ˆã€ŒICANNãŒãƒ¬ã‚¸ã‚¹ãƒˆãƒ©ã¨ã—ã¦èªå®šã—ãŸä¼æ¥ã€ä¸€è¦§ï¼ˆInterNICæä¾›ï¼‰å†…ã«ã€ŒJapanã€ã®è¨˜è¼‰ãŒã‚ã‚‹ã‚‚ã®ï¼‰ã‚’å¯¾è±¡ã€‚ ãƒ¬ã‚¸ã‚¹ãƒˆãƒ©ã€ŒGMO Internet Group, Inc. d/b/a Onamae.comã€ã®ã‚·ã‚§ã‚¢å€¤ã‚’é›†è¨ˆã€‚ 2023å¹´10æœˆæ™‚ç‚¹ã®èª¿æŸ»ã€‚
am_eto 2010/08/06
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLTunerã‚’ä½¿ã£ã¦MySQLã‚’é€Ÿãã™ã‚‹ | ï¾Œï¾žï½°ãƒã‚°
MySQLTunerã¯MySQLã‚’è¨ºæ–ã—ã¦ã€ã„ã‚ã„ã‚ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã—ã¦ãã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã€‚perlã‚¹ã‚¯ãƒªãƒ—ãƒˆã§æä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç°¡å˜ã«å®Ÿè¡Œã§ãã‚‹ã€‚ãªãŠWindowsã§ã¯å‹•ã‹ãªã„ã‚‰ã—ã„ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦å®Ÿè¡Œã™ã‚‹ã€‚ $ wget http://mysqltuner.com/mysqltuner.pl $ chmod +x mysqltuner.pl $ ./mysqltuner.pl ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã€‚ >> MySQLTuner 0.9.9 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter y
am_eto 2010/08/06
mysql

tips

DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
SET NAMESã¯ç¦æ¢
(Last Updated On: )MySQLã«ã¯æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹ã€ŒSET NAMESã€SQLæ–‡ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆPostgreSQLã‚‚åŒæ§˜ã®SQLæ–‡ã€SET CLIENT_ENCODINGãŒã‚ã‚Šã¾ã™ï¼‰ã“ã®æ©Ÿèƒ½ã¯SQLã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰ã¯ä½¿ã£ã¦ã‚ˆã„æ©Ÿèƒ½ã§ã™ãŒã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„æ©Ÿèƒ½ã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«è„†å¼±ã«ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Ruby on Railsã®æœ¬ã‚’èªã‚“ã§ã„ã¦ã€ActiveRecordã‚’èª¬æ˜Žã—ã¦ã„ã‚‹éƒ¨åˆ†ã«MySQLã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹å ´åˆã®ä¾‹ã¨ã—ã¦SET NAMESãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯SET NAMESã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„äº‹ã‚’å‘¨çŸ¥ã•ã›ã‚‹ã®ã¯çµæ§‹æ™‚é–“ãŒå¿…è¦ã‹ãªã¨æ€ã„ã¾ã—ãŸã€‚ PHPã‚‚5.2ã®é€”ä¸ã‹ã‚‰MySQLãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«libmysqlã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¨å®šAPIã®ãƒ©ãƒƒãƒ‘ãƒ¼é–¢æ•°ãŒè¿½åŠ ã•ã‚Œã¦ã„ãŸã‚Šã™ã‚‹
am_eto 2010/08/05
mysql

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

php
ãƒªãƒ³ã‚¯
PHPã§å¤§è¦æ¨¡ãƒ–ãƒ©ã‚¦ã‚¶ã‚²ãƒ¼ãƒ ã‚’é–‹ç™ºã—ã¦ã‚ã‹ã£ãŸã“ã¨
2010å¹´6æœˆ26æ—¥ã«è¡Œã‚ã‚ŒãŸã‚¤ãƒ™ãƒ³ãƒˆã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2010 Hokkaidoå†…ã®ã‚»ãƒŸãƒŠãƒ¼ã§ä½¿ã‚ã‚ŒãŸç™ºè¡¨ã‚¹ãƒ©ã‚¤ãƒ‰ã€ŒPHPã§å¤§è¦æ¨¡ãƒ–ãƒ©ã‚¦ã‚¶ã‚²ãƒ¼ãƒ ã‚’é–‹ç™ºã—ã¦ã‚ã‹ã£ãŸã“ã¨ã€Read less
am_eto 2010/07/01
é–‹ç™º

php

è² è·åˆ†æ•£

mysql
ãƒªãƒ³ã‚¯
(ç‰¹ã«MyISAMã‚’ä½¿ã£ã¦ã„ãŸ)ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ãŒInnoDBã‚’ä½¿ã†å ´åˆã®è¨å®šé …ç›® - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
InnoDBã¯MyISAMã¨æ¯”è¼ƒã—ã¦å®‰å…¨(OSã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ãŒç™ºç”Ÿã—ã¦ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå£Šã‚Œãªã„)åˆ†ã€æ›¸ãè¾¼ã¿ãŒé…ã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å±‹ã•ã‚“ã‹ã‚‰ã™ã‚‹ã¨ã€ãã‚Œã¯å½“ç„¶ã®ã“ã¨ã§MyISAMãŒãŠã‹ã—ã„ã‚“ã ã€ã¨ã„ã†ã“ã¨ã«ãªã‚Šã€ã ã‹ã‚‰ãƒãƒƒãƒ†ãƒªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã®ã¤ã„ãŸRAIDã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã†ã‚“ã ã€ã¨ã„ã†è©±ã«ãªã‚‹ã€‚ã§ã‚‚ã€MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ã®ç¾å ´ã§ã¯ã€å ´åˆã«ã‚ˆã£ã¦å¤šå°‘ãƒ‡ãƒ¼ã‚¿ãŒæ¶ˆãˆã¦ã‚‚ã‹ã¾ã‚ãªã„ã‹ã‚‰ã€å®‰ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã§å¤§é‡ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æŒããŸã„... ã£ã¦ä¹–é›¢ãŒã‚ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã‚‹ã€‚ ãã®ã‚ˆã†ãªå ´åˆã«ã¯ã€my.cnf ã® innodb_flush_log_at_trx_commit ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’èª¿æ•´ã™ã‚‹ã“ã¨ã§ã€MyISAMã«æ¯”è‚©ã™ã‚‹æ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹(ãã®ã‹ã‚ã‚Šã€ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ã®å ´åˆã¯ã€è¨å®šã«ã‚ˆã£ã¦ç›´è¿‘ï¼‘ç§’ä»¥å†…ã®å¤‰æ›´ãŒå¤±ã‚ã‚Œã‚‹)ã€‚ ä»–ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚‚å«ã‚ã¦æ›¸ã„ã¦ãŠãã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
am_eto 2009/11/02
database

mysql

tips

è¨å®š

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
am_eto 2009/05/28
mysql

session

database

tips
ãƒªãƒ³ã‚¯
MySQL table patcher
Reads a table creation file (tables.sql) and compares it to what mysqldump gives, and creates SQL clauses to update the database to match the creation file. sqlupdate v1.6.5 - Copyright (C) Joel Yliluoma (http://iki.fi/bisqwit/) Usage: sqlupdate [options] >changes.sql (Creates an update script) Options: -t tablefile Describes the file containing the new sql layout. Default: tables.sql -d database
am_eto 2009/04/07
Ruby on Railsã§ãªãã¨ã‚‚MySQLã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ç®¡ç†ã‚’å¯èƒ½ã«ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚

mysql

migration

ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†
ãƒªãƒ³ã‚¯
1