[B! mysql] sh-2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sh-2 id:sh-2

mysqlã«é–¢ã™ã‚‹sh-2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

${{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ã§slaveè¿½åŠ æ™‚ã«masterãŒå…¨åŠ›ã§binlogã‚’é€ã£ã¦å›°ã‚‹æ™‚ - As a Futurist...
ãŸã¾ã«ã¯ã—ã‚‡ã†ã‚‚ãªã„ TIPS ã§ã‚‚ã€‚MySQL ã®é…åŠ›ã¨ã„ãˆã°è¨€ã‚ãšã‚‚ãŒãª 10 å¹´ã®æ´å²ã‚’èª‡ã‚‹ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã®ä»•çµ„ã¿ã ã¨æ€ã„ã¾ã™ã€‚ã“ã‚Œã•ãˆã‚ã‚Œã° 1 ã¤ã®çä½“ã§å¿…æ»ã«ãƒ‡ãƒ¼ã‚¿ä¿å…¨ã—ãªãã¦ã‚‚ã‚³ãƒ”ãƒ¼ãŒã„ãã‚‰ã§ã‚‚å¢—ã‚„ã›ã‚‹ã—ã€@nippondanjiã•ã‚“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã«ã‚ã‚‹é€šã‚Šã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¦™æŠ€ã‚’é§†ä½¿ã™ã‚‹ã“ã¨ã§æ§˜ã€…ã«æŸ”è»Ÿãªé‹ç”¨ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ Art of MySQL Replication. slave è¿½åŠ ã¨ã¯ï¼Ÿ ã•ã¦ãã‚“ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ãŒã€å®Ÿé‹ç”¨ã§æœ€ã‚‚å¤šãè¡Œã‚ã‚Œã‚‹ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€Œslave ã®è¿½åŠ ã€ã ã¨æ€ã„ã¾ã™ã€‚è¿½åŠ ã®æ–¹æ³•ã¯å¤§ããåˆ†ã‘ã‚‹ã¨ 2 é€šã‚Šã§ã™ã€‚(ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ InnoDB ã‚’æƒ³å®šã€‚ã¨ã„ã†ã‹ InnoDB ä»¥å¤–èªã‚ã¾ã›ã‚“ï¼žï¼œ) è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’åˆ©ç”¨ mysqldump ç‰ã‚’åˆ©ç”¨ã—ã¦è«–ç†çš„ã«ãƒ‡ãƒ¼ã‚¿ã®é™æ¢æ–é¢ã‚’ä½œã‚‹ï¼†ãã®æ™‚ã® binlog ã®ãƒã‚¸ã‚·ãƒ§ãƒ³ã‚’
sh-2 2016/06/06
mysql

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢

ã‚¤ãƒ³ãƒ•ãƒ©
ãƒªãƒ³ã‚¯
MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’è¦‹ã¦ã‚¹ãƒ¬ãƒ¼ãƒ–åœæ¢ã®åŽŸå› ã‚’èª¿æŸ»ã™ã‚‹
ä»¥å‰ã‚¹ãƒ¬ãƒ¼ãƒ–å´ã®æ›´æ–°ãŒã¨ã¾ã£ã¦ã„ã‚‹ã“ã¨ã«æ°—ä»˜ãã¾ã—ãŸ :x001: ãã®æ™‚ã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã®æ‰‹é †ã§ã™ã€‚ ï¼‘ï¼Žã‚¹ãƒ¬ãƒ¼ãƒ–å´ã§ã€SlaveS tatusã‚’ç¢ºèªã™ã‚‹ ã¾ãšã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã®çŠ¶æ…‹ã‚’ç¢ºèªã—ã€ä½•ãŒåœæ¢ã—ã¦ã„ã‚‹ã‹ã‚’ãƒã‚§ãƒƒã‚¯ã—ã¾ã—ãŸã€‚ mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.xxx.xxx Master_User: xxx Master_Port: xxx Connect_Retry: 60 Master_Log_File: mysql-bin.000009 â†â‘ ã‚¹ãƒ¬ãƒ¼ãƒ–ã®I/Oã‚¹ãƒ¬ãƒƒãƒ‰ãŒç¾åœ¨å‡¦ç†ä¸ã®ãƒžã‚¹ã‚¿ã®ãƒã‚¤ãƒŠ
sh-2 2016/05/22
MySQL

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQL ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒªã‚«ãƒãƒª | Ore no homepage
ç›®é»’å·ã®æ¡œãã‚Œã„ã§ã™ãã€œ(*^^*)â€¦ãªãƒ¼ã‚“ã¦ã‚¬ãƒ©ã˜ã‚ƒãªã„ã“ã¨ã‚’è¨€ã„ãŸããªã‚‹ãã‚‰ã„è‰¯ã„å’²ãã£ã·ã‚Šã§ã—ãŸã‚ˆã€ã‚¨ã‚¨ã€‚ã§ã€æ¥é€±æœ«ã€èŠ±è¦‹ã«è¡Œãã‚“ã ã‘ã©ã€ã¾ã æ•£ã‚‰ãªã„ã§ã»ã—ã„ã£ã™ããƒ¼ã€‚ ãˆãƒ¼ã£ã¨ã€ä¹…ã—ã¶ã‚Šã«MySQLã®è¨˜äº‹ã€‚binlogã‚’ä½¿ã£ãŸãƒªã‚¹ãƒˆã‚¢æ‰‹æ³•ã«ã¤ã„ã¦ã€‚ãƒãƒƒãƒˆã‚’æ¼ã‚‹ã¨MySQLã®é‹ç”¨ã«é–¢ã™ã‚‹è¨˜äº‹ã¯å¤šããƒ’ãƒƒãƒˆã™ã‚‹ã‚“ã ã‘ã©ã€éšœå®³ã‹ã‚‰ã®ãƒ‡ãƒ¼ã‚¿ãƒªã‚«ãƒãƒªã€ç‰¹ã«ãƒãƒ¼ãƒ«ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã‚’æ‰±ã£ãŸè¨˜äº‹ãŒæ€ã£ãŸã‚ˆã‚Šå¤šããªã„ã€‚ãŠã‚Œã¯é‹ãŒè‰¯ã„ã®ã‹æ‚ªã„ã®ã‹MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒªã‚«ãƒãƒªã‚’ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‚ˆã†ãªå±€é¢ã«ä½•åº¦ã‹ç›´é¢ã—ã¦ã„ã‚‹ã®ã§ã€æ‰‹é †ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã‚ˆã†ã‹ãªã€ã¨ã€‚ã“ã“ã§ã¯MySQLã€œ5.5ã‚’å¯¾è±¡ã«ã—ã¦ã„ã‚‹ã€‚ç›´è¿‘ã§ã®æœ€æ–°ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL5.6ãªã‚“ã ã‘ã©ã€ãŠã‚Œã¯ã¾ã 5.6ã«ã¤ã„ã¦å¤§ã—ã¦çŸ¥ã‚‰ãªã„ã€‚5.6ãªã‚‰ã‚‚ã£ã¨ã‚¤ã‚±ã¦ã‚‹ã‚„ã‚Šã‹ãŸãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ã‚ã£ãŸã‚‰ã„ã„ãªã€‚ 0. ç’°å¢ƒ æ¬¡ã®ã‚ˆã†ãªç’°å¢ƒã‚’å‰æã¨ã—ã¦
sh-2 2016/05/21
ã‚¤ãƒ³ãƒ•ãƒ©

datastore

MySQL

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’Serializableã«ã™ã‚‹4ã¤ã®æ–¹æ³•
7. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽˆæ¥ã‚ã‚‹ã‚ã‚‹ ï¼¿ï¼¿ï¼¿_ ï¼ ï¼¼ ï¼ ï¼¼ ï½·ï¾˜ï½¯ . ï¼ ï¼ˆãƒ¼ï¼‰ ï¼ˆãƒ¼ï¼‰ï¼¼ ï¼ âŒ’ï¼ˆ__äºº__ï¼‰âŒ’ ï¼¼ | |râ”¬-| | ï¼¼ `ãƒ¼'Â´ ï¼ ãƒŽ ï¼¼ ï¼Â´ ãƒ½ | ï½Œ ï¼¼ ãƒ½ -ä¸€''''''"~~ï½€`'ãƒ¼--ï½¤ -ä¸€'''''''ãƒ¼-ï½¤. ãƒ½ ï¼¿ï¼¿ï¼¿ï¼¿(âŒ’)(âŒ’)âŒ’) ) (âŒ’ï¼¿(âŒ’)âŒ’)âŒ’)) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ACIDã‚’å®ˆã‚Šã¾ã™ã€‚ Aã¯Atomicity Cã¯Consistency Iã¯Isolation Dã¯Durability ã‚’æ„å‘³ã—ã¾ã™ã€‚ 8. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽˆæ¥ã‚ã‚‹ã‚ã‚‹ ï¼¿ï¼¿ï¼¿_ ï¼_ãƒŽ ãƒ½ï½¤_ï¼¼ ï¾ ï¾ ï¾ oï¾Ÿ(ï¼ˆâ—ï¼‰) (ï¼ˆâ—ï¼‰)ï¾Ÿo ï¾ ï¾ ï¾ /âŒ’)âŒ’)âŒ’. ::::::âŒ’ï¼ˆ__äºº__ï¼‰âŒ’:::ï¼¼ /âŒ’)âŒ’)âŒ’) | / / / |râ”¬-| | (âŒ’)/ / / /ï¼ | :::::::::::(âŒ’) | | | ï¼ ã‚:::::::::::/ |
sh-2 2016/05/16
DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL
ãƒªãƒ³ã‚¯
äºŒåƒä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®alterã‚’ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ãšã«æµã™ | All Your Bugs Are Belong To Ass
â€»ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯MySQL Casual Advent Calendar 2015ã®5æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ openark-kit ã¨ã„ã†ã‚‚ã®ã«ã¤ã„ã¦ ã“ã“ã¾ã§èªã‚“ã§ã‚ã‹ã£ãŸæ–¹ã¯ã€ã“ã®å…ˆã‚’èªã‚€å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ openark-kitã¨ã¯ã€mysqlã®é‹ç”¨ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã‚ãƒƒãƒˆã‚’14å€‹ã‚ã¤ã‚ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã™ã€‚ Shlomi Noachã¨ã„ã†æ–¹ãŒPythonã§é–‹ç™ºã—ã¦ãŠã‚Šã€å°‘ãªãã¨ã‚‚2009å¹´ã«ç™ºè¡¨ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ 2015-12-05æ™‚ç‚¹ã§ã®æœ€æ–°ç‰ˆã¯196.1ã¨ãªã£ã¦ãŠã‚Šã€.tar.gz ãŠã‚ˆã³ .deb ã§é…å¸ƒã•ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ãŸèƒŒæ™¯äº‹æƒ… ãã‚‚ãã‚‚åƒ•è‡ªèº«ã€50ã‚’è¶…ãˆã‚‹ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸmysqlãƒŽãƒ¼ãƒ‰ã¨ä¸€ç·’ã«æ¥å‹™ç”Ÿæ´»ã‚’é€ã£ã¦ãŠã‚Šã¾ã™ã€‚ ã¨ã“ã‚ãŒã€ã‚·ã‚¹ãƒ†ãƒ ãŒéžå¸¸ã«å¤ãã•ã„æ§‹æˆã®ãŸã‚ã€åˆè¨ˆãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒ2å„„ã‹ã‚‰3å„„ç¨‹åº¦ã‚ã‚‹åž‚ç›´åˆ†å‰²ã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ALTERã‚’æŠ•
sh-2 2015/12/06
mysql

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Linux performance tuning tips for MySQL
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
sh-2 2015/11/22
MySQL

linux
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ã®ãƒã‚¹ãƒˆã¯ç™ºç”Ÿã™ã‚‹ã‹ï¼Ÿ | Yakst
MySQLã‚ã‚‹ã„ã¯Mongo DBã«ãŠã‘ã‚‹ã‚³ãƒŸãƒƒãƒˆã®èªå–ã‚Šä¸€è²«æ€§ãŠã‚ˆã³å—ä¿¡ç¢ºèªã•ã‚ŒãŸã‚³ãƒŸãƒƒãƒˆã®ä¿è·ã«ã¤ã„ã¦ã®ãƒ–ãƒã‚°è¨˜äº‹ã‚’ç´¹ä»‹ã™ã‚‹ã€‚Mongo DBã«ãŠã‘ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®å•é¡Œã«ã¤ã„ã¦ã‚‚è¨€åŠã•ã‚Œã¦ã„ã‚‹ã€‚ å‡ºå…¸ã«ã¤ã„ã¦ ã“ã®è¨˜äº‹ã¯Mark Callaghanæ°ã®ãƒ–ãƒã‚°å†…ã®è¨˜äº‹ã€Losing it?(2015/10/11)ã‚’ç¿»è¨³ã—ãŸã‚‚ã®ã§ã™ã€‚ ä½•å¹´ã‚‚å‰ã€Googleç¤¾ã®MySQLãƒãƒ¼ãƒ ã®Wei Liæ°ã®åŽšæ„ã«ã‚ˆã£ã¦æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ã“ã®æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã¯é™ã‚‰ã‚Œã¦ãŠã‚Šã€ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¯ã“ã‚ŒãŒæ„å›³ã—ãŸå‹•ä½œã‚’ã—ãªã‹ã£ãŸãŸã‚å¤±æœ›ã—ã¾ã—ãŸã€‚ãã®ã†ã¡ã«ã€InnoDBã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã«ã‚°ãƒ«ãƒ¼ãƒ—ã‚³ãƒŸãƒƒãƒˆãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚æœ€åˆã¯Facebookç¤¾ã®MySQLãƒãƒ¼ãƒ ã«ã€ãã—ã¦MariaDBã§æ”¹å–„ã•ã‚Œã€æœ€å¾Œã«MySQLã®ã‚¢ãƒƒãƒ—ã‚¹ãƒˆãƒªãƒ¼ãƒ ã«å–ã‚Šè¾¼ã¾ã‚Œã¾ã—ãŸã€‚ã‚°ãƒ«ãƒ¼ãƒ—ã‚³ãƒŸãƒƒãƒˆã«ã‚ˆã£ã¦ã€ã„
sh-2 2015/10/27
DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL

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

DB

MySQL
ãƒªãƒ³ã‚¯
** YAPC::Asia Tokyo 2011 RejectConf æœ¬å½“ã¯é›£ã—ã„ãƒ•ãƒ¬ãƒ³ãƒ‰ãƒ»ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³å‡¦ç†
TopicsPlaceHolder SectionTitlePlaceHolder TIME rest time current/total
sh-2 2015/09/03
db

MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã“ã®ãƒšãƒ¼ã‚¸ã‚’è¦‹ã‚‹ã«ã¯ã€ãƒã‚°ã‚¤ãƒ³ã¾ãŸã¯ç™»éŒ²ã—ã¦ãã ã•ã„
Facebookã§æŠ•ç¨¿ã‚„å†™çœŸãªã©ã‚’ãƒã‚§ãƒƒã‚¯ã§ãã¾ã™ã€‚
sh-2 2015/09/01
mysql

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
varcharã¨textã®é•ã„(mysql innodb) - lxyuma BLOG
mysqlã®å¯å¤‰é•·æ–‡å—åˆ—ã‚’æ‰±ã†ã€varcharåž‹ã¨textåž‹ã®é•ã„ã®è©±ã€‚ å¤ã„æƒ…å ±ãŒæ··åœ¨ã—ã¦ã„ãŸã®ã§ã€ã¡ã‚‡ã£ã¨æ•´ç†ã—ã¦ãƒ¡ãƒ¢ã€‚ myisamã®é ƒã®è©± sizeãŒé•ã† è¡Œã®ä¸èº«ãŒdataã‹(varchar)ã€dataã¸ã®ãƒã‚¤ãƒ³ã‚¿ã‹(text) å‚ç…§æŒŸã‚€ã®ã§ã€performanceã®é•ã„ãŒã‚ã£ãŸ(varcharãŒæ—©ã„) ä»Š net ã§ããã£ã¦ã€ã²ã£ã‹ã‹ã‚‹æƒ…å ±ã®å¤§åŠãŒã“ã®è©±ã€‚ æœ€è¿‘ã®innodbã®è©± æœ€å¤§sizeã¯ä¸€ç·’ã€‚64kb(ä½†ã—ã€TINYTEXTåž‹ã€MEDIUMTEXTåž‹ã€LONGTEXTåž‹ã¯åå‰ã®é€šã‚Šé•ã†) varcharã‚‚textã‚‚ã€ä¸èº«ã¯åŒã˜ä»•çµ„ã¿(BLOB field / off page column) è¡Œã«dataå…¥ã‚Œã‚‹ã®ã‚‚ã€å¤–éƒ¨(overflow page)ã¸ã®å‚ç…§ã«ã™ã‚‹ã®ã‚‚ã€è¡Œãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆæ¬¡ç¬¬(row format) 5.6ã§è¡Œformatã®default ã¯ COMPACT
sh-2 2015/08/30
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

db
ãƒªãƒ³ã‚¯
MySQL 5.6ã§æœ¬å½“ã«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§DDLãŒå®Ÿè¡Œã§ãã‚‹ã‹æ¤œè¨¼ã—ã¦ã¿ãŸ - oinume journal
MySQL 5.6ã§ã®æ©Ÿèƒ½å¼·åŒ–ç‚¹ï¼ˆãã®1ï¼‰ - ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ä½¿ã„å‹æ‰‹ã‚’å¤§ããå‘ä¸Š | Think ITã«æ›¸ã„ã¦ã‚ã‚‹ã‚ˆã†ã«MySQL 5.6ã‹ã‚‰ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§DDLã‚’å®Ÿè¡Œã—ã¦ã‚‚ãƒ¬ã‚³ãƒ¼ãƒ‰ã®INSERT, UPDATEã¯ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã¨ã‚ã‚‹ã®ã§ã€ã“ã‚ŒãŒæœ¬å½“ãªã®ã‹æ¤œè¨¼ã—ã¦ã¿ãŸã€‚MySQLã«ãŠã„ã¦ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã®å¤šã„ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ALTER TABLEæ–‡ã®ç™ºè¡Œã¯ä»¥å‰ã‹ã‚‰å•é¡Œè¦–ã•ã‚Œã¦ã„ã¦ã€pt-online-schema-changeã¿ãŸã„ãªã‚‚ã®ã‚’é§†ä½¿ã™ã‚‹ã®ãŒå¸¸å¥—æ‰‹æ®µã ã£ãŸã€‚ æ¤œè¨¼ç’°å¢ƒ ConoHa VPS 2GB Ubuntu 14.04 MySQL 5.6.17-0ubuntu0.14.04.1-log my.cnf ãƒ‡ãƒ¼ã‚¿ã¯Wikipediaã®ãƒ€ãƒ³ãƒ—ãƒ‡ãƒ¼ã‚¿ã®enwiki-20140502-redirect.sql.gz ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ç”¨ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ CREATE TABL
sh-2 2015/08/15
mysql

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
InnoDBã®REPEATABLE READã«ãŠã‘ã‚‹Locking Readã«ã¤ã„ã¦ã®æ³¨æ„ç‚¹
æœ¬æ—¥ã¯ã€MySQL Casual Advent Calendar 2013ã®20æ—¥ç›®ã§ã‚ã‚‹ã€‚ã¨ã„ã†ã‚ã‘ã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«å°ãƒã‚¿ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ MVCC - Multi Version Concurrency Controlã”å˜çŸ¥ã®é€šã‚Šã€InnoDBã¯MVCCã‚’å®Ÿè£…ã—ã¦ã„ã‚‹ã€‚ãã®ãŸã‚ã€åˆ†é›¢ãƒ¬ãƒ™ãƒ«ãŒREPEATABLE READã®å ´åˆã«ã¯ã€è¡Œã«ãƒãƒƒã‚¯ã‚’ã‹ã‘ã‚‹ã“ã¨ãªãã€ä¸€è²«ã—ãŸèªã¿å–ã‚ŠãŒå¯èƒ½ã«ãªã£ã¦ã„ã‚‹ã€‚ ã‚‚ã—ã€ã‚ã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³T1é–‹å§‹å¾Œã«ã€åˆ¥ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³T2ã«ã‚ˆã£ã¦åŒã˜è¡ŒãŒæ›¸ãæ›ãˆã‚‰ã‚Œã¦ã—ã¾ã£ãŸå ´åˆã«ã¯ã€T1ã¯ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã‚»ã‚°ãƒ¡ãƒ³ãƒˆã«ã‚ã‚‹å¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®å€¤ã‚’èªã¿å–ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã€T1å†…ã§å®Ÿè¡Œã—ãŸSELECTã¯å¸¸ã«T1é–‹å§‹æ™‚ç‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã‚ã‚‹ã€‚å¤§äº‹ãªã®ã§ã‚‚ã†ä¸€åº¦è¨€ã†ãŒã€REPEATABLE READã«ãŠã‘ã‚‹å˜ç´”ãªSELECTã§ã¯è¡Œãƒãƒƒã‚¯ã¯å¿…è¦ãªã„ã€‚ Lost Up
sh-2 2015/06/07
db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql
ãƒªãƒ³ã‚¯
MySQLã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®4ã¤ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’è©¦ã™ - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ 1ã¤ã®ä½œæ¥å˜ä½ã¨ã—ã¦æ‰±ã‚ã‚Œã‚‹SQLã‚¯ã‚¨ãƒªã®é›†ã¾ã‚Šã§ã™ã€‚ è¤‡æ•°ã®UPDATEã‚„INSERTã‚’ã²ã¨ã¤ã®é›†ã¾ã‚Šã¨ã—ã¦ã€ ãã‚Œã‚‰ã®ã‚¯ã‚¨ãƒªãŒã™ã¹ã¦é©ç”¨ã§ããŸå ´åˆã®ã¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åæ˜ ã—ã¾ã™ã€‚ ã²ã¨ã¤ã§ã‚‚é©ç”¨ã«å¤±æ•—ã—ãŸã‚¯ã‚¨ãƒªãŒã‚ã£ãŸå ´åˆã¯ã€ãã®ã¾ã¨ã¾ã‚Šã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã®çµæžœã¯åæ˜ ã—ã¾ã›ã‚“ã€‚ ACIDç‰¹æ€§ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«æ±‚ã‚ã‚‰ã‚Œã‚‹4ã¤ã®ç‰¹æ€§ã§ã™ã€‚ åŽŸåæ€§ (Atomicity) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ‰‹é †ãŒã€Œã™ã¹ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‹ã€ã€Œã™ã¹ã¦ã•ã‚Œãªã„ã‹ã€ã®ã©ã¡ã‚‰ã‹ã«ãªã‚‹æ€§è³ªã€‚ ä¸€è²«æ€§ (Consistency) ã©ã‚“ãªçŠ¶æ³ã§ã‚‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‰å¾Œã§ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ãŒçŸ›ç›¾ãªãä¿ãŸã‚Œã‚‹æ€§è³ªã€‚ åˆ†é›¢æ€§ (Isolation) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿè¡Œä¸ã¯ã€å‡¦ç†é€”ä¸ã®ãƒ‡ãƒ¼ã‚¿ã¯å¤–éƒ¨ã‹ã‚‰éš è”½ã•ã‚Œã¦ä»–ã®å‡¦ç†ã«å½±éŸ¿ã‚’ä¸Žãˆãªã„æ€§è³ªã€‚ æ°¸ç¶šæ€§ (Durability) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒå®Œäº†ã—ãŸã‚‰ã€ã‚·ã‚¹
sh-2 2015/06/07
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

DB
ãƒªãƒ³ã‚¯
utf8_unicode_ci ã«å¯¾ã™ã‚‹æ—¥æœ¬ã®é–‹ç™ºè€…ã®è¦‹è§£ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
RailsãŒMySQLã®collationã‚’ã‚µãƒ¼ãƒãƒ¼å´ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8_general_ciã‹ã‚‰utf8_unicode_ciã«ã‚ã–ã‚ã–å¤‰ãˆã¦ã‚‹ã®ã©ã†ã›å¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã„ã ã‚ã¨æ€ã£ã¦æŽ˜ã£ã¦ã¿ãŸã‚‰ã‚„ã£ã±ã‚Šå¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã‹ã£ãŸâ€¦ https://t.co/6NeetGhTF0â€” Ryuta Kamizono (@kamipo) April 18, 2014 Railsã§collationã¨ã—ã¦utf8_unicode_ci(Railsã®DEFAULT_COLLATION)ãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã®ã¯charsetãŒæœªæŒ‡å®šã‚‚ã—ãã¯utf8(Railsã®DEFAULT_CHARSET)ã®ã¨ãã ã‘ã§ã€utf8mb4ã«ã™ã‚‹ã“ã¨ã¨ã‹ã¯å…¨ãè€ƒæ…®ã•ã‚Œã¦ãªã„ã€‚â€” Ryuta Kamizono (@kamipo) April 19, 2014 @frsyuki MySQLã®charset utf8ã®ã¨ãã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ
sh-2 2015/03/08
mysql

rails
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨ã«ã¤ã„ã¦è‰²ã€…
12. ã‚¹ãƒ†ãƒƒãƒ—çš„ãªã‚‚ã® ã‚µã‚¤ã‚º ä½¿ã„ã©ã“ã‚ ã‚³ãƒžãƒ³ãƒ‰ä¾‹ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã§ã‹ã„ å¿…ãšå¿…è¦ tar, rsync, mysqldump, XtraBackup å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— â¼©ã•ã„ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã® é–“éš”ãŒçŸã‘ã‚Œã°è¦ã‚‰ ãªã„ mysqldump(ã‚¹ã‚ãƒ¼ ãƒžã«åˆ¶ç´„) XtraBackup å¢—åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— æ›´æ–°é‡ã«ä¾å˜ ã»ã¼é–“é•ã„ãªãå¿…è¦ cp, rsync, mysqlbinlog 11/58 14. ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é¸æŠžè‚¢ ã‚³ãƒžãƒ³ãƒ‰ ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¢ãƒ—ãƒªå½±éŸ¿ â½…å¼ ã‚µã‚¤ã‚º tar, rsync MyISAM Ã— åœâ½Œã¾ãŸã¯ãƒãƒƒ ã‚¯ ç‰©ç† â¼¤ãã‚ tar, rsync InnoDB Ã— mysqldåœâ½Œ ç‰©ç† â¼¤ãã‚ LVMã‚¹ãƒŠãƒƒãƒ— ã‚·ãƒ§ãƒƒãƒˆ MyISAM InnoDB â–³ æ€§èƒ½åŠ£åŒ–ãŒã²ã© ã„ ç‰©ç† â¼¤ãã‚ mysqldump MyISAM Ã— ãƒãƒƒã‚¯ è«–ç† â¼©ã•ã‚ mysqldum
sh-2 2015/03/01
mysql
ãƒªãƒ³ã‚¯
æˆ‘ã€…(ä¸»èªžãŒå¤§ãã„)ã¯ä½•æ•…MySQLã§å¤–éƒ¨ã‚ãƒ¼ã‚’ä½¿ã‚ãªã„ã®ã‹
å¤–éƒ¨ã‚ãƒ¼ä¾¿åˆ©!!! Mackerelã§ã¯PostgreSQLã§å¤–éƒ¨ã‚ãƒ¼ã‚ã‚Š ãã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒã‚ã‚‹ã“ã¨ãŒä¿è¨¼ã•ã‚Œã‚‹ å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®idã«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¬ãƒ™ãƒ«(Mackerelã®å ´åˆScala)ã§åž‹ä»˜ã‘ã‚’ã™ã‚‹ã¨ãªãŠä¾¿åˆ© MemberIDåž‹ã€MonitorIDåž‹ â†’ idã§èª¤ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å¼•ãã¨ã‹ãŒãªã„ æœ¬æ—¥ã®ã‚¹ã‚ãƒ¼ãƒž CREATE TABLE `member` ( `id` INTEGER unsigned NOT NULL auto_increment, `earned_it em_count` INTEGER unsigned NOT NULL DEFAULT 0, `name` VARCHAR(191) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4; CREATE TABLE `it em`
sh-2 2015/02/14
db

mysql
ãƒªãƒ³ã‚¯
MySQLã®my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã‚µãƒ³ãƒ—ãƒ«
MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚ŒãŸMySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ åå‰ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å…ƒ my.cnfã‚µãƒ³ãƒ—ãƒ« ä»¥ä¸‹ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’å‚ç…§ã—ã¦ã€my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¦ãã ã•ã„ã€‚ # ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ MySQL 5.6ã‚’åŸºæº–ã¨ã—ã¦ä½œã‚‰ã‚Œã¦ã‚ã‚Šã¾ã™ã€‚ # http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ [mysqld] ##-------------------------------------------------------------------- # mysqldã®åŸºæœ¬è¨å®š ##-------------------------------------------------------------------- # id ã¯ 1 ã‹ã‚‰ 2^
sh-2 2015/01/22
è¨å®š

mysql
ãƒªãƒ³ã‚¯
1