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

sugyan id:sugyan

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

${{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ã®JSON Data Typeã®å€¤ã«å¯¾ã—ã€æ˜Žç¤ºçš„ãªã‚ãƒ£ã‚¹ãƒˆç„¡ã—ã« `BETWEEN`, `IN()`, `GREATEST()`, `LEAST()` ã‚’ä½¿ã£ã¦ã¯ãªã‚‰ãªã„ - ãã®æ‰‹ã®å¹³ã¯å°»ã‚‚ã¤ã‹ã‚ã‚‹ã•
è¡¨é¡Œã®é€šã‚Šã€MySQLã®JSON Data Typeã®å€¤ã«å¯¾ã—ã¦ã¯ã€æ˜Žç¤ºçš„ãªã‚ãƒ£ã‚¹ãƒˆç„¡ã—ã« BETWEEN, IN(), GREATEST() ãã—ã¦ LEAST() ã‚’ä½¿ã£ã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚ MySQLã‚€ãšã‹ã—ã„ pic.twitter.com/YKoadLbaG2â€” ã™ãŽã‚ƒãƒ¼ã‚“ðŸ’¯ (@sugyan) 2021å¹´9æœˆ7æ—¥ æœ¬è¨˜äº‹ã¯ã“ã‚Œã«ä¿‚ã‚‹è©±é¡Œã§ã€id:sugyan ã•ã‚“ã« Slack ã§ç›¸è«‡ã‚’å—ã‘ã¦ã€Œåƒ•ã‚‚ãã‚Œãƒãƒžã£ãŸã“ã¨ã‚ã‚‹ãªã€ã¨èª¿ã¹ãŸã¨ã“ã‚ä»¥ä¸‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«è¾¿ã‚Šã¤ãã¾ã—ãŸã€‚ dev.mysql.com ã“ã‚Œã¯MySQL 8.0ã®JSON Data Typeã«é–¢ã™ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã™ãŒã€ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã® Comparison and Ordering of JSON Values ã¨ã„ã†ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã« The following comparison operators and fun
sugyan 2021/09/11
å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸï¼ï¼ï¼ ã—ã‹ã—ãƒ›ãƒ³ãƒˆã«å¯¾å¿œã—ã¦ãªã„ã‚“ãªã‚‰warningã˜ã‚ƒãªãã¦ã‚¨ãƒ©ãƒ¼ã«ãªã£ã¦ãã‚Œã¦è‰¯ã„ã®ã«â€¦ã¨æ€ã†

MySQL

JSON
ãƒªãƒ³ã‚¯
MySQLã«åˆã‚ã¦INSERTã™ã‚‹ã¨ã‚¢ã‚¯ã‚»ã‚¹ãŒç™ºç”Ÿã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¯ä½•ã‹ã¨ã„ã†è³ªå•ã‚’ã©ã†èª¿ã¹ã‚‹ã®ã‹ - oranie's blog
yokuo825ã•ã‚“ã®ã‚«ãƒƒã‚³ã„ã„ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼è¨˜äº‹ã‚’ t.co èªã‚“ã§ã€ã“ã®éƒ¨åˆ†ã§ã™ã â”€â”€ä¾‹ãˆã°ã©ã®ã‚ˆã†ãªè©±ã‚’ã—ã¾ã—ãŸã‹ï¼Ÿ ã€Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚ŒãŸã°ã‹ã‚Šã®MySQLãŒã‚ã‚‹ã¨ã—ã¦ã€ç‰¹å®šãƒ†ãƒ¼ãƒ–ãƒ«ã«1ä»¶ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æœ€åˆã«INSERTã—ãŸå ´åˆã€ã‚¢ã‚¯ã‚»ã‚¹ãŒç™ºç”Ÿã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãã®ç†ç”±ã‚’ã™ã¹ã¦æ•™ãˆã¦ãã ã•ã„ã€ã¨è³ªå•ã•ã‚ŒãŸã®ã‚’è¦šãˆã¦ã„ã¾ã™ã€‚ å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªç†ç”±ã§ã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‹ã€ä¸€é€£ã®æµã‚Œã‚’ç‰‡ã£ç«¯ã‹ã‚‰ç”ãˆã¦ã„ãã¨ã€å½¼ã‚‰ãŒã™ã”ãæ¥½ã—ãã†ã«ã—ã¦ãã‚Œã¦ã€‚ã€Œãã†ã‹ã€LINEã®ç’°å¢ƒã ã¨â—‹â—‹ã®è¨å®šãŒæœ€åˆã‹ã‚‰â—‹â—‹ã«ãªã£ã¦ã„ã‚‹ã®ã§ã€ãã®ãƒ•ã‚¡ã‚¤ãƒ«ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯è€ƒãˆã¦ã„ãªã‹ã£ãŸã§ã™ã€‚ç¢ºã‹ã«ãã‚Œã‚‚ã‚ã‚Šã¾ã™ãã€ãªã©ã¨ç”ãˆã¦ãã‚Œã¾ã—ãŸã€‚ ã§ã“ã‚“ãªãƒ„ã‚¤ãƒ¼ãƒˆã—ãŸã‚“ã§ã™ãŒ å…¨å›½ã®DBAã¯ã€Œç‰¹å®šãƒ†ãƒ¼ãƒ–ãƒ«ã«1ä»¶ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æœ€åˆã«INSERTã—ãŸå ´åˆã€ã‚¢ã‚¯ã‚»ã‚¹ãŒç™ºç”Ÿã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãã®ç†ç”±ã‚’ã™ã¹ã¦æ•™ãˆã¦ãã ã•ã„ã€ã“ã‚Œæ˜Žæ—¥ã‹ã‚‰è·å ´ã§
sugyan 2021/08/27
MySQL
ãƒªãƒ³ã‚¯
MySQLã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆyoku0825ãŒç›®æŒ‡ã™ã€DBAã¨ã—ã¦ã®æœªæ¥åƒ
LINEæ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚ LINEãƒ¤ãƒ•ãƒ¼ Tech Blog LINEã§åƒãã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«è‰²ã€…ã¨è©±ã‚’èžã„ã¦ã„ãã€ŒLINE Engineer Insightsã€ã€‚LINEã®æŠ€è¡“çµ„ç¹”ã§åƒãäººã€…ã«ã€ä½•ã‚’é‡è¦–ã—ã¦æŠ€è¡“è€…ã¨ã—ã¦ã®ã‚ãƒ£ãƒªã‚¢ã‚’æ©ã‚“ã§ã„ã‚‹ã®ã‹ã€ä»ŠLINEã§ä½•ã«å–ã‚Šçµ„ã‚“ã§ã„ã‚‹ã®ã‹ã€ä»Šå¾Œå®Ÿç¾ã—ã¦ã„ããŸã„ã“ã¨ãªã©ã‚’èžã„ã¦ã„ãã¾ã™ã€‚ ä»Šå›žç™»å ´ã™ã‚‹ã®ã¯ã€MySQLã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦åºƒãåã‚’çŸ¥ã‚‰ã‚Œã‚‹ç”°ä¸ç¿¼ï¼ˆ@yoku0825ï¼‰ ã€‚æ—¥æœ¬äººã¨ã—ã¦3äººç›®ã®MySQLåˆ†é‡Žã®Oracle ACEã§ã‚ã‚Šã€2015å¹´ã«ã¯ã€Œdefault_password_lifetimeã€ã®åŠŸç¸¾ã§MySQL 5.7 Community Contributor Awardã«é¸å‡ºã•ã‚ŒãŸç”°ä¸ã¯ã€2021å¹´6æœˆã‚ˆã‚ŠLINEã®ITSC DB
sugyan 2021/08/25
LINE

engineer

interview

yoku0825

mysql
ãƒªãƒ³ã‚¯
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ãŒé•ã†ã“ã¨ãŒã‚ã£ã¦
sugyan 2021/02/24
MySQL

kamipo
ãƒªãƒ³ã‚¯
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ã—
sugyan 2020/12/17
ã€Œå¯¾ISUCONç”¨ç§˜ä¼ã®ã‚¿ãƒ¬ã€

mysql

isucon

tuning
ãƒªãƒ³ã‚¯
https://developer.hatenastaff.com/entry/2019/01/15/120431
sugyan 2019/01/30
hatena

hatenatech

MySQL
ãƒªãƒ³ã‚¯
MySQLã•ã‚“ã‹ã‚‰Column not foundã£ã¦è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€ãƒã‚°ã‚’è¦‹ã‚‹é™ã‚Šãã®ã‚«ãƒ©ãƒ ã¯SQLã®ã©ã“ã«ã‚‚å‡ºç¾ã—ãªã„
ã©ã…ãƒ¼ã‚ã @do_aki MySQL ã•ã‚“ã‹ã‚‰ Column not found ã£ã¦è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€ãƒã‚°ã‚’è¦‹ã‚‹é™ã‚Šãã®ã‚«ãƒ©ãƒ ã¯ SQL ã®ã©ã“ã«ã‚‚å‡ºç¾ã—ãªã„â€¦â€¦ã€‚ãªã‚“ã ã“ã‚Œ 2016-11-08 16:09:58
sugyan 2016/11/08
MySQL
ãƒªãƒ³ã‚¯
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
sugyan 2016/09/13
MySQL

security
ãƒªãƒ³ã‚¯
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
sugyan 2016/06/13
MySQL

ãŠã˜ã•ã‚“

presentation
ãƒªãƒ³ã‚¯
MySQLã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã‚ºãƒ³ãƒ‰ã‚³ã‚ãƒ¨ã‚· | GMOãƒ¡ãƒ‡ã‚£ã‚¢ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€DBAã§ã™ã€‚ ã‚ºãƒ³ãƒ‰ã‚³ã‚ãƒ¨ã‚·å¤§æµè¡Œã§ã™ãã€‚Â ã‚ºãƒ³ãƒ‰ã‚³ã‚ãƒ¨ã‚·ã¾ã¨ã‚ - QiitaÂ ã‚’è¦‹ã¦ã„ãŸã‚“ã§ã™ãŒã€MySQLã§ã‚„ã£ã¦ã‚‹äººã¯ã„ãªã•ãã†ãªã®ã§ MySQL Casualã®Slack ã§å‘¼ã³ã‹ã‘ã¦ã¿ã¾ã—ãŸã€‚ * by @do_aki ã€‚JOINä½¿ã£ã¦ã‚‹ã€‚ç¢ºã‹ã«æ¢ã‚ã‚‰ã‚Œãªã„ã€‚SET @zd = ''; SELECT zundoko FROM ( SELECT @t := IF(@zd = 'ã‚ºãƒ³ã‚ºãƒ³ã‚ºãƒ³ã‚ºãƒ³ãƒ‰ã‚³', 'ã‚ãƒ¨ã‚·ï¼', ELT(FLOOR(1 + RAND() * 2), 'ã‚ºãƒ³', 'ãƒ‰ã‚³') ) AS zundoko, @zd := RIGHT(CONCAT(IFNULL(@zd,''), @t), 10) FROM (SELECT 0 UNION SELECT 1) AS t0 JOIN (SELECT 0 UNION SELECT 1) AS t1 JOIN (
sugyan 2016/03/17
ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¾ã§å®Ÿè£…ã—ã¯ã˜ã‚ã¡ã‚ƒã†ã®ã€ãƒ¤ãƒã„

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
sugyan 2016/01/27
ã™ã”ã„ãƒœãƒªãƒ¥ãƒ¼ãƒ

MySQL

performance

presentation
ãƒªãƒ³ã‚¯
mysql Connector/J ã®è¨å®šã§åŠ¹ããã†ãªã‚„ã¤ - ãã®æ‰‹ã®å¹³ã¯å°»ã‚‚ã¤ã‹ã‚ã‚‹ã•
mysql Connector/J ã‚’ä½¿ã†æ™‚ã«è‰²ã€…åŠ¹ããã† (ã‚ã‚‹ã„ã¯åŠ¹ã‹ãªãã†) ãªè¨å®šé …ç›®ã‚’èª¿ã¹ãŸã®ã§ã¾ã¨ã‚ã¦ãŠãã“ã¨ã¨ã—ã¾ã™ï¼ŽãªãŠï¼Œå¯¾è±¡ã¨ã—ã¦ã„ã‚‹ mysql ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.6 (ä»¥é™)ï¼ŒConnector/J ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.1.34 (ä»¥é™) ã§ã™ï¼Ž Connector/J ã¯è¨å®šã§ãã‚‹é …ç›®ãŒå¤šãã¦è¿·ã£ã¦ã—ã¾ã†ã‚“ã§ã™ãŒï¼Œé“æ¨™ã¨ãªã‚‹è³‡æ–™ã‚‚å¹¾ã¤ã‹ã‚ã‚‹ã®ã§ãã‚Œã«ã¤ã„ã¦ã‚‚ã¾ã¨ã‚ã¦ãŠãã¾ã™ï¼Ž ä½•ã‹è¿½è¨˜ã™ã¹ãäº‹é …ãŒã‚ã£ãŸã‚‰é©å®œè¿½åŠ ã—ã¦ã‚†ããŸã„ã¨æ€ã£ã¦ã„ã¾ã™ï¼Žã€Œã“ã‚Œã‚‚å…¥ã‚ŒãŸã»ã†ãŒè‰¯ã„ã®ã§ã¯ç„¡ã„ã‹ã€ã¨ã„ã†ã‚ˆã†ãªã”æŒ‡æ‘˜ã‚ã‚Šã¾ã—ãŸã‚‰ã”ä¸€å ±ãã ã•ã„ï¼Ž è¨å®šé …ç›® characterEncoding ãŠãªã˜ã¿ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ï¼Žè¦è¨å®šï¼Ž ã¡ãªã¿ã«ä»¥ä¸‹ã®æ§˜ãªãƒ†ã‚¯ãŒã‚ã‚‹ï¼Ž Driver doesn't support utf8mb4 for servers 5.5.2 and newer. The drive
sugyan 2015/12/26
MySQL

java

JDBC
ãƒªãƒ³ã‚¯
ä¸–ç•Œã®ä½•å‡¦ã‹ã§ MySQLï¼ˆInnoDBï¼‰ã® REPEATABLE READ ã«åµŒã‚‹äººã‚’1äººã§ã‚‚æ¸›ã‚‰ã™ãŸã‚ã« - KAYAC Engineers' Blog
tech.kayac.com Advent Calendar 2015 8æ—¥ç›®æ‹…å½“ã® @m0t0k1ch1 ã§ã™ã€‚ ä»Šå¹´ã¯ MySQL ã•ã‚“ã«ã„ã‚ã„ã‚æ³£ã‹ã•ã‚ŒãŸ1å¹´ã§ã—ãŸã€‚ç‰¹ã«ã€ã‚ã®å¤ã€å¹¾å¤œã‚’ã¨ã‚‚ã«ã—ãŸå®Ÿè¡Œè¨ˆç”»ã®ã‚†ã‚‰ãŽã¯ä¸€ç”Ÿå¿˜ã‚Œãª(ry ã•ã¦ã€‚ã€‚ã€‚ä»Šå›žã¯ã€ãã‚“ãªä¸ã§ã‚‚èª°ã‚‚ãŒä¸€åº¦ã¯åµŒã‚‹ã§ã‚ã‚ã†ï¼ˆï¼Ÿï¼‰MySQLï¼ˆInnoDBï¼‰ã® REPEATABLE READ ã®åµŒã‚Šã©ã“ã‚ã«ã¤ã„ã¦è‡ªåˆ†ãªã‚Šã«ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ãŒç›®æŒ‡ã™ã“ã¨ MySQL ã®å„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã®åµŒã‚Šã©ã“ã‚ã«ã¤ã„ã¦ã¯ã€ç¾çŠ¶ã§ã‚‚ç¨®ã€…ã®ãƒ–ãƒã‚°è¨˜äº‹ãªã©ã§ã¾ã¨ã‚ã‚‰ã‚Œã¦ãŠã‚Šã€ãã‚“ãªã«çœŸæ–°ã—ã„è©±ã§ã¯ãªã„ã¨æ€ã„ã¾ã™ã€‚ãŒã€éŽåŽ»ã®è‡ªåˆ†ã®ã‚ˆã†ã«ã€åµŒã£ãŸã“ã¨ãŒãªã„äººé–“ã‹ã‚‰ã™ã‚‹ã¨ã€ è©±ã¨ã—ã¦ã¯ãªã‚“ã¨ãªãç†è§£ã§ãã‚‹ ãŒã€æŠ½è±¡çš„ã§ã„ã¾ã„ã¡èº«ã«ã¤ã‹ãªã„ ã¨ã„ã†ã®ãŒç¾å®Ÿã§ã—ãŸã€‚åµŒã‚Šã©ã“ã‚ã«å®Ÿéš›ã«åµŒã£ãŸä»Šèªã¿è¿”ã—ã¦ã¿ã‚‹ã¨ã€ã€Œã‚ãƒ¼ãƒ¼ãƒ¼ã€ã€ã€ã
sugyan 2015/12/09
MySQL

InnoDB

transaction
ãƒªãƒ³ã‚¯
[mac][osx][java][mysql] JDBC ã§ mysql ã«ã¤ãªã”ã†ã¨ã—ãŸã‚‰ "Communications link failure" ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ã¨ã - tokuhirom's blog
[mac][osx][java][mysql] JDBC ã§ mysql ã«ã¤ãªã”ã†ã¨ã—ãŸã‚‰ "Communications link failure" ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ã¨ã gradle ã§ãƒ†ã‚¹ãƒˆã‚’å‹•ã‹ã—ã¦ã„ãŸã‚‰ã€é€”ä¸ã§ JDBC ãŒ "Communications link failure" ã¨è¨€ã£ã¦æ»ã¬å ´åˆãŒã‚ã‚‹ã€‚ ã“ã‚Œã¯ com.mysql.jdbc.exceptions.jdbc4.CommunicationsException ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã ãŒã€ã“ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸è‡ªä½“ã¯ã€socket ã‚’ connect ã™ã‚‹ã“ã¨ã«ã—ãŸã¨ã„ã†ã“ã¨ã‚’ç¤ºã™ã®ã¿ã§ã€ãã‚Œä»¥ä¸Šã®æƒ…å ±ãŒç„¡ã„ã€‚ãŸã ã“ã®ã‚¨ãƒ©ãƒ¼è‡ªä½“ã¯ã€OS ãƒ¬ãƒ™ãƒ«ã§ã‚¨ãƒ©ãƒ¼è¿”ã—ã¦ç™ºç”Ÿã™ã‚‹ã“ã¨ãŒã»ã¨ã‚“ã©ãªã®ã§ã€strace -f ã¨ã‹ã—ã¦èª¿ã¹ã‚Œã°ã‚ˆã„ã§ã™ãã€‚ ã‚ã‚ŠãŒã¡ãªã®ã¯ bind-address ã‚’ 127.0.0.1 ã«è¨å®šã—ã¦ã„ã‚‹ã®ã«ä»–ã®ã‚µãƒ¼ãƒãƒ¼
sugyan 2015/09/28
java

MySQL

mac
ãƒªãƒ³ã‚¯
RDB - å®Ÿä¾‹ã§å¦ã¶ã€JOIN (NLJ) ãŒé…ããªã‚‹ç†å±ˆã¨å¯¾å‡¦æ³• - Qiita
"Nested Loop Joinã—ã‹å–ã‚Šä¸Šã’ã¦ç„¡ã„ã®ã«ã‚¿ã‚¤ãƒˆãƒ«ãŒå¤§ãã™ãŽãªã„ã‹" ã¨æŒ‡æ‘˜ã‚’é ‚ã„ãŸã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚Merge Joinã¨Hash Joinã®ã“ã¨ã¯ã¾ãŸä»Šåº¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ŒJOINã¯é…ã„ã€ã¨ã‚ˆãè¨€ã‚ã‚Œã¾ã™ã€‚ç‰¹ã«RDBã‚’ä½¿ã„å§‹ã‚ã¦é–“ãŒãªã„å†…ã«ãã†ã„ã†è¨€èª¬ã«è§¦ã‚ŒãŸçµæžœã€ŒJOIN=æ‚ªã€ã¨ã„ã†èªè˜ã§å›ºå®šåŒ–ã•ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‚ˆã†ã«æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãŸã—ã‹ã«ã€JOINã‚’å«ã‚€ã‚ˆã†ãªSELECTæ–‡ã¯ã€å«ã¾ãªã„ã‚‚ã®ã«æ¯”ã¹ã¦é‡ãŸããªã‚‹å‚¾å‘ãŒã‚ã‚‹ã“ã¨ã¯äº‹å®Ÿã§ã™ã€‚ã¾ãŸã€æœ¬è³ªçš„ã«å•ã„åˆã‚ã›ãŸã„å†…å®¹ãŒè¤‡é›‘ã§ã€å¯¾å‡¦ã™ã‚‹ã“ã¨ãŒé›£ã—ã„ã‚‚ã®ã‚‚å˜åœ¨ã—ã¾ã™ã€‚ã—ã‹ã—ã€RDBã®ä¸ã§ä¸€ä½“ã©ã†ã„ã†ã“ã¨ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚Šã€ãã‚Œã«åŸºã„ã¦å¯¾å‡¦ã™ã‚Œã°é«˜é€ŸåŒ–ã§ãã‚‹ã“ã¨ã‚‚å°‘ãªããªã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ æœ¬ç¨¿ã§ã¯ã€JOINã®å†…éƒ¨å‹•ä½œã‚’è§£èª¬ã—ãŸä¸Šã§ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã‚ˆãå‡ºã¦ãã‚‹JOIN SQLã‚’ä¾‹é¡Œã«
sugyan 2015/07/13
MySQL

join
ãƒªãƒ³ã‚¯
ãƒ«ãƒ¼ã‚¯ï¼MySQLã§ã¯kamipo TRADITIONALã‚’ä½¿ãˆï¼ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
ã‚ˆãMySQLã¯ã‚†ã‚‹ãµã‚ã ã‹ã‚‰ å€¤ãŒå‹æ‰‹ã«åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã‚‹ ã‚¨ãƒ©ãƒ¼ãŒèµ·ããšã«å¤‰ãªå€¤/æ—¥ä»˜ãŒå…¥ã‚‹ ä¸æ£ãªã‚¹ã‚ãƒ¼ãƒžãŒå…¥ã£ã¦ã—ã¾ã† ãªã©è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãŸã ãã‚Œã¯ã€ãã‚‚ãã‚‚ã®è¨å®šãŒæ‚ªã„ã®ã§ã™ã€‚(ç¢ºã‹ã«æ˜”ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒã‚†ã‚‹ãµã‚ãªã®ã¯ã„ã‘ãªã‹ã£ãŸã‚“ã§ã™ãŒ) ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ä¸æ£ãªå€¤ãŒå…¥ã‚‰ãªã„ã‚ˆã†ã«è¨å®šã¯ã¨ã«ã‹ãåŽ³ã—ãã—ã¦ãŠãã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã˜ã‚ƒã‚ã©ã†ã™ã‚‹ã‹ã€‚ MySQLã¯SQL Modeã«ã‚ˆã£ã¦ã€ãã®è¾ºã‚Šã®åˆ¶ç´„ã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥å‰ã€MySQLã®sql-modeã§ä¸€ç•ªåŽ³ã—ã„ã‚„ã¤ã¯TRADITIONALã€ã¨ã„ã†ã®ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯ä¸ååˆ†ã§ã€TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BYã¨ã™ã‚‹ã®ãŒã‚ˆã‚Šå®‰å¿ƒãªã‚ˆã†ã§ã™ã€‚ ã“ã‚Œã¯kamipoã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ @songmu TRADITI
sugyan 2015/07/08
MySQL

kamipo
ãƒªãƒ³ã‚¯
MySQL 5.7.4ã§å°Žå…¥ã•ã‚ŒãŸdefault_password_lifetimeãŒã˜ã‚ã˜ã‚ãã‚‹ï¼ˆMySQL 5.7.11ã§FIXï¼ï¼ï¼‰
MySQL 5.7.4ã§å°Žå…¥ã•ã‚ŒãŸdefault_password_lifetimeãŒã˜ã‚ã˜ã‚ãã‚‹ï¼ˆMySQL 5.7.11ã§FIXï¼ï¼ï¼‰ ã€2016/01/13 10:12ã€‘ MySQL 5.7.11ã§default_password_lifetimeã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯0ã«å¤‰æ›´ã«ãªã‚Šã¾ã—ãŸï¼ ãã‚Œä»¥é™ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚Œã°ã“ã®è¨˜äº‹ã®å†…å®¹ã¯æ°—ã«ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æ—¥ã€…ã®è¦šæ›¸: MySQL 5.7.11ã§default_password_lifetimeã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒ0ã«ãªã‚‹ã‚‰ã—ã„ï¼ TL;DR default_password_lifetime= 0 ã‚’ç§˜ä¼ã®my.cnfã«å…¥ã‚Œã¦ãŠãã¤ã‚‚ã‚Šã€‚ MySQL :: MySQL 5.7 Reference Manual :: 5.1.4 Server System Variables ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã®æ„å‘³ã¯èªã‚“ã§å—ã®ã”ã¨ãã€ã€Œæœ€å¾Œã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ›´æ–°ã•
sugyan 2015/06/09
MySQL

mysql5.7
ãƒªãƒ³ã‚¯
Kazuho's Weblog: ã•ã‚‰ã°ã€æ„›ã—ãè«–ç†å‰Šé™¤ã€‚MySQLã§å¤§ç¦å¸³åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã€Œdaifukuã€ã‚’ä½œã£ã¦ã¿ãŸ
ã•ã‚‰ã°ã€æ„›ã—ãè«–ç†å‰Šé™¤ã€‚MySQLã§å¤§ç¦å¸³åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã€Œdaifukuã€ã‚’ä½œã£ã¦ã¿ãŸ å…ˆã®ã‚¨ãƒ³ãƒˆãƒªã€Œè«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹ã€ã§æ›¸ã„ãŸã¨ãŠã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦è¡Œã‚ã‚ŒãŸæ“ä½œã‚’è¨˜éŒ²ã—ã€å¿…è¦ã«å¿œã˜ã¦å‚ç…§ã—ãŸã‚Šå–ã‚Šæ¶ˆã—ãŸã‚Šã—ãŸã„ã¨ã„ã†è¦æ±‚ã¯è‡³æ¥µå¦¥å½“ãªã‚‚ã®ã§ã™ãŒã€å¤šãã®RDBã¯ã€ãã®ãŸã‚ã«ç°¡å˜ã«ä½¿ãˆã‚‹ä»•çµ„ã¿ã‚’æä¾›ã—ã¦ã„ã¾ã›ã‚“ã€‚ daifukuã¯ã€RDBã«å¯¾ã—ã¦åŠ ãˆã‚‰ã‚ŒãŸå¤‰æ›´ã‚’ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å˜ä½ã§RDBå†…ã«JSONã¨ã—ã¦è¨˜éŒ²ã™ã‚‹ãŸã‚ã®ã‚¹ãƒˆã‚¢ãƒ‰ã‚„ãƒˆãƒªã‚¬ã‚’ç”Ÿæˆã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ % daifuku dbname tbl1 tbl2 > setup.sql ã®ã‚ˆã†ã«å®Ÿè¡Œã™ã‚‹ã¨ã€æŒ‡å®šã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆã“ã“ã§ã¯tbl1ã¨tbl2ï¼‰ã«ã‚»ãƒƒãƒˆã™ã¹ããƒˆãƒªã‚¬ã‚„ã€æ›´æ–°ãƒã‚°ã‚’è¨˜éŒ²ã™ã‚‹ãŸã‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã€Œdaifuku_logã€ã‚’ç”Ÿæˆã™ã‚‹CREATE TABLEã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãªã©ã€å¿…è¦ãªSQLæ–‡ã‚’set
sugyan 2015/03/31
MySQL

tool
ãƒªãƒ³ã‚¯
MySQL ã¨å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
MySQL ã¨ Unicode Collation Algorithm (UCA) - ã‹ã¿ã½ã‚ãƒ¼ã‚‹ ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã§ã€ MySQL ã«ã¯å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã¨ã„ã†ã®ãŒã‚ã‚‹ã€‚ å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã©ã£ã‹ã§è©³ã—ããŠè©±ã‚’èžãã¹ãã ã‚ˆãªãã€‚ã€‚ã€‚â€” RKajiyama (@RKajiyama) March 18, 2015 ã“ã‚Œã¯ã©ã†ã„ã†å•é¡Œã‹ã¨ã„ã†ã¨ã€ MySQL ã® Unicode ã§ã¯ binary collation ã«ã—ã¦ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã§æ¯”è¼ƒã—ãªã„ã¨ðŸ£ã¨ðŸºã«é™ã‚‰ãšçµµæ–‡å—ãŒåŒå€¤åˆ¤å®šã•ã‚Œã‚‹ã¨ã„ã†å•é¡Œã§ã™ã€‚ ã‚ã‚Œï¼Ÿ MySQL ã® utf8mb4 charset ã£ã¦ã€4ãƒã‚¤ãƒˆæ–‡å—åŒå£«ã‚’æ¯”è¼ƒã™ã‚‹ã¨åŒã˜æ–‡å—æ‰±ã„ã•ã‚Œã‚‹ï¼Ÿ SELECT 'ðŸ£'='ðŸº' â†’ 1 MySQLçš„ã«ã¯å¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã¯åŒã˜æ‰±ã„ã€‚â€” ã¨ã¿ãŸã¾ã•ã²ã‚ (@tmtms) December 22, 2014 MySQLã§ select
sugyan 2015/03/23
kamipo

MySQL
ãƒªãƒ³ã‚¯
æˆ‘ã€…ã¯ä½•æ•…RDBMSã‚’ä½¿ã†ã®ã‹
Your browser doesn't support the features required by impress.js, so you are presented with a simplified version of this presentation. For the best experience please use the latest Chrome or Safari browser. Firefox 10 (to be released soon) will also handle it.
sugyan 2015/02/16
fk_night

RDBMS

MySQL

kamipo

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