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

ducky19999 id:ducky19999

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

${{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 8ç³»ã§ PHPã‹ã‚‰æŽ¥ç¶šã§ããªã„å ´åˆ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã©ã†ã‚‚fujiharaã§ã™ã€‚ä»Šå¹´ã‚‚æ®‹ã‚Šã‚ãšã‹ã§ã™ãã€‚ å¹´ã€…å¯’ãæ„Ÿã˜ã‚‹åº¦åˆã„ãŒå¼·ããªã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€åŸºç¤Žä»£è¬ãŒè½ã¡ã¦ã‚‹ã®ãŒ åŽŸå› ã‹ã¨æ€¯ãˆã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã¨ã‚ã‚‹æ¡ˆä»¶ã§ã‚µãƒ¼ãƒç§»è¡Œæ™‚ã«MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒä¸ŠãŒã‚Š 8.x ã«ãªã£ãŸã¨ãã« PHPã‹ã‚‰æŽ¥ç¶šã§ããªã„ç¾è±¡ãŒç™ºç”Ÿã—ã¦è§£æ±ºã—ãŸæ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ ã¨ã‚ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚µãƒ¼ãƒç§»è¡ŒãŒå¿…è¦ã ã£ãŸã®ã§ã™ãŒã€ ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ç§»è¡Œã—ã¦ã€ã„ã–ãƒšãƒ¼ã‚¸ã‚’è¡¨ç¤ºã™ã‚‹ã¨MySQLã«ã¤ãªãŒã‚‰ãªã„ã€‚ åŽŸå› ã‚¨ãƒ©ãƒ¼ã‚’ç¢ºèªã™ã‚‹ã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã§å¼¾ã‹ã‚Œã¦ã¾ã—ãŸã€‚ åŽŸå› ã‚’æŽ¢ã™ã¨MySQL 8ã§ã¯ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æš—å·åŒ–ã•ã‚Œã‚‹ã®ã§(cache_sha2_password) ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰æŽ¥ç¶šã™ã‚‹å ´åˆã‚‚ã“ã‚Œã«å¯¾å¿œã—ã¦ã„ãªã„ã¨æŽ¥ç¶šãŒã§ããªã„ã¨ã®ã“ã¨ã€‚ ä»Šå›žã¯ãƒ—ãƒã‚°ãƒ©ãƒ å´ã‚’å¤‰æ›´ã—ãªã‹ã£ãŸã®ã§ã€ MySQLå´ã§ä»¥ä¸‹ã®ç”¨ã«å¯¾å¿œã—ã¾ã—ãŸã€‚ # /etc/my.cnf [mysq
ducky19999 2019/06/05
MySQL
ãƒªãƒ³ã‚¯
MySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’utf8mb4ã«å¤‰æ›´ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
ducky19999 2018/05/15
MySQL
ãƒªãƒ³ã‚¯
MySQL(InnoDB) ã§ charset ã‚’ utf8mb4 ã«ã™ã‚‹æ³¨æ„ç‚¹ã®ç¾åœ¨
çµµæ–‡å—ã«å¯¾å¿œã—ãŸã„ãªã©ã®ç†ç”±ã§ utf8mb4 ã‚’ä½¿ã†ã€‚ ãŸã ã€utf8mb4 ã«è¨å®šã™ã‚‹ã ã‘ã ã¨ä»¥å‰ã¯å•é¡ŒãŒã‚ã£ãŸã€‚ MySQL 5.7.9 ä»¥é™ã§ã¯è§£æ±ºã•ã‚ŒãŸã®ã§ã€ãã®è©±ã‚’ã¾ã¨ã‚ã‚‹ã€‚
ducky19999 2018/05/15
MySQL
ãƒªãƒ³ã‚¯
ãªãœã‚ãªãŸã¯ SHOW ENGINE INNODB STATUS ã‚’èªã¾ãªã„ã®ã‹ - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
ã“ã®è¨˜äº‹ã¯ã€MySQL Casual Advent Calendar 2017ã®20æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ç…½ã‚Šæ°—å‘³ã®ã‚¿ã‚¤ãƒˆãƒ«ã§ã™ãŒã¿ãªã•ã‚“ SHOW ENGINE INNODB STATUS èªã‚“ã§ã¾ã™ã‹ï¼Ÿ SHOW ENGINE INNODB STATUS \G è¦‹ã¥ã‚‰ã„ã®ãªã‚“ã¨ã‹ãªã‚‰ã‚“ã®ã‹ã€‚â€” ããƒ¼ã ã„@åˆä»£ALF (@soudai1025) 2016å¹´12æœˆ20æ—¥ ã‚ã‹ã‚‹ã€‚ã§ã‚‚MySQLã®æŒ¯ã‚‹èˆžã„ã‚’çŸ¥ã‚‹ä¸ã§SHOW ENGINE INNODB STATUSã‚’èªã¾ã–ã‚‹å¾—ãªã„å ´é¢ã¯ãã“ãã“ã‚ã‚Šã¾ã™ã€‚ ã©ã‚“ãªæ™‚ã«å¿…è¦ã«ãªã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã“ã§SHOW ENGINE INNODB STATUSã«ã¾ã¤ã‚ã‚‹è©±ã‚’æ›¸ãã¾ã™ã€‚ SHOW ENGINE INNODB STATUS ã‚’ã¾ãšèªã¿ã‚„ã™ãã™ã‚‹ ã¾ãšæœ«å°¾ã« \G ã‚’ä»˜ã‘ã¾ã—ã‚‡ã†ã€‚ ã“ã‚Œã§3å€èªã¿ã‚„ã™ããªã‚Šã¾ã™ã€‚ æ¬¡ã« pager less -S ã‚’
ducky19999 2017/12/20
MySQL
ãƒªãƒ³ã‚¯
CentOS7 mysqlãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããªã„ - americandog1993ã®æ—¥è¨˜
$ sudo yum install mysql-server èªã¿è¾¼ã‚“ã ãƒ—ãƒ©ã‚°ã‚¤ãƒ³:fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: ftp.iij.ad.jp * epel: ftp.riken.jp * extras: ftp.iij.ad.jp * updates: centosk3.centos.org ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ mysql-server ã¯åˆ©ç”¨ã§ãã¾ã›ã‚“ã€‚ ã‚¨ãƒ©ãƒ¼: ä½•ã‚‚ã—ã¾ã›ã‚“ã‚¨ãƒ©ãƒ¼ã®åŽŸå› ã¯æ£ç¢ºã«ã¯ã‚ã‹ã‚‰ãªã„ãŒã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§å…¥ã£ã¦ã‚‹mariaDBã¨ç«¶åˆã™ã‚‹å ´åˆãŒã‚ã‚‹ã¨ã„ã†è¨˜äº‹ã‚’ç™ºè¦‹ã€‚ ä¸‹è¨˜ã®é€šã‚Šã«å®Ÿæ–½ã—ãŸã‚‰ç„¡äº‹ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããŸã€‚ $ sudo yum remove mariadb-libs $ sudo rm -rf /var/lib/mysql/ $ sudo yum
ducky19999 2017/09/28
MySQL
ãƒªãƒ³ã‚¯
MySQLã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
2017/09/05 db tech showcase Tokyo 2017 http://www.db-tech-showcase.com/dbts/tokyoRead less
ducky19999 2017/09/06
MySQL
ãƒªãƒ³ã‚¯
MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ã‚„ã‚‹ã“ã¨ï¼ˆDBã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä½œæˆç‰ï¼‰ - Qiita
WordPressç”¨ã«MySQLã‚’ä½¿ã„ãŸããªã£ãŸã®ã§ã€åˆæœŸè¨å®šã‚’ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ å¯¾è±¡ MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå®Œäº†ã—ã¦ã„ã‚‹äº‹ MySQLã‚’ã“ã‚Œã‹ã‚‰ä½¿ã„å§‹ã‚ã‚‹æ–¹ rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤‰æ›´ ç°¡å˜ãªæ–¹æ³•ï¼ˆCentOSã§ç¢ºèªæ¸ˆã¿ï¼‰ mysqladminã§rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤‰æ›´ã™ã‚‹ rootã§ãƒã‚°ã‚¤ãƒ³ã§ãã‚‹ã‹ã©ã†ã‹ç¢ºèªã™ã‚‹
ducky19999 2017/02/01
MySQL
ãƒªãƒ³ã‚¯
MySQLã‚’ï¼‘ã€œï¼’æ™‚é–“ã§ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
æœ€è¿‘ã€Elastic Beanstalkã‚„ECSã¨æˆ¦ã£ã¦ã„ã‚‹SREãƒãƒ¼ãƒ ã®è…åŽŸã§ã™ã€‚ P5ã‚’ã‚„ã‚ŠãŸã„ã®ã«PS3ã‚‚PS4ã‚‚æŒã£ã¦ã„ãªã„ã®ã§æŒ‡ã‚’ãã‚ãˆã¦ç¾¨ã¾ã—ãŒã£ã¦ã„ã‚‹æ¯Žæ—¥ã§ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€çªç„¶ã®ã‚¢ã‚¯ã‚»ã‚¹å¢—ã«å‚™ãˆã‚‹ãŸã‚ã«ã€MySQLã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ï¼‘ã€œï¼’æ™‚é–“ã§ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã§ãã‚‹ã‚ˆã†ã«ã—ãŸè©±ã‚’æ›¸ãã¾ã™ã€‚ MySQL on EC2 ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã¯å‘¨çŸ¥ã®é€šã‚ŠAWSã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ãŒã€ä¸»è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ã¯Amazon RDSã§ã¯ãªãMySQL on EC2ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯ä»¥ä¸‹ã®ã‚ˆã†ãªç†ç”±ã«ã‚ˆã‚‹ã‚‚ã®ã§ã™ã€‚ æ´å²çš„ãªçµŒç·¯: AWSç§»è¡Œå½“æ™‚ã€RDSãŒç„¡ã‹ã£ãŸã€‚ã¾ãŸã€ç§»è¡Œå¾Œã‚‚ã—ã°ã‚‰ãã¯Tritonnã‚’ä½¿ã£ã¦ã„ãŸãŸã‚ã€RDSã‚’ä½¿ã†ã“ã¨ãŒã§ããªã‹ã£ãŸ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã®å®Ÿç¾: VPCãƒ«ãƒ¼ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ãŸä»®æƒ³IPã¨MHA for MySQLã‚’ä½¿ã£ã¦ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã‚¼ãƒã®ãƒžã‚¹ã‚¿DBã®åˆ‡ã‚Šæ›¿ãˆã‚’
ducky19999 2016/10/06
MySQL
ãƒªãƒ³ã‚¯
mysqldã¨ã¯ï½œã€Œåˆ†ã‹ã‚Šãã†ã€ã§ã€Œåˆ†ã‹ã‚‰ãªã„ã€ã§ã‚‚ã€Œåˆ†ã‹ã£ãŸã€æ°—ã«ãªã‚Œã‚‹ITç”¨èªžè¾žå…¸
ç°¡å˜ã«æ›¸ãã‚ˆ mysqldï¼ˆèªï¼šãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ãƒ‡ã‚£ãƒ¼ï¼‰ã¨ã¯ Linuxã¨ã‹ã«ãŠã‘ã‚‹å¸¸é§ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆå¸¸ã«ï¼ˆè¦‹ãˆãªã„æ‰€ã§ï¼‰å‹•ã„ã¦ã„ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ï¼‰ï¼ˆãƒ‡ãƒ¼ãƒ¢ãƒ³ï¼‰ã®ã²ã¨ã¤ ã§ã‚ã‚Š MySQLï¼ˆWebã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã‚ã‚Œã‚‹ã“ã¨ãŒå¤šã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã¨ã—ã¦ã®ãŠä»•äº‹ã‚’ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ãƒ¢ãƒ³ã•ã‚“ ã§ã™ã€‚ é †ç•ªã«è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ ã¾ãšã¯äºˆå‚™çŸ¥è˜ã¨ã—ã¦ ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ»MySQL ãƒ»ãƒ‡ãƒ¼ãƒ¢ãƒ³ ã«ã¤ã„ã¦ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ ã€Œãã‚“ãªã®èª¬æ˜Žã•ã‚Œãªãã¦ã‚‚çŸ¥ã£ã¦ã‚‹ã‚ˆï¼ã€ãªäººã¯é©å½“ã«èªã¿é£›ã°ã—ã¦ãã ã•ã„ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€Œãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã¦ãŠãç®±ã€ã§ã™ã€‚ çªã£è¾¼ã‚“ã§è€ƒãˆã‚‹ã¨æ··ä¹±ã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä½•ã¨ãªãã®ãƒ•ã‚£ãƒ¼ãƒªãƒ³ã‚°ã§ç†è§£ã—ã¦ãã ã•ã„ã€‚ MySQLã¯ã€ŒWebã‚·ã‚¹ãƒ†ãƒ ï¼ˆã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚’ä½¿ã†ã‚·ã‚¹ãƒ†ãƒ ï¼‰ã§ã€ã‚ˆãä½¿ã‚ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã§ã™ã€‚ æ£ç¢ºã«ã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹ã‚„ã¤ã§ã™ãŒã€æ°—ã«ã—ãªãã¦çµæ§‹
ducky19999 2016/07/28
MySQL
ãƒªãƒ³ã‚¯
MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨
â€” ããƒ¼ã ã„ï¼ åˆä»£ALF (@soudai1025) 2015, 8æœˆ 24 ã¨ãƒ–ãƒ¼ãƒ¡ãƒ©ãƒ³æŠ•ã’ã¦è¦‹äº‹ã«åˆºã•ã£ã¦ã‚‹ã®ã§ä»Šã‹ã‚‰è¨˜äº‹æ›¸ãã€‚ ä¸¡ã‚µã‚¤ãƒ‰ã«ã¯ã‹ãªã‚ŠåŽ³ã—ã„è©±ã‚‚ã™ã‚‹ãŒä¿ºã®æœ¬éŸ³ã‚’è´ã„ã¦ãŠã‘ï¼ˆé–¢ç™½å®£è¨€ï¼‰ ã¾ãæ´å²ã®é•·ã„RDBãªã®ã§ãŠäº’ã„ã®æ¯”è¼ƒè¨˜äº‹ã¯æ²¢å±±ã‚ã‚‹ã€‚ ãªã®ã§ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰(MySQL)ã¨ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹(PostgreSQL)ã ã¨ã‹VACUUMã ã£ã¦è©±ã¯ã—ãªã„ã€‚ ã‚€ã—ã‚å®Ÿéš›ã«ä½¿ã£ã¦ã¿ãŸéš›ã®é•ã„ã‚’ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã™ã‚‹ã€‚ 1. SQLã®é•ã„ åŸºæœ¬çš„ã«MySQLã§ã‚„ã£ã¦ã„ãŸã“ã¨ã¯PostgreSQLå‡ºæ¥ã‚‹ã€‚ ã—ã‹ã—é–¢æ•°ã®æŒ™å‹•ã®é•ã„ã¯å¹¾ã¤ã‹ã‚ã‚‹ã€‚ ä¾‹ãˆã°æ™‚é–“ã‹ã‚‰æ›œæ—¥ã«è©²å½“ã™ã‚‹æ•°å—ã«å¤‰æ›ã—ãŸå ´åˆã« MySQLã€€â†’ã€€date_format(time,"%w")ã€€0ã‹ã‚‰å§‹ã¾ã‚Šã€æ—¥æ›œæ—¥ã«è©²å½“ã™ã‚‹ PostgreSQLã€€â†’ã€€to_char(time,'D')ã€€1ã‹ã‚‰å§‹ã¾ã‚Šã€æ—¥æ›œæ—¥ã«è©²å½“ã™ã‚‹ ãªã©æŒ™å‹•ã«äº’æ›æ€§
ducky19999 2015/08/24
PostgreSQL

MySQL
ãƒªãƒ³ã‚¯
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
ducky19999 2015/03/23
MySQL

emoji

å¯¿å¸
ãƒªãƒ³ã‚¯
utf8_unicode_ci ã«å¯¾ã™ã‚‹æ—¥æœ¬ã®é–‹ç™ºè€…ã®è¦‹è§£ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
RailsãŒMySQLã®collationã‚’ã‚µãƒ¼ãƒãƒ¼å´ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8_general_ciã‹ã‚‰utf8_unicode_ciã«ã‚ã–ã‚ã–å¤‰ãˆã¦ã‚‹ã®ã©ã†ã›å¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã„ã ã‚ã¨æ€ã£ã¦æŽ˜ã£ã¦ã¿ãŸã‚‰ã‚„ã£ã±ã‚Šå¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã‹ã£ãŸâ€¦ https://t.co/6NeetGhTF0â€” Ryuta Kamizono (@kamipo) April 18, 2014 Railsã§collationã¨ã—ã¦utf8_unicode_ci(Railsã®DEFAULT_COLLATION)ãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã®ã¯charsetãŒæœªæŒ‡å®šã‚‚ã—ãã¯utf8(Railsã®DEFAULT_CHARSET)ã®ã¨ãã ã‘ã§ã€utf8mb4ã«ã™ã‚‹ã“ã¨ã¨ã‹ã¯å…¨ãè€ƒæ…®ã•ã‚Œã¦ãªã„ã€‚â€” Ryuta Kamizono (@kamipo) April 19, 2014 @frsyuki MySQLã®charset utf8ã®ã¨ãã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ
ducky19999 2015/03/09
rails

MySQL

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
mysqld_safeã¯å¦‚ä½•ã«ã—ã¦mysqldã®ãƒ€ã‚¦ãƒ³ã‚’æ¤œçŸ¥ã™ã‚‹ã®ã‹
2025 ( 2 ) 2æœˆ ( 2 ) 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 ) 4æœˆ ( 1 ) 3æœˆ ( 2 ) 2020 ( 4
ducky19999 2015/03/06
MySQL
ãƒªãƒ³ã‚¯
[Q&A]MySQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãƒŸã‚¹ | Yakst
Percona MySQL Webinarsã®ç™ºè¡¨(MYSQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãªãƒŸã‚¹ã«ã¤ã„ã¦)ã®QAã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬ç™ºè¡¨ã¯SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³è‘—è€…ã®Bill Karwinã•ã‚“ã®ç™ºè¡¨ã§ã™ã€‚ ã‚ªãƒªã‚¸ãƒŠãƒ«: http://www.percona.com/resources/mysql-webinars/how-avoid-even-more-common-deadly-mysql-development-mistakes July 17, 2014 by Bill Karwin æ°´æ›œæ—¥ã«ã€ŒMySQLã‚’é–‹ç™ºã™ã‚‹ä¸Šã§ã‚ˆãèµ·ã“ã‚‹(ãã—ã¦è‡´å‘½çš„ãª)ãƒŸã‚¹ã‚’ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã‹ã€ã‚’Percona MySQL webinarsã§ç™ºè¡¨ã—ãŸã€‚ãŠè¦‹é€ƒã®éš›ã¯ã€ãƒ“ãƒ‡ã‚ªã¨ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’è¦‹ã‚‹ç‚ºã«ç™»éŒ²ã™ã‚Œã°ã¾ã ã”è¦§ã«ã„ãŸã ã‘ã‚‹ã€‚ å‚åŠ ã„ãŸã ã„ãŸçš†æ§˜ã€ãã—ã¦ã¨ã‚Šã‚ã‘ã™ã°ã‚‰ã—ã„è³ªå•ã‚’ã—ã¦ã„ãŸã ãã‚ã‚ŠãŒãŸãæ€ã£ã¦ã„ã‚‹
ducky19999 2014/08/11
â€œdayã‚«ãƒ©ãƒ ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨å‰Šé™¤ã¯é€Ÿããªã‚‹ã ã‚ã†ã‹ï¼Ÿã‚‚ã—ãã†ã§ã‚ã‚‹ã¨ã™ã‚‹ã¨ã©ã®ãã‚‰ã„é€Ÿããªã‚Šã€ã©ã®ãã‚‰ã„SELECTãŒé…ããªã‚‹ã ã‚ã†ã‹ï¼Ÿå…¨ã¦ã®ã‚¨ãƒ³ãƒˆãƒªã‚’å‰Šé™¤ã›ãšã€éŽåŽ»ã®ç‰¹å®šã®æ—¥ã‚’ä¾‹ãˆã°" WHERE day = '1 week ag

MySQL
ãƒªãƒ³ã‚¯
ã“ã‚Œã‹ã‚‰MySQLã‚’ã‚¤ãƒã‹ã‚‰å¦ã¶äººã«æ§ã’ãŸã„23å€‹ã®ã‚³ãƒžãƒ³ãƒ‰ãƒªã‚¹ãƒˆ
ã©ãƒ¼ã‚‚ã€‚ä»Šå¹´ã®æ˜¥é ƒã‹ã‚‰MySQLã‚’å¦ã³å§‹ã‚ãŸã€ã™ã‚‹ã·ï¼ˆ @isloop ï¼‰ã§ã™ã€‚ å¦ã³åˆã‚ã®ã“ã‚ã¯ã€ã€ŒãŸã‹ã ã‹æ–‡å—åˆ—ã‚’è¨˜éŒ²ã™ã‚‹ã ã‘ã§ãªã‚“ã¦ã‹ã£ãŸã‚‹ã„ã‚“ã ã€‚ã‚„ã£ã±ã‚ŠCSVä¿å˜ã«é€ƒã’ã‚ˆã†ã‹ãªã€‚ã€ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ãŒã€æœ€è¿‘ã«ãªã£ã¦ã‚ˆã†ã‚„ãæ…£ã‚Œã¦ããŸã‚ˆã†ã§ã€ã€Œçµæ§‹ä¾¿åˆ©ã˜ã‚ƒã‚“MySQLã€ã¨æ€ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ã€å¦ã³åˆã‚ã®é ƒã«æ¬²ã—ã‹ã£ãŸã€Œã¨ã‚Šã‚ãˆãšã“ã‚Œã ã‘è¦šãˆãŸã‚‰ãªã‚“ã¨ã‹ãªã‚‹MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãƒªã‚¹ãƒˆã€ã¨ã„ã†ã‚‚ã®ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã‹ã‚‰MySQLã‚’ã‚¤ãƒã‹ã‚‰å¦ã³ãŸã„ã¨ã„ã†äººãŒå‚è€ƒã«ãªã‚Œã°ã“ã‚Œå¹¸ã„ã€‚
ducky19999 2014/07/16
MySQL
ãƒªãƒ³ã‚¯
ãµã¤ã†ã®Webé–‹ç™ºè€…ã®ãŸã‚ã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
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.
ducky19999 2014/07/12
slide

mysql
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
ducky19999 2012/07/25
MySQL
ãƒªãƒ³ã‚¯
http://www.2ch-search.net/blog/3
ducky19999 2012/06/27
MySQL

Tips
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã® MySQL ã§100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹æ™‚ã«è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚
MySQL ã®å‹‰å¼·ã‚’ã›ãšã«ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ç‰ã§ SQL ã‚’æ›¸ã‹ãšã« Web ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿æ•°ã‚‚2ä¸‡ä»¶ç¨‹åº¦ã§ã—ãŸã®ã§ã€ãã“ã¾ã§å›°ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›ž100ä¸‡å¼±ã®å•†å“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†æ©Ÿä¼šãŒã§ããŸã®ã§ã€MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ç™ºè¡Œã™ã‚‹ SQL ã«ã¤ã„ã¦è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ MySQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã®ã«è¡Œã£ãŸå¯¾ç–ãªã©å‹‰å¼·ã—ãŸã‚‚ã®ã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã—ãŸã€‚ æ¡ä»¶å¼ã§æ¯”è¼ƒã™ã‚‹ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦é«˜é€ŸåŒ– å•†å“ã‚³ãƒ¼ãƒ‰ã§å˜åœ¨ã—ãªã„å•†å“ã‚’è¦‹ã¤ã‘ã¦ã€å•†å“ã‚’DBã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†å‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€4ä¸‡ä»¶è¶…ãˆãŸã“ã‚ã‹ã‚‰å‡¦ç†ã«2ç§’ä»¥ä¸Šã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã™ã€‚12ä¸‡ä»¶è¶…ãˆãŸé ƒã«ã¯10ç§’ç¨‹åº¦ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€å•†å“ã‚³ãƒ¼ãƒ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦ã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§0.2ç§’ã«çŸç¸®ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ MySQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚‚ä»¥ä¸‹ã®ã‚ˆ
ducky19999 2011/07/23
MySQL
ãƒªãƒ³ã‚¯
DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
ducky19999 2011/07/22
mysql

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸