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

kikunantoka id:kikunantoka

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

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

BASEã®ãƒ¡ã‚¤ãƒ³DBã‚’Aurora(MySQL)ã«ç§»è¡Œã—ã¾ã—ãŸ - BASEãƒ—ãƒãƒ€ã‚¯ãƒˆãƒãƒ¼ãƒ ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€BASEãƒ©ãƒ³ãƒ‹ãƒ³ã‚°éƒ¨ã§10kmãƒžãƒ©ã‚½ãƒ³ãªã©ã«å‚åŠ ã—ã€3kgã»ã©ä½“é‡ãŒè½ã¡ãŸSRE Groupã«æ‰€å±žã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ¤æœ¨ã§ã™ã€‚ãŠã‹ã’ã§ç”˜ã„ã‚‚ã®ãŒç¾Žå‘³ã—ã„ã§ã™ã€‚ã¡ãªã¿ã«æ¬¡ã¯ãƒãƒ¼ãƒ•ãƒžãƒ©ã‚½ãƒ³ã«æŒ‘æˆ¦ã§ã™ï¼ ä»Šå›žã¯ä¼šç¤¾ã®ãƒ–ãƒã‚°ãªã©ã‚’æ›¸ã„ã¦ã¿ã¾ã™ã€‚å¼Šç¤¾ã§ã¯ã€ãƒãƒƒãƒˆã‚·ãƒ§ãƒƒãƒ—ä½œæˆã‚µãƒ¼ãƒ“ã‚¹ã€ŒBASEã€ãŠã‚ˆã³ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚¢ãƒ—ãƒªã€ŒBASEã€ã‚’é‹å–¶ã—ã¦ã„ã¾ã™ãŒã€11æœˆã«ãƒ¡ã‚¤ãƒ³DBã‚’RDS for MySQL5.6ã‹ã‚‰Aurora(MySQL5.6ã‚³ãƒ³ãƒ‘ãƒãƒ–ãƒ«)ã«å¤‰æ›´ã—ã¾ã—ãŸã®ã§ã€ãã¡ã‚‰ã®è©±ã‚’æ›¸ã‹ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ä½•æ•…Auroraï¼Ÿ ã¾ãšã€å¼Šç¤¾ã§AWSã‚’ãƒ¡ã‚¤ãƒ³ã«ä½¿ã£ã¦ã„ãŸã¨ã„ã†èƒŒæ™¯ãŒã‚ã‚Šã¾ã™ã€‚å…¥ç¤¾ã—ãŸéš›ã«ã¯RDS for MySQLã‚’ä½¿ç”¨ã—ã¦ãŠã‚Šã€CTOã®è—¤å·ã‚‚ã€ŒAWSã‚’ä½¿ã†ãªã‚‰Auroraã«ã—ãŸã„ã€ã¨ã„ã†è¦æœ›ã‚’æŒã£ã¦ã„ã¾ã—ãŸã€‚ç§è‡ªèº«ã€AWSã‚’ãƒ¡ã‚¤ãƒ³ã«ä½¿ã„ç¶šã‘ã‚‹ã¤ã‚‚ã‚Šã§ã‚ã‚Œã°Aurora
kikunantoka 2018/11/28
å¼Šç¤¾ã§ã‚‚ç§»è¡ŒãŒé€²ã‚“ã§ãŠã‚Šã¾ã™ï¼ˆå…ˆã€…é€±å®Ÿæ–½ã—ãŸï¼‰

mysql

é–‹ç™º

aws

Aurora

RDS

ã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã«ä¼´ã†ãƒãƒƒã‚¯ã®å°è©±
4. ãƒãƒƒã‚¯ãŠã•ã‚‰ã„ï¼ˆç°¡æ˜“ï¼‰ â€¢ å…±æœ‰ãƒãƒƒã‚¯ï¼ˆLOCK_Sï¼‰ å…±æœ‰ãƒãƒƒã‚¯åŒå£«ã¯äº’ã„ã«ãƒ–ãƒãƒƒã‚¯ã—ãªã„ ä¾‹ï¼šSELECT LOCK IN SHARE MODE â€¢ æŽ’ä»–ãƒãƒƒã‚¯ï¼ˆLOCK_Xï¼‰ ä½•ã‚‚å—ã‘ä»˜ã‘ãªã„ãžã€æŽ’ä»– ä¾‹ï¼šINSERT(æˆåŠŸ), UPDATE, DELETE, SELECT FOR UPDATE X S X Conï¬‚ict Conï¬‚ict S Conï¬‚ict Compatible 4 å¤§ããåˆ†ã‘ã¦ãƒãƒƒã‚¯ã¯2ç¨®é¡ž 5. 5 > BEGIN; > SELECT * FROM player WHERE id = 100 LOCK IN SHARE MODE; > BEGIN; ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³A ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³B å…±æœ‰ã¨æŽ’ä»–é †ã«ã‚ˆã‚‹ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ä¾‹ 6. 6 > BEGIN; > SELECT * FROM player WHERE id = 100 LOCK IN SHARE MO
kikunantoka 2018/10/10
mysql

ãƒãƒƒã‚¯
ãƒªãƒ³ã‚¯
Macã®ãƒãƒ¼ã‚«ãƒ«ã®MySQLã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã‚’AWSã®RDSã®MySQLã®è¨å®šã¨åˆã‚ã›ã‚‹ - Qiita
mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | JST | | time_zone | SYSTEM | +------------------+--------+ 2 rows in set (0.00 sec)
kikunantoka 2018/04/26
æ›¸ãã¾ã—ãŸ

mysql
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
kikunantoka 2018/02/05
ãªã‚‹ã»ã©ãƒ¼

mysql

FLOAT
ãƒªãƒ³ã‚¯
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 ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã®æ„å‘³ã¯èªã‚“ã§å—ã®ã”ã¨ãã€ã€Œæœ€å¾Œã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ›´æ–°ã•
kikunantoka 2017/02/15
MySQL
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨ã«ã¤ã„ã¦è‰²ã€…
12. ã‚¹ãƒ†ãƒƒãƒ—çš„ãªã‚‚ã® ã‚µã‚¤ã‚º ä½¿ã„ã©ã“ã‚ ã‚³ãƒžãƒ³ãƒ‰ä¾‹ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã§ã‹ã„ å¿…ãšå¿…è¦ tar, rsync, mysqldump, XtraBackup å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— â¼©ã•ã„ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã® é–“éš”ãŒçŸã‘ã‚Œã°è¦ã‚‰ ãªã„ mysqldump(ã‚¹ã‚ãƒ¼ ãƒžã«åˆ¶ç´„) XtraBackup å¢—åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— æ›´æ–°é‡ã«ä¾å˜ ã»ã¼é–“é•ã„ãªãå¿…è¦ cp, rsync, mysqlbinlog 11/58 14. ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é¸æŠžè‚¢ ã‚³ãƒžãƒ³ãƒ‰ ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¢ãƒ—ãƒªå½±éŸ¿ â½…å¼ ã‚µã‚¤ã‚º tar, rsync MyISAM Ã— åœâ½Œã¾ãŸã¯ãƒãƒƒ ã‚¯ ç‰©ç† â¼¤ãã‚ tar, rsync InnoDB Ã— mysqldåœâ½Œ ç‰©ç† â¼¤ãã‚ LVMã‚¹ãƒŠãƒƒãƒ— ã‚·ãƒ§ãƒƒãƒˆ MyISAM InnoDB â–³ æ€§èƒ½åŠ£åŒ–ãŒã²ã© ã„ ç‰©ç† â¼¤ãã‚ mysqldump MyISAM Ã— ãƒãƒƒã‚¯ è«–ç† â¼©ã•ã‚ mysqldum
kikunantoka 2015/03/01
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
Rails3ã® bundle install ã§ mysql.h ãŒè¦‹ã¤ã‹ã‚‰ãªã„ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ - ã˜ã‚‡ã«ãƒ¼ã•ã‚“ã®ã«ã£ã
Rails3ã® bundle install ã§ mysql2 ãŒå…¥ã‚‰ãªã„ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿï¼Ž mysql.h ãŒç„¡ã„ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ï¼Ž $ sudo gem install mysql2 Building native extensions. This could take a while... ERROR: Error installing mysql2: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb install mysql2 checking for rb_thread_blocking_region()... no checking for mysql.h... no checking for mysql/mysql.h... no ----- mysql.h is missing. plea
kikunantoka 2014/07/13
rails

mysql
ãƒªãƒ³ã‚¯
CentOSã®MySQLã‚’5.5ã‹ã‚‰5.6ã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã™ã‚‹
æœ¬ãƒ–ãƒã‚°ã‚’å‹•ä½œã•ã›ã¦ã„ã‚‹ CentOS ã® MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ 5.5 ã‹ã‚‰ 5.6 ã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ã¾ã—ãŸã€‚æ›´æ–°ã«ã‚ãŸã‚Šç¢ºèªã—ãŸã“ã¨ã€å®Ÿè¡Œã—ãŸã‚³ãƒžãƒ³ãƒ‰ã€ã‚¨ãƒ©ãƒ¼ã®å¯¾å¿œãªã©ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ ã“ã‚Œã¾ã§ç¨¼åƒã—ã¦ã„ãŸ MySQL 5.5 ã¯ remi ãƒªãƒã‚¸ãƒˆãƒªã®ã‚‚ã®ã‚’ä½¿ã£ã¦ã„ã¾ã—ãŸãŒã€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã® 5.6 ã¯ MySQL ã®å…¬å¼ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ãŸã€‚ã‚µãƒ³ãƒ—ãƒ«ã® my.cnf ã‚‚ç½®ã„ã¦ãŠãã¾ã—ãŸã®ã§ã€ã¾ã MySQL ã‚’ 5.6 ã«ä¸Šã’ã¦ã„ãªã„æ–¹ã®å‚è€ƒã«ãªã‚Œã°ã€‚ remi ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ MySQL 5.5 ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ãã®è¨˜äº‹ã¯ã“ã¡ã‚‰ã€‚ ãŠåå‰.com VPS ã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—WordPressç”¨ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° å‹•ä½œç¢ºèªç’°å¢ƒ CentOS 6.5 ç›®æ¬¡ MySQL 5.6 å…¬å¼ãƒªãƒã‚¸ãƒˆãƒªã‚’è¿½åŠ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã£ã¦ãŠã MySQL ã‚’
kikunantoka 2014/07/13
mysql
ãƒªãƒ³ã‚¯
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 -
kikunantoka 2014/07/13
mysql
ãƒªãƒ³ã‚¯
Vagrant+VirtualBox+CentOSç’°å¢ƒã§MySQL5.6ãŒèµ·å‹•ã—ãªã„å ´åˆã®å¯¾å‡¦æ³• - æ†‚é¬±ãªä¸–ç•Œã«ãƒã‚³ãƒ‘ãƒ³ãƒï¼
ç™ºç”Ÿã—ãŸç¾è±¡ Vagrant+VirtualBox+CentOSã£ã¦ç’°å¢ƒã«MySQL5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦èµ·å‹•ã—ã‚ˆã†ã¨ã—ãŸã¨ã“ã‚ $ sudo service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] ã¨ã“ã‚“ãªæ„Ÿã˜ã§èµ·å‹•ã§ããªã‹ã£ãŸã®ã§èª¿ã¹ã¦ã¿ãŸã‚ˆã€‚ ã¾ãšã€ãƒã‚°ã®å ´æ‰€ã‚’ç¢ºèªã€‚ $ cat /etc/my.cnf ... [mysqld_safe] log-error=/var/log/mysqld.log /var/log/mysqld.logã«ãƒã‚°ãŒã‚ã‚‹ã‚ˆã†ã ã€‚ ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ç¢ºèª ã¨ã„ã†ã‚ã‘ã§ã€ãƒã‚°ã‹ã‚‰ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’æŽ¢ã—ã¦ã¿ã‚‹ã€‚ $ sudo cat /var/log/mysqld.log ... 2014-03-21 15:21:46 2492 [Note] InnoDB: Ini
kikunantoka 2014/07/13
mysql
ãƒªãƒ³ã‚¯
yumã«ã‚ˆã‚‰ãªã„MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼ˆCentOS 6.4ï¼‰ | æ˜Ÿç©ºã®å¤ªé™½
CentOS 6.4 (x86, 64-bit)ã«ã¯ã€æœ€æ–°ã§ã¯ãªã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ï¼ˆ5.1.69ï¼‰ã®ã‚‚ã®ãŒãƒ¬ãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ãŒã€ã“ã‚Œã‚’é™¤å¤–ã—ã¦æ–°ãŸã«æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ï¼ˆ5.6.13ï¼‰ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã¨ã—ãŸã€‚é€”ä¸ã€é›£æ‰€ãŒï¼“ã¤ã‚ã£ãŸã€‚ å¤§ã¾ã‹ãªæµã‚Œã¯æ¬¡ã®é€šã‚Šã§ã‚ã‚‹ã€‚ 1) yumã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‚ã®ã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« 2) æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« 3) è¨å®šã¨èµ·å‹• ï¼‘ï¼Žyumã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‚ã®ã®ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’è¡Œã†ã€‚ # yum remove mysql mysql-server mysql-devel ï¼’ï¼Žãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‹ã‚‰ã®æ”¹ã‚ã¦ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQL æœ¬å®¶ã‚µã‚¤ãƒˆ http://dev.mysql.com/download ã‚ˆã‚Šæ¬¡ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ Linux â€“ Generic(glib
kikunantoka 2014/07/13
mysql
ãƒªãƒ³ã‚¯
1