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

papiro id:papiro

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

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

ä»Šã“ãçŸ¥ã‚ŠãŸã„ã€2å¤§OSSãƒ†ã‚™ãƒ¼ã‚¿ãƒ˜ã‚™ãƒ¼ã‚¹ã®MySQLã¨PostgreSQLã®é•ã„ã«ã¤ã„ã¦è©±ã‚’ã—ã¦ããŸ - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
åŽ»å¹´æ›¸ã„ãŸSoftwareDesignã‚’é¡Œæã«ãŠè©±ã—ã¦ãã ã•ã„ï¼ã£ã¦è¨€ã‚ã‚ŒãŸã®ã§è©±ã—ã¦ãã¾ã—ãŸã€‚ ä¸‹ã®ç‰¹é›†è¨˜äº‹ã¯ï¼‘å¹´çµŒã£ãŸä»Šã‚‚ç¾å½¹ã§èªã‚ã‚‹å†…å®¹ãªã®ã§èˆˆå‘³ãŒã‚ã‚‹äººã¯ãœã²èªã‚“ã§ã¿ã¦ãã ã•ã„ã€‚ ã¾ãŸRDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã„ã†é€£è¼‰ã‚’ã—ã¦ã„ã¾ã™ã®ã§ã“ã¡ã‚‰ã‚‚ã‚ã‚ã›ã¦ã”ç¢ºèªãã ã•ã„ã£ï¼ gihyo.jp ãã—ã¦å½“æ—¥ã®è³‡æ–™ã¯ã“ã¡ã‚‰ã§ã™ã€‚ SoftwareDesignã«ã—ã£ã‹ã‚Šã¨MySQLã¨PostgreSQLã®é•ã„ã«ã¤ã„ã¦ã¯è§¦ã‚Œã¦ã„ã‚‹ã®ã§ãã“ã§ã¯è§¦ã‚Œã¦ã„ãªã„ã€ãƒãƒžã‚Šã©ã“ã‚ã‚„åˆã‚ã¦ä¸¡æ–¹ã®DBã‚’çŸ¥ã£ãŸã¨è¨€ã†äººå‘ã‘ã®ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã¯éƒ¨åˆ†ã‚’æ”»ã‚ã¾ã—ãŸã€‚ ã¾ãŸDBã ã‘ã®å‹‰å¼·ä¼šã§ã™ã®ã§æ™®æ®µèª¬æ˜Žã™ã‚‹ã‚ˆã†ãªã¨ã“ã‚ã¯çœç•¥ã—ã€ã§ãã‚‹ã ã‘çµŒé¨“è«‡ã‚„ã‚³ã‚¢ã®è©±ã«æ³¨åŠ›ã—ãŸã¤ã‚‚ã‚Šã§ã™ã€‚ ã“ã®ã¸ã‚“ã¯è³‡æ–™ã«å«ã¾ã‚Œã¦å±…ãªã„ã®ã§å½“æ—¥å±…ãŸäººãŸã¡ã ã‘ã®ç‰¹å…¸ã§ã™ãï¼ï¼ ã¨ã„ã†ã“ã¨ã§å®Ÿã¯ä»Šæœˆã¯ç™»å£‡3é€±é€£ç¶šã ã£ãŸã®ã§ã™ãŒä¸€æ®µè½ã—ã¾ã—ãŸã€‚ æ¥é€±ã¯AWS Sum
papiro 2017/05/28
PostgreSQL

MySQL

Slack

OSS
ãƒªãƒ³ã‚¯
PHPerã«çŸ¥ã£ã¦ã»ã—ã„RDBã®äº‹ ãã®3
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹é–¢è¥¿ 2016ã®è³‡æ–™ã§ã™ã€‚ http://conference.kphpug.jp/2016/
papiro 2016/08/14
RDBã„ã¾ã ã«è¨è¨ˆåŠ›ç„¡ã„ã®ã§èªã‚€

RDB

MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã¹ãé …ç›® | Yakst
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒžãƒãƒ¼ã‚¸ãƒ£ã®Morgan Tockeræ°ã«ã‚ˆã‚‹ã€MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‹ã‚‰å¤‰æ›´ã—ãŸæ–¹ãŒã‚ˆã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®è§£èª¬ã€‚ æ•°ã€…ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æ”¹å–„ã«ã‚ˆã£ã¦ã€éŽåŽ»ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨æ¯”ã¹ã¦MySQL 5.6ã§ã¯è¨å®šã—ãªãã¦ã¯ãªã‚‰ãªã„å€¤ãŒã‹ãªã‚Šæ¸›ã£ãŸã€‚ã¨ã¯è¨€ãˆã€å¤‰æ›´ã™ã¹ãã‚‚ã®ã«ã¤ã„ã¦ã“ã“ã§æ›¸ã„ã¦ãŠããŸã„ã€‚ InnoDBã®è¨å®š innodb_buffer_pool_size - ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯128Mã€‚ã“ã‚Œã¯ã€ãƒ¡ãƒ¢ãƒªã«ãƒãƒ¼ãƒ‰ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŸã‚ã«InnoDBãŒã©ã®ãã‚‰ã„ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã‹ã‚’æŒ‡å®šã™ã‚‹ã‚‚ã®ãªã®ã§ã€è¨å®šã™ã¹ãé‡è¦ãªå€¤ã ã€‚MySQLã®å°‚ç”¨ã‚µãƒ¼ãƒãªã‚‰ã€æè¼‰ã•ã‚Œã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®50%ã‹ã‚‰80%ãŒæŽ¨å¥¨ã•ã‚Œã‚‹è¨å®šå€¤ã ã€‚ä¾‹ãˆã°ã€64GBã®RAMã‚’æè¼‰ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒãªã‚‰ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯50GBç¨‹åº¦ã«ã™ã¹ãã ã‚ã†ã€‚ innodb_log_file_size -
papiro 2015/09/20
MySQLãªã©ã®RDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚ˆãåˆ†ã‹ã£ã¦ãªã„ã®ã§ã‚ã‚ŠãŒãŸã„ã€‚

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

MySQL

è¨å®š

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQL 5.7ã®ç½ ãŒã‚ãªãŸã‚’ç‹™ã£ã¦ã„ã‚‹
2015/08/22 YAPC::Asia Tokyo 2015 Lightning Talk 2016/01/13 update about default_password_lifetime will be 0
papiro 2015/08/23
ãªã‚“ã‹è‰²ã€…ã¨å±é™ºã™ãã‚‹ãƒ»ãƒ»ãƒ»

MySQL

database

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

MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL ã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰‹ã£å–ã‚Šæ—©ãæŒ¿å…¥ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
papiro 2015/07/06
MySQL
ãƒªãƒ³ã‚¯
MySQLã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ã¦ã¿ã‚‹ - yk5656 diary (æ—§)
MySQLã§å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ã¦ã¿ã‚‹ ã®ç¶šã MySQLã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ã¦ã¿ã‚‹ã€‚ ä»Šå›žä½¿ç”¨ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ« ã‚µãƒ³ãƒ—ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒ1000ä¸‡ä»¶å…¥ã£ãŸçŠ¶æ…‹ã€‚ mysql> show create table sample; +--------+---------------------------------------------------+ | Table | Create Table | +--------+---------------------------------------------------+ | sample | CREATE TABLE `sample` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `point` int(11) NOT NULL, `
papiro 2015/07/06
MySQL

DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã§æœˆåˆ¥ã€æ—¥åˆ¥ã€æ™‚é–“ã€æ›œæ—¥åˆ¥ã«ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’é›†è¨ˆã™ã‚‹æ–¹æ³• - ãŠãŠã‚‰ã‹ã«ã„ã“ã†
ä¼šå“¡ç™»éŒ²æ•°ãªã©ã‚’èª¿ã¹ã‚‹ã¨ãã«ã€æœˆåˆ¥ã€æ—¥åˆ¥ã€æ™‚é–“ã€æ›œæ—¥åˆ¥ã®ç™»éŒ²è€…æ•°ã‚’èª¿ã¹ãŸã„ã£ã¦ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆãã€‚ ãã“ã§ä»Šå›žã¯ã€MySQLã§datetimeåž‹ã®ã‚«ãƒ©ãƒ (ä»Šå›žã¯ã€Œregist_timeã€ã¨ã—ã¦ã„ã¾ã™)ã‚’ä½¿ã£ã¦æœˆæ¯Žã€æ—¥æ¯Žã€æ™‚é–“ã€æ›œæ—¥æ¯Žã«ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’é›†è¨ˆã‚’ã™ã‚‹SQLã®ç´¹ä»‹ã§ã™ã€‚ â– æœˆæ¯Ž SELECT DATE_FORMAT(regist_time, '%Y-%m') as regist_time, COUNT(*) as count FROM users GROUP BY DATE_FORMAT(regist_time, '%Y%m'); â– æ—¥æ¯Ž SELECT DATE_FORMAT(regist_time, '%Y-%m-%d') as regist_time, COUNT(*) as count FROM users GROUP BY DATE_FORMAT(regist_time, '%Y
papiro 2015/04/27
GROUP BYã«æ–‡å—åˆ—æŒ‡å®šã—ã¦é›†è¨ˆã€‚ã‚·ã‚§ãƒ«èŠ¸ã‚‚ä¼¼ãŸç™ºæƒ³ã€‚

MySQL

é›†è¨ˆ
ãƒªãƒ³ã‚¯
é›†è¨ˆã¯RDBã°ã‹ã‚Šã«é ‘å¼µã‚‰ã›ã‚‹ã®ã‚’ã‚„ã‚ã‚‹ã¨å¹¸ã›ã«ãªã‚Œã‚‹ã€‚ - Qiita
ã¯ã˜ã‚ã« å„ç¨®ã®DBä¸ã®é›†è¨ˆä½œæ¥ã‚’è¡Œã†ã«ã‚ãŸã£ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã‚’ã©ã†ã—ã¦ã‚‚æ‰±ã‚ãªã‘ã‚Œã°ãªã‚‰ãªã„å ´åˆã¯ã€SQLã®ã¿ã§å®Œçµã•ã›ãªã„ã“ã¨ã‚’æ¤œè¨Žã—ãªã‘ã‚Œã°ã€ã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã‚’å¤§é‡ã«æ¶ˆè²»ã—ãŸæŒ™å¥ã€ä½•æ™‚ã¾ã§çµŒã£ã¦ã‚‚ä½œæ¥ãŒå®Œäº†ã—ãªã„ã¨ã„ã†ã“ã¨ãŒæœ‰ã‚Šã¾ã™ã€‚ SQLæ“ä½œã ã‘ã«é ¼ã‚‰ãªã„ã“ã¨ã‚’æ¤œè¨Žã—ãŸã„é›†è¨ˆä¾‹ explainã™ã‚‹ã“ã¨ã§å¤§ä½“ã®å‚¾å‘ã¯ã‚ã‹ã‚Šã¾ã™ãŒã€ãŠãŠã‚ˆãä»¥ä¸‹ã®ã‚ˆã†ãªè¦ç´ ã‚’å«ã‚€é›†è¨ˆãŒå¯¾è±¡ã¨ãªã‚Šã¾ã™ã€‚ å¯¾è±¡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå·¨å¤§ã§ã‚ã‚‹ï¼ˆæ•°ç™¾ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šï¼‰ DBã®ä½™å‰°ãƒªã‚½ãƒ¼ã‚¹ã«ã‚‚ã¨ã‚‚ã¨ä½™è£•ãŒç„¡ã„ indexã®ãµã‚‰ã‚Œã¦ã„ãªã„é …ç›®ã§é›†è¨ˆ/joinã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ joinå¯¾è±¡ã®é …ç›®ãŒã‚„ã‘ã«å¤šã„ not in å·¨å¤§ãªã‚µãƒ–ã‚¯ã‚¨ãƒª is null group by like etc... ã§ã¯ã©ã†ã™ã‚‹ã‹ï¼Ÿ é›†è¨ˆå¯¾è±¡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸€æ—¦ãƒ•ã‚¡ã‚¤ãƒ«ã«åãå‡ºã—ãŸä¸Šã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹ã®å‡¦ç†ã‚’ã—ã¦ã—ã¾ã„ã¾ã—ã‚‡ã†ã€‚ å®Ÿè·µä¾‹1
papiro 2015/04/27
ã“ã‚Œã‚’çªãè©°ã‚ãŸã®ãŒã‚·ã‚§ãƒ«èŠ¸ã€ãƒ¦ãƒ‹ã‚±ãƒ¼ã‚¸ã€‚

MySQL

shell

ShellScript
ãƒªãƒ³ã‚¯
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ã®ã¨ãã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ
papiro 2015/03/09
æ¿éŸ³åŠæ¿éŸ³åŒä¸€è¦–ã¨ã‹ãƒ»ãƒ»

MySQL

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

Rails
ãƒªãƒ³ã‚¯
ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã ã‘ã§MySQLã‹ã‚‰MongoDBã¸ã®ç§»è¡Œã—ã¡ã‚ƒã† - 256bitã®æ®ºäººãƒ¡ãƒ‹ãƒ¥ãƒ¼
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ã€MySQL Casual Advent Calendar 23æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ ã©ã†ã‚‚ã©ã†ã‚‚ä¹™ã‚«ãƒ¬ãƒ¼æ§˜ã§ã™ã€‚æ¡‘é‡Žã§ã™ã€‚ ãŠé…’ãŒå…¥ã£ã¦ã‚‹ã¨ã‚ã‘ã‚ã‹ã‚“ãªã„ã“ã¨ã‚’ã„ã†ã“ã¨ãŒãŠãŠã„ã‚“ã§ã™ãŒï¼ˆã”ã‚ã‚“ãªã•ã„ï¼‰ ã•ã¦ãƒ–ãƒã‚°æ›¸ã“ã†ã¨æ€ã£ã¦ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®ãƒšãƒ¼ã‚¸è¦‹ãªãŠã—ãŸã‚‰ãªã‚“ã‹æ›¸ã„ã¦ã‚ã‚‹ã‚“ã§ã™ã‚ˆãã€‚ MySQLã ã£ã¤ã£ã¦ã‚“ã ã‚ã€‚ ã¨ã„ã†ã“ã¨ã§ä½•æ›¸ã“ã†ã‹ãªã¨æ€ã£ã¦ãŸã‚“ã§ã™ãŒã€ãƒã‚¿è¨˜äº‹ã¨ã—ã¦ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã ã‘ã§MySQLã‹ã‚‰Mongo DBã¸ã®ç§»è¡Œã—ã¡ã‚ƒã†ã®ã‚’ã‚„ã‚ã†ã‹ã¨æ€ã„ã¾ã™ã€‚ èª°å¾—ãªã®ã‹ã¨ã„ã†ã“ã¨ã§ã‚ã‚Œã°ä¿ºå¾—ã§ã™(âˆ—áµ’Ì¶Ì¶Ì·Ì€Ï‰Ë‚Ì¶Ìâˆ—)à©â‚Žâ‚ŽÌŠâ‚Šâ™¡ï½³ï½¹ï¾„ï¾šï½¨! ã¨è¨€ã†ã‹ãªã‚“ã‹æ€’ã‚‰ã‚Œãã†ã€ã€ã€ã”ã‚ã‚“ãªã•ã„ã”ã‚ã‚“ãªã•ã„ãƒã‚¿ãŒæ€ã„ã¤ã‹ãªã‹ã£ãŸã‚“ã§ã™ãƒ›ãƒ³ãƒˆã§ã™m(_ _)m ã¡ã‚…ãƒ¼ã‚ã‘ã§ãƒ†ã‚¹ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ä½œã£ã¦ã¿ã‚‹ã€‚ ã¾ãšã¯ç§»è¡Œå…ƒã®MySQLã«ãƒ†ãƒ¼ãƒ–ãƒ«ä½œã£ã¦ã¿ã¾ã—ã‚‡ã€‚ é©å½“ã«ã€‚ mysql
papiro 2014/12/24
ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã§ã‚·ã‚§ãƒ«èŠ¸å‡ºæ¥ãã†

MySQL

NoSQL

MongoDB

shell

ShellScript
ãƒªãƒ³ã‚¯
[MySQL]ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€œãƒã‚°å‡ºåŠ›ã€EXPLAINã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€œ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
papiro 2014/12/12
ã‚¯ã‚¨ãƒªãƒã‚°ã®å‡ºã—æ–¹ã€‚ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã£ã¦ï¼Ÿ

MySQL

è¨å®š

ãƒã‚°
ãƒªãƒ³ã‚¯
[MySQL] å…ˆé ãŒ â€œtest_â€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã«ã¯æ¨©é™ã‚’è§£æ”¾ | ãã‚Œãªã‚Šãƒ–ãƒã‚°
Ubuntu-12.10 ã® aptitude ã§ MySQL-5.5 ã‚’å…¥ã‚Œã¾ã—ãŸã€‚ ãã‚Œã‚’ä½¿ã£ã¦ã€Django ã®ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã„ãŸã‚‰ãƒ»ãƒ»ãƒ»ãŠã‹ã—ã„ï¼ MySQLãƒ¦ãƒ¼ã‚¶ã® foouser ã«ã¯ã€foodb ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã—ã‹æ¨©é™ã‚’ä»˜ã‘ã¦ã„ãªã„ã®ã« test_foodb ã‚’å‹æ‰‹ã«ä½œã£ã¦ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã„ã‚‹ãƒ»ãƒ»ãƒ»ï¼ï¼Ÿ ãªã‚“ã ã“ã‚Šã‚ƒï¼Ÿ åŽŸå› ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ã€â€test_â€ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã®ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã«å¯¾ã—ã¦ã¯ MySQL å´ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æ¨©é™ã‚’å…¨é–‹ã«ã—ã¦ã„ã¾ã—ãŸ mysql> select * from mysql.db; (..ä»–ã®è¡Œã¯ç•¥..) *************************** 2. row *************************** Host: % Db: test\_% User: Select_priv: Y Insert_priv: Y Upd
papiro 2014/08/14
test_ã§å§‹ã¾ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã¯ä½œã£ã¡ã‚ƒã„ã‹ã‚“ãƒ»ãƒ»

MySQL
ãƒªãƒ³ã‚¯
Rails3 + ActiveRecord ã§æ£ã—ãtimezoneã‚’è¨å®šã™ã‚‹ - Future Journal
ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®I18Nå¯¾å¿œã‚’ã™ã‚‹ä¸ã§å‡ºã¦ãã‚‹ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³å•é¡Œã€‚ä»Šå›žã¯Rails3ç’°å¢ƒã§ ActiveRecordã®Timezoneã®è¨å®šã‚’ã©ã®ã‚ˆã†ã«ã™ã¹ãã‹ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ photo credit: Myxi via photo pin cc Timezoneã®å•é¡Œã¯OSã€DBã€Frameworkã¨ã„ã‚ã„ã‚çµ¡ã¿ã†ã‚‹ã®ã§ã€ä¸€ã¤ä¸€ã¤è¡ŒããŸã„ã¨æ€ã„ã¾ã™ã€‚ OSã®Timezone Amazon EC2ãªã©ã ã£ãŸã‚‰ãã‚Œãžã‚Œã®åœ°åŸŸã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã§é‹ç”¨ã—ã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ã‚‚ ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ãŒã€JSTï¼ˆæ—¥æœ¬æ¨™æº–æ™‚ï¼‰ã§é‹ç”¨ã—ã¦ã„ã‚‹ã¨ã“ã‚ãŒå¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ $ date Tue Jul 3 12:54:53 JST 2012 $ ls -l /etc/localtime lrwxrwxrwx 1 root root 30 Jul 3 10:51 /etc/localtime -> /usr/sh
papiro 2014/06/20
db

MySQL

ActiveRecord

è¨å®š

Rails
ãƒªãƒ³ã‚¯
ã„ãžã‚‹ã§é›‘è¨˜annex mysqlã®timestampåž‹ã‚’ä½¿ã£ã¦æ›´æ–°æ—¥æ™‚ã¨ç”Ÿæˆæ—¥æ™‚ã®ä¸¡æ–¹ã‚’è¨˜éŒ²ã™ã‚‹
mysqlã®timestampåž‹ã¯ä»–ã®ä¸»ãªRDBMSã¨é•ã£ã¦å‹æ‰‹ã«å€¤ã‚’æ ¼ç´ã™ã‚‹ã‚‰ã—ã„ã€‚ ã‚ã¨ã€DEFAULTå€¤ã«now()ã®ã‚ˆã†ãªé–¢æ•°ã‚’ä½¿ã†ã“ã¨ã‚‚å‡ºæ¥ãªã„ã£ã½ã„ã€‚ ãã®ä»£ã‚ã‚Šã«ã¨ã„ã£ã¦ã¯ã‚¢ãƒ¬ã ã‘ã©ON UPDATE CURRENT_TIMESTAMPã®ã‚ˆã†ãªå±žæ€§ãŒä½¿ãˆã‚‹ã®ã§ã€æ›´æ–°æ—¥æ™‚ã®ã‚ˆã†ãªå€¤ã‚’ä¿æŒã™ã‚‹ã«ã¯ã‚‚ã£ã¦ã“ã„ã®åž‹ã¿ãŸã„ã€‚ ã§ã€ä»Šå›žã‚„ã‚ŠãŸã‹ã£ãŸã®ã¯ã²ã¨ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã« modified_date ã¨ create_date ã®ã‚ˆã†ãª2ã¤ã®timestampåž‹ã®ã‚«ãƒ©ãƒ ã‚’ä½œã£ã¦ã€æ›´æ–°æ—¥æ™‚ã¨ãƒ‡ãƒ¼ã‚¿ã‚’æœ€åˆã«ä½œã£ãŸæ—¥ã®ä¸¡æ–¹ã‚’ç®¡ç†ã™ã‚‹æ–¹æ³•ã€‚ ã‚¹ã‚ãƒ¼ãƒžã¯ã“ã‚“ãªæ„Ÿã˜ã§å®šç¾©ã—ã¦ãŠã CREATE TABLE `test` ( id int(4) unsigned NOT NULL auto_increment, name varchar(10) , . . ç•¥ . . modified_date tim
papiro 2014/05/20
MySQL

CURRENT_TIMESTAMP
ãƒªãƒ³ã‚¯
â˜…MySQL5.5ã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - yuhei.kagaya
CentOS5.6ã«ã¦ã€‚ã‚½ãƒ¼ã‚¹ã‹ã‚‰å…¥ã‚Œã¦ã¿ãŸãƒ¡ãƒ¢ã€‚ æŠ˜è§’ãªã®ã§ã„ã£ãŸã‚“ã‚ãƒ¬ã‚¤ã«ã—ã¦ã¿ãŸ yumã§MySQLã‚’å…¥ã‚Œã¦ã‚‹å ´åˆ yum remove mysql-server mysql rpmã§MySQLã‚’å…¥ã‚Œã¦ã‚‹å ´åˆ rpm -qa | grep -i mysql | xargs rpm -e mysqlã®ãƒ¦ãƒ¼ã‚¶ã®ç™»éŒ² groupadd mysql useradd -m mysql -g mysql -d /usr/local/mysql/data passwd mysql ã‚½ãƒ¼ã‚¹ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãã¦å±•é–‹ cd /usr/local/src wget http://www-jp.mysql.com/get/Downloads/MySQL-5.5/MySQL-5.5.18-1.rhel5.src.rpm/from/http://ftp.iij.ad.jp/pub/db/mysql/ rpm
papiro 2013/02/21
configureã˜ã‚ƒãªãã¦cmakeã‚‰ã—ã„

MySQL
ãƒªãƒ³ã‚¯
ï¼ ITï¼šAmazon RDSã®ä½¿ã„æ–¹ï¼ˆ1/3ï¼‰
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBã€ŒMySQLã€ã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§åˆ©ç”¨ã—ã€ãƒ‹ãƒ¼ã‚ºã«å¿œã˜ã¦ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’å¢—ã‚„ã›ã‚‹ã€ŒAmazon RDSã€ï¼ˆAmazon Relational Database Serviceï¼‰ã€‚ãã®ç‰¹å¾´ã¨ä½¿ã„æ–¹ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ TISæ ªå¼ä¼šç¤¾ SonicGarden ä¸¦æ²³ ç¥è²´ 2010/4/12 Amazon Web Servicesã®ãƒ‹ãƒ¥ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ å¤§æ‰‹ãƒ‘ãƒ–ãƒªãƒƒã‚¯ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã®1ã¤ã§ã‚ã‚‹Amazon Web Servicesã¯ã€2009å¹´ä»¥é™ã‚‚ç¶šã€…ã¨æ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚„æ©Ÿèƒ½ã‚’ç™ºè¡¨ã—ã€æ—¥æœ¬ã§ã‚‚ã¾ã™ã¾ã™æ³¨ç›®ã‚’é›†ã‚ã‚‹å˜åœ¨ã¨ãªã£ã¦ã„ã¾ã™ã€‚ Amazon Web Servicesã¯ã€ä»®æƒ³ã‚µãƒ¼ãƒã‚’1æ™‚é–“å˜ä½ã®å¾“é‡åˆ¶ã§åˆ©ç”¨ã§ãã‚‹Amazon EC2ã‚„ã€1GBå˜ä½ã‹ã‚‰ã®å¾“é‡åˆ¶ãªãŒã‚‰ã€é«˜ä¿¡é ¼æ€§ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒåˆ©ç”¨ã§ãã‚‹Amazon S3ãªã©ã‚’ä¸å¿ƒã¨ã—ãŸã€IaaSï¼ˆInfrastru
papiro 2010/04/13
ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§MySQL

MySQL

ã‚¯ãƒ©ã‚¦ãƒ‰

amazon
ãƒªãƒ³ã‚¯
http://blog.suz-lab.com/2010/01/macportsmysql.html
papiro 2010/03/03
MySQLã®æœ€ä½Žé™ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ³•

mac

MySQL

MacPorts
ãƒªãƒ³ã‚¯
inasphere blog | MySQLã®æ–‡å—åŒ–ã‘å¯¾ç–
PHP-MySQLé–“ã§ã®æ–‡å—åŒ–ã‘ã«ã¤ã„ã¦ã€‚ å•é¡Œç‚¹ PHPã€MySQLã¨ã‚‚ã«UTF-8ã§æ§‹æˆã—ã¦ã„ã‚‹ã®ã«ã€DBã¨ã®ãƒ‡ãƒ¼ã‚¿å—ã‘æ¸¡ã—ã§æ–‡å—åŒ–ã‘ãŒèµ·ã“ã‚‹ï¼ˆãŠãã‚‰ãä»–ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã§ã‚‚åŒæ§˜ï¼‰ã€‚ å¯¾å¿œç– ä¸‹è¨˜ã©ã¡ã‚‰ã‹ã®å¯¾å¿œã‚’å®Ÿæ–½ã™ã‚‹ã€‚ ãã®1 DBæŽ¥ç¶šã”ã¨ã«ã€å‡¦ç†å®Ÿè¡Œå‰ã«ã€ŒSET NAMES UTF8ã€ã¨ã„ã†ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã™ã‚‹ã€‚ ãã®2 my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã®è¨å®šã‚’ä¸‹è¨˜ã®ã‚ˆã†ã«å¤‰æ›´ã™ã‚‹ã€‚ #character-set-server = latin1 // å…ƒã€…ã‚ã‚‹ã‚‚ã®ã‚’ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆ #collation-server = latin1_general_ci // åŒ ä¸Š default-character-set=utf8 // æ–°ã—ãè¿½åŠ ã™ã‚‹ skip-character-set-client-handshake // åŒ ä¸Š å®Ÿè¡Œæ™‚ã®ç’°å¢ƒ Windows 2000 XAMPP 1.6.1 PH
papiro 2010/01/29
ã ã‹ã‚‰MySQLã¯ä½•ã¨ãªãã„ã‚„ãƒ¼ã‚“ï¼ï¼Ÿ

MySQL
ãƒªãƒ³ã‚¯
åƒ•ã¯æœ¨ã«ãªã‚ŠãŸã„ã€‚ã€‚ã€‚ : gem install mysql ã«ãƒãƒžã‚‹ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
Rails2.2.2ã§ã¯ã€mysqlãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ä½¿ãˆãšã€ gem install mysql ã‚’ã‚„ã‚Œã¨è¨€ã‚ã‚Œã¾ã—ãŸã€‚ ã‚„ã£ã¦ã¿ã‚‹ã€‚ $ sudo gem install mysql Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension. /usr/local/bin/ruby extconf.rb install mysql checking for mysql_query() in -lmysqlclient... no checking for main() in -lm... yes checking for mysql_query() in -lmysqlclient...
papiro 2009/11/30
MySQLã®å ´æ‰€ã‚’æŒ‡å®šã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

MySQL

Ruby

Rails
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸