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

AKIMOTO id:AKIMOTO

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

${{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ã€œ)
ãŠçŸ¥ã‚‰ã› connpassãƒ—ãƒ©ã‚¤ãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼ã®æ”¹å®šåŠã³å¤–éƒ¨é€ä¿¡è¦å¾‹ãƒšãƒ¼ã‚¸ã‚’è¿½åŠ ã„ãŸã—ã¾ã—ãŸã€‚è©³ç´°ã«ã¤ãã¾ã—ã¦ã¯ã“ã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚ æ–°æ©Ÿèƒ½ æŠ€è¡“ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ã‚ˆã‚Šè¦‹ã¤ã‘ã‚„ã™ãã€å‚åŠ ã—ã‚„ã™ãã™ã‚‹ãŸã‚ã®æ–°æ©Ÿèƒ½ã€Œã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ç‰¹é›†ãƒšãƒ¼ã‚¸ã€ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ã€ŒæŠ€è¡“ã€ã‚„ã€Œãƒ†ãƒ¼ãƒžã€ãªã©ã®ãƒˆãƒ”ãƒƒã‚¯åˆ¥ã«æŽ¢ã›ã‚‹ã»ã‹ã€ç›´è¿‘é–‹å‚¬äºˆå®šã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãŒä¸€è¦§ã§ç¢ºèªã§ãã¾ã™ã®ã§ã”æ´»ç”¨ãã ã•ã„ã€‚è©³ã—ã„æ©Ÿèƒ½èª¬æ˜Žã‚„æŽ²è¼‰æ–¹æ³•ã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã‚’ã”ç¢ºèªãã ã•ã„ã€‚ æ³¨æ„ ç¾åœ¨ã€ä¸€éƒ¨ã®ãƒ–ãƒ©ã‚¦ã‚¶ç’°å¢ƒã«ãŠã„ã¦ã€ã‚¤ãƒ™ãƒ³ãƒˆå‚åŠ ç”»é¢ã®ã€Œç”³ã—è¾¼ã¿ã‚’ç¢ºå®šã™ã‚‹ã€ãƒœã‚¿ãƒ³ãŒã‚°ãƒ¬ãƒ¼ã‚¢ã‚¦ãƒˆã—ãŸã¾ã¾ã‚¯ãƒªãƒƒã‚¯ã§ããªã„ç¾è±¡ãŒå ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ–ãƒ©ã‚¦ã‚¶æ‹¡å¼µæ©Ÿèƒ½(Video Speed Controllerãªã©)ã®å½±éŸ¿ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ãŠæ‰‹æ•°ã‚’ãŠã‹ã‘ã—ã¾ã™ãŒã€ç¾è±¡ãŒç™ºç”Ÿã—ãŸå ´åˆã¯ãŠä½¿ã„ã®ãƒ–ãƒ©ã‚¦ã‚¶ã®æ‹¡å¼µæ©Ÿèƒ½ã‚’ä¸€æ™‚çš„ã«ç„¡åŠ¹åŒ–ã™ã‚‹ã‹ã€ã‚·ãƒ¼ã‚¯ãƒ¬ãƒƒãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§ã®æ“ä½œ
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
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
https://developer.hatenastaff.com/entry/2019/01/15/120431
AKIMOTO 2019/01/15
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
ãƒªãƒ³ã‚¯
Sudoku Recursive Common Table Expression Solver
All of Perconaâ€™s open source software products, in one place, to download as much or as little as you need.
AKIMOTO 2017/11/29
SQLiteã‚„MySQLã§æ•°ç‹¬ã‚’è§£ãSQL

Sudoku

solver

SQLite

MySQL

æ•°ç‹¬
ãƒªãƒ³ã‚¯
Free MySQL Hosting
Register Create your Free MySQL Database Creating your new database couldnâ€™t be easier. Enter your em ail address above, weâ€™ll send you your new password and youâ€™re ready to start. Included MySQL Database 5MB MySQL Hosting Space phpMyAdmin Secure, Reliable, Fast hosting Upgrade options available Having your own MySQL database has never been easier Within a few minutes you could have your own MySQL
AKIMOTO 2017/09/29
MySQL

hosting

free

freemium
ãƒªãƒ³ã‚¯
å¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã«ã¤ã„ã¦è©±ã—åˆã„ã‚’ã—ã¦ãã¾ã—ãŸ | GREE Engineering
ã“ã‚“ã«ã¡ã‚ã€‚ã›ã˜ã¾ã§ã™ã€‚ ã•ã„ãã‚“ã® kernel ã«ã¤ã„ã¦èª¿ã¹ã¦ãŸã‚‰ã€ä¿„ã« Chromebook ã¸ã®èˆˆå‘³ãŒæ¹§ã„ã¦ããŸã®ã§ã€é…ã¾ããªãŒã‚‰ C302CA ãƒãƒã£ã¦ã¿ã¾ã—ãŸã€‚ã‚ãŸã—ã«ã¨ã£ã¦äººç”Ÿåˆ Core M ã¨ã„ã†ã“ã¨ã‚‚ã‚ã£ã¦ã€æ—©ãå±Šã‹ãªã„ã‹ãªã¨å¿ƒå¾…ã¡ã«ã—ã¦ã„ã‚‹ä»Šæ—¥ã“ã®ã”ã‚ã§ã™ã€‚ ã¯ã˜ã‚ã« MySQL5.7ä»¥å‰ã§ãŠãã‚‰ãæœ€ã‚‚æœ‰åãªå•é¡Œã®ä¸€ã¤ã«ã€Sushi-Beer issue of MySQL with utf8mb4 ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ å¿™ã—ã„äººã®ãŸã‚ã«ä¸‰è¡Œã§ã¾ã¨ã‚ã¾ã™ã¨ MySQL ã¯ character-set ã« utf8mb4 ã‚’æŒ‡å®šã™ã‚‹ã¨ã€å¯¿å¸ã‚„ãƒ“ãƒ¼ãƒ«ãªã©ã®çµµæ–‡å—ã‚’æ‰±ãˆã‚‹ã€‚ ãŸã ã€Collationï¼ˆç…§åˆé †åºï¼‰ ãŒ utf8mb4_general_ci ã‚„ utf8mb4_unicode_ci ã ã¨ã€çµµæ–‡å—ã‚’åŒºåˆ¥ã§ããªã„ï¼ˆå¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã®çµµæ–‡å—ã‚’åŒºåˆ¥ã§ããªã„ï¼‰ã€‚ utf8mb
AKIMOTO 2017/04/20
MySQL

æ—¥æœ¬èªž

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