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

amari3 id:amari3

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

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

TiDBã¨MySQLã®æ©Ÿèƒ½æ¯”è¼ƒ - Believe you can
ZOZO Advent Calendar 2022 ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ Vol.3 ã® 9 æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ä¹…ã—ã¶ã‚Šã®ãƒ–ãƒã‚°æ›´æ–°ã«ãªã‚Šã¾ã™ã€‚å‰å›žã‹ã‚‰ã ã„ã¶æ™‚é–“ãŒç©ºã„ã¦ã—ã¾ã£ãŸã®ã§å®šæœŸçš„ã«æ›¸ã‘ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‹ãªã„ã¨ã¨åçœã—ã¦ã„ã¾ã™ã€‚ã€‚ NewDBã¨å‘¼ã°ã‚Œã‚‹æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒç™»å ´ã—åˆ©ç”¨äº‹ä¾‹ãŒå¢—ãˆã¦ãã¾ã—ãŸã€‚ãã®ä¸ã§ã‚‚MySQLäº’æ›ã®TiDBã«ã¤ã„ã¦è€³ã«ã™ã‚‹æ©Ÿä¼šãŒå¢—ãˆãŸã®ã§ã€MySQLã¨ã®æ©Ÿèƒ½æ¯”è¼ƒã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚DBé¸å®šã‚„ç§»è¡Œæ¤œè¨Žã®éš›ã«ãŠå½¹ã«ç«‹ã¦ã‚Œã°å¹¸ã„ã§ã™ã€‚ TiDBã¨ã¯ TiDBã¯PingCAPç¤¾ãŒé–‹ç™ºã—ãŸåˆ†æ•£åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€RDBMSã¨NoSQLã®æ©Ÿèƒ½ã‚’çµ„ã¿åˆã‚ã›ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ MySQLäº’æ›ã®SQLè§£æžæ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã‚‹ãŸã‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯MySQLã¨åŒæ§˜ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒå¯èƒ½ã§ã‚ã‚Šã€æ°´å¹³æ–¹å‘ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãƒ»å”åŠ›ãªä¸€è²«æ€§ãƒ»é«˜å¯ç”¨æ€§ã‚’å…¼ãå‚™ãˆã¦ã„ã¾ã™ã€‚ pingcap.co.jp
amari3 2023/11/09
tidb

mysql
ãƒªãƒ³ã‚¯
MySQL ã§æŽ¡ç•ªãƒ†ãƒ¼ãƒ–ãƒ« - Qiita
LAST_INSERT_ID(expr) ã‚’ä½¿ã†æ–¹æ³• å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹æ–¹æ³•. MySQL 5.6 Reference Manual :: 12.14 Information Functions LAST_INSERT_ID(), LAST_INSERT_ID(expr) If expr is given as an argument to LAST_INSERT_ID(), the value of the argument is returned by the function and is rem embered as the next value to be returned by LAST_INSERT_ID(). This can be used to simulate sequences: ãƒ†ãƒ¼ãƒ–ãƒ«æº–å‚™ æŽ¡ç•ªãƒ†ãƒ¼ãƒ–ãƒ«
amari3 2020/08/27
mysql

innodb
ãƒªãƒ³ã‚¯
ã‚ˆã†ã“ãâ€¦ã€Žç”·ã®ä¸–ç•Œã€ã¸â€¦ï¼ˆAUTO_INCREMENTãŒå·»ãæˆ»ã‚‹ãŠè©±ï¼‰ - 41ã‹ã‚‰å§‹ã‚ã¾ã—ãŸ
AUTO_INCREMENTãŒå·»ãæˆ»ã‚‹ ä»Šã®ä¼šç¤¾ã«å…¥ã‚‹ã¾ã§çŸ¥ã‚‰ãªã‹ã£ãŸã‚“ã§ã™ãŒã€çµæ§‹æœ‰åãªãƒã‚°ã£ã½ã„ã§ã™ãã€‚ AUTO_INCREMENTã§æŽ¡ç•ªã•ã‚ŒãŸç•ªå·ãŒã€å†èµ·å‹•ã™ã‚‹ã¨MySQL5.7ä»¥å‰ã¯å·»ãæˆ»ã‚‹ç¾è±¡ãŒèµ·ãã‚‹è©±ã§ã™ã€‚ å†ç¾ã—ã¦ã¿ã‚‹ MySQL5.7ã¨8.0ã«ãã‚Œãžã‚ŒåŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã€æœ€æ–°ã®è¡Œã‚’å‰Šé™¤ã—ã¾ã™ã€‚ å…±é€š mysql> use test; Database changed mysql> CREATE TABLE `t1` ( -> `id` int(11) NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB; Query OK, 0 rows affected, 1 warning (0.04 sec) mysql> insert into t1 values(NULL); Query
amari3 2020/08/25
mysql

innodb
ãƒªãƒ³ã‚¯
InnoDBã®ã™ã‚ã‚ï¼ˆä»®ï¼‰
2. Copyright Â© GREE, Inc. All Rights Reserved. è‡ªå·±ç´¹ä»‹ â— ã‚ã‚Šã¨ MySQL ã®ã²ã¨ â— 3.23.58 ã‹ã‚‰ä½¿ã£ã¦ã‚‹ â— å‰è·ã®é ƒã€10å¹´ä»¥ä¸Šå‰ã¯ã€ MMO RPG ã® DB ã®è¨è¨ˆãªã©ã‚‚ã‚„ã£ã¦ã¾ã—ãŸ â— ã‚€ã‹ã—ã¯ Resource Monitoring ã‚‚åŠ›å…¥ã‚Œã¦ã‚„ã£ã¦ãŸ â— ganglia & rrdcached ã®ï¼ˆãŸã¶ã‚“ï¼‰ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ â— ã¨ã„ã†ã‚ã‘ã§ã€è‡ªåˆ†ã¯ Monitoring ã‚’å¤§äº‹ã«ã™ã‚‹ â— ä¸€æ™‚æœŸã¯ Flare ã¨ã„ã† OSS ã® bugfix ãªã©ã‚‚ã‚„ã£ã¦ãŸ â— ã•ã„ãã‚“ã¯ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®è©•ä¾¡ã‚’ã—ã¦ã„ã‚‹æ™‚é–“ãŒé•·ã‹ã£ãŸ â— ãŸã¾ã« Linux ã® TCP ãƒ—ãƒãƒˆã‚³ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ã«ã¤ã„ã¦èª¿ã¹ãŸã‚Šã‚‚ã™ã‚‹ 2
amari3 2019/10/08
mysql

presentation

innodb
ãƒªãƒ³ã‚¯
ãã®è¡ŒãŒãƒžã‚¹ã‚¿ãƒ¼ã«INSERTã•ã‚Œã¦ã‹ã‚‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã§SELECTã•ã‚Œã‚‹ã¾ã§
2019/10/02 æ—¥æœ¬OSSæŽ¨é€²ãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³éƒ¨ä¼š ç¬¬11å›žå‹‰å¼·ä¼š https://ossforum.connpass.com/event/145515/
amari3 2019/10/07
mysql

presentation
ãƒªãƒ³ã‚¯
MySQLã®å®¹é‡ã¨ã‹åœ§ç¸®ã¾ã‚ã‚Š
APIdays Paris 2019 - Innovation @ scale, APIs as Digital Factories' New Machi...
amari3 2019/09/17
mysql

presentation
ãƒªãƒ³ã‚¯
MySQL 8.0.14ã§SELECT COUNT(*)ãŒåŠ é€Ÿã™ã‚‹ï¼- ã€Œinnodb_parallel_read_threadsã€æ¤œè¨¼ãã®ï¼‘ - ãªã‹ã‚‰ãªLife
ãã‚Œã¯çªç„¶ã‚„ã£ã¦ããŸ MySQL 8.0.14ãŒGAã•ã‚Œã¾ã—ãŸã€‚ dev.mysql.com ã¾ã‚ã€MySQLã¯çµæ§‹ãªé »åº¦ã§ãƒªãƒªãƒ¼ã‚¹ãŒã‚ã‚Šã¾ã™ã—ã€ã€ŒGAã¨ã¯ãªã‚“ãžã‚„ã€ã¨ã®åè¨€ãŒç”Ÿã¾ã‚Œã‚‹ç¨‹åº¦ã«ã€ãƒžã‚¤ãƒŠãƒ¼ãƒªãƒªãƒ¼ã‚¹ã§ã‚‚æ©Ÿèƒ½ãŒå¢—ãˆã‚‹ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒå¢—ãˆã‚‹ã€æ—¢å˜ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ãŒå¤‰ã‚ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ãŒç™ºç”Ÿã™ã‚‹ã‹ã‚ã„ã„ãƒ¤ãƒ„ã§ã™ã€‚ ã¾ã‚ã€ã‚ã¨ã§ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆèªã‚“ã§ã¿ã‚‹ã‹ã€ã¨æ€ã„ã¤ã¤ã€ãƒ“ãƒ¼ãƒ«ã‚’é£²ã¿ãªãŒã‚‰Youtubeåž‚ã‚Œæµã—ã¦ãƒœã‚±ãƒ¼ã£ã¨ã—ã¦ã„ã‚‹ã¨ã“ã‚ã«ã€æ–°ã—ã„ã‚‚ã®ãŒå‡ºã¦ãã‚‹ã¨ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã¨ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã¿æ¼ã‚‹æŸAPIã®äººã®ãƒ„ã‚¤ãƒ¼ãƒˆãŒæ·±å¤œã«æµã‚Œã¦ãã¦ã€ãµã¨æ°—ã«ãªã£ãŸã®ãŒã€ä»Šå›žã®ãƒ†ãƒ¼ãƒžã§ã‚ã‚‹ã€Œinnodb_parallel_read_threadsã€ã§ã™ã€‚ InnoDB: InnoDB now supports parallel clustered index reads, which can im
amari3 2019/09/13
mysql
ãƒªãƒ³ã‚¯
MySQL 8.0.17ã§ã¤ã„ã«Cloneãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒå…¥ã£ãŸ
TL;DR MySQL 8.0.17 ã§ã¤ã„ã«ä¿ºå¾…æœ›ã® Cloneãƒ—ãƒ©ã‚°ã‚¤ãƒ³ ãŒè¿½åŠ ã•ã‚ŒãŸ CLONE LOCAL DATA DIRECTORY .. ã§ã€ãƒãƒ¼ã‚«ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«ã»ã¼ãƒŽãƒ³ãƒ–ãƒãƒƒã‚ãƒ³ã‚°ã§ç‰©ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’åãå‡ºã™ CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY 'password' .. ã§ã‚°ãƒ«ãƒ¼ãƒ—ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®çµŒè·¯ã‚’ä½¿ã£ã¦ãƒ•ãƒ„ãƒ¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨åŒã˜3306ã®çµŒè·¯ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ä¸¸ã‚³ãƒ”ãƒ¼ãŒã§ãã‚‹ã‚‰ã—ã„ ã“ã®ã¸ã‚“ã‚’èªã‚“ã§ãŠãã®ãŒè‰¯ã•ã’ MySQL :: MySQL 8.0 Reference Manual :: 5.6.7 The Clone Plugin MySQL :: MySQL 8.0 Reference Manual :: 5.6.7.13 Clone Plugin Limitations mysql
amari3 2019/07/25
mysql
ãƒªãƒ³ã‚¯
MySQL ã® max_connections, table_open_cache, open_files_limit ã®é–¢ä¿‚ - tmtms ã®ãƒ¡ãƒ¢
æ˜”æ›¸ã„ãŸè¨˜äº‹ã‚’ä¹…ã€…ã«è¦‹ã¦ã¿ãŸã‚‰ä½•æ›¸ã„ã¦ã‚ã‚‹ã‹ã•ã£ã±ã‚Šã‚ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€æœ€æ–°æƒ…å ±ã§æ›¸ãç›´ã—ã¦ã¿ã¾ã™ã€‚ tmtms.hatena blog.com ä»¥ä¸‹ã¯ MySQL 5.6, 5.7 ã«ã¤ã„ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ MySQL ã® max_connectoins, table_open_cache, open_files_limit ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ç›¸äº’ã«ä¾å˜ã—ã¦å‹•çš„ã«å€¤ãŒè¨å®šã•ã‚Œã¾ã™ã€‚ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿å ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ æœ€å°å€¤ æœ€å¤§å€¤ max_connections 151 1 100000 table_open_cache 2000 1 524288 open_files_limit 5000 0 4G ã‚ã‹ã‚‰ãªã„ã¨è¨€ã‚ã‚ŒãŸã®ã§è¿½è¨˜ã€‚ my.cnfã‚„ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³ç‰ã§è¨å®šã•ã‚ŒãŸå€¤(ã¾ãŸã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤)ã‚’åˆæœŸå€¤ã¨ã—ã¦ã€open_files_limit â†’ max_connections â†’ ta
amari3 2019/07/02
mysql
ãƒªãƒ³ã‚¯
InnoDB ã®å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã«ãŠã‘ã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥åˆ©ç”¨ã«ã¤ã„ã¦ | ã‚¹ãƒžãƒ¼ãƒˆã‚¹ã‚¿ã‚¤ãƒ« TECH BLOG
MySQL 5.7 ã«ãŠã„ã¦ InnoDB ã®å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ãŒæ—¥æœ¬èªžã«å¯¾å¿œã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ç´„ 3 å¹´ãŒçµŒã¡ã¾ã—ãŸã€‚ä»Šã§ã¯ InnoDB ã§æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ãŒã§ãã‚‹ã“ã¨ã¯åºƒãçŸ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã‚“ãªä¸ã€ä»Šå›žã¯ MySQL 8.0 ã«ãŠã„ã¦ã‚‚ã¾ã ä¿®æ£ã•ã‚Œã¦ã„ãªã„ã€å…¨æ–‡æ¤œç´¢ã®åˆ¶é™ã«ã¤ã„ã¦ç¢ºèªã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ MySQL 5.7 ã®æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã¨ã¯ ã¾ãšã€MySQL 5.7 ã«ãŠã„ã¦ä½•ãŒå¤‰ã‚ã£ãŸã®ã‹ã«ã¤ã„ã¦ç°¡å˜ã«ãŠã•ã‚‰ã„ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ MySQL 5.6 ã¾ã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ FULLTEXT ãƒ‘ãƒ¼ã‚µãƒ¼ãŒä½¿ç”¨ã•ã‚Œã¦ã„ãŸãŸã‚ã€æ—¥æœ¬èªžã®ã‚ˆã†ã«å˜èªžã®åˆã‚ã¨çµ‚ã‚ã‚ŠãŒæ˜Žç¢ºã§ãªã„è¨€èªžã§ FULLTEXT ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã€å˜èªžã‚’åŒºåˆ‡ã£ãŸã‚Š N-gram ã§åˆ†å‰²ã—ãŸçŠ¶æ…‹ã§ DB ã«æ ¼ç´ã™ã‚‹ãªã©ã€ä½¿ç”¨ã™ã‚‹ãŸã‚ã«ã¯ DB ã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤‰å½¢ã—ã¦æ ¼ç´ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾
amari3 2019/05/22
mysql
ãƒªãƒ³ã‚¯
MySQL5.7 InnoDB ã®N-gramå…¨æ–‡æ¤œç´¢ã‚’æ¤œè¨¼ï¼†ã‚µãƒ¼ãƒ“ã‚¹å°Žå…¥ã—ãŸ
MySQL5.7ãƒ»InnoDBãƒ»N-gram ã¨ã„ã†ç’°å¢ƒä¸‹ã§å…¨æ–‡æ¤œç´¢ã®æŒ™å‹•ã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦æ¤œè¨¼ã‚’è¡Œã£ãŸã€‚FULLTEXT INDEXã¯ä»¥å‰ã¯MyISAMã§ã—ã‹åˆ©ç”¨ã§ããªã‹ã£ãŸãŒã€ 5.6.4ã‹ã‚‰InnoDBã§ã®ã‚µãƒãƒ¼ãƒˆãŒå§‹ã¾ã£ã¦ã„ãŸã€‚ InnoDBã®å…¨æ–‡æ¤œç´¢ã¯5.7ã€ç‰¹ã«5.7.6ä»¥é™ã§ã„ã‚ã‚†ã‚‹CJKï¼ˆä¸å›½èªžãƒ»æ—¥æœ¬èªžãƒ»éŸ“å›½èªžï¼‰ãŒN-gramã§æ¨™æº–ã‚µãƒãƒ¼ãƒˆã•ã‚Œå§‹ã‚ã€ CREATE TABLEæ–‡ã§ç°¡å˜ã«ãƒ‘ãƒ¼ã‚µãƒ¼ã‚’æŒ‡å®šã§ãã‚‹æ§‹æ–‡ã®ã‚µãƒãƒ¼ãƒˆã€ è¨å®šã‚„ã‚¯ã‚¨ãƒªã®çµ„ç«‹ã§è€ƒãˆãªã„ã¨ã„ã‘ãªã„äº‹ãŒæ¸›ã£ãŸäº‹ã§å°Žå…¥éšœå£ãŒã‹ãªã‚Šä¸‹ãŒã£ã¦ã„ã‚‹ã€‚ â€»4.1ã¨5.0ã§ã‚µãƒ¼ãƒ“ã‚¹å°Žå…¥çµŒé¨“ãŒã‚ã‚‹ç§ã®å€‹äººçš„ãªæ¯”è¼ƒæ„Ÿæƒ³ã§ã™ã€‚ FULLTEXT INDEXã‚‚ä»–ã®INDEXã¨åŒæ§˜ã«ãƒ‡ãƒ¼ã‚¿æ›´æ–°ãƒ»å‰Šé™¤ã®éš›ã«INDEXã®rebuildãŒèµ°ã‚‹ã®ã§æ›´æ–°æ™‚ã®è² è·ã«ã¯æ³¨æ„ãŒå¿…è¦ã§ã€FULLTEXT INDEXã®å ´åˆã¯ã€Œrebuildè² è·ãŒåˆ—
amari3 2019/05/21
mysql
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã®å°‚ç”¨ã‚µãƒ¼ãƒã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿæ–½ã—ã¦ã¿ãŸ ï½ž æ‰‹é †ç·¨ ï½ž | ã•ãã‚‰ã®ãƒŠãƒ¬ãƒƒã‚¸
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€æ ªå¼ä¼šç¤¾ã‚¹ãƒžãƒ¼ãƒˆã‚¹ã‚¿ã‚¤ãƒ«ã®ä¸é‡Žã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€ä»¥å‰æŠ•ç¨¿ã—ãŸã€Žã•ãã‚‰ã®å°‚ç”¨ã‚µãƒ¼ãƒã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿæ–½ã—ã¦ã¿ãŸ ï½ž ã‚¹ã‚³ã‚¢ç·¨ ï½žã€ã§å®Ÿæ–½ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®æ‰‹é †ã‚„æ³¨æ„ç‚¹ã‚’ç´¹ä»‹ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ä»Šå¾Œã€MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è©¦é¨“ã‚’å®Ÿæ–½ã—ã‚ˆã†ã¨æ€ã£ã¦ã„ã‚‹æ–¹ã®å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ è©¦é¨“å…¨ä½“ã®æµã‚Œ å‰å›žã®è¨˜äº‹ã«ã‚‚è¨˜è¼‰ã—ã¾ã—ãŸãŒã€ä»Šå›žã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è©¦é¨“ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæµã‚Œã§å®Ÿæ–½ã—ã¦ã„ã¾ã™ã€‚ Flashã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®ãƒžã‚¦ãƒ³ãƒˆã€ã‚«ãƒ¼ãƒãƒ«è¨å®šã®å¤‰æ›´ï¼ˆå°‚ç”¨ã‚µãƒ¼ãƒã®ã¿ï¼‰ DBã‚µãƒ¼ãƒã« MySQL5.7.18 ã¨ Percona XtraBackup2.4.8 ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« è¨ˆæ¸¬ã‚µãƒ¼ãƒã« Sysbench 1.0 ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Sysbenchã®ãƒ‡ãƒ¼ã‚¿ãƒãƒ¼ãƒ‰å®Ÿè¡Œ XtraBackupã§å…¨ä½“ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾— ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ç”¨ã®my.cnfã‚’è¨å®š Sysbenchã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿè¡Œ MySQLã‚’
amari3 2019/05/08
mysql

benchmark
ãƒªãƒ³ã‚¯
MySQL 8.0.16ã«CHECKåˆ¶ç´„ãŒæ¥ã¦ã€NOT ENFORCEDãªã‚“ã¦ã‚‚ã®ã¾ã§ã¤ã„ã¦ããŸ
mysql80 8> SELECT @@version; +-----------+ | @@version | +-----------+ | 8.0.16 | +-----------+ 1 row in set (0.00 sec) mysql80 8> CREATE TABLE t1 (num serial, val varchar(32)); Query OK, 0 rows affected (0.02 sec) mysql80 8> INSERT INTO t1 VALUES (1, 'one'), (2, 'two'), (3, 'ã•ã‚“'); Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql80 8> SELECT * FROM t1; +-----+-------
amari3 2019/05/07
mysql
ãƒªãƒ³ã‚¯
ã€ŒMySQL 8.0 ã®è–„ã„æœ¬ã€ã‚’æ›¸ã„ãŸè©± - æ§‹ç¯‰ä¸ã€‚
1 ã¤å‰ã®ã‚¨ãƒ³ãƒˆãƒªã€ hmatsu47.hatena blog.com ã§ã‚‚å°‘ã—è§¦ã‚Œã¾ã—ãŸãŒã€ã€ŒMySQL 8.0 ã®è–„ã„æœ¬ã€ã¨ã„ã†ã®ã‚’æ›¸ã„ã¦ã¿ãŸã®ã§ã€ãã‚Œã«ã¤ã„ã¦ã‚‚ã†å°‘ã—çªã£è¾¼ã‚“ã§è§¦ã‚Œã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ MySQL 8.0ã®è–„ã„æœ¬ã€ç¾æ™‚ç‚¹ã®é…å¸ƒç”¨ãƒ‡ãƒ¼ã‚¿ã¯ã“ã“ã«ç½®ã„ã¦ã‚ã‚‹ã€‚https://t.co/2UJ0xNQXEK https://t.co/dVq6lNlHnTâ€” hmatsu47(ã¾ã¤) (@hmatsu47) 2019å¹´4æœˆ13æ—¥ æŠ€è¡“åŒäººèªŒã‚’æ›¸ã„ãŸç†ç”± å˜ç´”ã«ã€ŒRe:VIEW ã‚’ä½¿ã£ã¦åŸ·ç†ä½“é¨“ã‚’ã—ã¦ã¿ãŸã‹ã£ãŸã€ã¨ã„ã†ã®ãŒæœ€å¤§ã®ç†ç”±ã§ã™ã€‚ reviewml.org åŠ ãˆã¦ã€ä½•ã‹ã‚¤ãƒ™ãƒ³ãƒˆã®ã¨ãã«æ•°å†ŠæŒã£ã¦ã„ã£ã¦é…ã‚Œã°è©±é¡Œä½œã‚Šã«ãªã‚‹ã€ã¨ã„ã†ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã¾ãŸã€åŸ·ç†ãƒ†ãƒ¼ãƒžã¨ã—ã¦ã€ŒMySQL 8.0 ã®æ–°æ©Ÿèƒ½ã¨ MySQL 5.7 ã‹ã‚‰ã®å¤‰æ›´ç‚¹ã€ã‚’é¸ã‚“ã ç†ç”±ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Qiit
amari3 2019/04/23
mysql
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾Go-Next | ãŠå®¢æ§˜ã«ãƒ“ã‚¸ãƒã‚¹ã®æˆé•·ã¨é©æ–°ã‚’
ä»Šæ—¥ã‚‚ç”Ÿã¾ã‚Œã‚‹æ„Ÿå‹•ã¨ç¬‘é¡” ãŠå®¢æ§˜ã®äº‹æ¥ã€æˆ¦ç•¥ã€Webã‚µã‚¤ãƒˆã®ç¾çŠ¶ãªã©ã‚’æŠŠæ¡ã—ã€æœ€é©ãªæ–½ç–ã‚’ç«‹æ¡ˆãƒ»å®Ÿè¡Œã—ã¾ã™ã€‚ more info Top Message ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®éœ€è¦ãŒé«˜ã¾ã‚Šã€ãã®å¿…è¦æ€§ã¨å¯èƒ½æ€§ã‚’æ„Ÿã˜2005å¹´ã«å‰µæ¥ã—ã¦ä»¥æ¥ã€ç¾åœ¨ã«è‡³ã‚‹ã¾ã§ã‚¹ãƒ†ãƒ¼ã‚¯ãƒ›ãƒ«ãƒ€ãƒ¼ã®çš†ã•ã¾ã«æ”¯ãˆã¦ã„ãŸã ããªãŒã‚‰æˆé•·ã‚’ç¶šã‘ã¦ã¾ã„ã‚Šã¾ã—ãŸã€‚ã€ŒITã¨ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ–ã®ãƒã‚«ãƒ©ã§ã€å¿ƒæ²¸ãèµ·ã“ã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚’ç”Ÿã¿å‡ºã™ã€ã“ã¨ã‚’ãƒŸãƒƒã‚·ãƒ§ãƒ³ã«æŽ²ã’ã€ã•ã‚‰ãªã‚‹å……å®Ÿã—ãŸãƒã‚«ãƒ©æº¢ã‚Œã‚‹æœªæ¥ã®å®Ÿç¾ã‚’ç›®æŒ‡ã—ã¾ã™ã€‚ç§ãŸã¡ã®å¼·ã¿ã¯ã€ä¼ç”»æˆ¦ç•¥ã‹ã‚‰ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã€ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ–ã€ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«æ¸¡ã‚‹ãƒ¯ãƒ³ã‚¹ãƒˆãƒƒãƒ—ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³æä¾›ã¨ã‚ªãƒ¼ãƒŠãƒ¼ã‚·ãƒƒãƒ—ãƒžã‚¤ãƒ³ãƒ‰ã‚’ä¸¡ç«‹ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€ã‚ˆã‚Šç²¾åº¦ã®é«˜ã„ã€é¡§å®¢æº€è¶³åº¦ã®é«˜ã„ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã¨èª²é¡Œè§£æ±ºã‚’é”æˆã—ã¾ã™ã€‚ã¾ãŸã€å‰µé€ æ€§ã®å‘ä¸Šã€ç”Ÿç”£æ€§ã®å‘ä¸Šã€ã‚³ã‚¹ãƒˆã®å‰Šæ¸›ã¨ã„ã£ãŸæ„è˜ã€æ–‡åŒ–ã‚’è‚²ã‚€ãŸ
amari3 2019/04/23
mysql
ãƒªãƒ³ã‚¯
InnoDB å…¨æ–‡æ¤œç´¢ : MeCab Parser | MySQL Server Blog
(ã“ã®è¨˜äº‹ã¯Â InnoDB Full-Text: MeCab Parser ã‚’ Yoshiaki Yamasaki ãŒç¿»è¨³ã—ãŸã‚‚ã®ã§ã™) ã“ã®ãƒ–ãƒã‚°è¨˜äº‹ã§ç´¹ä»‹ã—ãŸä¸€èˆ¬çš„ãªCJK(ä¸å›½èªžã€æ—¥æœ¬èªžã€éŸ“å›½èªž)ã®ã‚µãƒãƒ¼ãƒˆã«åŠ ãˆã¦ã€ç§é”ã¯MeCabãƒ‘ãƒ¼ã‚µãƒ¼ã‚‚è¿½åŠ ã—ã¾ã—ãŸã€‚MeCabã¯æ—¥æœ¬èªžã®å½¢æ…‹ç´ è§£æžã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ç§é”ã¯ä»ŠMeCabã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸå…¨æ–‡æ¤œç´¢ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãƒ‘ãƒ¼ã‚µãƒ¼ã‚’æŒã£ã¦ã„ã¾ã™ï¼ ä½¿ç”¨æ–¹æ³• mecab_rc_fileã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è¨å®šã™ã‚‹ â€” mecab_rc_fileã¯MeCabãƒ‘ãƒ¼ã‚µãƒ¼ã«é–¢é€£ã™ã‚‹èªã¿å–ã‚Šå°‚ç”¨ã®ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã§ã™ã€‚mecab_rc_fileãŒæŒ‡ã™mecabrcãƒ•ã‚¡ã‚¤ãƒ«ã¯MeCabãŒå¿…è¦ã¨ã™ã‚‹è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ãã—ã¦ã€MeCabã«è¾žæ›¸ã‚’ã©ã“ã‹ã‚‰ãƒãƒ¼ãƒ‰ã™ã‚Œã°ã„ã„ã‹ã‚’ä¼ãˆã‚‹ãŸã‚ã«ã€ dicdir=/path/to/ipadicã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãŒå¿…è¦ã§ã™ã€‚MySQLãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã¨ã€
amari3 2019/04/23
mysql

mecab
ãƒªãƒ³ã‚¯
MySQL5.7_MeCabç”¨è¾žæ›¸ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚º â€“ variable.jp [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹,ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹,é‹ç”¨]
æœ€è¿‘ã€MySQL5.7ã®å½¢æ…‹ç´ è§£æžã‚¨ãƒ³ã‚¸ãƒ³ã®mecabã«é–¢ã—ã¦è¾žæ›¸ã‚’ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå‡ºæ¥ã‚‹ã‹ã©ã†ã‹ èžã‹ã‚Œã‚‹äº‹ãŒå¢—ãˆãŸç‚ºã€mecabã®è¾žæ›¸ã‚’ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã—ã¦ãã¡ã‚“ã¨å‹•ä½œç¢ºèªã—ã¦ã¿ã¾ã—ãŸã€‚ çµè«–ã¨ã—ã¦ã¯ã€å•é¡Œç„¡ãã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã—ãŸè¾žæ›¸ã‚‚åˆ©ç”¨å‡ºæ¥ã‚‹ã‚ˆã†ã§ã™ã€‚ ä½†ã—ã€MySQLã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãƒšãƒ¼ã‚¸ã‚’è¦‹ã‚‹é™ã‚Šã€MySQL Binaryã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹mecabè¾žæ›¸ã®åˆ©ç”¨ã‚’æŽ¨å¥¨ã—ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ã€ä»¥ä¸‹ã€æŠœç²‹ã€‘ Installing MeCab From Source (Optional) https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html The mecab and mecab-ipadic packages distributed with the MySQL binary are recommended but if
amari3 2019/04/22
mysql

mecab
ãƒªãƒ³ã‚¯
LTï¼šMySQLã®ã‚®ãƒ£ãƒƒãƒ—ãƒãƒƒã‚¯ã¨ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ã«ã¤ã„ã¦
2019å¹´4æœˆ19æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã€Œä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼š in æ²–ç¸„ã€ã®LTã§ã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚ https://dbstudychugoku.connpass.com/event/127067/
amari3 2019/04/22
mysql

presentation
ãƒªãƒ³ã‚¯
Charsetã¨Collationã®è¨å®šãŒMySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ä¸Žãˆã‚‹å½±éŸ¿ | Yakst
MySQL 8 ã¯ MySQL 5.7 ã‚ˆã‚Šå¸¸ã«é«˜é€Ÿã¨ã¯é™ã‚‰ãªã„(MySQL 8 is not always faster than MySQL 5.7) ã«ç¶šã„ã¦ã€ ä»Šå›žã¯ã€ãƒ‡ãƒ¼ã‚¿ãŒãƒ¡ãƒ¢ãƒªã«åŽã¾ã£ã¦ãŠã‚Šã€CPUãƒã‚¦ãƒ³ãƒ‰ãªã€read only ã®ã¨ã¦ã‚‚ã‚·ãƒ³ãƒ—ãƒ«ãªãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã®ãƒ†ã‚¹ãƒˆã‚’ã™ã‚‹ã¨æ±ºã‚ã¾ã—ãŸã€‚ã“ã®ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã«IOå‡¦ç†ã¯ã‚ã‚Šã¾ã›ã‚“ã€ãƒ¡ãƒ¢ãƒªã¨CPUã®å‡¦ç†ã ã‘ã§ã™ã€‚ ãƒ†ã‚¹ãƒˆç’°å¢ƒ ç’°å¢ƒã®ã‚¹ãƒšãƒƒã‚¯ Release | Ubuntu 18.04 LTS (bionic) Kernel | 4.15.0-20-generic Processors | physical = 2, cores = 28, virtual = 56, hyperthreading = yes Models | 56xIntel(R) Xeon(R) Gold 5120 CPU @ 2.20GHz< Memory T
amari3 2019/04/17
mysql
ãƒªãƒ³ã‚¯
MySQL 8.0 ã® INSTANT DDL ã«ã¤ã„ã¦ | ã‚¹ãƒžãƒ¼ãƒˆã‚¹ã‚¿ã‚¤ãƒ« TECH BLOG
MySQL 8.0.12 ã¯ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã§ã™ãŒã€ALTER TABLE ã§ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã™ã‚‹éš›ã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã«ã€ŒINSTANTã€ãŒè¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚ MySQL 8.0: InnoDB now supports Instant ADD COLUMN | MySQL Server Blog ALGORITHM=INSTANT ã¨ã¯ï¼Ÿ å¾“æ¥ã®ã€ŒCOPYã€ã‚„ã€ŒINPLACEã€ã¨ç•°ãªã‚Šã€ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°ã ã‘è¡Œã†ã“ã¨ã§é«˜é€Ÿã‹ã¤è² è·ã‚’ã‹ã‘ãšã«ã‚«ãƒ©ãƒ ã®è¿½åŠ ãªã©ãŒè¡Œãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ãŸã ã—ã€ä½¿ãˆã‚‹ç¯„å›²ã¯é™å®šçš„ã§ä¸‹è¨˜ã®ã‚ˆã†ãªæ“ä½œã®ã¿ã«ãªã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®å¤‰æ›´ ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤‰æ›´ SET/DROP DEFAULT MODIFY COLUMN virtual column ã®è¿½åŠ ã€å‰Šé™¤ ã‚«ãƒ©ãƒ è¿½åŠ ï¼ˆåˆ¶é™ã‚ã‚Šï¼‰ ã‚«ãƒ©ãƒ è¿½åŠ ã§ã‚ã£ã¦ã‚‚ã€ä»¥ä¸‹ã®ã‚ˆã†ãªåˆ¶é™ãŒã‚ã‚Šã¾ã™ã€‚ INSTANTã‚¢ãƒ«ã‚´ãƒª
amari3 2019/04/16
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸