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

no8410 id:no8410

mysqlã«é–¢ã™ã‚‹no8410ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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ã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
no8410 2013/09/20
mysql

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

mariadb
ãƒªãƒ³ã‚¯
Red Hat Enterprise Linux 7ã§ã‚‚MySQLã«ä»£ãˆã¦MariaDBã‚’æŽ¡ç”¨ | ã‚¹ãƒ©ãƒ‰ Linux
2013å¹´ç¬¬2å››åŠæœŸã«å‡ºè·äºˆå®šã®Red Hat Enterprise Linux(RHEL) 7ã§ã¯ã€MySQLã«ä»£ãˆã¦MariaDBã‚’æŽ¡ç”¨ã™ã‚‹ãã†ã (ITWireã®è¨˜äº‹ã€ The Registerã®è¨˜äº‹ã€ æœ¬å®¶/.)ã€‚ MariaDBã¯ã€MySQLã‚’ãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€ç¾åœ¨ã®ã¨ã“ã‚MySQLã¨å®Œå…¨ãªäº’æ›æ€§ãŒã‚ã‚‹ã€‚Red Hatã®Radek VokÃ¡iæ°ã«ã‚ˆã‚Œã°ã€MySQLã‚ˆã‚ŠMariaDBã®æ–¹ãŒãƒ‘ãƒƒãƒã‚„æ©Ÿèƒ½è¿½åŠ ãªã©ã®ã‚³ãƒ³ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚å®¹æ˜“ã«ãªã‚‹ã¨æœŸå¾…ã—ã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ãƒ™ãƒ¼ã‚¹ã®Linuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯MySQLã‹ã‚‰MariaDBã¸ã®ç§»è¡ŒãŒé€²ã‚“ã§ã„ã‚‹ãŒã€ä¼æ¥å‘ã‘ã®ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚MariaDBã¸ã®ç§»è¡ŒãŒé€²ã‚€ã‚‚ã®ã¨ã¿ã‚‰ã‚Œã‚‹ã€‚
no8410 2013/06/17
Linux

Oracle

mysql

RHEL
ãƒªãƒ³ã‚¯
MySQL Bootcamp â€” MySQL Bootcamp 2013 documentation
MySQL BootcampÂ¶ This document is for programmers new to MySQL. Contents:
no8410 2013/05/17
mysql

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
no8410 2012/09/12
mysql

PostgreSQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
no8410 2012/07/25
mysql

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚¸ãƒ§ã‚¤ãƒ³ãŒ70å€é«˜é€Ÿã§ã€Memcached APIæè¼‰ã®ã€ŒMySQL Cluster 7.2ã€æ£å¼ç‰ˆãŒç™»å ´
ç±³ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æ™®åŠã—ã¦ã„ã‚‹MySQLã‚’ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã—ã¦åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒMySQL Cluster 7.2ã€ã®æ£å¼ç‰ˆã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ GPLã«æº–æ‹ ã—ãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆã¨åŒæ™‚ã«ã€ç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’åŒæ¢±ã—ã€24æ™‚é–“365æ—¥ã®ã‚µãƒãƒ¼ãƒˆã‚‚è¡Œã†å•†ç”¨ç‰ˆã®ã€ŒMySQL Cluster Carrier Grade Editionã€ã‚‚åŒæ™‚ã«å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‚¸ãƒ§ã‚¤ãƒ³ãŒ70å€é«˜é€Ÿã« MySQL Cluster 7.2ã®æœ€å¤§ã®ãƒã‚¤ãƒ³ãƒˆã¯ã€ã‚¸ãƒ§ã‚¤ãƒ³ãŒé«˜é€Ÿã«ãªã£ãŸã“ã¨ã§ã™ã€‚ã“ã‚Œã¾ã§ã‚¯ãƒ©ã‚¹ã‚¿ã§ã®ã‚¸ãƒ§ã‚¤ãƒ³ã¯ã€ã‚¸ãƒ§ã‚¤ãƒ³ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãŒã‚¯ãƒ©ã‚¹ã‚¿å†…ã®ãƒŽãƒ¼ãƒ‰é–“ã‚’ã„ã¡ã„ã¡é£›ã³äº¤ã£ã¦ã„ãŸãŸã‚ã€è¤‡é›‘ãªã‚¸ãƒ§ã‚¤ãƒ³ã«ãªã‚‹ã»ã©é…ã„ã‚‚ã®ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ MySQL Cluster 7.2ã§æŽ¡ç”¨ã•ã‚ŒãŸAdaptive Query Localizationï¼ˆã‚ã‚‹ã„ã¯Push Down Joinsï¼‰ã¨å‘¼ã°
no8410 2012/02/16
mysql

memcached

Publickey
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ç›®çš„åˆ¥ã«ä½¿ã„åˆ†ã‘ã‚‹ã¹ã—
å…ƒãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®SQL Serveré–‹ç™ºãƒãƒ¼ãƒ ã®ä¸€å“¡ã§ã‚ã‚Šã€ãã®å¾Œãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã¨ã—ã¦æ´»èºã€‚æ˜¨å¹´ã‚¢ãƒžã‚¾ãƒ³ã«ç§»ç±ã—ã¦ã€ç¾åœ¨ã¯Amazon Web Servicesã®ä¸Šç´šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹James Hamiltonæ°ãŒã€è‡ªèº«ã®ãƒ–ãƒã‚°ã®ã€ŒOne Size Does Not Fit Allã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã‘ã«ã¨ã©ã¾ã‚‰ãªã„å¹…åºƒã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡žã‚’4ã¤ã«åˆ†é¡žã—ã¦ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ 4ã¤ã®ç¨®é¡žã¨ã¯ã€Œæ©Ÿèƒ½å„ªå…ˆã€ã€Œã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£å„ªå…ˆã€ã€Œã‚·ãƒ³ãƒ—ãƒ«ã€ã€Œç›®çš„åˆ¥ã€ã§ã™ã€‚ Hamiltonæ°ã¯ã€ã‚¢ãƒžã‚¾ãƒ³ãŒAmazonã‚¯ãƒ©ã‚¦ãƒ‰ã§MySQLã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ãŸã¨ã“ã‚ã€ä»¥å‰ã‹ã‚‰æä¾›ã—ã¦ã„ãŸã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ã€ŒSimpleDBã€ã¯çµ‚äº†ã™ã‚‹ã®ã§ã¯ãªã„ã‹ã¨å¿ƒé…ã™ã‚‹å£°ãŒã‚ã£ãŸã“ã¨ã‚’æŒ™ã’ã€ I can understand why some might co
no8410 2010/12/25
mysql

database
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆé–‹ç™ºã«ãŠã‘ã‚‹ãƒ†ã‚¹ãƒˆç”¨DBã®(ä½¿ã„|ä½œã‚Š)æ–¹
æ˜”æ›¸ã„ãŸã‚ˆã†ãªæ°—ãŒã—ã¦ãŸã‘ã©æ›¸ã„ã¦ãªã‹ã£ãŸã®ã§ã€‚ ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã¤ãã£ã¦ã„ã¦DBå›žã‚Šã®ãƒ†ã‚¹ãƒˆã‚’æ›¸ããŸã„å ´åˆã¯ Test::mysqldã‚„Test::postgresql ã‚’ä½¿ã†ã“ã¨ã€‚ CPANãªã‚“ã‹ã«ä¸Šã’ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã¯ãªãã€ãŠä»•äº‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¦ DBå›žã‚Šã®ãƒ†ã‚¹ãƒˆã‚’æ›¸ããŸã„ã‚±ãƒ¼ã‚¹ã«ã¤ã„ã¦ã§ã™ã€‚ ç§ã¯MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã€Test::mysqldã‚’ã¤ã‹ã£ã¦ã‚‚ã‚ˆã„ã®ã§ã™ãŒã€ èµ·å‹•ã‚³ã‚¹ãƒˆãŒãã‚Œãªã‚Šã«ã‹ã‹ã‚‹ã®ã¨ã€ãƒãƒ¼ã‚«ãƒ«ã®é–‹ç™ºç’°å¢ƒã«ã¯æ—¢ã«MySQLã¯ç«‹ã¡ä¸ŠãŒã£ã¦ã„ã‚‹å‰æãŒã‚ã‚‹ã®ã§ã€ æ—¢ã«ç«‹ã¡ä¸ŠãŒã£ã¦ã„ã‚‹MySQLã‚’ãã®ã¾ã¾åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã‚’ã¨ã£ã¦ã„ã¾ã™ã€‚ ãã“ã§ãƒ†ã‚¹ãƒˆç”¨ã®ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã‚¯ãƒ©ã‚¹ã‚’ç´¹ä»‹ã—ã¦ã¿ã¾ã™ã€‚ package t::Utils; use strict; use warnings; use utf8; use lib './t/'; use Test::Fixtu
no8410 2010/12/15
mysql

database

test
ãƒªãƒ³ã‚¯
1