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

masasuz id:masasuz

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

${{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 5.6 ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLã«ã¤ã„ã¦èª¿ã¹ãŸ - takatoshiono's blog
ä»Šæ›´ã ã‘ã© MySQL 5.6 ã§ã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLã®æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã€‚ä»Šæ—¥ã¯ã“ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLã«ã¤ã„ã¦å‹‰å¼·ã—ãŸã“ã¨ã‚’æ›¸ã„ã¦ã¿ã‚‹ã€‚ MySQL ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« MySQL :: MySQL 5.6 Reference Manual :: 14.11 InnoDB and Online DDL ã«ã„ã‚ã„ã‚æ›¸ã„ã¦ã‚ã‚‹ã€‚ã„ã¾ã‹ã‚‰æ›¸ãã“ã¨ã¯ã“ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‹ã‚‰å¾—ãŸçŸ¥è˜ãŒå…ƒã«ãªã£ã¦ã„ã‚‹ã€‚ DDL ã¦ãªã«ã‚ˆï¼Ÿ ãƒ‡ãƒ¼ã‚¿ã§ã¯ãªãã€ãƒ†ãƒ¼ãƒ–ãƒ«è‡ªèº«ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®SQLæ–‡ã®ã“ã¨ã€‚CREATE, ALTER, DROP, TRUNCATEãªã©ã€‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLã§ã¯CREATE INDEX, DROP INDEX, ALTER TABLEã«é©ç”¨ã•ã‚Œã‚‹ã€‚ http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_ddl 5.1 ã¾ã§ã® ALTER TABLE
masasuz 2018/02/21
mysql

mysql 5.6
ãƒªãƒ³ã‚¯
MySQL Casual Talks vol.10ã§ãƒˆãƒ¼ã‚¯ã—ã¦ããŸMySQLçš„ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
2024 ( 24 ) 9æœˆ ( 4 ) 8æœˆ ( 2 ) 5æœˆ ( 1 ) 4æœˆ ( 3 ) 3æœˆ ( 6 ) 2æœˆ ( 1 ) 1æœˆ ( 7 ) 2023 ( 20 ) 12æœˆ ( 3 ) 11æœˆ ( 3 ) 10æœˆ ( 1 ) 8æœˆ ( 1 ) 5æœˆ ( 2 ) 4æœˆ ( 2 ) 3æœˆ ( 3 ) 2æœˆ ( 5 ) 2022 ( 27 ) 12æœˆ ( 5 ) 10æœˆ ( 1 ) 9æœˆ ( 1 ) 8æœˆ ( 5 ) 7æœˆ ( 4 ) 6æœˆ ( 3 ) 4æœˆ ( 1 ) 3æœˆ ( 3 ) 2æœˆ ( 2 ) 1æœˆ ( 2 ) 2021 ( 22 ) 12æœˆ ( 4 ) 10æœˆ ( 2 ) 9æœˆ ( 6 ) 7æœˆ ( 1 ) 6æœˆ ( 3 ) 5æœˆ ( 3 ) 4æœˆ ( 1 ) 3æœˆ ( 2 ) 2020 ( 42 ) 12æœˆ ( 3 ) 10æœˆ ( 2 ) 9æœˆ ( 4 ) 8æœˆ ( 3
masasuz 2017/02/02
mysql
ãƒªãƒ³ã‚¯
MySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰äº‹æƒ… 2017ç‰ˆ
10. æ–‡å—é›†åˆæ–‡å—é›†åˆ US-ASCII æ•°å—ã€è‹±å—ã€32å€‹ã®è¨˜å· JIS X 0201 US-ASCII(ã€Œã€â†’ã€ŒÂ¥ã€/ã€Œ~ã€â†’ã€Œâ€¾ã€)+ã‚«ã‚¿ã‚« ãƒŠ JIS X 0208 æ•°å—ã€ã²ã‚‰ãŒãªã€ã‚«ã‚¿ã‚«ãƒŠã€æ¼¢å—ã€ãƒ©ãƒ†ãƒ³æ–‡å—ã€ ã‚®ãƒªã‚·ãƒ£æ–‡å—ã€è¨˜å·ç‰ã€… JIS X 0213 JIS X 0208 + ç¬¬ä¸‰æ°´æº–/ç¬¬å››æ°´æº–ã€ãƒãƒ¼ãƒžæ•°å—ã€ é¼»æ¿éŸ³æ–‡å—ç‰ã€… 11. æ–‡å—é›†åˆæ–‡å—é›†åˆ Windows-31J JIS X 0201 + JIS X 0208 + NECç‰¹æ®Šæ–‡å— + IBM æ‹¡å¼µæ–‡å—(ã€Œâ‘§ã€ã€Œâ…§ã€ã€Œãˆ±ã€ã€Œé«™ã€ã€Œï¨‘ã€ã€Œå½…ã€ ç‰) Unicode ä¸–ç•Œä¸ã®æ–‡å—ã€‚çµµæ–‡å—(ã€Œï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ã€ã€Œï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ã€ç‰)ã‚‚å«ã‚€ã€‚
masasuz 2017/02/02
mysql

encoding

character

unicode
ãƒªãƒ³ã‚¯
5.6 ä»¥å‰ã® InnoDB Flushing
Bind Peek ã‚’ã‚‚ã£ã¨ä½¿ãŠã†ãœï¼(æŸ´ç”° æ©) - JPOUG Advent Calendar 2014(Day 5) -æ© æŸ´ç”°
masasuz 2016/06/24
innodb

mysql

mysql5.6
ãƒªãƒ³ã‚¯
MySQL 5.7ã«ã‚„ã‚‰ã‚Œãªã„ãŸã‚ã«ãŠã¼ãˆã¦ãŠã„ã¦ã»ã—ã„ã“ã¨
2015/10/03 phpcon 2015 updated at 2016/01/13 about default_password_lifetime's default will be 0Read less
masasuz 2016/06/20
mysql 5.7

mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ãŒé…ã›ã‚‹æ–°ã—ã„é‹ç”¨ã®å½¢
9. MySQL Bugs: #71659: Make UTF8 Default Character Set â€œAffects meâ€ã®æ•°ã¯ä¸ã®â¼ˆã«ã—ã‹â¾’ãˆãªã„ã‚‰ã—ã„ã‘ã‚Œã© ã“ã®FRã¯ã‚ã‚“ã¾ã‚Šæµâ¾ã£ã¦ãªã„ã‚‰ã—ã„ ã¿ã‚“ãªã§â€Affects meâ€æŠ¼ã—ãŸã‚‰ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå¤‰ã‚ã£ãŸã‚Šã— ãªã„ã‹ãªï¼Ÿ ã„ã£ã±ã„é›†ã¾ã£ã¦å¤‰ã‚ã£ãŸã‚‰ä¸å¹¸ã›ã«ãªã‚‹â¼ˆãŒæ¸›ã‚Šãã† ã ã— - ã„ã£ã±ã„é›†ã¾ã£ãŸã®ã«å¤‰ã‚ã‚‰ãªã‹ã£ãŸã‚‰ã€Œã“ã‚Œã ã‹ã‚‰ â—‹racleã¯ï¼ã€ã£ã¦disã‚Œã°ã„ã„ã— - ã©ã£ã¡ã«è»¢ã‚“ã§ã‚‚æ‚ªã„ã“ã¨ã¯ãªã„ã‹ãªã£ã¦- 8/104
masasuz 2016/06/14
mysql

mysql5.7
ãƒªãƒ³ã‚¯
MySQLãŠã˜ã•ã‚“ã®é€†è¥²
17. MySQLã®â½´ã¡ä½ç½® app, browser app, browser app, browser app, browser app, browser app, browser WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP Database 16/136 18. ã“ã“ãª app, browser app, browser app, browser app, browser app, browser app, browser WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP Database 17/136 19. WEBã‚µãƒ¼ãƒãƒ¼ã¨ã®å¯¾â½ app, browser app, browser app, browser app, browser app, browser app, browser
masasuz 2016/06/10
mysql
ãƒªãƒ³ã‚¯
[Deep Dive]Infraå¯„ã‚Šã®DevãŒãŠé€ã‚Šã™ã‚‹RDS for Auroraå¾¹åº•æ¤œè¨¼
2. ãˆã£ã¨ã€èª°ã§ã™ã‹ï¼Ÿ Masashi Terui JIG-SAW æœå¹Œã‚ªãƒ•ã‚£ã‚¹ æŠ€è¡“é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ— ãƒªãƒ¼ãƒ€ãƒ¼ Twitter: @marcy_terui Github: marcy-terui Facebook: marcy.terui Dev for Opsçš„ãªãŠä»•äº‹ Likeâ†’MySQLã€Workâ†’Postgres AWS Certiï¬ed SysOps,Dev,SA(Associate) Winner of Tuningathon #5 (MySQL)
masasuz 2016/05/26
mysql

aurora
ãƒªãƒ³ã‚¯
é«˜å¯ç”¨æ€§ã¨ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å®Ÿç¾ã§ãã‚‹MySQL Fabricã¨ã¯ï¼Ÿ
Full Name Comment goes here. 12 hours ago Reply Edit Delete Spam Block é«˜å¯ç”¨æ€§ã¨ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å®Ÿç¾ã§ãã‚‹MySQL Fabricã¨ã¯ï¼Ÿ Presentation Transcript é«˜å¯ç”¨æ€§ã¨ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’ å®Ÿç¾ã§ãã‚‹MySQL Fabricã¨ã¯ï¼Ÿ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ å±±å´Ž ç”±ç« / MySQL Senior Sales Consultant, Asia Pacific and Japan Copyright Â© 2014, Oracle and/or its affiliates. All rights reserved.2 ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã¾ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ ã§ãã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹
masasuz 2016/05/20
fabric

mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã®CHANGE MASTER TOã§å‡ºã‚‹ã‚ˆã†ã«ãªã£ãŸãƒ¯ãƒ¼ãƒ‹ãƒ³ã‚°
MySQL 5.5ã¾ã§ã¯ä½•ã‚‚å‡ºãªã‹ã£ãŸã‘ã©ã€MySQL 5.6ã§è¿½åŠ ã•ã‚ŒãŸãƒ¯ãƒ¼ãƒ‹ãƒ³ã‚°ã€‚ mysql56> CHANGE MASTER TO MASTER_HOST= 'localhost', MASTER_PORT= 64055, MASTER_USER= 'replicatior', MASTER_PASSWORD= 'xxxx', MASTER_LOG_FILE= 'bin.000001', MASTER_LOG_POS= 1; Query OK, 0 rows affected, 2 warnings (0.06 sec) mysql56> SHOW WARNINGS; +-------+------+--------------------------------------------------------------------------------------------
masasuz 2016/05/20
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ãŒåŠ‡çš„å¤‰åŒ–ï¼ï¼GTIDã«ã¤ã„ã¦ä»•çµ„ã¿ã‹ã‚‰ç†è§£ã™ã‚‹
ãƒ¡ãƒªãƒ¼ã‚¯ãƒªã‚¹ãƒžã‚¹ï¼ï¼ã‚„ã‚ã€è‰¯ã„åã®ã¿ã‚“ãªï¼ï¼ã‚µãƒ³ã‚¿ã‚¯ãƒãƒ¼ã‚¹ãƒ»ãƒ»ãƒ»ã§ã¯ãªãã€ãƒ’ã‚²ãƒ¢ã‚¸ãƒ£ã‚®ãƒ¼ã‚¯ã‹ã‚‰ã®ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒˆã ã‚ˆï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€MySQL Casual Advent Calendarã®25æ—¥ç›®ã§ã‚ã‚‹ã€‚ä»ŠæœAdvent Calendarã‚’è¦—ã„ã¦ã¿ã‚‹ã¨ã€æœ¬æ—¥åˆ†ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒç„¡ã‹ã£ãŸã®ã§ã€æ€¥é½æ›¸ãã“ã¨ã«ã—ãŸã€‚Advent Calendaræœ€å¾Œã®æ—¥ã€ã‚¯ãƒªã‚¹ãƒžã‚¹ã‚’é£¾ã‚‹è¨˜äº‹ã®ãƒ†ãƒ¼ãƒžã¯GTIDã ã€‚ å‰å›žã®æŠ•ç¨¿ã§ã¯ã€MySQL 5.6ã®ç›®çŽ‰æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ãªã£ãŸã“ã¨ã‚’æŒ™ã’ãŸã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¾ã‚ã‚Šã§è¨€ãˆã°ã€ã‚‚ã†ã²ã¨ã¤å¤–ã›ãªã„ç›®çŽ‰æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ãã‚ŒãŒGTIDï¼ˆGlobal Transaction IDï¼‰ã§ã‚ã‚‹ã€‚ GTIDã¯è‰¯ãã‚‚æ‚ªãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ã‚’å¤‰åŒ–ã•ã›ã‚‹ã€‚GTIDã‚’ä½¿ã†ã“ã¨ã«ã‚ˆã£ã¦å¾—ã‚‰ã‚Œã‚‹æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€CHANGE MASTER TOã§ãƒã‚¤ãƒŠãƒªãƒ
masasuz 2016/05/20
mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ã®æ–°æ©Ÿèƒ½å®Œå…¨ãƒªã‚¹ãƒˆ | Yakst
MySQL 5.7ã«ã¯150ã‚’è¶…ãˆã‚‹æ–°æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ MySQLã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¯ã¨ã¦ã‚‚ã„ã„ã‚‚ã®ã ãŒã€å°‘ã—é•·ã™ãŽã‚‹ã€‚ã“ã‚Œã¯ã€æ–°æ©Ÿèƒ½ã®ç®‡æ¡æ›¸ããƒªã‚¹ãƒˆã ã€‚ãã‚Œãžã‚Œã®æ©Ÿèƒ½ã«ã¤ã„ã¦1ã¤ãšã¤ã¾ã¨ã‚ã‚‹ã‚ˆã†ã«é ‘å¼µã£ã¦ã‚ã‚‹ã€‚ãªã®ã§ã€ InnoDBã®ãƒã‚¤ãƒ†ã‚£ãƒ–ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° ã«ã¤ã„ã¦ã¯ã€InnoDBã®é …ã‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®é …ã®ã©ã¡ã‚‰ã‹ã«ã ã‘è¼‰ã£ã¦ã„ã‚‹ã€‚ MySQL 5.7.8 RC2ã¯ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ ãã‚Œã‹ã€yumã‹aptã®ãƒªãƒã‚¸ãƒˆãƒªãƒ¼ã‹ã‚‰ã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¯èƒ½ã ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–¢é€£ ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(è¨³æ³¨: 1ã‚¹ãƒ¬ãƒ¼ãƒ–ã«è¤‡æ•°ãƒžã‚¹ã‚¿ãƒ¼ã‚’è¨å®šå¯èƒ½ã«ãªã£ãŸ) [ 1 ] ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§ã®GTIDã®æœ‰åŠ¹åŒ– [ 1 2 3 ] æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½å‘ä¸Š [ 1 2 ] ãƒã‚¹ãƒ¬ã‚¹æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ [ 1 2 ] æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã„ãã¤ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‹ã‚‰ACKãŒè¿”ã£ã¦ãã‚‹ã¾ã§å¾…ã¤
masasuz 2016/05/20
mysql 5.7

mysql
ãƒªãƒ³ã‚¯
MySQL User Conference Tokyo 2015ã§ç™ºè¡¨ã—ã¾ã—ãŸï¼šMySQL 5.7ã«ãŠã‘ã‚‹ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã®æ”¹è‰¯ç‚¹
æ˜¨æ—¥ã€å‘ŠçŸ¥ã•ã›ã¦ã„ãŸã ã„ãŸMySQL User Conference Tokyo 2015ã§ç™»å£‡ã—ãŸã®ã§ã€ãã®æ™‚ã®è³‡æ–™ã‚’å…¬é–‹ã—ãŸã€‚MySQL 5.7ã®æ©Ÿèƒ½ã¯å…¨éƒ¨ã²ã¨ã¤ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ç´¹ä»‹ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€å¤šã™ãŽã¦ç§ã«ã¯ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆã«ã¾ã¨ã‚ã‚‹ã ã‘ã®æŠ€é‡ã¯ç„¡ã„ãŸã‚ã€ä»Šå›žã¯ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã ã‘ã®ç´¹ä»‹ã«ã—ãŸã€‚èˆˆå‘³ã®ã‚ã‚‹æ–¹ã¯ã”è¦§é ‚ããŸã„ã€‚ ãã†ã„ãˆã°ã™ã£ã‹ã‚Šå¿˜ã‚Œã¦ã—ã¾ã£ã¦ã„ãŸã®ã ãŒã€MySQL 5.7ãŒç™»å ´ã—ãŸï¼ï¼ã¨ã„ã†ãƒ–ãƒã‚°ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ãã®ã‚’å¿˜ã‚Œã¦ã„ãŸã€‚ã‚‚ã—ã‹ã™ã‚‹ã¨èªè€…ã®çš†ã•ã‚“ã®ä¸ã«ã¯ã€MySQL 5.7ãŒæ£å¼ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã“ã¨ã‚’ã”å˜ã˜ãªã„æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã‚‚çŸ¥ã‚Œãªã„ã€‚é…ããªã£ã¦ç”³ã—è¨³ãªã„ãŒã€MySQL 5.7ã¯ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.7.9ã‚’ã‚‚ã£ã¦æ£å¼ç‰ˆã¨ãªã£ã¦ã„ã‚‹ã€‚5.7.9ã¯ç´„2ãƒ¶æœˆå‰ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚ã¤ã„ã§ã«è¨€ã†ã¨ã€ãƒã‚°ä¿®æ£ã‚’å«ã‚“ã 5.7.10ãŒæ—¢ã«å‡ºã¦ã„ã‚‹ã€‚ MySQL 5.7ã¯ã¾ã•ã«ãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼ã ï¼ï¼ï¼ã¨
masasuz 2016/05/20
mysql

mysql5.7
ãƒªãƒ³ã‚¯
é›‘ãª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
masasuz 2016/01/26
MySQL
ãƒªãƒ³ã‚¯
Osc2015åŒ—æµ·é“ æœå¹Œmy sqlå‹‰å¼·ä¼š_æ³¢å¤šé‡Ž_r3
MySQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç›£è¦–ã™ã‚‹ Cacti ã‚°ãƒ©ãƒ•ã®è¦‹æ–¹ã€InnoDB ã® I/O ã®ä»•çµ„ã¿ã®èª¬æ˜ŽRead less
masasuz 2015/12/22
mysql
ãƒªãƒ³ã‚¯
æ—¥æœ¬ã®ãŠå®¢æ§˜ã«ãŠã‘ã‚‹Amazon Auroraã¸ã®ç§»è¡Œãƒ»æ¤œè¨¼äº‹ä¾‹ã¨æŠ€è¡“ãƒã‚¤ãƒ³ãƒˆ
8. ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚‚ã†â¼€ä¸€åº¦ï¨è€ƒãˆã‚‹ â€¢ ä»Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å†åº¦ï¨å®Ÿè£…ã™ã‚‹ãªã‚‰ã©ã†ã™ã‚‹ ã‹ï¼Ÿ â€“ å°‘ãªãã¨ã‚‚1970å¹´ï¦Žä»£ã®â½…æ–¹æ³•ã§å®Ÿè£…ã¯ã—ãªã„ â€“ AWSã‚µãƒ¼ãƒ“ã‚¹ã‚’æ´»ã‹ã™ã“ã¨ãŒã§ãã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆãŒç°¡å˜ã§ã€ ã‚»ãƒ«ãƒ•ãƒ’ãƒ¼ãƒªãƒ³ã‚°ãŒå‡ºæ¥ã‚‹ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚ŠãŸã„ã¨è€ƒ ãˆãŸ 10. Amazon Auroraã®ç‰¹å¾´ â€¢ MySQL5.6ã¨äº’æ›æ€§ãŒã‚ã‚‹ãŸã‚æ—¢å˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç°¡å˜ã«ç§»è¡Œå¯èƒ½ â€¢ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒ10GBã‹ã‚‰64TBã¾ã§ã‚·ãƒ¼ãƒ ãƒ¬ã‚¹ã«æ‹¡å¼µ â€¢ 3AZã«2ã¤ãšã¤ã€è¨ˆ6ã¤ã®ãƒ‡ãƒ¼ã‚¿ã®ã‚³ãƒ”ãƒ¼ã‚’ä¿æŒ â€“ S3ã«ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å®Ÿæ–½ â€¢ VPCå†…ã«èµ·å‹• â€“ Security Â Groupã‚„NACLã‚’ä½¿â½¤ç”¨ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«å¯èƒ½ â€¢ Amazon Â Auroraã¯99.99%ã®å¯â½¤ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ã‚ˆã†ã«è¨è¨ˆã•ã‚Œã¦ã„ã‚‹ http://bit.ly/1LXB7Jq 1
masasuz 2015/12/21
aurora

aws

mysql
ãƒªãƒ³ã‚¯
MySQLé–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿(ä¸»ã«InnoDB)ã«ã¤ã„ã¦ - hiroi10ã®ãƒ–ãƒã‚°
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯MySQL Casual Advent Calendar 2015ã®10æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ å…ˆæ—¥ã®MySQL Casual Talks Vol8ã§@karupaneruraã•ã‚“ãŒãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æŒ¯ã‚Šè¿”ã‚Šã®ã‚ˆã†ãªç™ºè¡¨ã‚’ã•ã‚Œã¦ã„ãŸã®ã§ã€æ˜¨ä»Šã‚ã¾ã‚Šæ›¸ã‹ã‚Œãªããªã£ãŸMySQLã«çµ¡ã‚€è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ãã‚Œãªã‚Šã®ãƒ¡ãƒ¢ãƒª(32GBã¨ã‹)ã‚„SSDã¨ã‹ä½¿ã£ã¦ã‚‹äº‹ã‚’å‰æã«ã—ãŸã‚ˆã†ãªå†…å®¹ã¨ãªã‚Šã¾ã™ã€‚ ä¾å˜ã—ã¦å¤‰æ›´ã—ãŸæ–¹ãŒè‰¯ã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚‚ã‚ã‚‹ã®ã§å†…å®¹ãŒå‰å¾Œã«é£›ã³ã¾ã™ãŒã”å®¹èµ¦ä¸‹ã•ã„ã€‚ã¾ãŸã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ãŒã£ã¤ã‚Šèªã‚“ã ã‚ã‘ã§ã¯ãªãã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä¸ã®æŒ™å‹•ã‹ã‚‰æŽ¨æ¸¬ã—ã¦ã„ã‚‹ç®‡æ‰€ãŒå¤šåˆ†ã«ã‚ã‚Šã¾ã™ã€‚MyISAMã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚µãƒ¼ãƒ“ã‚¹ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åŒå±…ã™ã‚‹äº‹ã‚’è€ƒæ…®ã—ã¦ã„ã¾ã›ã‚“ã€‚ çµæ§‹çªè²«ã§æ›¸ã„ã¦ã„ã‚‹ã®ã§å¾Œã‹ã‚‰å¾®å¦™ã«ä¿®æ£ã™ã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ InnoDBã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ innodb_buffer_pool_
masasuz 2015/12/10
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ã‚’æŠ•
masasuz 2015/12/07
mysql
ãƒªãƒ³ã‚¯
Pelletkachels | DÃ© Expert voor jou duurzame Pelletkachel in huis
Pelletkachels waren ooit eenvoudige apparaten voor verwarming, maar ze hebben een opmerkelijke evolutie doorgemaakt sinds hun bescheiden begin in de jaren â€™80 van de vorige eeuw. In dit artikel duiken we diep in de geschiedenis van pelletkachel, bespreken we de belangrijkste mijlpalen en ontwikkelingen op het gebied van subsidiemogelijkheden en werpen we een blik op de transf ormatie tot moderne en
masasuz 2015/12/02
mysql

aurora

AWS
ãƒªãƒ³ã‚¯
MySQL Casual Talks Vol.8 ã§MySQL 5.7ã¨MariaDB 10.1ã®æ€§èƒ½æ¯”è¼ƒã«ã¤ã„ã¦ç™ºè¡¨ã—ã¾ã—ãŸ - hiroi10ã®ãƒ–ãƒã‚°
ã¯ã˜ã‚ã« é…ããªã‚Šã¾ã—ãŸãŒ11/20(é‡‘)ã«é–‹å‚¬ã•ã‚ŒãŸMySQL Casual Talks Vol.8ã§ä»¥ä¸‹ã‚¹ãƒ©ã‚¤ãƒ‰ã§ç™ºè¡¨ã—ã¾ã—ãŸã€‚ãã®å†…å®¹ã®è£œè¶³ã¨ã‹ã‚’è¼‰ã›ã¦ãŠãã¾ã™ã€‚ MySQL5.7ã¨MariaDB10.1ã®æ€§èƒ½æ¯”è¼ƒ(ç°¡æ˜“) from hiroi10 æœ€è¿‘MariaDB 10.1ãŒGAã«ãªã‚Šã€MySQL 5.7ãŒGAã«ãªã‚Šã€MariaDBã£ã¦ã©ã†ãªã‚“ï¼Ÿã€ã¨ã‹èžã‹ã‚Œã‚‹äº‹ãŒå¢—ãˆãŸãŸã‚ã¨ã‚Šã‚ãˆãšãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§æ€§èƒ½æ¯”è¼ƒã—ã¦ã¿ã‚ˆã†ã€ãŒç™ºç«¯ã§ã—ãŸã€‚MariaDBã®10ç³»ã¯MySQL 5.5ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã§æ£ç›´ã‚ã¾ã‚ŠæœŸå¾…ã—ã¦ã„ãªã‹ã£ãŸã®ã§ã™ãŒã€èµ·å‹•æ™‚ã®ãƒã‚°ã‚’è¦‹ã‚‹ã¨InnoDBã¯Perconaã®XtraDB5.6ãƒ™ãƒ¼ã‚¹ã ã£ãŸã®ã§Percona5.6ã¨åŒã˜å‚¾å‘ã‹ãªãã¨ã„ã†æƒ³åƒã§å®Ÿæ–½ã—ã¾ã—ãŸãŒæ¦‚ãåŒã˜å‚¾å‘ã¨ãªã‚Šã¾ã—ãŸã€‚ ã¾ãšã€ç§ã¯MariaDB10ç³»ã¯ã¾ã¨ã‚‚ã«è§¦ã£ãŸã“ã¨ãŒãªã‹ã£ãŸã®ã§å¤‰ã ãªã¨
masasuz 2015/11/30
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸