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

repon id:repon

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

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

PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã¨ãã®ã¾ã¨ã‚ - Qiita
ã€2021/10/15 è¿½è¨˜ã€‘ ã“ã®è¨˜äº‹ã¯æ›´æ–°ãŒåœæ¢ã•ã‚Œã¦ã„ã¾ã™ã€‚ç¾åœ¨ã§ã¯ç†è€…ã®æ€æƒ³ãŒå¤‰åŒ–ã—ã¦ã„ã‚‹é¢ã‚‚ã‚ã‚Šã¾ã™ã®ã§ï¼ŒéŽåŽ»ã®è¨˜äº‹ã¨ã—ã¦å‚è€ƒç¨‹åº¦ã«ã”è¦§ãã ã•ã„ã€‚PDO ã«é–¢ã—ã¦ã¯å¤§ããå¤‰ã‚ã£ã¦ã„ãªã„éƒ¨åˆ†ãŒå¤šã„ã¨ã¯æ€ã„ã¾ã™ãŒï¼Œ PHP 8.x ä»¥é™ã§ã®å‹•ä½œä¿è¨¼ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã‚ã‚‰ã‹ã˜ã‚èªã‚“ã§ãŠããŸã„è¨˜äº‹ Qiita - ã€PHPè¶…å…¥é–€ã€‘ã‚¯ãƒ©ã‚¹ï½žä¾‹å¤–å‡¦ç†ï½žPDOã®åŸºç¤Ž by @7968 åˆå¿ƒè€…ãŒã‚„ã‚ŠãŒã¡ãªãƒŸã‚¹ ä»¥ä¸‹ã®ã©ã‚Œã‹ã«1ã¤ã§ã‚‚å½“ã¦ã¯ã¾ã‚‹ã‚³ãƒ¼ãƒ‰ã¯è¦‹ç›´ã™å¿…è¦ãŒã‚ã‚Šã¾ã™ï¼Žä»˜éŒ²ã«ãƒªãƒ³ã‚¯ã‚’è²¼ã£ã¦ãŠãã¾ã—ãŸã®ã§ï¼Œã€Œè©²å½“ã™ã‚‹ã‹ã‚‚ï¼Ÿã€ã¨ã„ã†äººã¯ã‚¯ãƒªãƒƒã‚¯ã—ã¦é£›ã‚“ã§èªã‚“ã§ãã ã•ã„ï¼Žå¤ªå—ã«ã—ã¦ã‚ã‚‹ã‚‚ã®ã¯è„†å¼±æ€§ã«ç›´çµã™ã‚‹å±é™ºåº¦ã®é«˜ã„ã‚‚ã®ã§ã™ï¼Ž mysql_query ãªã©ã®éžæŽ¨å¥¨é–¢æ•°ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ SET NAMES ã‚ã‚‹ã„ã¯ SET CHARACTER SET ãªã©ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¦ã„ã‚‹ ãã‚‚ãã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
repon 2019/06/24
php

PDO

mysql
ãƒªãƒ³ã‚¯
MySQLã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£å›³è§£è¬›åº§
ç¬¬1å›žDatabase Lounge Tokyoã§ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã§ã™ã€‚ã‚†ã‚‹ãµã‚ã«MySQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’è§£èª¬ã—ã¾ã—ãŸã€‚
repon 2016/07/28
mysql
ãƒªãƒ³ã‚¯
MariaDB Documentation
E-book: A Practical Guide to AI and Vector Search in Relational Databases
repon 2016/07/10
â€œWindows ã§ã®å ´æ‰€ Window ã§ã¯ã€my.ini ã‚’ my.cnf ã¨åŒã˜ã‚ˆã†ã«ä½¿ã†ã“ã¨ãŒã§ãã€MariaDB ã¯ä»¥ä¸‹ã®å ´æ‰€ã‹ã‚‰ãã‚Œã‚’æœã—ã¾ã™ã€‚â€

mysql

windows

mariadb
ãƒªãƒ³ã‚¯
MariaDBã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
MySQLã®æ´¾ç”ŸDBã€MariaDBã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ãŸã€‚ MariaDBã«ã¤ã„ã¦ - AskMonty KnowledgeBase https://kb.askmonty.org/ja/mariadb-japanese-mariadb/ 1)ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ MariaDBã®ã‚µã‚¤ãƒˆ(https://mariadb.org/)ã‹ã‚‰æœ€æ–°å®‰å®šæ¿ã€Œmariadb-5.5.30-winx64.msiã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ mariadb-5.5.30-winx64.msi(55.3 MB) https://downloads.mariadb.org/mariadb/5.5.30/ â€» ç”»é¢ä¸å¤®ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ã‹ã‚‰ã¯ãã®ã¾ã¾ã§ã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ããªã„å ´åˆã¯ã€å³ã® Mirrer ã‹ã‚‰æ—¥æœ¬ä»¥å¤–ã®ã‚µã‚¤ãƒˆã‚’é¸æŠžã—ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚
repon 2016/07/10
â€œã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’ç®¡ç†è€…æ¨©é™ã§å®Ÿè¡Œã—ã€ä¸‹è¨˜ã‚³ãƒžãƒ³ãƒ‰ã«ã‚ˆã‚ŠMySQLã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã€‚ net stop mysqlâ€

mariadb

Windows

MySQL
ãƒªãƒ³ã‚¯
ãŠä½¿ã„ã®ã‚µãƒ¼ãƒãƒ¼ã® PHP ã§ã¯ WordPress ã«å¿…è¦ãª MySQL æ‹¡å¼µã‚’åˆ©ç”¨ã§ããªã„ã‚ˆã†ã§ã™ã€‚
repon 2015/06/09
php

apache

mysql
ãƒªãƒ³ã‚¯
my.cnfã®å ´æ‰€ã‚’èª¿ã¹ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
repon 2015/06/08
â€œmysql --help | grep my.cnfâ€

mysql
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒãƒ¼ãƒˆæ™‚ã«ã€ŒMySQL server has gone awayã€ãŒç™ºç”Ÿã—ãŸã¨ãã®å¯¾å‡¦ | æ ªå¼ä¼šç¤¾ãƒŠãƒ³ã‚¯ãƒž å¤§é˜ªã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸åˆ¶ä½œä¼šç¤¾
ãŠæ°—è»½ã«ãŠå•ã„åˆã‚ã›ãã ã•ã„ TELï¼š050-3152-1848 é›»è©±å—ä»˜æ™‚é–“ã€€å¹³æ—¥9:30ï½ž18:30 ãƒ¡ãƒ¼ãƒ«ãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰ã®ãŠå•åˆã›ã¯ã‚³ãƒãƒ©ã‹ã‚‰
repon 2015/06/08
mysql

max_allowed_packet

tips
ãƒªãƒ³ã‚¯
MySQL ã«å¤§ããªãƒ‡ãƒ¼ã‚¿ã‚’é€ã‚‹éš›ã« max_allowed_packet ã‚’ç¢ºèªã—ãŸæ–¹ãŒã„ã„ | Sun Limited Mt.
MySQL ã§ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã‚µãƒ¼ãƒã«é€ã‚‹ã“ã¨ãŒã§ãã‚‹ãƒ‘ã‚±ãƒƒãƒˆã®æœ€å¤§ã¯ 16MB ã§ã™ã€‚ã—ã‹ã—ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ 1MB ã«ãªã£ã¦ã„ã¾ã™ã€‚ç”»åƒã‚’ DB ã«æ ¼ç´ã—ã¦ã„ã‚‹ OpenPNE ã®ã‚ˆã†ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã“ã®åˆ¶é™ã«å¼•ã£ã‹ã‹ã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ max_allowed_packet ã®ç¢ºèª mysql> show variables like 'max_allowed_packet'; +--------------------+---------+ | Variable_name | Value | +--------------------+---------+ | max_allowed_packet | 1048576 | +--------------------+---------+ max_allowed_packet ã‚’ SQL ã«ã‚ˆã‚Šå¤‰æ›´ã™ã‚‹ mysql> set
repon 2015/06/08
mysql

è¨å®š

max_allowed_packet
ãƒªãƒ³ã‚¯
ç¨¼åƒä¸ã®MySQLã‚’ç„¡åœæ¢ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ - Qiita
ç¨¼åƒä¸ã®MySQLã‚’ç„¡åœæ¢ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ å€‹äººãƒ¡ãƒ¢ã§ã™ã€‚ç¨¼åƒä¸ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã§ããªã„ã‘ã©ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¢—ã‚„ã—ãŸã„ï¼ˆå¢—æ®–ã—ãŸã„ï¼‰ãªã‚“ã¦å ´åˆã«ä½¿ãˆã‚‹æŠ€ã«ãªã‚Šã¾ã™ã€‚ ãƒžã‚¹ã‚¿ãƒ¼ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã¾ãšã€ã‚¹ãƒ¬ãƒ¼ãƒ–å´ã®ãƒ›ã‚¹ãƒˆã§ãƒžã‚¹ã‚¿ãƒ¼ã®ã‚¹ã‚ãƒ¼ãƒžï¼ˆä¾‹ã§ã¯ã€schema1 schema2ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã‚Šã¾ã™ã€‚ã“ã®éš›ã«ã€--master-data ã¨ --single-transaction ã¯å¿…é ˆã§ã™ã€‚ --master-data ã‚’æŒ‡å®šã—ã¾ã™ã¨ã€masterå´ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒã‚¸ã‚·ãƒ§ãƒ³ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ --single-transaction ã‚’æŒ‡å®šã—ã¾ã™ã¨ã€innodbã®å ´åˆã¯ã€ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒå´ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã›ãšã«ã€dumpã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™
repon 2015/06/07
mysql
ãƒªãƒ³ã‚¯
MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ‰‹é † - ã‚ãã‚ãæŠ€è¡“ãƒ©ãƒ³ãƒ‰
æƒ³å®šã—ã¦ã„ã‚‹ã“ã¨ â€ MySQL5.0 MySQLãŒã™ã§ã«ç¨¼å‹•ä¸ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®šã¯ã—ã¦ã„ãªã„ ä»Šå›žMySQLã‚’ã‚‚ã†ä¸€å°å¢—ã‚„ã—ã¦2å°æ§‹æˆã¨ã—ã€masterã€slaveã®æ§‹æˆã«ã™ã‚‹ â€»ä»Šå›žã¨çŠ¶æ³ãŒç•°ãªã‚‹å ´åˆã¯ã€MySQLã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’èªã‚€ã¨ã„ã„ã§ã™ã€‚ â†‘ 1. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ â€ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ ä½œæˆã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒžã‚¹ã‚¿ã®ãƒã‚¤ãƒŠãƒª ãƒã‚°ã‚’èªã¿è¾¼ã‚€ã¨ãã«æŽ¥ç¶šã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ãªã‚‹ã€‚ æ—¢å˜ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯å¯èƒ½ã ãŒã€ãƒ¦ãƒ¼ã‚¶åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒ master.info ãƒ•ã‚¡ã‚¤ãƒ«å†…ã«ãƒ†ã‚ã‚¹ãƒˆã§ä¿å˜ã•ã‚Œã‚‹ãŸã‚ã€å®‰å…¨ã®ãŸã‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒã‚»ã‚¹ã«ã ã‘æ¨©é™ãŒã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ è¨å®šä¾‹(ãƒžã‚¹ã‚¿ã®ã»ã†ã«è¨å®š) 192.168.23.0/24 å†…ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã§è¨±å¯ ãƒ¦ãƒ¼ã‚¶ãƒ¼åï¼šrepl ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ï¼šslavepass mysql >
repon 2015/06/07
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ã§ãƒã‚¤ãƒŠãƒªãƒ
repon 2015/06/07
mysql
ãƒªãƒ³ã‚¯
é›†è¨ˆã¯RDBã°ã‹ã‚Šã«é ‘å¼µã‚‰ã›ã‚‹ã®ã‚’ã‚„ã‚ã‚‹ã¨å¹¸ã›ã«ãªã‚Œã‚‹ã€‚ - Qiita
ã¯ã˜ã‚ã« å„ç¨®ã®DBä¸ã®é›†è¨ˆä½œæ¥ã‚’è¡Œã†ã«ã‚ãŸã£ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã‚’ã©ã†ã—ã¦ã‚‚æ‰±ã‚ãªã‘ã‚Œã°ãªã‚‰ãªã„å ´åˆã¯ã€SQLã®ã¿ã§å®Œçµã•ã›ãªã„ã“ã¨ã‚’æ¤œè¨Žã—ãªã‘ã‚Œã°ã€ã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã‚’å¤§é‡ã«æ¶ˆè²»ã—ãŸæŒ™å¥ã€ä½•æ™‚ã¾ã§çµŒã£ã¦ã‚‚ä½œæ¥ãŒå®Œäº†ã—ãªã„ã¨ã„ã†ã“ã¨ãŒæœ‰ã‚Šã¾ã™ã€‚ SQLæ“ä½œã ã‘ã«é ¼ã‚‰ãªã„ã“ã¨ã‚’æ¤œè¨Žã—ãŸã„é›†è¨ˆä¾‹ explainã™ã‚‹ã“ã¨ã§å¤§ä½“ã®å‚¾å‘ã¯ã‚ã‹ã‚Šã¾ã™ãŒã€ãŠãŠã‚ˆãä»¥ä¸‹ã®ã‚ˆã†ãªè¦ç´ ã‚’å«ã‚€é›†è¨ˆãŒå¯¾è±¡ã¨ãªã‚Šã¾ã™ã€‚ å¯¾è±¡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå·¨å¤§ã§ã‚ã‚‹ï¼ˆæ•°ç™¾ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šï¼‰ DBã®ä½™å‰°ãƒªã‚½ãƒ¼ã‚¹ã«ã‚‚ã¨ã‚‚ã¨ä½™è£•ãŒç„¡ã„ indexã®ãµã‚‰ã‚Œã¦ã„ãªã„é …ç›®ã§é›†è¨ˆ/joinã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ joinå¯¾è±¡ã®é …ç›®ãŒã‚„ã‘ã«å¤šã„ not in å·¨å¤§ãªã‚µãƒ–ã‚¯ã‚¨ãƒª is null group by like etc... ã§ã¯ã©ã†ã™ã‚‹ã‹ï¼Ÿ é›†è¨ˆå¯¾è±¡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸€æ—¦ãƒ•ã‚¡ã‚¤ãƒ«ã«åãå‡ºã—ãŸä¸Šã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹ã®å‡¦ç†ã‚’ã—ã¦ã—ã¾ã„ã¾ã—ã‚‡ã†ã€‚ å®Ÿè·µä¾‹1
repon 2015/06/05
MySQL

tips
ãƒªãƒ³ã‚¯
èª°ã‚‚æ•™ãˆã¦ãã‚Œãªã‹ã£ãŸMySQLã®éšœå®³è§£æžæ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
repon 2015/06/05
mysql
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
repon 2015/05/30
mysql

tips
ãƒªãƒ³ã‚¯
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ¼æ´©ã—ãªã„ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã®ä½œã‚Šæ–¹ ã€œ ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã§æº€è¶³ã™ã‚‹å‰ã«è€ƒãˆã‚‹ã¹ãã“ã¨
â– â– åºè«– å¾³ä¸¸ã•ã‚“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã€Œã„ã¾ã•ã‚‰èžã‘ãªã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å–ã‚Šæ‰±ã„æ–¹ã€ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã€æ˜¨ä»Šã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆè¦ä»¶ã¨ã—ã¦ã€ã‚µãƒ¼ãƒå†…ã«ä¾µå…¥ã•ã‚ŒãŸå ´åˆã§ã‚‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã§ãã‚‹ã ã‘ä¿è·ã™ã¹ãã¨ã„ã†è«–èª¿ãŒè¦‹å—ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ä¸ŠæŽ²ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã¯ã€ãã®æ‰‹æ³•ã¨ã—ã¦ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥åŒ–ã‚’å‹§ã‚ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã‚¹ãƒ©ã‚¤ãƒ‰ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã¨ãŠã‚Šã€ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã«ã¯ã€è¤‡é›‘ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®è§£èªã¯å›°é›£ã«ãªã‚‹ã‚‚ã®ã®ã€å˜ç´”ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã«ã¤ã„ã¦ã¯ååˆ†ãªä¿è·ã‚’æä¾›ã§ããªã„ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯é©åˆ‡ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰é‹ç”¨ãŒã§ããªã„ã€ã¨ã„ã†ã®ãŒæ‚²ã—ã„ç¾å®Ÿã§ã™ã€‚ ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã‚’ä½¿ã£ãŸæ‰‹æ³•ã§ã“ã®ã‚ˆã†ãªå•é¡ŒãŒæ®‹ã‚‹ã®ã¯ã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã«ä¾µå…¥ã—ãŸæ”»æ’ƒè€…ãŒãƒ¦ãƒ¼ã‚¶ãƒ¼ã®èªè¨¼æƒ…å ±ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã€èªè¨¼æƒ…å ±ã‚’ã‚ªãƒ•ãƒ©ã‚¤ãƒ³æ”»æ’ƒã™ã‚‹ã“
repon 2015/04/21
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

database

mysql
ãƒªãƒ³ã‚¯
dfltweb1.onamae.com â€“ ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚
ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ã€ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãŠåå‰.comã®ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ã¸ Copyright Â© 2020 GMO Internet, Inc. All Rights Reserved.
repon 2015/04/06
cron

mysql
ãƒªãƒ³ã‚¯
MySQLã§too many connectionsã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ãŸéš›ã®å¯¾å‡¦æ–¹æ³• | ã‚¯ãƒ©ãƒ³ãƒã‚¿ã‚¤ãƒžãƒ¼æ ªå¼ä¼šç¤¾
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å®®æœ¬ã§ã™ã€‚ å…ˆæ—¥ã‚¢ãƒ—ãƒªé–‹ç™ºã‚’ã—ã¦ã„ã‚‹ã¨ã€Œtoo many connectionsã€ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã€MySQLã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªããªã‚Šã¾ã—ãŸã€‚ ã€Œtoo many connectionsã€ã€ã¤ã¾ã‚ŠæŽ¥ç¶šæ•°ãŒå¤šã„ã¨ã„ã†ç†ç”±ã®ãŸã‚ã€MySQLã®è¨å®šã‚’å¤‰æ›´ã—æŽ¥ç¶šæ•°ï¼ˆmax_connectionsï¼‰ã‚’å¢—ã‚„ã™ã€ï¼‘å›žã®æŽ¥ç¶šæ™‚é–“ï¼ˆwait_timeoutï¼‰ã‚’çŸãã™ã‚‹ãªã©ã®å¯¾ç–ã‚’ã¨ã‚Œã°è§£æ±ºã—ã¾ã™ã€‚ ãã®æ–¹æ³•ã¯ã€SSHã§ã‚µãƒ¼ãƒã¸ãƒã‚°ã‚¤ãƒ³ã—ã€Œ/etc/my.cnfã€ã‚’ç·¨é›†ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦å¯èƒ½ã§ã™ã€‚ ã—ã‹ã—ã€ã‚¯ãƒ©ãƒ³ãƒã‚¿ã‚¤ãƒžãƒ¼ã§ã¯ã‚¢ãƒ—ãƒªé–‹ç™ºãƒ»é‹ç”¨ç’°å¢ƒã¨ã—ã¦AWSï¼ˆAmazon Web Serviceï¼‰ã‚’ä½¿ã£ã¦ãŠã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã¯RDSã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚’ä½¿ç”¨ã—ã¦SSHã§ç›´æŽ¥ãƒã‚°ã‚¤ãƒ³ã—ã€ã€Œ/etc/my.cnfã€ã‚’ç›´æŽ¥ç·¨é›†ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ ã©ã†ã™ã‚Œã°ã‚ˆã„ã‹ã¨èª¿
repon 2015/03/27
wait_timeoutã‚’è¨å®šã™ã‚‹

mysql

max_connections
ãƒªãƒ³ã‚¯
YouTubeãŒMySQLã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã€ŒVitessã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚Kubernetesã«å¯¾å¿œ
YouTubeãŒMySQLã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã€ŒVitessã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚Kubernetesã«å¯¾å¿œ Google Cloud Platformã®ãƒ–ãƒã‚°ã«æŠ•ç¨¿ã•ã‚ŒãŸè¨˜äº‹ã€ŒScaling MySQL in the cloud with Vitess and Kubernetesã€ã§ã€Vitessã¯æ¬¡ã®ã‚ˆã†ã«èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ At YouTube, we went on that journey as we scaled our MySQL deployment, which today handles the metadata for billions of daily video views and 300 hours of new video uploads per minute. To do this, we developed the Vitess platform,
repon 2015/03/23
mysql
ãƒªãƒ³ã‚¯
å¤–éƒ¨ã‚ãƒ¼Nightã§ã€Œæˆ‘ã€…(ä¸»èªžãŒå¤§ãã„)ã¯ä½•æ•…MySQLã§å¤–éƒ¨ã‚ãƒ¼ã‚’ä½¿ã‚ãªã„ã®ã‹ã€ã¨ã„ã†ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
ç™ºè¡¨è³‡æ–™:æˆ‘ã€…(ä¸»èªžãŒå¤§ãã„)ã¯ä½•æ•…MySQLã§å¤–éƒ¨ã‚ãƒ¼ã‚’ä½¿ã‚ãªã„ã®ã‹ ã‚‚ã†ä¸€æœˆä»¥ä¸Šå‰ã§ã™ãŒã€å¤–éƒ¨ã‚ãƒ¼Nightã¨ã„ã†å‹‰å¼·ä¼šã§ã€MySQLã®å¤–éƒ¨ã‚ãƒ¼ã«ã¤ã„ã¦ã®ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚ ã‚ˆãè¨€ã‚ã‚Œã¦ã„ã‚‹ã“ã¨ã§ã™ãŒã€ãã‚Œãªã‚Šã®è¦æ¨¡ã®Webã‚µãƒ¼ãƒ“ã‚¹ã®MySQLé‹ç”¨ã¨ãªã‚‹ã¨å¤–éƒ¨ã‚ãƒ¼ã‚’é¿ã‘ã–ã‚‹ã‚’å¾—ãªã„éƒ¨åˆ†ãŒã‚ã‚Šã€ã¨ã¯è¨€ãˆãã®è¾ºã‚Šã«é–¢ã—ã¦ã¾ã¨ã¾ã£ãŸè³‡æ–™ãŒä½™ã‚Šãªã•ãã†ã ã£ãŸã®ã§ã€è‡ªåˆ†ãªã‚Šã«ã¾ã¨ã‚ãŸå†…å®¹ã‚’è©±ã—ãŸæ¬¡ç¬¬ã§ã™ã€‚ MySQLã‚’ä½¿ã£ãŸãã“ãã“ã®è¦æ¨¡ã®Webã‚µãƒ¼ãƒ“ã‚¹ã‚’é‹ç”¨ã—ã¦ã„ã‚‹äººã«ã¨ã£ã¦ã¯å½“ãŸã‚Šå‰ã®å†…å®¹ã—ã‹æ›¸ã‹ã‚Œã¦ã¾ã›ã‚“ã€‚ãŸã ã€ã€Œå¤–éƒ¨ã‚ãƒ¼ä½¿ã‚ãªã„ã¨ã‹é¦¬é¹¿ãªã®ã€ã¨ã‹ãã‚“ãªè«–èª¿ã‚’è¦‹ã‚‹ã“ã¨ãŒã‚ã‚Šã€ãã†ã„ã†æ„è¦‹ã«å¯¾ã—ã¦ã€å®Ÿéš›å•é¡Œå¤–éƒ¨ã‚ãƒ¼ã‚’ä½¿ãˆã‚‹ã¨ãªã‚Œã°ä¾¿åˆ©ã ã¨ã¯æ€ã„ã¾ã™ãŒã€ãã‚ŒãŒã‚ã‹ã£ãŸä¸Šã§ã€ä½¿ã‚ãªã„ã¨ã„ã†é¸æŠžã‚’ã™ã‚‹ã“ã¨ãŒã‚ã‚Šå¾—ã‚‹ã¨ã„ã†ã“ã¨ã‚’ç¤ºã—ãŸã‹ã£ãŸã¨ã„ã†ã®ãŒã‚ã‚Šã¾ã™ã€‚ å®Ÿéš›ãƒ–ã‚³ãƒ¡ã§ã€Œãã“ãã“ã®è¦æ¨¡ãªã‚‰ã°å¤–
repon 2015/03/17
mysql
ãƒªãƒ³ã‚¯
MySQL 5.5.11 unicode_ci ã§åŒä¸€è¦–ã•ã‚Œã‚‹æ–‡å—
MySQL 5.5.11 unicode_ci ã§åŒä¸€è¦–ã•ã‚Œã‚‹æ–‡å— Unicode 002000A02000200120022003200420052006200720082009200A202F205F3000 Character Unicode 0021FE57FF01 Character !ï¹—ï¼ Unicode 0022FF02 Character "ï¼‚ Unicode 0023FE5FFF03 Character #ï¹Ÿï¼ƒ Unicode 0024FE69FF04 Character $ï¹©ï¼„ Unicode 0025FE6AFF05 Character %ï¹ªï¼… Unicode 0026FE60FF06 Character &ï¹ ï¼† Unicode 0027FF07 Character 'ï¼‡ Unicode 0028207D208DFE35FE59FF08 Character (â½â‚ï¸µï¹™
repon 2015/03/08
mysql

unicode

è³‡æ–™
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 æ¬¡ã®ãƒšãƒ¼ã‚¸