[B! Development][innodb] beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

beth321 id:beth321

Developmentã¨innodbã«é–¢ã™ã‚‹beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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ã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
JPOUG> SET EVENTS 20140907 | Japan Oracle User Group (JPOUG)ã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚IIJã•ã¾ã®ã‚»ãƒŸãƒŠãƒ«ãƒ¼ãƒ ã¯çª“ã‹ã‚‰ã®çœºã‚ãŒã™ã°ã‚‰ã—ã„ã§ã™ãã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸIIJã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ŒMySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ã€ã¨é¡Œã—ã¦ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ãªã©ã®èª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã¨ã€èª¿æŸ»ã®ãŸã‚ã«ä½œæˆã—ãŸãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) Lock Inspector 1.0 ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Lists: mysql: Re: InnoDB's inner workings + checkpoints éŽåŽ»è¨˜äº‹ã®è¨‚æ£ @kami
beth321 2014/09/15
development

MySQL

japan

mysql

InnoDB

ãƒãƒƒã‚¯

lock

db

ã‚ã¨ã§èªã‚€

ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼
ãƒªãƒ³ã‚¯
MySQL5.5ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ä½¿ã£ã¦æ™‚ç³»åˆ—ã®ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æ•£ã™ã‚‹ - 256bitã®æ®ºäººãƒ¡ãƒ‹ãƒ¥ãƒ¼
ã¯ã„ã€ä¹™ã‚«ãƒ¬ãƒ¼ã•ã¾ã§ã™ã€‚å¯’ã„æ—¥ãŒç¶šãã¾ã™ãã€‚ ãã—ã¦MySQLã‚‚ç¶šããã†ãªç§ã§ã™ã€‚ å‰å›žã¯ãƒˆãƒªã‚¬ã‚’ã‚„ã£ã¦ã¿ã¾ã—ãŸãŒã€ä»Šåº¦ã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã¿ã¾ã™ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¯ã€ç‰¹å®šã®ã‚«ãƒ©ãƒ æƒ…å ±ã‚’ä½¿ã£ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è«–ç†çš„ï¼ç‰©ç†çš„ã«è‡ªå‹•ã§åˆ†ã‘ã‚‹äº‹ã§ç®¡ç†ã‚’ç°¡å˜ã«ã—ãŸã‚Šã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç¢ºä¿ã™ã‚‹æ©Ÿèƒ½ã®ã“ã¨ã§ã™ã€‚ä¾‹ãˆã°ä»Šå›žã¯ã€æ›´æ–°æ—¥æ™‚ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ã§ã€ç‰¹å®šæœŸé–“ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤ã™ã‚‹ç‰ã®é‹ç”¨ãŒç°¡å˜ã«ãªã‚Šã¾ã™ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚·ãƒ§ãƒ³ã®è¨å®š ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã®è¨å®š ã¾ãšæ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å ´åˆã¯æœ€åˆã«ãƒ‘ãƒ¼ãƒ†ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ã‚«ãƒ©ãƒ ãŒãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ãŒå«ã¾ã‚Œã¦ã„ãªã„ã¨ã„ã‘ãªã„ã®ã§è²¼ã‚Šç›´ã—ã¾ã™ã€‚ mysql> ALTER TABLE usermaster_cs DROP PRIMARY KEY, ADD PRIMARY KEY(user_id, upd_datetime); æ–°è¦ãƒ†ãƒ¼ãƒ–ãƒ«ã®å ´åˆ
beth321 2014/02/08
mysql

development

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³

*ã‚ã¨ã§

database

partitioning

innodb

è¨å®š

ä»•äº‹

sysadmin
ãƒªãƒ³ã‚¯
MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰ã€å¿…ãšç¢ºèªã™ã¹ã10ã®è¨å®š | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«å¿…ãšè¨å®šã‚’ç¢ºèªã—ãªã‘ã‚Œã°ãªã‚‰ãªã„è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿10ã¤ã‚’æŒ™ã’ã€ãã®æ„å‘³ã‚’è§£èª¬ã™ã‚‹ã€‚MySQLã®è¨å®šå¤‰æ›´æ™‚ã®ã€ä¸€èˆ¬çš„ãªæ³¨æ„ç‚¹ã‚‚åˆã‚ã›ã¦ã€‚ January 28, 2014 By Stephane Combaudon æˆ‘ã€…ãŒãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£æŸ»ã®ä»•äº‹ã‚’ã™ã‚‹æ™‚ã«ã¯ã€MySQLã®è¨å®šã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¨æ”¹å–„ææ¡ˆã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã€‚å¤§æŠµã®å ´åˆã€ãŸãã•ã‚“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ä¸ã§ã»ã‚“ã®ã„ãã¤ã‹ã®è¨å®šã—ã‹å¤‰æ›´ã™ã‚‹ã‚ˆã†ã«ææ¡ˆã—ãªã„ã“ã¨ã«ã€å¤šãã®é¡§å®¢ã¯é©šãã€‚ã“ã®è¨˜äº‹ã®ã‚´ãƒ¼ãƒ«ã¯ã€ã‚‚ã£ã¨ã‚‚é‡è¦ãªè¨å®šã‚’ã„ãã¤ã‹æŒ™ã’ã¦ã¿ã‚‹ã“ã¨ã«ã‚ã‚‹ã€‚ æ—¢ã«ã“ã†ã„ã£ãŸææ¡ˆã¯éŽåŽ»ã«ã‚‚ã—ã¦ã„ã‚‹ãŒæ•°å¹´å‰ã®ã‚‚ã®ã§ã€ãã‚Œä»¥æ¥MySQLã®ä¸–ç•Œã§ã¯ãŸãã•ã‚“ã®å¤‰åŒ–ãŒã‚ã£ãŸã®ã ã€‚ è©±ã®å‰ã« ç†Ÿç·´ã—ãŸäººã§ã‚‚ã€é‡å¤§ãªãƒˆãƒ©ãƒ–ãƒ«ã‚’å¼•ãèµ·ã“ã™ãƒŸã‚¹ã‚’ã—ã§ã‹ã™ã“ã¨ãŒã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã“ã“ã«æŒ™ã’ãŸã‚‚ã®ã‚’ç›²ç›®çš„ã«é©ç”¨ã™ã‚‹å‰ã«ã€
beth321 2014/02/03
MySQL

development

#ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

tech

#ä»•äº‹

mysql

db

innodb

è¨å®š

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQL 5.6 ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æ¤œè¨Žä¼š - SH2ã®æ—¥è¨˜
7æœˆ29æ—¥ã«MyNA(æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š)ä¼š 2013å¹´7æœˆãŒè¡Œã‚ã‚Œã€Oracle ACE Directorã®@sheeriã•ã‚“ã€MyNAä¼šé•·ã®@tmtmsã•ã‚“ã«æ··ã–ã£ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é‹å–¶ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã„ã¤ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ Performance Schema - Sheeri Cabral (PDF) MyNAä¼š2013å¹´7æœˆ ã«è¡Œã£ã¦æ¥ã¾ã—ãŸ - MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ - @tmtms ã®ãƒ¡ãƒ¢ ä»Šå›žã¯@yoku0825ã•ã‚“ã€@yyamasaki1ã•ã‚“ãŒãƒ©ã‚¤ãƒˆãƒ‹ãƒ³ã‚°ãƒˆãƒ¼ã‚¯ã‚’ã•ã‚Œã¾ã—ãŸã€‚@yoku0825ã•ã‚“ã‚¢ã‚¤ã‚¹ã”ã¡ãã†ã•ã¾ã§ã—ãŸã€‚ æ—¥ã€…ã®è¦šæ›¸: MyNAä¼š2013å¹´7æœˆã«è¡Œã£ã¦ãã¾ã—ãŸ 5åˆ†ã§ä½œã‚‹MySQL Clusterç’°å¢ƒ ç§ã¯ç™ºè¡¨å†…å®¹ã«ã¤ã„ã¦æ‡‡è¦ªä¼šã§ã„ã‚ã„ã‚å®¿é¡Œã‚’ã‚‚ã‚‰ã£ã¦ã—ã¾ã„ã€ã—ã°ã‚‰ãå¾©ç¿’ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚ã‚ˆã†ã‚„ãä¿®æ£ãŒçµ‚ã‚ã‚Šã¾
beth321 2013/08/06
MySQL

#ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼

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

mysql

db

tuning

Config

development

innodb

self
ãƒªãƒ³ã‚¯
1