[B! MySQL] AKIMOTOã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

AKIMOTO id:AKIMOTO

MySQLã«é–¢ã™ã‚‹AKIMOTOã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (66)

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

ã€å¤œé–‹å‚¬ã€‘GitHubã€MySQL5.7â†’8.0ã¸ã®ã‚µãƒ¼ãƒ“ã‚¹ç„¡åœæ¢ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã®å†…å¹• (2024/03/25 19:00ã€œ)
ãŠçŸ¥ã‚‰ã› é‹å–¶ä¼šç¤¾ã®å¹´æœ«å¹´å§‹ä¼‘æ¥ã«ã¤ãã€2023å¹´12æœˆ27æ—¥(é‡‘)13æ™‚ä»¥é™ã®connpassæ©Ÿèƒ½ã®ãŠå•ã„åˆã‚ã›ã«ã¤ãã¾ã—ã¦ã¯2024å¹´1æœˆ6æ—¥(æœˆ)ã‚ˆã‚Šé †æ¬¡ã”æ¡ˆå†…ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ã‚ã‚‰ã‹ã˜ã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ãŠçŸ¥ã‚‰ã› ã‚¤ãƒ™ãƒ³ãƒˆãƒšãƒ¼ã‚¸å†…ã®ãƒ•ã‚£ãƒ¼ãƒ‰ã‚³ãƒ¡ãƒ³ãƒˆæŠ•ç¨¿ä»•æ§˜ã‚’å¤‰æ›´ã—ã¾ã—ãŸã€‚ä»Šå¾Œã€ã‚³ãƒ¡ãƒ³ãƒˆã®æŠ•ç¨¿ã¯ã€ã‚¤ãƒ™ãƒ³ãƒˆã«å‚åŠ ç™»éŒ²ï¼ˆè£œæ¬ ãƒ»æŠ½é¸ã‚’å«ã‚€ï¼‰ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã€ã¾ãŸã¯ã‚¤ãƒ™ãƒ³ãƒˆé–‹å‚¬é–¢ä¿‚è€…ï¼ˆç®¡ç†è€…ãƒ»ç™ºè¡¨è€…ï¼‰ã®ã¿å¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚å‚åŠ ç™»éŒ²ã‚’ã—ã¦ã„ãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã€ã‚¤ãƒ™ãƒ³ãƒˆãƒšãƒ¼ã‚¸ã«é–¢ã™ã‚‹é€£çµ¡ã‚„è³ªå•ãŒã‚ã‚‹å ´åˆã¯ã€ã€Œã‚¤ãƒ™ãƒ³ãƒˆã¸ã®ãŠå•ã„åˆã‚ã›ã€æ©Ÿèƒ½ã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚ ãŠçŸ¥ã‚‰ã› 2024å¹´9æœˆ1æ—¥ã‚ˆã‚Šã€connpassã§ã¯ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’ç¦æ¢ã—ã€åˆ©ç”¨è¦ç´„ã«æ˜Žè¨˜ã—ã¾ã—ãŸã€‚ä»¥é™ã®æƒ…å ±å–å¾—ã«ã¯connpass APIã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚APIã”åˆ©ç”¨ã«ã¤ã„ã¦ã¯ãƒ˜ãƒ«ãƒ—ãƒšãƒ¼ã‚¸ã‚’ã”ç¢ºèªãã ã•ã„ã€‚ 3æœˆ 25 ã€å¤œé–‹å‚¬ã€‘GitH
AKIMOTO 2024/03/22
MySQL

é‹ç”¨

ã‚¤ãƒ™ãƒ³ãƒˆ

ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¤ãƒ™ãƒ³ãƒˆ
ãƒªãƒ³ã‚¯
GitHub - bigprof-software/online-rental-property-manager: Manage your rental properties, units, applications, leases and tenants.
AKIMOTO 2023/10/09
CRM

ä¸å‹•ç”£

è³ƒè²¸

OSS

PHP

MySQL
ãƒªãƒ³ã‚¯
GitHub - pingcap/tidb: TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.
Distributed Transactions: TiDB uses a two-phase commit protocol to ensure ACID compliance, providing strong consistency. Transactions span multiple nodes, and TiDB's distributed nature ensures data correctness even in the presence of network partitions or node failures. Horizontal and Vertical Scalability: TiDB can be scaled horizontally by adding more nodes or vertically by increasing resources o
AKIMOTO 2022/01/25
database

MySQL
ãƒªãƒ³ã‚¯
æ¬¡ä¸–ä»£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ TiDB ã®æ¤œè¨¼ã¨ãã®è©•ä¾¡ [DeNA ã‚¤ãƒ³ãƒ•ãƒ© SRE] | BLOG - DeNA Engineering
â€»ã“ã¡ã‚‰ã¯å…ˆæ—¥å®Ÿæ–½ã•ã‚ŒãŸ DeNA ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ / SRE MEETUP ã§è©±ã—ãŸå†…å®¹ã‚’ Blog è¨˜äº‹åŒ–ã—ãŸã‚‚ã®ã§ã™ï¼ ã“ã‚“ã«ã¡ã¯ï¼ITåŸºç›¤éƒ¨ã®ç†Šè°·ã§ã™ã€‚ITåŸºç›¤éƒ¨ã«ã¦å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’è¦‹ã¦ã„ã‚‹ æ–°å’ï¼’å¹´ç›®ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ â€œDeNA ã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é‹ç”¨ã¨ãã®ãƒ„ãƒ©ãƒŸâ€ ã¨ã€â€œTiDBå°Žå…¥ã¸ã®æ¤œè¨¼ãƒ»æ¤œè¨Žâ€ ã‚’ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æœ€é©è§£ DeNA ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹æˆã¯æœ€é©è§£ã‚’æ±‚ã‚ã¦æ”¹è‰¯ã‚’ç©ã¿é‡ãã¦ãã¾ã—ãŸã€‚æœ€åˆæœŸã®æ§‹æˆã€(ä¾¿å®œä¸Šã€ç¬¬ï¼‘ä¸–ä»£ã¨å‘¼ã³ã¾ã™) ã§ã¯ VM Instance ä¸Šã« MySQL ã‚’æ§‹ç¯‰ã—ç®¡ç†ã™ã‚‹ MySQL on EC2 æ§‹æˆã€‚ç¶šãç¬¬ï¼’ä¸–ä»£ã§ã¯ã€ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã‚’é§†ä½¿ã—ãŸ Aurora MySQL æ§‹æˆã€‚ã“ã®ï¼’ä¸–ä»£ã®ä¸ã§ç”Ÿã˜ãŸ â€œãƒ„ãƒ©ãƒŸâ€ ã‚’è§£æ¶ˆã™ã‚‹æ¬¡ã®ä¸–ä»£ã€è¨€ã‚ã° ç¬¬ï¼“ä¸–ä»£ã«è©²å½“ã™ã‚‹æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹æˆã‚’ç¾
AKIMOTO 2022/01/25
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL

AWS

TiDB
ãƒªãƒ³ã‚¯
The ultimate MySQL database platform
Scale, performance, and reliabilityScale, performance, and reliabilitypowered by Vitess The MySQL database platform built for scalePlanetScale is built on Vitess and unlocks performance, scalability, and cost optimization for hyperscale databases through horizontal sharding.
AKIMOTO 2022/01/13
AWS RDSç«¶åˆ

database

MySQL

webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
Bump babel from 2.8.0 to 2.9.1 in /extra/libcbor/doc/source by dependabot[bot] Â· Pull Request #377 Â· mysql/mysql-server
AKIMOTO 2021/11/24
https://labs.cybozu.co.jp/blog/akky/2021/11/bot-vs-bot-stalemate/

bot

GitHub

dependabot

mysql

Oracle

è‡ªå‹•åŒ–

å¤±æ•—

ç´¹ä»‹ã—ãŸ
ãƒªãƒ³ã‚¯
MOCO - Kubernetes ç”¨ MySQL ã‚¯ãƒ©ã‚¹ã‚¿é‹ç”¨ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
ã‚µã‚¤ãƒœã‚¦ã‚ºã® Kubernetes åŸºç›¤ã‚’é–‹ç™ºã—ã¦ã„ã‚‹ Neco ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã® ymmt ã§ã™ã€‚ ã‚µã‚¤ãƒœã‚¦ã‚ºè£½å“ã®ã»ã¨ã‚“ã©ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ MySQL ã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚ ç¾åœ¨ 400 ã‚’è¶Šãˆã‚‹ MySQL ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’é‹ç”¨ã—ã¦ãŠã‚Šã€ã“ã‚Œã‚‰å…¨ã¦ã‚’æ–°ã—ã„ Kubernetes åŸºç›¤ã«ç§»è¡Œã—ã¦ã„ãäºˆå®šã§ã™ã€‚ Kubernetes ä¸Šã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®é‹ç”¨ã‚’è‡ªå‹•åŒ–ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ã“ã¨ã‚’ã‚ªãƒšãƒ¬ãƒ¼ã‚¿ãƒ¼ã¨è¨€ã„ã¾ã™ã€‚ å¤§é‡ã® MySQL ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ Kubernetes åŸºç›¤ã«ç§»è¡Œã™ã‚‹ã«ã¯ã‚ªãƒšãƒ¬ãƒ¼ã‚¿ãƒ¼ãŒå¿…é ˆã§ã‚ã‚‹ã¨è€ƒãˆã€æŠ€è¡“é¡§å•ã® @yoku0825 ã•ã‚“ã®ç›£ä¿®ã®ä¸‹ã§ MOCO ã¨ã„ã†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’é–‹ç™ºã—ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ã¾ã—ãŸã€‚ æœ¬è¨˜äº‹ã§ã¯ Kubernetes ä¸Šã® MySQL ã‚ªãƒšãƒ¬ãƒ¼ã‚¿ãƒ¼ã®çŠ¶æ³ã¨ã€é–‹ç™ºã—ãŸ MOCO ã®æ©Ÿèƒ½ã‚’è©³ç´°ã«è§£èª¬ã„ãŸã—ã¾ã™ã€‚ M
AKIMOTO 2021/06/04
Kubernetes

MySQL

cybozu

é‹ç”¨
ãƒªãƒ³ã‚¯
MySQL 8.0 ã¸ã®ç§»è¡ŒãŒå®Œäº†ã—ã¾ã—ãŸ ï½žã•ã‚ˆã†ãªã‚‰å…¨ã¦ã® MySQL 5.7ï½ž - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¯ãƒ©ã‚¦ãƒ‰é‹ç”¨ãƒãƒ¼ãƒ ã®é£¯å¡šã§ã™ã€‚ ç§ãŸã¡ã¯ cybozu.com æœ¬ç•ªç’°å¢ƒã® MySQL ã‚’æ˜¨å¹´æœ«ã‹ã‚‰é †æ¬¡ 8.0 ç³»ã¸ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ã¦ãŠã‚Šã€å‰å›žã®å®šæœŸãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«ãŠã„ã¦å…¨ã¦ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚’å®Œäº†ã—ã¾ã—ãŸã€‚ã“ã®è¨˜äº‹ã§ã¯ã€ç§ãŸã¡ãŒ MySQL 8.0 ã¸ã®ç§»è¡Œã«å–ã‚Šçµ„ã‚“ã ç†ç”±ã¨å¿…è¦ã«ãªã£ãŸå¯¾å¿œã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãªãœ MySQL 8.0 ã¸ç§»è¡Œã—ãŸã®ã‹ GTID-based ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹åˆ¶é™ã®ç·©å’Œ å†èµ·å‹•æ™‚ã« AUTO_INCREMENT ã®ã‚«ã‚¦ãƒ³ã‚¿ãŒå·»ãæˆ»ã‚‹å•é¡Œã®è§£æ¶ˆ å®Ÿéš›ã«å¯¾å¿œãŒå¿…è¦ã ã£ãŸ MySQL 8.0 ã®å¤‰æ›´ç‚¹ utf8mb4 ã®ç…§åˆé †åºã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®å¤‰æ›´ SQL_CALC_FOUND_ROWS ã¨ FOUND_ROWS() ãŒ deprecated ã« Connector/J ã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿å–å¾—å‡¦ç†ã®æ€§èƒ½ä½Žä¸‹ sys.innodb_lo
AKIMOTO 2021/05/25
MySQL
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºã•ã‚“ã®é–‹é‹ç ”ä¿®(ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã§è©±ã—ã¦ãã¾ã—ãŸ
2024 ( 30 ) 12æœˆ ( 5 ) 11æœˆ ( 1 ) 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 ) æ±äº¬éƒ½ã‚ªãƒ¼ãƒ—ãƒ³ãƒ‡ãƒ¼ã‚¿ã‚«ã‚¿ãƒã‚°ã‚µã‚¤ãƒˆã®CSVã‚’ä½¿ã£ã¦LOAD DATA LOCAL INFIL
AKIMOTO 2021/05/25
MySQL

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

è§£èª¬
ãƒªãƒ³ã‚¯
MariaDB 10.5 ã®æ€§èƒ½ã¯ä¸æ£ï¼Ÿ
æ™®æ®µã¯åŸºæœ¬çš„ã«MariaDBã®å‹•å‘ã¯å…¨ãè¿½ã£ã¦ç„¡ã„ã§ã™ã€‚ ã§ã‚‚å…ˆæ—¥ã€MariaDB 10.5 ã®fsync()ç™ºè¡ŒãŒå°‘ãªãæ€§èƒ½ãŒè‰¯ã„ã®ã¯ä½•æ•…ãªã®ã‹ã¡ã‚‡ã£ã¨è¦‹ã¦ã»ã—ã„ã¨è¨€ã‚ã‚Œã¦ã€ mariadb-10.5.9.tar.gz ã‚’ã–ã£ã¨è¦‹ãŸã‚‰ã‚ã£ã¨ã„ã†é–“ã«åŽŸå› ç‰¹å®šã€‚ ã€Œfsync()ã‚’å¾…ã¤ã¹ããªã®ã«å¾…ã£ã¦ãªã„ã‹ã‚‰ã€ åªã®ä¸æ£ã¨åˆ¤æ˜Žã€‚ å‹•ä½œã¨ã—ã¦ã¯ã€ innodb_flush_log_at_trx_commit = 1 ã§ã‚‚ innodb_flush_log_at_trx_commit = 2 ã§ã‚‚ ä¸¦åˆ—åº¦ãŒä¸ŠãŒã‚‹ã¨å¤šãã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒ innodb_flush_log_at_trx_commit = 0 ã®å‹•ä½œã¨åŒç‰ã¨ãªã£ã¦ã—ã¾ã†ã‚ˆã†ã§ã™ã€‚ å¾…ãŸãªã„ã®ã ã‹ã‚‰é€Ÿã„ã«æ±ºã¾ã£ã¦ã‚‹ã€‚ã“ã‚“ãªä¸æ£ãªã‚‚ã®ã¨æ¯”è¼ƒã•ã‚Œã‚‹ã®ã¯è…¹ç«‹ãŸã—ã„ã§ã™ã€‚ æŒ‡å®šã®LSNã¾ã§ã®writeã‚„flushã‚’çµ‚ã‚ã‚‰ã›ã‚‹ log_wri
AKIMOTO 2021/04/22
database

MySQL

MariaDB
ãƒªãƒ³ã‚¯
MySQL 8.0ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§MySQL 5.7ã®ã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã¨charsetãŒè¨å®šã•ã‚Œãªã„ã‹ã‚‚ã—ã‚Œãªã„ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
mysql_options(mysql, MYSQL_SET_CHARSET_NAME, cs_name) ã ã‘ã—ã¦ mysql_real_connect(mysql, ...) ã—ãŸå¾ŒSHOW VARIABLESã—ã¦ã¿ãŸã‚‰æŽ¥ç¶šã®charsetãŒè¨å®šæ¸ˆã¿ã®æŒ™å‹•ã‚’ã™ã‚‹ã‚“ã‚„ã‘ã©mysql_real_connectã‹ã‚‰ã®ä¸€é€£ã®ã‚³ãƒ¼ãƒ‰èªã‚“ã§ã‚‚ã©ã“ã§ãã‚ŒãŒèµ·ãã‚‹ã®ã‹ã‚ã‹ã‚‰ã‚“èª°ã‹ãŸã™ã‘ã¦ðŸ¥²https://t.co/ZScoD3tIQ8â€” Ryuta Kamizono (@kamipo) February 20, 2021 MySQLã®ãƒãƒ³ãƒ‰ã‚·ã‚§ã‚¤ã‚¯ãƒ‘ã‚±ãƒƒãƒˆã«collation_idã‚’1ãƒã‚¤ãƒˆã ã‘å…¥ã‚Œã‚‰ã‚Œã‚‹ã¨ã“ã‚ãŒã‚ã£ã¦ã€charset name ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã® collation_id ã‚’é€ã£ã¦ã„ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã‚µãƒ¼ãƒãƒ¼ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒé•ã†ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®collation_idãŒé•ã†ã“ã¨ãŒã‚ã£ã¦
AKIMOTO 2021/02/22
MySQL

æ–‡å—ã‚³ãƒ¼ãƒ‰

ãƒãƒ¼ã‚¸ãƒ§ãƒ³éžäº’æ›
ãƒªãƒ³ã‚¯
Re: çµå±€ã€Goè¨€èªžã‚’ã‚„ã‚ã‚‹ç†ç”±ã¯ãªã‹ã£ãŸä»¶ - Hateburo: kazeburo hatenablog
ã™ã¿ã¾ã›ã‚“ã€ISUCONã®ã‚¢ãƒ¬ã«ç«ãŒã¤ã„ã¦ã—ã¾ã£ãŸã®ã§..ã€‚ Advent Calendarã¨ã¯ã¨ãã«é–¢ä¿‚ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ qiita.com qiita.com ã“ã¡ã‚‰ã®è¨˜äº‹ã‚’ã¿ã¦ã€æ°—ã«ãªã£ã¦ã—ã¾ã£ãŸã®ã§ interpolateParams ã®è¿½åŠ ã¨MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å›žã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ç’°å¢ƒãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã¯ç´ æ™´ã‚‰ã—ã„ã§ã™ãã€‚ github.com 8vCPU/16GB Memã®c5a.2xlargeãªEC2ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’èµ·å‹•ã—ã¦ã€ä»¥ä¸‹ã®æ‰‹é †ã«ã—ãŸãŒã£ã¦dockerã¨docker-composeã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ãŸã€‚OSã¯Ubuntu 20.04ã‚’ä½¿ã„ã¾ã—ãŸã€‚ docs.docker.com docs.docker.com ä¸Šè¨˜ã®benchmarkã®repositoryã‚’git cloneã—ã€compose build && compose upã—
AKIMOTO 2020/12/17
MySQL

Golang

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

tuning
ãƒªãƒ³ã‚¯
Social Network for Programmers and Developers
AKIMOTO 2019/06/12
Docker

Docker Compose

Laravel

PHP

nginx

MySQL

tutorial
ãƒªãƒ³ã‚¯
https://developer.hatenastaff.com/entry/2019/01/15/120431
AKIMOTO 2019/01/15
MySQL

ä½“é¨“è«‡
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºç‰ˆ MySQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ãã®çµæžœ - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åŸºç›¤ãƒãƒ¼ãƒ ã®é’æœ¨(@a_o_k_i_n_g)ã§ã™ã€‚å…ˆæ—¥è¦ªçŸ¥ã‚‰ãšã‚’æŠœæ¯ã—ãŸæ™‚ã€ã¤ã‚‰ã™ãŽãŸã®ã§ MySQL ã® JOIN ã®ã“ã¨ã‚’è€ƒãˆã¦å¿ƒã®å¹³é™ã‚’ä¿ã£ã¦ã„ã¾ã—ãŸã€‚ ã‚µã‚¤ãƒœã‚¦ã‚ºã®è£½å“ã®ã²ã¨ã¤ã§ã‚ã‚‹ kintone ã¯ãƒ‹ãƒ¼ã‚ºã«å¿œã˜ã¦è‡ªç”±ã«æ¥å‹™ã‚¢ãƒ—ãƒªã®ã‚ˆã†ãªã‚‚ã®ã‚’æ‰‹è»½ã«ä½œã‚‹ã“ã¨ãŒã§ãã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢æ¡ä»¶ã‚„ã‚½ãƒ¼ãƒˆæ¡ä»¶ã‚‚ç´°ã‹ãã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ã§ã€æ§˜ã€…ãªãƒ¬ãƒ™ãƒ«ã§ã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã‚‚è¨å®šå¯èƒ½ã¨ã„ã†éžå¸¸ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ã—ã‹ã—ãã®æ©Ÿèƒ½ã‚’æ”¯ãˆã‚‹è£å´ã§ã¯è¤‡é›‘ãªã‚¯ã‚¨ãƒªãŒç™ºè¡Œã•ã‚Œã€MySQL ã«å¤šå¤§ãªè² è·ã‚’ã‹ã‘ã¦ã„ã¾ã™ã€‚ã‚µã‚¤ãƒœã‚¦ã‚ºã®ã‚¯ãƒ©ã‚¦ãƒ‰ã«ã¯æ•°åãƒ†ãƒ©ãƒã‚¤ãƒˆã«ç™»ã‚‹ MySQL ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‚Šã€æ•°åƒä¸‡ä»¶ã‚ªãƒ¼ãƒ€ãƒ¼ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¤‡æ•° JOIN ã™ã‚‹ã‚¯ã‚¨ãƒªãŒæ¯Žç§’ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã¨ã„ã†ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é‚ãŒæ»¾ã‚‹ç’°å¢ƒã§ã™ã€‚ ç¾åœ¨ã‚µã‚¤ãƒœã‚¦ã‚ºã§ã¯æ€§èƒ½æ”¹å–„ã«åŠ›ã‚’å…¥ã‚Œã¦ãŠã‚Šã€åƒ•ã‚‚ãã®æ¥å‹™ã«å¾“äº‹ã—ã¦ã„ã¾ã™ã€‚ä¾‹ãˆã°2018å¹´
AKIMOTO 2018/08/08
mysql

ã‚µã‚¤ãƒœã‚¦ã‚º

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
In MySQL, never use â€œutf8â€. Use â€œutf8mb4â€.
Todayâ€™s bug: I tried to store a UTF-8 string in a MariaDB â€œutf8â€-encoded database, and Rails raised a bizarre error: Incorrect string value: â€˜\xF0\x9F\x98\x83 <â€¦â€™ for column â€˜summaryâ€™ at row 1This is a UTF-8 client and a UTF-8 server, in a UTF-8 database with a UTF-8 collation. The string, â€œðŸ˜ƒ <â€¦â€, is valid UTF-8. But hereâ€™s the rub: MySQLâ€™s â€œutf8â€ isnâ€™t UTF-8. The â€œutf8â€ encoding only supports th
AKIMOTO 2018/06/15
MySQL

UTF-8

utf8mb4

æ´å²
ãƒªãƒ³ã‚¯
ã•ã„ãã‚“ã®MySQLã®JSONã¾ã‚ã‚Š | GREE Engineers' Blog
ã“ã‚“ã«ã¡ã‚ã€‚ã›ã˜ã¾ã§ã™ã€‚ ã•ã„ãã‚“ã€ã—ã°ã—ã°åºåœ’ã‚„æ—¥å¸°ã‚Šç™»å±±ã«è¡Œã£ã¦é¢¨æ™¯å†™çœŸã‚’æ’®ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã‚«ãƒ¡ãƒ©ã§å†™çœŸã‚’æ’®ã‚‹ã¨ã„ã†è¡Œç‚ºã¯ï¼ˆä¸ç•¥ï¼‰å®Ÿè¡Œè¨ˆç”»ã‚’è€ƒãˆãªãŒã‚‰SQLã‚’æ›¸ãè¡Œç‚ºã«è¿‘ã—ã„ã“ã¨ã ã¨æ€ã„ã¾ã™ã®ã§ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã«ã¯ã‘ã£ã“ã†ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ä»Šæ—¥ã¯è»½ã‚ã®è©±ã‚’ã•ã£ãã‚Šã•ã›ã¦ã„ãŸã ã“ã†ã‹ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« çš†ã•ã‚“ã¯æœ€è¿‘ã®MySQLãŒJSONåž‹ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã‚’ã”å˜çŸ¥ã§ã—ã‚‡ã†ã‹ã€‚ã€Œãªãœæ£è¦åŒ–ã•ã‚Œã¦ã„ãªã„JSONã‚’RDBMSã«æ ¼ç´ã™ã‚‹ã®ã§ã™ã‹ï¼æ£è¦åŒ–ã—ã¾ã—ã‚‡ã†æ£è¦åŒ–ã€ã¨ã„ã†è‡³æ¥µã”ã‚‚ã£ã¨ã‚‚ãªã”æ„è¦‹ã‚‚ã‚ã‚‹ã§ã—ã‚‡ã†ãŒã€ MySQLã¯5.7ã‹ã‚‰JSONåž‹ã®ã‚µãƒãƒ¼ãƒˆã‚’ã¯ã˜ã‚ã€8.0ã§ã‹ãªã‚Šé–‹ç™ºãŒåŠ é€Ÿã—ã¦ã„ã‚‹å°è±¡ã‚’å—ã‘ã¾ã™ã€‚JSONåž‹ãŒãƒã‚¤ãƒ†ã‚£ãƒ–ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã¯ã€MySQL5.7ã®Release Candidateä»¥é™ã§ã™ã€‚5.7 RCãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸ2015å¹´ã‚ãŸã‚Šã‹ã‚‰ã€MySQL
AKIMOTO 2018/06/08
MySQL

JSON
ãƒªãƒ³ã‚¯
MySQL 8.0ç™»å ´ï¼ç«‹ã¡æ¢ã¾ã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„é€²åŒ–ã¯ã“ã‚Œã‹ã‚‰ã‚‚ç¶šãã€‚
ã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯ã¯ã„ã‹ãŒãŠéŽã”ã—ã•ã‚ŒãŸã ã‚ã†ã‹ã€‚ä»Šå¹´ã¯å¤©æ°—ã‚‚è‰¯ãã€è¡Œæ¥½æ—¥å’ŒãŒç¶šã„ãŸã‚ˆã†ã«æ€ã†ã€‚ ã•ã¦ã€å…ˆæ—¥MySQL 8.0ãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚å°‘ã—æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã£ãŸãŒã€ä»Šå›žã¯MySQL 8.0ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰å¯èƒ½ã ã€‚ ã²ã¨ã¤å‰ã®æ£å¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL 5.7ã ã£ãŸã®ã ãŒã€MySQL 8.0ã¯éžå¸¸ã«å¤§ããªãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒå«ã¾ã‚Œã¦ãŠã‚Šã€5.xå°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æ¨ã¦åŽ»ã‚ã†ã¨ã„ã†è©±ãŒã‚ã£ãŸã€‚ãã“ã§ã€æ¬¡ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯æœ€åˆã®æ¡ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã«ãªã£ãŸã®ã ãŒã€MySQL 6.0ã¯éŽåŽ»ã«æ—¢ã«å˜åœ¨ã—ã€è²·åŽãªã©ã®é¨’ãŽã§é–‹ç™ºãŒé “æŒ«ã—ã¦ã—ã¾ã£ãŸçµŒç·¯ãŒã‚ã‚‹ã€‚7.xã¯MySQL NDB Clusterã¨è¢«ã£ã¦ã„ã‚‹ã€‚ã¨ã„ã†ã‚ã‘ã§ã€5.7ã®7ã®éƒ¨åˆ†ã®æ¬¡ã¨ã„ã†æ„å‘³åˆã„ã‚‚ã‚ã£ã¦ã€8.0ã¨ã„ã†ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’å¼•ã£ã•ã’ã€æº€ã‚’æŒã—ã¦ã®ç™»å ´ã¨ãªã£ãŸã€‚ãã®
AKIMOTO 2018/05/07
MySQL

MySQL8
ãƒªãƒ³ã‚¯
HeidiSQL - MariaDB/MySQL, MSSQL, PostgreSQL, SQLite and Interbase/Firebird made easy
What is HeidiSQL? HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and M
AKIMOTO 2018/04/23
SQL

MySQL

client

database
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
AKIMOTO 2017/12/22
MySQL

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