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

ghostbass id:ghostbass

programmingã¨MySQLã«é–¢ã™ã‚‹ghostbassã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

Auroraãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã«ä¼´ã„æ”¹ã‚ã¦MySQL5.7ã®æŠ¼ã•ãˆã‚‹ã¹ããƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦å‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã¾ã—ãŸï¼ - ANDPAD Tech Blog
ã“ã‚“ã«ã¡ã¯ï¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç¦é–“ï¼ˆfkm_yï¼‰ã§ã™ã€‚ å¼Šç¤¾ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŠ€è¡“é¡§å•ã‚’ã—ã¦é ‚ã„ã¦ã„ã‚‹ä¸‰è°·ï¼ˆmita2ï¼‰ã•ã‚“ã«ã€MySQL5.7ã®è¿½åŠ æ©Ÿèƒ½ã«ã¤ã„ã¦ã®é–‹ç™ºéƒ¨å‘ã‘å‹‰å¼·ä¼šã‚’å®Ÿæ–½ã„ãŸã ãã¾ã—ãŸã®ã§ãã®ãƒ¬ãƒãƒ¼ãƒˆã‚’ãŠä¼ãˆã—ã¾ã™ã€‚ é–‹å‚¬èƒŒæ™¯ å¼Šç¤¾ã§ã¯ä¸‰è°·ã•ã‚“ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‹‰å¼·ä¼šã‚’å®šæœŸçš„ã«é–‹å‚¬ã—ã¦ãŠã‚Šã€3æœˆã«ã‚‚MySQLãƒãƒƒã‚¯ã®åŸºç¤Žç·¨ã®å‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã¾ã—ãŸã€‚ ANDPADã§ã¯ã€ä»Šå¹´ã®4æœˆã«Aurora MySQLã‚’Ver.1ï¼ˆMySQL5.6äº’æ›ï¼‰ã‹ã‚‰Ver.2ï¼ˆ5.7äº’æ›ï¼‰ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã‚’å®Ÿæ–½ã—ã¾ã—ãŸã€‚ tech.andpad.co.jp Aurora MySQL Ver.2 ã«ãªã‚‹ã“ã¨ã§ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã€MySQL5.7ã§è¿½åŠ ã•ã‚ŒãŸæ©Ÿèƒ½ã«ã¤ã„ã¦é–‹ç™ºè€…ã«çŸ¥ã£ã¦ã‚‚ã‚‰ã„ã€æ™®æ®µã®é–‹ç™ºã«å–ã‚Šå…¥ã‚Œã¦ã‚‚ã‚‰ã†ãŸã‚ã«MySQL5.7ã®å‹‰å¼·ä¼šã‚’é–‹å‚¬ã™ã‚‹ã“ã¨ã¨ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯è¿½åŠ ã•ã‚ŒãŸ150ä»¥ä¸Šã®æ–°æ©Ÿèƒ½
ghostbass 2022/08/03
ãˆã€ä»Š ï¼•ï¼Žï¼— ã«æ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ï¼Ÿ8ç³»åˆ—ã§ãªãï¼Ÿï¼Ÿ

mysql

programming
ãƒªãƒ³ã‚¯
CentOS7ã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦åˆæœŸè¨å®šã™ã‚‹ã¾ã§ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
ghostbass 2021/09/09
programming

mysql

database
ãƒªãƒ³ã‚¯
PHP5.6ã¨MySQL8ã§ã€ŒServer sent charset (255) unknown to the client.ã€ãƒãƒžã£ãŸâ€¦
å®Ÿè¨¼ç’°å¢ƒ Windows10 Apache2.4.10 PHP5.6.4 MySQL8.0.15 (æ—§)MySQL5.6.43 PHPã¯mod_phpã§Apacheã¨é€£æºã€MySQLã«ã¯PDOã§æŽ¥ç¶šã—ã¦ã„ã¾ã™ã€‚ çµŒç·¯ é–‹ç™ºç’°å¢ƒã§ä½¿ç”¨ã—ã¦ã„ãŸphp5.6.4ï¼‹MySQL5.6.43ã‚’MySQL8ã«ç§»è¡Œã—ã‚ˆã†ã¨ã—ã¾ã—ãŸã€‚ MySQL8.0.15ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã€æ—¢å˜ã®MySQL5.6.4ã‹ã‚‰å¿…è¦ãªDBã ã‘dumpã—ã¦ç§»è¡Œã™ã‚‹äºˆå®šã€‚ MySQL8.0.15ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«php5.6.4ã‹ã‚‰æŽ¥ç¶šç¢ºèªã‚’ã™ã‚‹æ™‚ã«ãƒãƒžã‚Šã¾ã—ãŸã€‚ ãƒ†ã‚¹ãƒˆDB MySQL8.0.15ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ä¸‹è¨˜DBã¨TABLEã‚’ä½œæˆã€‚ ãƒ†ã‚¹ãƒˆç”¨ã®DB mysql> CREATE DATABASE test; ãƒ†ã‚¹ãƒˆç”¨ã®TABLE mysql> CREATE TABLE sample(id int,name text); ãƒ†
ghostbass 2021/09/07
å•é¡Œãªã®ã¯ php5.6ã®ã»ã†ã§ã—ã‚‡â€¦

programming

php

mysql
ãƒªãƒ³ã‚¯
MySQL :: Hash join in MySQL 8
The build phase The literature usually divides hash join in two pha ses; the build phase and the probe phase. In the build phase, the server builds an in-memory hash table where rows from one of the inputs are stored, using the join attribute(s) as the hash table key. This input is also known as the build input, and let us assume that â€˜countriesâ€™ is designated as the build input. Ideally, the serve
ghostbass 2019/11/23
ã“ã‚Œã¯ï¼

programming

mysql

rdb
ãƒªãƒ³ã‚¯
ã€MySQLã€‘å¤–éƒ¨ã‚ãƒ¼ã®åˆ¶ç´„ã‚’ç„¡è¦–ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ã™ã‚‹ | ãƒŸãƒ¼ãƒŸãƒ«ã®æ³¥æ³‰
foreign key ãŒå¤šã™ãŽã¦ãƒ†ãƒ¼ãƒ–ãƒ«ãŒæ¶ˆã›ãªã„ã‚ˆãƒžãƒžãƒ³â€¦ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã®é¬¼åã€‚ERDï¼ˆERå›³ï¼‰ã‚’æ›¸ãã¨ãã«ã‚ã‹ã‚Šã‚„ã™ããªã‚‹ã®ã§ã¤ã‘ã‚‹äººãŒå¤šã„ã ã‚ã†ã€‚ ç¢ºã‹ã«ã“ã‚ŒãŒã‚ã‚‹ã“ã¨ã§åˆ¶ç´„ãŒå®ˆã‚‰ã‚Œã¦å¥å…¨ãªæ§‹é€ ã«ãªã‚‹ã¨ã„ã†ã®ã¯åˆ†ã‹ã‚‹ã‚“ã ã‘ã©ã€ãã®é–¢ä¿‚æ€§ã‚’ï¼ˆã‚ãŸã‚Šã¾ãˆã ã‘ã©ï¼‰å¸¸ã«ä¿ã¤ãŸã‚ã¨ã«ã‹ããƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã—è¾›ããªã‚‹ã€‚ ç‰¹ã«é–‹ç™ºåˆæœŸã«ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã‚’é »ç¹ã«ä½œã‚Šæ›¿ãˆã‚‹ã¨ããªã©ã¯drop tableã‚‚ã¾ã¾ãªã‚‰ãªã„çŠ¶æ…‹ã«é™¥ã£ã¦ã€ã¤ã„drop databaseã—ã¦ã—ã¾ã†ã“ã¨ã‚‚ã—ã°ã—ã°ã ã‚ã†ã€‚ â€¦ã ã‚ˆãï¼Ÿ ã¨ã„ã†ã‚ã‘ã§ã€MySQLã§åˆ¶ç´„ã‚’ç„¡è¦–ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ã§ãã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ¡ãƒ¢ã€‚ å¯¾å¿œæ–¹æ³• MySQLã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’åˆ©ç”¨ã™ã‚‹ã¨åˆ¶å¾¡ã‚’ONãƒ»OFFã§ãã‚‹ã€‚ å¤–éƒ¨ã‚ãƒ¼ãŠã‚ˆã³ãã®ä»–ã®MySQLã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ ä½¿ã†ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯ä»¥ä¸‹ã€‚ FOREIGN_KEY_CHECKS åˆ¶ç´„ã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨ãã¯ S
ghostbass 2019/09/20
å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ç„¡è¦–ã—ã¦drop table

mysql

database

programming
ãƒªãƒ³ã‚¯
å…è´¹é€å½©é‡‘å®˜æ–¹ç½‘ç«™-å…è´¹é«˜æ¸…å®Œæ•´ç‰ˆ
ghostbass 2019/05/10
å˜ç´”ã«æš—é»™ã®ã‚ãƒ£ã‚¹ãƒˆãŒç™ºç”Ÿã—ã¦ã„ã‚‹ã ã‘ãªã®ã§ã¯

programming

sql

mysql
ãƒªãƒ³ã‚¯
Oracleã‹ã‚‰MySQLã¸ç§»è¡Œã™ã‚‹ãŸã‚ã®æŠ€è¡“çš„ãªè¦ç´ ã¨å…·ä½“çš„ãªæ–¹æ³•ã‚’ã¾ã¨ã‚ãŸç„¡æ–™ã®é›»åæ›¸ç±ï¼šäººæ°—é€£è¼‰ã¾ã¨ã‚èªã¿ï¼ ï¼ IT eBookï¼ˆ42ï¼‰ - ï¼ IT
2016å¹´1æœˆã€Oracle Databaseã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä½“ç³»ãŒå¤‰æ›´ã•ã‚Œã€æœ€ã‚‚å®‰ä¾¡ã ã£ãŸä¸å°è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®ã€ŒOracle Database Standard Edition Oneï¼ˆä»¥ä¸‹ã€SE1ï¼‰ã€ãŒå»ƒæ¢ã€‚å¾“æ¥ã®ã€ŒOracle Database Standard Editionï¼ˆä»¥ä¸‹ã€SEï¼‰ã€ã®å†…å®¹ã‚’å¤‰æ›´ã—ãŸæ–°ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§ã‚ã‚‹ã€ŒOracle Database Standard Edition 2ï¼ˆSE2ï¼‰ã€ã«ä¸€æœ¬åŒ–ã•ã‚Œã¾ã—ãŸã€‚ ä¾‹ãˆã°ã€ç´„70ä¸‡å††ã ã£ãŸSE1ã®æœ€ä½Žä¾¡æ ¼ã¯ã€SE2ã§ã¯210ä¸‡å††ã‹ã‚‰ã¨é«˜é¡ã«ãªã‚Šã¾ã™ï¼ˆ2016å¹´11æœˆç¾åœ¨ã€ä»¥ä¸‹åŒï¼‰ã€‚ã¾ãŸã€SEã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã—ã¦ã‚‚ã€ç‰©ç†ã‚µãƒ¼ãƒå˜ä½ã®æœ€å¤§æè¼‰CPUã‚½ã‚±ãƒƒãƒˆæ•°ãŒã€SEã®4ã‚½ã‚±ãƒƒãƒˆã‹ã‚‰ã€SE2ã§ã¯2ã‚½ã‚±ãƒƒãƒˆã«æ¸›ã‚‹ã“ã¨ã‹ã‚‰ã€ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒã«ã‚ˆã£ã¦ã¯ã€ã‚ˆã‚Šä¸Šä½ã§570ä¸‡å††ã‹ã‚‰ã¨ãªã‚‹ã€ŒOracle Database Enterprise Ed
ghostbass 2018/07/25
æ—¢ã«æŒ‡æ‘˜å¤šæ•°ã ã‘ã©ç§»è¡Œå…ˆã¯postgresã˜ã‚ƒãªã„ã®â€¦

Oracle

MySQL

programming
ãƒªãƒ³ã‚¯
MySQL 8.0ç™»å ´ï¼ç«‹ã¡æ¢ã¾ã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„é€²åŒ–ã¯ã“ã‚Œã‹ã‚‰ã‚‚ç¶šãã€‚
ã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯ã¯ã„ã‹ãŒãŠéŽã”ã—ã•ã‚ŒãŸã ã‚ã†ã‹ã€‚ä»Šå¹´ã¯å¤©æ°—ã‚‚è‰¯ãã€è¡Œæ¥½æ—¥å’ŒãŒç¶šã„ãŸã‚ˆã†ã«æ€ã†ã€‚ ã•ã¦ã€å…ˆæ—¥MySQL 8.0ãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚å°‘ã—æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã£ãŸãŒã€ä»Šå›žã¯MySQL 8.0ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰å¯èƒ½ã ã€‚ ã²ã¨ã¤å‰ã®æ£å¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL 5.7ã ã£ãŸã®ã ãŒã€MySQL 8.0ã¯éžå¸¸ã«å¤§ããªãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒå«ã¾ã‚Œã¦ãŠã‚Šã€5.xå°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æ¨ã¦åŽ»ã‚ã†ã¨ã„ã†è©±ãŒã‚ã£ãŸã€‚ãã“ã§ã€æ¬¡ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯æœ€åˆã®æ¡ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã«ãªã£ãŸã®ã ãŒã€MySQL 6.0ã¯éŽåŽ»ã«æ—¢ã«å˜åœ¨ã—ã€è²·åŽãªã©ã®é¨’ãŽã§é–‹ç™ºãŒé “æŒ«ã—ã¦ã—ã¾ã£ãŸçµŒç·¯ãŒã‚ã‚‹ã€‚7.xã¯MySQL NDB Clusterã¨è¢«ã£ã¦ã„ã‚‹ã€‚ã¨ã„ã†ã‚ã‘ã§ã€5.7ã®7ã®éƒ¨åˆ†ã®æ¬¡ã¨ã„ã†æ„å‘³åˆã„ã‚‚ã‚ã£ã¦ã€8.0ã¨ã„ã†ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’å¼•ã£ã•ã’ã€æº€ã‚’æŒã—ã¦ã®ç™»å ´ã¨ãªã£ãŸã€‚ãã®
ghostbass 2018/05/07
å†å¸°çš„CTEãŒä½¿ãˆã‚‹ã£ã¦ã“ã¨ã¯å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã‚‚ç”¨æ¸ˆã¿ã«ãªã‚‹ã£ã¦ã“ã¨ã‹

MySQL

programming

database
ãƒªãƒ³ã‚¯
mysql_*ãŒéžæŽ¨å¥¨ã«ãªã‚Šã€ãã®å¾Œå»ƒæ¢ã•ã‚ŒãŸç†ç”±ã¨ã¯ï¼Ÿ
SQL(Structured Query Language)ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ (RDBMS)ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨€èªžã§ã™ã€‚å¤§ããåˆ†ã‘ã¦ã€ãƒ‡ãƒ¼ã‚¿å®šç¾©è¨€èªž(DDL)ã€ãƒ‡ãƒ¼ã‚¿æ“ä½œè¨€èªž(DML)ã€ãƒ‡ãƒ¼ã‚¿åˆ¶å¾¡è¨€èªž(DCL)ã®3ã¤ã§æ§‹æˆã•ã‚Œã¦ãŠã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒ ä¸Šã§SQLæ–‡ã‚’ç”Ÿæˆã—ã¦ã€RDBMSã«å‘½ä»¤ã‚’å‡ºã—ã€RDBã«å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã§ãã¾ã™ã€‚ã¾ãŸã€æ ¼ç´ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’å¼•ãå‡ºã™ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
ghostbass 2016/12/30
ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®å•é¡Œã¯ãªã„ã®ï¼Ÿ

programming

php

mysql
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Amazon Auroraç™ºè¡¨ã€‚MySQLäº’æ›ã§æ€§èƒ½5å€ã€å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒç‰ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚AWS re:Invent 2014
ï¼»é€Ÿå ±ï¼½Amazon Auroraç™ºè¡¨ã€‚MySQLäº’æ›ã§æ€§èƒ½5å€ã€å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒç‰ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚AWS re:Invent 2014 Amazonã‚¯ãƒ©ã‚¦ãƒ‰ã‚’æä¾›ã™ã‚‹Amazon Web Servicesã¯ã€åŒç¤¾ã®å¹´æ¬¡ã‚¤ãƒ™ãƒ³ãƒˆã€ŒAWS re:Inventã€ã‚’ç±³ãƒ©ã‚¹ãƒ™ã‚¬ã‚¹ã§é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ åˆæ—¥ã®åŸºèª¿è¬›æ¼”ã§ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºITã«ãŠã‘ã‚‹ãƒ‹ãƒ¥ãƒ¼ãƒŽãƒ¼ãƒžãƒ«ï¼ˆæ–°ã—ã„æ™®é€šï¼‰ã§ã‚ã‚‹ã“ã¨ã‚’å¼·èª¿ã€‚æ–°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã€MySQLäº’æ›ã§ã‚ã‚Šã¤ã¤å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸¦ã®æ€§èƒ½ã¨æ©Ÿèƒ½ã‚’å®Ÿç¾ã—ãŸã¨ã„ã†ã€ŒAmazon Auroraã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ MySQLã¨ãƒ•ãƒ«äº’æ›ã§ã‚ã‚ŠãªãŒã‚‰5å€ã®æ€§èƒ½ Amazon Web Servicesã‚·ãƒ‹ã‚¢ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆ Andy Jassyæ°ã€‚ æ—¢å˜ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯é«˜ä¾¡ã§ã€ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªã§
ghostbass 2014/11/13
5å€ä»¥ä¸Šã®ã‚¨ãƒãƒ«ã‚®ãƒ¼ã‚²ã‚¤ãƒ³ãŒ

programming

mysql
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2012/08/21/20120818oracle-makes-more-moves-to-kill-open-source-mysql/
ghostbass 2012/08/21
ãã†ã„ã†ç¥žè¨—ãŒç™ºã›ã‚‰ã‚ŒãŸã€ã¨ã€‚ã“ã‚Œã‹ã‚‰ã¯è–å‡¦å¥³ã«ç¥ˆã‚Šã‚’ã•ã•ã’ã‚‹ã¹ã—

programming

database

oracle

mysql

opensource
ãƒªãƒ³ã‚¯
MySQLã«ãŠã‘ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã®å‚¾å‘ã¨å¯¾ç–
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã§æœ€ã‚‚ã‚ˆãä½¿ã‚ã‚Œã‚‹æ©Ÿèƒ½ã®ã²ã¨ã¤ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯åŸºæœ¬çš„ã«éžåŒæœŸã§ãƒ‡ãƒ¼ã‚¿ã®è¤‡è£½ã‚’è¡Œã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã ãŒã€éžåŒæœŸæ•…ã«ã©ã†ã—ã¦ã‚‚é€ƒã‚Œã‚‰ã‚Œãªã„å•é¡ŒãŒã‚ã‚‹ã€‚ãã®ã²ã¨ã¤ãŒä»Šå›žã®ãƒ†ãƒ¼ãƒžã€é…å»¶ã§ã‚ã‚‹ã€‚ã¨ã„ã†ã¨ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã™ãã«é…å»¶ãŒç”Ÿã˜ã¦ã—ã¾ã†ã‚ˆã†ã«æ„Ÿã˜ã¦ã—ã¾ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãã®ã‚ˆã†ãªã“ã¨ã¯ãªã„ã€‚ã»ã¨ã‚“ã©ã®å ´åˆã¯å³åº§ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ›´æ–°ãŒè¡Œã‚ã‚Œã‚‹ã€‚ ãªãœé…å»¶ã¯ç™ºç”Ÿã™ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«é…å»¶ãŒèµ·ãã¦ã„ã‚‹ã“ã¨ã‚’èª¿ã¹ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚’æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯è§£èª¬ã—ãŸã„ã€‚ã†ã¾ãé…å»¶ã¨ä»˜ãåˆã£ã¦ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚ˆã‚Šå¿«é©ã«é‹ç”¨ã—ã¦ã‚‚ã‚‰ãˆã‚Œã°ã¨æ€ã†ã€‚ ãã‚‚ãã‚‚é…å»¶ã¨ã¯ä½•ã‹MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžåŒæœŸã§è¡Œã‚ã‚Œã‚‹ã€‚ã“ã‚Œã¯æº–åŒæœŸã§ã‚‚åŒã˜ã§ã‚ã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãŠã„ã¦æ›´æ–°ãŒèµ·ãã‚‹ã®ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚ˆã‚Šã‚‚ä¸€çž¬é…ã‚Œã¦ã—ã¾ã†ã€‚ã“ã‚Œã¯éžåŒæœŸã§ã‚ã‚‹ãŒæ•…ã«é€ƒã‚Œ
ghostbass 2011/12/14
database

mysql

programming
ãƒªãƒ³ã‚¯
ã¼ããŒPDOã‚’æŽ¡ç”¨ã—ãªã‹ã£ãŸã‚ã‘(Shift_JISã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³)
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´7æœˆ1æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚ è¿½è¨˜(2011/06/19) ã“ã“ã«æ¥ã¦æ€¥ã«ãƒ–ã‚¯ãƒžãŒè¿½åŠ ã•ã‚Œã¯ã˜ã‚ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰çŠ¶æ³ãŒæ”¹å–„ã—ã¦ã„ã¾ã™ã€‚PHP5.3.6(2011/03/17)ã«ã¦ã€PDOã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ç‰ˆã§ã€UNIXç‰ˆã®PHPã§ã¯è§£æ±ºã—ã¾ã—ãŸãŒã€Win
ghostbass 2010/07/01
security

mysql

php

programming
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 24.2 MySQL Connector/NET
Connector/NET ã¯ã€å®‰å…¨ã§æ€§èƒ½ã®é«˜ã„ MySQL ã¨ã®ãƒ‡ãƒ¼ã‚¿ã®æŽ¥ç¶šæ€§ã‚’å¿…è¦ã¨ã™ã‚‹ .NET ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã€é–‹ç™ºè€…ãŒå®¹æ˜“ã«ä½œæˆã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã‚‚ã®ã§ã™ã€‚å¿…è¦ãª ADO.NET ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å®Ÿè£…ã—ã€ADO.NET å¯¾å¿œãƒ„ãƒ¼ãƒ«ã‚’çµ±åˆã—ã¾ã™ã€‚é–‹ç™ºè€…ã¯ã€å¥½ããª .NET è¨€èªžã‚’ä½¿ç”¨ã—ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚Connector/NET ã¯ 100% ç´”ç²‹ãª C# ã§æ›¸ã‹ã‚Œã€å®Œå…¨ã«ç®¡ç†ã•ã‚ŒãŸ ADO.NET ãƒ‰ãƒ©ã‚¤ãƒã§ã™ã€‚ Connector/NET ã¯æ¬¡ã®æ©Ÿèƒ½ã«å®Œå…¨å¯¾å¿œã—ã¦ã„ã¾ã™ : MySQL 5.0 ã®æ©Ÿèƒ½ ( ã‚¹ãƒˆã‚¢ãƒ‰ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ç‰ ) MySQL 4.1 ã®æ©Ÿèƒ½ ( ã‚µãƒ¼ãƒå´ã®ãƒ—ãƒªãƒšã‚¢ãƒ‰ ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã€Unicode ã€å…±æœ‰ãƒ¡ãƒ¢ãƒªã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã€ç‰ ) è¡Œã‚„ æœ€å¤§ 2 ã‚®ã‚¬ãƒã‚¤ãƒˆã®BLOB ã®é€ä¿¡ã¨å—ä¿¡ã‚’è¡Œã†ãŸã‚ã®å¤§åž‹ãƒ‘ã‚±ãƒƒãƒˆã®ã‚µãƒãƒ¼ãƒˆ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³
ghostbass 2010/05/31
mysql

C#

programming
ãƒªãƒ³ã‚¯
Ruby on Rails + MySQL ã§å…¨æ–‡æ¤œç´¢ - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ Ruby on Rails ã¨ MySQL ã‚’ä½¿ã£ã¦æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã†æ–¹æ³•ã‚’è¨˜è¿°ã™ã‚‹ã€‚Ruby on Rails ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 2.0.2ã€MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 5.0.67ã€Tritonn ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.0.12ã€Hyper Estraier ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.4.10 ã‚’ä½¿ç”¨ã—ãŸã€‚ã‚µãƒ³ãƒ—ãƒ«ã®æ–‡ç« ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ã€ã‚ã‚‰ã‚†ã‚‹æ—¥æœ¬äººã«ã¨ã£ã¦æ¥µã‚ã¦èº«è¿‘ãªè‘—ä½œæ¨©åˆ‡ã‚Œæ–‡ç« ã§ã‚ã‚‹ã€Žãƒ‰ã‚°ãƒ©ãƒ»ãƒžã‚°ãƒ©ã€ã¨ã€Žé»’æ»é¤¨æ®ºäººäº‹ä»¶ã€ã‚’åˆ©ç”¨ã—ãŸã€‚å‡¦ç†ã®ãŸã‚ã«æ•´å½¢ã—ãŸãƒ‡ãƒ¼ã‚¿ã¯æœ¬ã‚¨ãƒ³ãƒˆãƒªã«æ·»ä»˜ã—ã¦ãŠãã€‚ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚³ãƒ¼ãƒ‰ã§ã¯ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é™¤ãã§ãã‚‹ã ã‘ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å–ã‚‹ã‚ˆã†ã«ã—ã€ãã®çµæžœã¯æœ¬ã‚¨ãƒ³ãƒˆãƒªã®æœ€å¾Œã«è¨˜è¼‰ã™ã‚‹ã€‚ ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ Rails ã§ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ will_paginate ã¨ã„ã† plugin ã¯ ActiveRecord ã«æ¨™æº–ã§ã¤
ghostbass 2009/02/03
programming

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™º

ruby on rails

mysql
ãƒªãƒ³ã‚¯
1