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

hiboma id:hiboma

innodbã«é–¢ã™ã‚‹hibomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

innotopã§MySQLçŠ¶æ…‹ã‚’topé¢¨ã«è¡¨ç¤ºï¼ˆã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ï¼ï¼‰ - mikedaã®æ—¥è¨˜
innotopã¯MySQLã®çŠ¶æ…‹ã‚’topé¢¨ã«è¡¨ç¤ºã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ DBã‚’1å°ãšã¤è¦‹ã¦ã„ãã¶ã‚“ã«ã¯ç‰¹ã«ä½¿ã†å¿…è¦æ€§ã‚’æ„Ÿã˜ãªã‹ã£ãŸã®ã§ã™ãŒã€ ã‚µãƒ¼ãƒã®ã‚°ãƒ«ãƒ¼ãƒ”ãƒ³ã‚°ï¼†ä¸€æ‹¬è¡¨ç¤ºæ©Ÿèƒ½ãŒã‚ã‚‹ã“ã¨ã‚’çŸ¥ã£ã¦ã“ã‚Œã¯ã‘ã£ã“ã†ä¾¿åˆ©ãªã®ã§ã¯ï¼Ÿã¨æ€ã„ãªãŠã—ãŸã®ã§ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰ã‚°ãƒ«ãƒ¼ãƒ—è¨å®šã¾ã§ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã‚¤ãƒ¡ãƒ¼ã‚¸ ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ã‚¯ã‚¨ãƒªãƒ¼ãƒªã‚¹ãƒˆã‚’è¡¨ç¤º ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³çŠ¶æ…‹ã‚’è¡¨ç¤º ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ â€»ä»Šå›žä½¿ã£ãŸã®ã¯innotop1.8 ï¼† CentOS5.Xã§ã™ã€‚ ä¾å˜ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« # yum install perl-DBI perl-DBD-mysql # rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-4.noarch.r
hiboma 2012/02/08
mysql

innodb
ãƒªãƒ³ã‚¯
InnoDB ã®åœ§ç¸®ã‚’ä½¿ã†ã¨ãã®é‹ç”¨ - ã„ã¡ã„ã®æ—¥è¨˜
.@nippondanji ã•ã‚“ã«ãƒ–ãƒã‚°ã«ã¾ã¨ã‚ã‚ã¨è¨€ã‚ã‚ŒãŸæ°—ãŒã™ã‚‹ã®ã ã‘ã©ã€ã‚ã‚“ã¾å¤§ã—ãŸãƒã‚¿ã§ã¯ãªã„ã§ã™ã€‚ã—ã‹ã‚‚ã€ã“ã®ä½œæ¥ã¯å¤±æ•—ã™ã‚‹å¯èƒ½æ€§ã‚’è¦‹è¶Šã—ã¦ã„ãŸã®ã§ã‚ã¾ã‚Šä½œæ¥ãƒã‚°ã‚’å–ã£ã¦ãªã‹ã£ãŸ...ã€‚ ã®ã§ã€ã¡ã‚‡ã£ã¨ç–‘å•ã«æ€ã£ãŸç‚¹ã‚’å¹¾ã¤ã‹æ›¸ã„ã¦ãŠã“ã†ã‹ã¨æ€ã„ã¾ã™ã€‚ ã§ã‹ã„ InnoDB ãªãƒ†ãƒ¼ãƒ–ãƒ« ã¨ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå¤§ãããªã£ã¦ã—ã¾ã„ã€é‹ç”¨ãŒã‚ã‚“ã©ãã•ãã¦å›°ã£ã¦ã¾ã—ãŸã€‚ mysql> show create table hoge\G *************************** 1. row *************************** Table: hoge Create Table: CREATE TABLE `hoge` ( `date` date NOT NULL, `key` int(10) unsigned NOT NULL, `value` double NOT
hiboma 2011/12/02
mysql

innodb
ãƒªãƒ³ã‚¯
InnoDBã®è¡¨é ˜åŸŸç›£è¦– - MySQL Casual Advent Calendar 2011 - ã¾ã„ã‚“ã ãƒ¼ã®ã¯ã¦ãªãƒ–ãƒã‚°
ã“ã‚“ã°ã‚“ã¯ã“ã‚“ã°ã‚“ã¯!! myfinder ã§ã™ã€‚ MySQL Casual Advent Calendar 2011 å§‹ã¾ã‚Šã¾ã—ãŸ!! 1æ—¥ç›®ã¯è¨€ã„å‡ºã—ãŸè‡ªåˆ†ã‹ã‚‰æ›¸ãã¾ã™ã€‚ ã‚ˆã Casualã˜ã‚ƒãªã„ ã¨ã„ã‚ã‚Œã®ãªã„ãƒ„ãƒƒã‚³ãƒŸã‚’å—ã‘ã‚‹ MySQL Casual ã§ã™ãŒã€Casual Advent Calendar ã¨ã„ã†åå‰ã®é€šã‚Šãƒ©ã‚¤ã‚¿ãƒ¼ã®çš†ã•ã‚“è‡ªèº«ãŒæ°—è»½ã«æ›¸ã‘ã‚‹ãƒã‚¿ã§ã‚µã‚¯ã£ã¨upã™ã‚Œã°OKã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€ç¶¿å¯†ãªæ¤œè¨¼ã«åŸºã¥ã„ãŸã‚¬ãƒãªè¨˜äº‹ã‚‚æ›¸ã‘ã‚‹æ–¹ãŒã„ãŸã‚‰æ˜¯éžãŠé¡˜ã„ã—ã¾ã™ã€‚ ãã‚ã©ã„ãƒã‚¿ã¯ id:kamipo ã•ã‚“ã‚„ id:do_aki ã•ã‚“ãŒãã£ã¨ã‚„ã£ã¦ãã‚Œã‚‹ã®ã§ã€ãŠäºŒäººã«ãŠä»»ã›ã—ã¾ã—ã‚‡ã†ã€‚ ã¯ã˜ã‚ã« MySQL5.5 ã‹ã‚‰ã¯ InnoDB ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ãªã‚Šã¾ã—ãŸã€‚ 4.xã‚„5.1ä»¥å‰ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹æ–¹ã‚‚ã€ä»Šã¨ãªã£ã¦ã¯ InnoDB ã‚’ä½¿ã‚ãªã„ã®ã¯æ•¢ãˆã¦ãã‚Œä»¥å¤–ã‚’
hiboma 2011/12/01
mysql

innodb
ãƒªãƒ³ã‚¯
InnoDBè¡Œãƒãƒƒã‚¯å¾…ã¡ã®ç§’æ•°ã‚’ã‚»ãƒƒã‚·ãƒ§ãƒ³å˜ä½ã§æŒ‡å®šã™ã‚‹[MySQL 5.1, MySQL 5.5ã®å ´åˆ] | ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ãƒ–ãƒã‚°
InnoDBã®è¡Œãƒãƒƒã‚¯å¾…ã¡æ™‚é–“ã¯ç§’å˜ä½ã§innodb_lock_wait_timeoutã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã«æŒ‡å®šã—ãŸæ™‚é–“å¾…ã¤ä»•æ§˜ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚(ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯50ç§’) ãŸã MySQLã§ã¯ã“ã®å¤‰æ•°ã¯ã‚°ãƒãƒ¼ãƒãƒ«ã§ã—ã‹è¨å®šã§ããšã€ä¸€éƒ¨ã®ã‚¯ã‚¨ãƒªã®ãŸã‚ã ã‘ã«ã‚°ãƒãƒ¼ãƒãƒ«è¨å®šã‚’å¤‰æ›´ã™ã‚‹ã®ã¯ã‚¤ãƒ³ãƒ‘ã‚¯ãƒˆãŒå¤§ããã€ç‰¹å®šã®æŽ¥ç¶š(ã‚»ãƒƒã‚·ãƒ§ãƒ³)ã‚„ã‚¯ã‚¨ãƒªå˜ä½ã§è¨å®šã§ããªã„ã‹ã¨ã„ã†æ©Ÿèƒ½è¦æ±‚ãŒã‚ã’ã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚ innodb_lock_wait_timeout is not dynamic, not per session ãƒ“ãƒ«ãƒˆã‚¤ãƒ³ã®InnoDBã§ã¯ã€ã“ã®å‹•ä½œã¯å¤‰ã‚ã‚Šã¾ã›ã‚“ãŒã€Pluginã®InnoDB(MySQL 5.1 + InnoDB Plugin 1.0, ã‚‚ã—ãã¯MySQL 5.5(InnoDB Plugin 1.1))ã§ã¯ã€innodb_lock_wait_timeoutã«ã‚»ãƒƒã‚·ãƒ§ãƒ³å˜ä½ã®ã‚‚ã®ãŒç”¨æ„ã•ã‚Œã€ä»¥ä¸‹
hiboma 2011/08/02
mysql

innodb
ãƒªãƒ³ã‚¯
*roongaæ—ãƒªãƒªãƒ¼ã‚¹ - 2011-06-29 - ã‚¯ã‚¯ãƒã‚°
è‚‰ã®æ—¥ãªã®ã§groongaã¨ãã®é–¢é€£ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ groonga 1.2.3 rroonga 1.2.4 mroonga 0.7ï¼ˆgroongaã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼‰ ã“ã®ã†ã¡ã€mroongaã®å¤‰æ›´ç‚¹ãŒå¤§ãã‚ãªã®ã§ã€mroonga 0.7ã®å¤‰æ›´ç‚¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ mroongaã¨ã¯ mroonga1ã¯MySQLã«groongaã®å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã„ã†ã®ã¯MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢æ©Ÿèƒ½ãƒ»æ¤œç´¢æ©Ÿèƒ½ã‚’æ‹…å½“ã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã“ã¨ã§ã™ã€‚ã“ã“ãŒãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦å¾Œã‹ã‚‰è¿½åŠ ã§ãã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚groongaã‚’ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã—ã¦ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å®Ÿè£…ã—ã¦ã„ã‚‹ã®ãŒmroongaã§ã™2ã€‚ mroongaã‚’ä½¿ã†ã¨å¬‰ã—ã„ã“ã¨ mroongaã‚’ä½¿ã†ã¨ä½¿ã„æ…£ã‚ŒãŸRDBã‚„SQLã‚’ä½¿ã£ã¦å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ãŒå¾—æ„ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾
hiboma 2011/07/01
mysql

innodb

groonga
ãƒªãƒ³ã‚¯
MySQLã§ALTER TABLEæ–‡ã®é€²æ—çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹ - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆã‚’è¡Œã†ã«ã¯ã€ALTER TABLEæ–‡ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚MySQLã®ALTER TABLEæ–‡ã¯ã€å¤‰æ›´å¾Œã®å®šç¾©ã«ã‚‚ã¨ã¥ãä½œæ¥ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã€å¤‰æ›´å‰ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ä½œæ¥ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€æœ€å¾Œã«äºŒã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã‚‹ã¨ã„ã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã«ã¤ã„ã¦ã‚‚ã€ç¾åœ¨ã®ã¨ã“ã‚å¤§åŠã®ã‚±ãƒ¼ã‚¹ã§å†…éƒ¨çš„ã«ALTER TABLEæ–‡ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ã¾ã™ã€‚ ALTER TABLEæ–‡ã®æ€–ã„ã¨ã“ã‚ã¯ã€å‡¦ç†ãŒã‚‚ã†ã™ãçµ‚ã‚ã‚‹ã®ã‹ã©ã†ã‹ãŒåˆ†ã‹ã‚‰ãªã„ã¨ã“ã‚ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºãŒ1GBã‚’è¶…ãˆã‚‹ã‚ãŸã‚Šã‹ã‚‰åˆ†å˜ä½ã®æ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ã«ãªã‚Šã€100GBã¨ã‚‚ãªã‚‹ã¨æœ¬å½“ã«çµ‚ã‚ã‚‹ã®ã‹ï¼Ÿã¨è¦‹ã¦ã„ã¦ä¸å®‰ã«ãªã‚Šã¾ã™ã€‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ™‚é–“ãŒé™ã‚‰ã‚Œã¦ã„ã‚‹å ´åˆã¯ã€ä½œæ¥ã‚’ä¸æ–ã™ã¹ãã‹ã©ã†ã‹é›£ã—ã„åˆ¤æ–ã‚’è¿«ã‚‰ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ å®Ÿã¯ã€ã¨ã„ã†ã»ã©ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ALTER
hiboma 2011/06/15
Handler_write

innodb

mysql
ãƒªãƒ³ã‚¯
Transactions on InnoDB Â» Blog Archive Â» Only God can make random selections
hiboma 2011/04/19
mysql

memcached

innodb
ãƒªãƒ³ã‚¯
1