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

umiyosh id:umiyosh

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

${{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ã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
14. MySQLã®â¾¯å€’ã‚’â¾’ã‚‹ #ã¨ã¯ DBã«ç‰¹åŒ–ã—ãŸï¼ˆåºƒç¾©ã®ï¼‰ã‚¤ãƒ³ãƒ•ãƒ©ãƒ‡ã‚¶ã‚¤ãƒ³ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é »åº¦, ä¿ç®¡å…ˆ, ..etc. + ãã®å®Ÿè£…- ç›£è¦–, ãƒªã‚½ãƒ¼ã‚¹ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°, ..etc. + ãã®å®Ÿè£…- mikasafabric for MySQL + MySQL Router- ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æ¤œè¨¼ã¨ã‹ã€Percona Serverã¨ã‹ MariaDBã¨ã‹ - DBã«ç‰¹åŒ–ã—ãŸã‚·ãƒ§ãƒƒãƒˆä½œæ¥ åŠã‚‹ã—ã® ALTER TABLE ä»¥å¤–ã‚’ä½¿ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®æ›´æ–° < 5.6 ã ã£ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ãŒâ¼¤ãã™ãŽã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒè©°ã¾ã£ãŸã‚Šã™ã‚‹ã‚±ãƒ¼ã‚¹ - ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°- ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—- 13/63
umiyosh 2017/09/16
mysql
ãƒªãƒ³ã‚¯
B Treeã¨B+ Treeã®é•ã„ - Carpe Diem
æ¦‚è¦ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«å¯¾ã—ã¦Mongo DBã¯B Treeã‚’æŽ¡ç”¨ã—ã€MySQLã®InnoDBã¯B+ Treeã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚ ã©ã†ã—ã¦æŽ¡ç”¨ã—ã¦ã„ã‚‹ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ãŒé•ã†ã®ã ã‚ã†ï¼Ÿã¨æ€ã£ã¦èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ä¸»ãªé•ã„ B+ Treeã¯ã»ã¨ã‚“ã©B Treeã¨åŒã˜ã§ã™ãŒã€ä»¥ä¸‹ã®ç‚¹ãŒç•°ãªã‚Šã¾ã™ã€‚ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ã¨ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ã‚’çµã¶ãƒã‚¤ãƒ³ã‚¿ãŒã‚ã‚‹ ãƒ‡ãƒ¼ã‚¿ã¯ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ã®ã¿ã«ä¿æŒã™ã‚‹ å…·ä½“ä¾‹ è¨€è‘‰ã ã‘ã ã¨åˆ†ã‹ã‚Šã«ãã„ã®ã§ã€Visualizeã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦å…·ä½“ä¾‹ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ [1, 2, 3, 4, 5, 6, 8, 10, 15, 18]ã¨ã„ã†æ•°åˆ—ã«å¯¾ã—ã€Order: 3ã§ä½œã£ã¦ã¿ã¾ã™ã€‚ Orderã¯ï¼‘ãƒŽãƒ¼ãƒ‰ã‹ã‚‰å‡ºã‚‹æžã®æ•°ã®ã“ã¨ã§ã™ã€‚ B Tree B-Tree Visualization B+ Tree B+ Tree Visualization å…ˆç¨‹ã®B Treeã¨é•ã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ã¯ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ã«æŒã¤ã®
umiyosh 2017/05/20
mysql

mongodb
ãƒªãƒ³ã‚¯
CVE-2016-6662 MySQL Remote Root Code Execution / Privilege Escalationã«ã¤ã„ã¦ - Qiita
å…è²¬ å–ã‚Šæ•¢ãˆãšã‚ã‹ã£ã¦ã„ã‚‹ç¯„å›²ã§æ›¸ã„ãŸã ã‘ãªã®ã§ã€æ‰‹å…ƒã§å†ç¾ã‚„ãƒ‘ãƒƒãƒã®æ£å½“æ€§ã¯ç¢ºèªã—ã¦ã„ã¾ã›ã‚“ã€‚ è‡ªå·±è²¬ä»»ã§ã©ã†ãžã€‚ ã“ã‚Œ(2016/09/22 22:00)ä»¥é™æ–°ã—ã„æƒ…å ±ãŒå‡ºã¦ãã¦ã‚‚ã€ãŠãã‚‰ãã‚‚ã†æ›´æ–°ã—ã¾ã›ã‚“ã€‚ CVE-2016-6662 ã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ MySQLã«é‡å¤§ãªè„†å¼±æ€§è¦‹ã¤ã‹ã‚‹ã€ãƒ‘ãƒƒãƒå˜åœ¨ã›ãšãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§å½±éŸ¿ - ITmedia ãƒ‹ãƒ¥ãƒ¼ã‚¹ oss-sec: CVE-2016-6662 - MySQL Remote Root Code Execution / Privilege Escalation ( 0day ) ã“ã®è„†å¼±æ€§ã‚’å†ç¾ã•ã›ã‚‹ãŸã‚ã«å¿…è¦ãªã‚‚ã® (æœªæ¤œè¨¼) 5.5.52, 5.6.33, 5.7.15ã¯å½±éŸ¿ã‚’å—ã‘ãªã„ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚è©³ã—ãã¯å›³ã®ã•ã‚‰ã«ä¸‹ã«ã€‚ æ‰‹å…ƒã§å†ç¾ã•ã›ã¦ã¯ã„ã¾ã›ã‚“ãŒã€ ã‚ªãƒªã‚¸ãƒŠãƒ«ã®è„†å¼±æ€§å ±å‘Š ã®å½±éŸ¿ã‚’å—ã‘ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã—ã‚ƒã‚‰ã£ã¨ "5.7.14
umiyosh 2016/09/13
mysql

security
ãƒªãƒ³ã‚¯
MySQLé‹ç”¨ã¨ã‚‰ã¶ã‚‹ã™ã¨ãƒ¼ã‚Šã€œ^2 / MySQL-Troubleshooting-Story
AWS CDKã§ãƒ‡ãƒ¼ã‚¿ãƒªã‚¹ãƒˆã‚¢ã®é‹ç”¨ã€ã©ã®ã‚ˆã†ã«è¨è¨ˆã™ã‚‹ï¼Ÿï½žAuroraãƒ»EFSã®å®Ÿè·µäº‹ä¾‹ã‚’ç´¹ä»‹ï½ž/aws-cdk-data-restore-aurora-efs
umiyosh 2016/09/02
mysql
ãƒªãƒ³ã‚¯
gh-ost: GitHub's online schema migration tool for MySQL
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
umiyosh 2016/08/02
mysql
ãƒªãƒ³ã‚¯
é›‘ãªMySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
26. EXPLAIN mysql> EXPLAIN SELECT * FROM table_1 a JOIN `table_2` s ON a.user_id=s.`user_id` AND s.site_i d=120 WHERE app_id=8250G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: a type: ref possible_keys: PRIMARY,ix_table_1,ix2_table_2,ix3_table_1,idx_table_1_06,idx_table_1_07,idx_t able_1_09 key: idx_table_1_06 key_len: 4 ref: const rows: 13496 Ext
umiyosh 2016/01/26
mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã¨5.7ã«ãŠã‘ã‚‹é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®Q&A(The Percona Performance Blogã‚ˆã‚Š) | Yakst
ç´„9å¹´å‰æŠ•ç¨¿ ä¿®æ£ã‚ã‚ŠMySQL 5.6ã¨5.7ã«ãŠã‘ã‚‹é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®Q&A(The Percona Performance Blogã‚ˆã‚Š) å‡ºå…¸ã«ã¤ã„ã¦ ã“ã®è¨˜äº‹ã¯The Percona Performance Blogå†…ã®Alexander Rubinæ°ã«ã‚ˆã‚‹ã€ŒAdvanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&Aã€(2015/8/24)ã‚’ç¿»è¨³ã—ãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ 8æœˆ22æ—¥ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚»ãƒŸãƒŠãƒ¼ã€ŒMySQL 5.6ãŠã‚ˆã³5.7ã«ãŠã‘ã‚‹é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒ¼ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã«å‚åŠ ã—ã¦ã„ãŸã ã„ã¦ã‚ã‚ŠãŒã¨ã†(ç§ã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŠã‚ˆã³å‹•ç”»ã¯ã“ã“ã§ç¢ºèªã§ãã‚‹)ã€‚ã“ã“ã§ã¯è³ªå•ã¨ãã®å›žç”ã®ä¸€è¦§ã‚’ç´¹ä»‹ã™ã‚‹(ã„ã„è³ªå•ã‚’ã‚ã‚ŠãŒã¨ã†) ã€‚ Q: ã“ã“ã«explainã®ä¾‹ãŒã‚ã‚‹ mysql> explain extended select id, s
umiyosh 2015/09/07
mysql
ãƒªãƒ³ã‚¯
MHA(MasterHighAvailabilityManager)ã®å°Žå…¥è¨å®š
MHA(MasterHighAvailabilityManager)ã®å°Žå…¥è¨å®š ä½¿ç”¨ãƒãƒ¼ã‚¸ãƒ§ãƒ³ï¼šmha4mysql-manager-0.53-0ã€MySQL-5.5 â‘ ç°¡å˜ãªåˆ©ç‚¹ãªã©ã®è§£èª¬ MHAã¨ã¯mysqlã®ãƒžã‚¹ã‚¿éšœå®³æ™‚ã«æœ€æ–°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ãƒžã‚¹ã‚¿ã¨ã—ã¦ä»–ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã®å·®åˆ†ã‚’è£œå®Œã—ãƒžã‚¹ã‚¿ã®å‘ãå…ˆã‚’å¤‰ãˆã¦ãã‚Œã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆã€‚ Heartbeat+mon+mysqlã«æ¯”ã¹ã‚‹ã¨replicationã®å†æ§‹æˆã‚‚è¡Œã£ã¦ãã‚Œã‚‹ã®ã§åˆ‡ã‚Šæ›¿ã‚ã£ã¦ã‚‚DBãŒã‚·ãƒ³ã‚°ãƒ«ã«ãªã‚‰ãªã„ã®ãŒåˆ©ç‚¹ã€‚(3å°ä»¥ä¸Šã®æ§‹æˆã®å ´åˆ) ä½œè€…ã®ã‚¹ãƒ©ã‚¤ãƒ‰ å…¬å¼ã‚µã‚¤ãƒˆ MHAã®åˆ¶ç´„ï¼šmysql5.0ä»¥ä¸Šã€SBR(ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒ™ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³)ã®å ´åˆLOAD DATA INFILEã‚’ä½¿ãˆãªã„ â€»ãƒžãƒãƒ¼ã‚¸ãƒ£ã¯adminã‚µãƒ¼ãƒã€ãƒŽãƒ¼ãƒ‰ã¯DBã‚µãƒ¼ãƒ(ãƒžã‚¹ã‚¿ãƒ»ã‚¹ãƒ¬ãƒ¼ãƒ–å…±é€š) â‘¡ ãƒžãƒãƒ¼ã‚¸ãƒ£ã«ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€€ã€€ã€€ã€€â€»ä»¥ä¸‹ã€admã‚µãƒ¼ãƒã‹ã‚‰å®Ÿæ–½ ãƒ»ã‚¤
umiyosh 2015/08/21
MHA

mysql
ãƒªãƒ³ã‚¯
MySQL ã® wait_timeout ã‚’å¤‰æ›´ã€‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
umiyosh 2014/12/03
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
umiyosh 2014/06/29
mysql
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
umiyosh 2014/06/29
mysql
ãƒªãƒ³ã‚¯
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
umiyosh 2014/06/18
mysql
ãƒªãƒ³ã‚¯
MySQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã‚‹ã¹ãMySQLã®å†…éƒ¨æ§‹é€ ã¨ã¯ï¼Ÿ | Yakst
MySQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã‚‹ã¹ãMySQLã®å†…éƒ¨æ§‹é€ ã«ã¤ã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ä¼šç¤¾PalominoDBã‚’çµŒå–¶ã™ã‚‹Laine Campbellæ°ã«ã‚ˆã‚‹å›žç”ã€‚MySQLã‚’çŸ¥ã‚‹ãŸã‚ã«ã¯ä½•ã‚’ãƒã‚¤ãƒ³ãƒˆã«å¦ç¿’ã™ã‚Œã°ã‚ˆã„ã®ã‹ãŒã‚ˆãã‚ã‹ã‚‹ã€DBAã‚„é–‹ç™ºè€…ã«ã¨ã£ã¦ã‚‚å½¹ç«‹ã¤å†…å®¹ã€‚ 1. ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã€æ°¸ç¶šæ€§ã€ãƒãƒƒã‚¯æ©Ÿæ§‹ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®æŒ¯ã‚‹èˆžã„ã‚„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã„ã£ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®åŸºç¤Žã¨ãªã‚‹å‹•ãã«ã¤ã„ã¦ã®ç†è§£ãªã—ã«ã€MySQLè‡ªä½“ã‚„ãƒ¢ãƒ‡ãƒ«ãƒ‡ãƒ¼ã‚¿ã®ã‚³ãƒ¼ãƒ‰ã‚’ã„ã˜ã‚‹ã¹ãã§ãªã„ã€‚ãã‚Œã«åŠ ãˆã¦ã€InnoDBã®ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚„ã€MyISAMã®å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚ˆã†ãªã‚³ã‚¢è¦ç´ ã‚‚ã€æ¥µã‚ã¦é‡è¦ãªæƒ…å ±ã ã€‚ 2. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆ ç‰¹ã«ä»¥ä¸‹ã®ã‚ˆã†ãªç‚¹ã«ã¤ã„ã¦ã€‚ ã‚«ãƒãƒªãƒ³ã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é€£çµã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸã‚½ãƒ¼ãƒˆ
umiyosh 2013/12/18
mysql
ãƒªãƒ³ã‚¯
MySQLã§ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è¿½åŠ ã€å‰Šé™¤ã‚’ã™ã‚‹ã¨ãã®ãƒãƒƒã‚¯ã®è©±ãªã© - (ï¾Ÿâˆ€ï¾Ÿ)oå½¡ sasata299's blog
2013å¹´12æœˆ12æ—¥14:03 MySQL MySQLã§ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è¿½åŠ ã€å‰Šé™¤ã‚’ã™ã‚‹ã¨ãã®ãƒãƒƒã‚¯ã®è©±ãªã© ã™ã£ã‹ã‚Š2013å¹´ã‚‚çµ‚ã‚ã‚Šã«è¿‘ã¥ã„ã¦ãã¾ã—ãŸãã€‚ã•ã¦ã€ä»Šå›žã¯MySQLã§ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è¿½åŠ ã€å‰Šé™¤ã‚’ã™ã‚‹ã¨ãã«çŸ¥ã£ã¦ãŠã„ãŸæ–¹ãŒã„ã„ã‹ãªãƒ¼ã¨æ€ã£ãŸæ³¨æ„ç‚¹ã®è©±ã§ã™ã€‚ ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è¿½åŠ ã€å‰Šé™¤ã‚’è¡Œã†éš›ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå…±æœ‰ãƒãƒƒã‚¯ã•ã‚Œã‚‹ ã¾ãšã€ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è¿½åŠ ã€å‰Šé™¤ã¨ã„ã£ãŸã„ã‚ã‚†ã‚‹ ALTER TABLE ã«ç›¸å½“ã™ã‚‹å‡¦ç†ã‚’è¡Œã†ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå…±æœ‰ãƒãƒƒã‚¯ï¼ˆèªã¿è¾¼ã¿ã®ã¿å—ã‘ä»˜ã‘ã€æ›´æ–°å‡¦ç†ã¯å—ã‘ä»˜ã‘ãªã„ã¨ã„ã†ãƒãƒƒã‚¯ï¼‰ã•ã‚Œã‚‹ã¨ã„ã†è©±ã§ã™ã€‚ ã“ã®è¾ºã®è©±ã¯ @nippondanji ã•ã‚“ãŒè©³ã—ãæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: ALTER TABLEã‚’ä¸Šæ‰‹ã«ä½¿ã„ã“ãªãã†ã€‚ 1. ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’TL_WRITE_ALLOW_READãƒãƒƒã‚¯ã™ã‚‹ã€‚ã“ã®ãƒãƒƒã‚¯ã¯ç‰¹æ®Šãªãƒãƒƒã‚¯
umiyosh 2013/12/13
mysql
ãƒªãƒ³ã‚¯
(å¸°ã£ã¦ããŸ)InnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Ž | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ç†è€…ãŒã€InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Žã«ã¤ã„ã¦ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„OSã®é¸å®šã‹ã‚‰ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æŽ¨å¥¨å€¤ã¾ã§è§£èª¬ã™ã‚‹ã€‚ æœ€è¿‘ã€2007å¹´ã«Peter ZaitevãŒæ›¸ã„ãŸã€ŒInnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Žã€ã¨ã„ã†è¨˜äº‹ã‚’è¦‹ã¤ã‘ãŸã€‚ã“ã‚Œã¯ç´ æ™´ã‚‰ã—ã„è¨˜äº‹ã§ã€èªã‚“ã§ã„ã‚‹ã¨ã€MySQLã¨Percona Serversãã—ã¦ä»Šæ—¥åˆ©ç”¨å¯èƒ½ãªå…¨ã¦ã®åŸºç›¤æŠ€è¡“ã«é–¢ã—ã¦ã€6å¹´è¿‘ãã®é–“ã«ä½•ãŒå¤‰ã‚ã£ã¦ããŸã®ã‹ã‚’è¦‹ç›´ã—ã¦ã¿ãŸã„ã¨æ€ã‚ã›ã‚‹ã‚‚ã®ã ã€‚ æœ¬å½“ã«ãŸãã•ã‚“ã®ã“ã¨ãŒå¤‰ã‚ã£ãŸã‚‚ã®ã ï¼ã“ã®è¨˜äº‹ã§ã¯ã€InnoDBã®ä½¿ç”¨ã«åŠ¹æžœçš„ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®å¤šãã«ã€ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ç„¦ç‚¹ã‚’å½“ã¦ã‚‹ã€‚ç§ã¯ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã€Percona Supportã§ã¯InnoDBãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®é©åˆ‡ãªã‚µã‚¤ã‚ºã«é–¢ã™ã‚‹è³ªå•ãŒãŸãã•ã‚“å¯„ã›ã‚‰ã‚Œã¦ã„ã‚‹
umiyosh 2013/09/28
InnoDB

mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãŒé€²åŒ–ã—ã¦ã„ãŸï¼ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6 ãŒå¾…æœ›ã®GAã¨ãªã‚Šã¾ã—ãŸï¼æ—©é€Ÿã€ã‚ã„ã¦ã„ãŸã‚µãƒ¼ãƒã«å…¥ã‚Œã¦ã¿ã¾ã—ãŸã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®è¨å®šãŒã€è‡³ã‚Œã‚Šå°½ãã›ã‚Šã«ãªã£ã¦ã„ã¦ã€ã³ã£ãã‚Šï¼*1 ã¡ã‚‡ã£ã¨å¼•ç”¨ãŒé•·ããªã‚‹ã‘ã©ã€æ•¢ãˆã¦é€”ä¸ã®ã‚«ãƒƒãƒˆã¨ã‹ã‚’ã—ãªã„ã§è¼‰ã›ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ã€linux(CentOS) ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã™ã€‚ ã¾ãšã€å–å¾—ã—ãŸrpmã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # rpm -ivh MySQL-server-5.6.10-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]ã™ã‚‹ã¨ã€æ•°åˆ†é–“ã‹ã‘ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–‡å—åˆ—ãŒã¤ã‚‰ã¤ã‚‰ã¨è¡¨ç¤ºã•ã‚Œã¦ãã¾ã™ï¼ˆã“ã“ã§ã¯ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã„
umiyosh 2013/09/23
MySQL

database
ãƒªãƒ³ã‚¯
MySQL/SQLiteã®ERå›³ã‚’æãPHPã‚¹ã‚¯ãƒªãƒ—ãƒˆÂ·mysqlviz MOONGIFT
mysqlvizã¯MySQL/SQLiteã®æ§‹é€ ã‚’å¯è¦–åŒ–ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ DBã‚’ä½¿ã£ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¦ã„ã‚‹ã¨å¿…è¦ã«ãªã‚‹ã®ãŒERå›³ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã‚“ãªERå›³ã‚’å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ™ãƒ¼ã‚¹ã«æãå‡ºã™ã®ãŒmysqlvizã§ã™ã€‚ ãƒ˜ãƒ«ãƒ—ã§ã™ã€‚ ã¾ãšdotãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ã¾ã™ã€‚ ã•ã‚‰ã«dotãƒ•ã‚¡ã‚¤ãƒ«ã‚’pngã«å¤‰æ›ã—ã¦å¾—ã‚‰ã‚ŒãŸçµæžœã§ã™ã€‚ mysqlvizã¯MySQLã¨SQLiteã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚MySQLã®å ´åˆã¯ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã€SQLiteã®å ´åˆã¯å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚“ã§dotãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã—ã¾ã™ã€‚å¾Œã¯Graphvizã‚’ä½¿ã£ã¦PNGç”»åƒã«å¤‰æ›ã™ã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚ mysqlvizã¯PHPè£½ã€GPL v3ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ MOONGIFTã¯ã“ã†è¦‹ã‚‹ mysqlvizã®é¢ç™½ã„ã¨ã“ã‚ã¯MySQLã«ã¤ã„ã¦ã¯ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨
umiyosh 2013/08/06
ERå›³

mysql

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
chef ã§ mysql ã®ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ - Hack like a rolling stone
ä»¥å‰ã€ã‚ã‚‹ç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ãŸã¨ãã¯ã€å¿™ã—ãã¦æ‰‹ãŒå›žã‚‰ãªã„ã¨ã„ã†ç†ç”±ã§ ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã¯ script ãƒªã‚½ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãˆã„ã‚„ã¨æ¸ˆã¾ã›ã¦ã—ã¾ã£ãŸ tk0miya ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šå›žã¯ã™ã¹ã¦ community cookbook ã§ç’°å¢ƒã‚’ä½œã‚‹æ–¹æ³•ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã‚„ã‚Šæ–¹ãŒåˆ†ã‹ã£ã¦ã—ã¾ãˆã°ã‚·ãƒ³ãƒ—ãƒ«ã«å®Ÿç¾ã§ãã‚‹ã®ã§ã€æ³¥è‡ã script ãƒªã‚½ãƒ¼ã‚¹ã‚’ä½œã‚‰ãšã«æ¸ˆã¿ãã†ã§ã™ã€‚ éµã¯ database cookbook ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ãƒ¬ã‚·ãƒ”ãŒ mysql cookbook ã«å…¥ã£ã¦ã„ãªã„ãŸã‚ã€ å…¬å¼ã«ã¯æä¾›ã•ã‚Œã¦ã„ãªã„ã‚‚ã®ã¨ã„ã¾ã¾ã§è«¦ã‚ã¦ã„ãŸã®ã§ã™ãŒã€ èª¿ã¹ã¦ã¿ã‚‹ã¨ mysqll cookbook ã§ã¯ãªã database cookbook ã§ãƒªã‚½ãƒ¼ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ä»¥ä¸‹ã€README ã®èª¬æ˜Žã§ã™ã€‚ The main highlight of
umiyosh 2013/05/26
mysql

database

chef
ãƒªãƒ³ã‚¯
ãƒã‚¿ã•ã‚“ã®ãƒ–ãƒã‚° : Q4Mã‚’PHP(PDO)ã§
Q4MãŒç„¡äº‹ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããŸã®ã§ã€PHPã‹ã‚‰è§¦ã£ã¦ã¿ã‚‹ã€‚è©³ç´°ãªã“ã¨ã¯ä»Šåº¦æ›¸ãã€‚ã¨ã‚Šã‚ãˆãšè§¦ã‚Šã ã‘ã§ã‚‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© drop table if exists hoge_queue; create table hoge_queue( id int not null, name varchar(25) not null ) engine=queue; ã“ã‚“ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ã‚¬ãƒ³ã‚¬ãƒ³å›žã—ã¦ã€ç›£è¦– $conn = new PDO('mysql:host=localhost; dbname=hogetest', 'user', 'password'); $wait = $conn->prepare('SELECT queue_wait("hoge_queue", 10)'); $abort = $conn->prepare('SELECT queue_abort()'); $e = $conn->pr
umiyosh 2013/03/27
PHP

q4m

mysql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Q4M - MySQL ä¸Šã§å‹•ä½œã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼
umiyosh 2013/03/27
q4m

mysql
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸