[B! hirose31] hideokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hideoki id:hideoki

hirose31ã«é–¢ã™ã‚‹hideokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

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

ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«ã¯default-character-setã‚’æŒ‡å®šã—ãŸã„ã‘ã©mysqlbinlogã«ã¯æ€’ã‚‰ã‚ŒãŸããªã„ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
my.cnfã«ã¯[group]ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚°ãƒ«ãƒ¼ãƒ—ãŒæ›¸ã‘ã¦ã€ã‚°ãƒ«ãƒ¼ãƒ—æ¯Žã«è¨å®šãŒã§ãã¾ã™ã€‚ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚°ãƒ«ãƒ¼ãƒ—ã«ã¯ç‰¹æ®Šãª[client]ã¨ã„ã†ã®ãŒã‚ã‚Šã¾ã™ã€‚ [client]ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚°ãƒ«ãƒ¼ãƒ—ã¯ã€ã™ã¹ã¦ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ—ãƒã‚°ãƒ©ãƒ (mysqldã¯é™¤ãï¼‰ã«ã‚ˆã£ã¦è§£èªã•ã‚Œã¾ã™ã€‚ã“ã‚Œã«ã‚ˆã£ã¦å…¨ã¦ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«å½“ã¦ã¯ã¾ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 4.2.6 ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã®ä½¿ç”¨ ãªã®ã§[client]ã«default-character-set = utf8ã¨æ›¸ã„ã¦ãŠã‘ã°ã€(my.cnfã‚’è§£é‡ˆã™ã‚‹)å…¨ã¦ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«default-character-setã‚’ã‚»ãƒƒãƒˆã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ ã¨ã“ã‚ãŒdefault-character-setã‚’è§£ã•ãªã„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®å ´åˆã¯ã‚¨ãƒ©ãƒ¼ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ä¾‹ãˆã°mysql
hideoki 2013/03/14
mysql

hirose31
ãƒªãƒ³ã‚¯
InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã§unique keyãŒã‚ã‚‹å ´åˆã€ãã‚Œã‚’primary keyã«ã™ã‚‹ã¹ãã‹ã©ã†ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
InnoDBãªãƒ†ãƒ¼ãƒ–ãƒ«ã®ãŠè©±ã§ã™ã€‚ ã¨ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã€ã„ãã¤ã‹ã‚ã‚‹ã‚«ãƒ©ãƒ ã®ã†ã¡ã€ãŸã ã²ã¨ã¤ã®ã‚«ãƒ©ãƒ ãŒunique keyã«ãªã‚Šå¾—ã‚‹ã‚‚ã®ã ã¨ã—ã¾ã™ã€‚ ã“ã†ã„ã†ã¨ãã¯ã€ãã®unique keyã¯ç„¡æ¡ä»¶ã§primary keyã«ã—ãŸã»ã†ãŒã‚¤ã‚¤ï¼ã¨æ€ã£ã¦ãŸã‚“ã§ã™ãŒã€èª¿ã¹ã¦ã¿ã‚‹ã¨å¿…ãšã—ã‚‚ãã†ã§ãªã„ã‚ˆã†ãªã®ã§ã€ä»Šã®ã¨ã“ã‚ã®ãƒ¢ãƒ¤ãƒ¢ãƒ¤ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ æ•™ãˆã¦ï¼ å‰ã„äººï¼ï¼ äºˆå‚™çŸ¥è˜ High Performance MySQL ä½œè€…: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Jeremy D. Zawodny,Arjen Lentzå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: Oreilly & Associates Incç™ºå£²æ—¥: 2008/06/01ãƒ¡ãƒ‡ã‚£ã‚¢: ãƒšãƒ¼ãƒ‘ãƒ¼ãƒãƒƒã‚¯è³¼å…¥: 4äºº ã‚¯ãƒªãƒƒã‚¯: 33å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (8ä»¶) ã‚’è¦‹ã‚‹ã‹ã‚‰ã®è¶…æŠœç²‹ã€‚ã—ã‹ã—ã“ã®æœ¬ã¯ç¥žæœ¬
hideoki 2009/07/27
mysql

innodb

hirose31
ãƒªãƒ³ã‚¯
gitã®commitã€pushå¾…ã¡ã®çŠ¶æ…‹ã‚’ãƒ—ãƒãƒ³ãƒ—ãƒˆã«è¡¨ç¤ºã™ã‚‹ã¨çµæ§‹ä¾¿åˆ© - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
gitã®ãƒ–ãƒ©ãƒ³ãƒåã‚’ãƒ—ãƒãƒ³ãƒ—ãƒˆã«è¡¨ç¤ºã™ã‚‹ã¨çµæ§‹ä¾¿åˆ© ã®ç¶šãã€‚ gitã§commitã—å¿˜ã‚Œã€pushã—å¿˜ã‚Œãªã„ã‚ˆã†ã«ã€ _color_() { color=$1; shift echo -e "\e[${color}${@}\e[0m" } fg_black() { _color_ "30m" $@; } fg_BLACK() { _color_ "30;1m" $@; } fg_red() { _color_ "31m" $@; } fg_RED() { _color_ "31;1m" $@; } fg_green() { _color_ "32m" $@; } fg_GREEN() { _color_ "32;1m" $@; } fg_yellow() { _color_ "33m" $@; } fg_YELLOW() { _color_ "33;1m" $@; } fg_blue()
hideoki 2009/07/24
git

hirose31
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (3)

hirose31ã«é–¢ã™ã‚‹hideokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (3)

hirose31ã«é–¢ã™ã‚‹hideokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«ã¯default-character-setã‚’æŒ‡å®šã—ãŸã„ã‘ã©mysqlbinlogã«ã¯æ€’ã‚‰ã‚ŒãŸããªã„ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢

InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã§unique keyãŒã‚ã‚‹å ´åˆã€ãã‚Œã‚’primary keyã«ã™ã‚‹ã¹ãã‹ã©ã†ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢

gitã®commitã€pushå¾…ã¡ã®çŠ¶æ…‹ã‚’ãƒ—ãƒ­ãƒ³ãƒ—ãƒˆã«è¡¨ç¤ºã™ã‚‹ã¨çµæ§‹ä¾¿åˆ© - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (3)

hirose31ã«é–¢ã™ã‚‹hideokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«ã¯default-character-setã‚’æŒ‡å®šã—ãŸã„ã‘ã©mysqlbinlogã«ã¯æ€’ã‚‰ã‚ŒãŸããªã„ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢

InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã§unique keyãŒã‚ã‚‹å ´åˆã€ãã‚Œã‚’primary keyã«ã™ã‚‹ã¹ãã‹ã©ã†ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢

gitã®commitã€pushå¾…ã¡ã®çŠ¶æ…‹ã‚’ãƒ—ãƒãƒ³ãƒ—ãƒˆã«è¡¨ç¤ºã™ã‚‹ã¨çµæ§‹ä¾¿åˆ© - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹