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

Miyakey id:Miyakey

MySQLã«é–¢ã™ã‚‹Miyakeyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

MEAN(MongoDB, Express, AngularJS, Node.js)ã‚¹ã‚¿ãƒƒã‚¯ãŒå„ªã‚Œã¦ã„ã‚‹ç†ç”± - Mozilla Open Web Day in Tokyoã‚’çµ‚ãˆã¦ - albatrosary's blog
MEANã¨ã¯ã€LAMP(Linux, Apache, MySQL, PHP)ã«å¤‰ã‚ã‚‹æŠ€è¡“ã¨ã—ã¦ã˜ã‚ã˜ã‚ã¨æ³¨ç›®ã•ã‚Œã¯ã˜ã‚ã¦ã„ã‚‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã™ã€‚ã“ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£MEAN(Mongo DB, Express, AngularJS, Node.js)ã¯ã€ã‚·ãƒ³ãƒ—ãƒ«ã§ã‹ã¤å¼·åŠ›ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã€ç¾åœ¨ã®Javaã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã¨ã¯ä¸€ç·šã‚’ç”»ã™ã¨ã“ã‚ã§ã™ã€‚HTML5é–‹ç™ºã«ã¨ã£ã¦Javaã®å½¹å‰²ãŒæ®†ã©ãªããªã‚‹ã¨ã„ã†ã®ã‚‚æ³¨ç›®ã™ã¹ãç‚¹ã ã¨è€ƒãˆã¾ã™ã€‚MEANã§ä¸€èˆ¬çš„ã«è¨€ã‚ã‚Œã‚‹æ³¨ç›®ã™ã¹ãäº‹é …ã¯æ¬¡ã®ã¨ã“ã‚ã§ã™ï¼š JavaScriptãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ã§ã‚ã‚‹ ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨ã—ã¦ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è‡³ã¾ã§JSON ãã—ã¦ã€ã“ã®è¨˜äº‹ã‚’æ›¸ã“ã†ã¨æ€ã£ãŸãã£ã‹ã‘ã§ã™ãŒã€2014/10/5(æ—¥)Â Mozilla Open Web Day in Tokyo | Mozilla JapanÂ ã§ã®MEANè§£èª¬å±•ç¤ºã§ã€æ§˜
Miyakey 2014/10/06
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

angularjs

node.js

*ã‚ã¨ã§èªã‚€

*ã‚ã¨ã§è©¦ã™

*è³‡æ–™

MySQL
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
çµ±è¨ˆæƒ…å ±ã®ãƒªã‚»ãƒƒãƒˆã«ã‚ˆã‚‹autovacuumã¸ã®å½±éŸ¿ã«ã¤ã„ã¦ï¼ˆç¬¬39å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ ç™ºè¡¨è³‡æ–™ï¼‰
Miyakey 2014/03/02
MySQL

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

*è³‡æ–™

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
MySQLã‚µãƒ¼ãƒãƒ¼ã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ãã‚‹å‰ã«
ã“ã®ãƒ“ãƒƒã‚°ã‚¦ã‚§ãƒ¼ãƒ–ã«ã„ã¤ä¹—ã‚‹ã®ï¼ ä»Šã§ã—ã‚‡ï¼ å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… Linuxã‚µãƒ¼ãƒãŒãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡ä¸è¶³ã«ãªã£ãŸï¼ä½•ã‹æ¶ˆã•ãã°ï¼ã£ã¦ãªã£ãŸæ™‚ã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ tagomorisã®ãƒ¡ãƒ¢ç½®ãå ´ Linuxã‚µãƒ¼ãƒã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ããŸï¼ã£ã¦ã¨ãã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ iã‚’gã«å¤‰ãˆã‚‹ã¨orangeã«ãªã‚‹ã“ã¨ã«æ°—ã¥ã„ãŸoranieã®æ—¥è¨˜ Cassandraã‚µãƒ¼ãƒã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ããŸï¼ã£ã¦ã¨ãã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ â€¦ã¨æ€ã£ã¦ãŸã‚‰MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚‚æ—¢ã«å‡ºãŸã€‚ã‘ã©ã‚ã’ãªã„ã€‚ã‹ã¶ã‚‰ãªã„ã‚ˆã†ã«æ›¸ãã¾ã™ã€‚ã¨ã„ã†ã‹ã‚¿ã‚¤ãƒˆãƒ«ã¯ã‹ã¶ã‚‰ãªã„ã‚ˆã†ã«å¤‰ãˆã¾ã—ãŸ(ã¤Ð´ï½€) Y-Ken Studio MySQLã‚µãƒ¼ãƒã®ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡æ¸›å°‘ã‚¢ãƒ©ãƒ¼ãƒˆãŒé£›ã‚“ã§ããŸï¼ã£ã¦ã¨ãã«ã©ã†å¯¾å‡¦ã™ã‚‹ã‹ ã•ã¦ã¾ãšã€MySQLã§å‹æ‰‹ã«(?)å¢—ãˆã‚‹ã‚‚ã®ã¨ã„ãˆã°ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«(.MYD, .MYI, .ibd, ibda
Miyakey 2013/07/30
MySQL

ã‚µãƒ¼ãƒ

*è³‡æ–™
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ç…©é›‘ãªä½œæ¥ã‚’è‡ªå‹•åŒ–ã™ã‚‹ã€ŒERMasterã€
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
Miyakey 2013/04/27
eclipse

MySQL

é–‹ç™º

*è³‡æ–™

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
WordPressã‚’100å€é€Ÿãã™ã‚‹ï¼ MySQLã®èª¿æ•´ã‚„nginx proxy cache | KRAY Inc
[è¿½è¨˜ï¼‘] æœ€å¾Œã§èª¬æ˜Žã—ã¦ã„ã‚‹proxy cacheã®è¨å®šã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚ [è¿½è¨˜ï¼’] nginx proxy cacheã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„å ´åˆã®å‡¦ç†ã‚’å¤‰æ›´ã—ã¾ã—ãŸã€‚ [è¿½è¨˜ï¼“] ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚„æºå¸¯ã§é–²è¦§ã—ãŸæ™‚ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„è¨å®šã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« å¤§ã’ã•ãªé¡Œåã§ã™ãŒã€ä»Šå›žã¯WordPresså˜ä½“ã‚’é€Ÿãã™ã‚‹ã®ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„Webã‚µãƒ¼ãƒãªã©ã®èª¿æ•´ã€ã¾ãŸnginxã®proxy cacheæ©Ÿèƒ½ã‚’ä½¿ã£ã¦é€Ÿãã™ã‚‹è©±ã«ãªã‚Šã¾ã™ã€‚ ã‚µã‚¤ãƒˆã®æ§‹æˆã«ã‚ˆã£ã¦ã¯ã€proxy cacheã¯ä½¿ãˆãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ä½¿ã‚ãªãã¦ã‚‚5å€ç¨‹åº¦é€Ÿãã™ã‚‹ã“ã¨ã¯ã§ãã¾ã—ãŸã®ã§ã€å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žè¡Œã†ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ä¸€è¦§ DBã‚’æœ€é©åŒ–ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å°Žå…¥ã™ã‚‹ APCã‚’å°Žå…¥ã—ã¦PHPã‚’é€Ÿãã™ã‚‹ MySQLã‚’é€Ÿãã™ã‚‹ é‡ã„WordPressãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å¤–ã™ nginx+FastCGIã«ã™ã‚‹ W
Miyakey 2013/04/25
wordpress

nginx

MySQL

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

*è³‡æ–™
ãƒªãƒ³ã‚¯
Zabbixã®DBã‚’MySQLã®åœ§ç¸®æ©Ÿèƒ½(Barracuda)ã§å°ã•ãã—ã¦ã¿ãŸã€‚
@qryuu ãŸã‚“ã«æ•™ã‚ã£ãŸã‚„ã‚Šæ–¹ã«ã¦å®Ÿéš›è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ â– my.cnfã®æ›¸ãæ›ãˆ ãƒ†ãƒ¼ãƒ–ãƒ«åœ§ç¸®ã‚’ä»Šå¾Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã«ã™ã‚‹å ´åˆã¯ã€ä»¥ä¸‹ã®2è¡Œã‚’my.cnfã«è¿½è¨˜ã™ã‚‹ã€‚ innodb_file_format = Barracuda innodb_file_per_table = 1 ã¡ãªã¿ã«åœ§ç¸®å‰ã®çŠ¶æ³ã¯ã“ã¡ã‚‰ã€‚ç·è¨ˆ 388MB ä½¿ã£ã¦ã„ã‚‹ã€‚ [root@FLAMINGO]/var/lib/mysql/zabbix# ls -l | sort -k5 åˆè¨ˆ 396432 -rw-rw----. 1 mysql mysql 65 4æœˆ 3 14:21 2013 db.opt -rw-rw----. 1 mysql mysql 8602 4æœˆ 3 14:21 2013 valuemaps.frm -rw-rw----. 1 mysql mysql 8622 4æœˆ 3 14:22 2013 glob
Miyakey 2013/04/22
zabbix

MySQL

*è³‡æ–™
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãŒé€²åŒ–ã—ã¦ã„ãŸï¼ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6 ãŒå¾…æœ›ã®GAã¨ãªã‚Šã¾ã—ãŸï¼æ—©é€Ÿã€ã‚ã„ã¦ã„ãŸã‚µãƒ¼ãƒã«å…¥ã‚Œã¦ã¿ã¾ã—ãŸã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®è¨å®šãŒã€è‡³ã‚Œã‚Šå°½ãã›ã‚Šã«ãªã£ã¦ã„ã¦ã€ã³ã£ãã‚Šï¼*1 ã¡ã‚‡ã£ã¨å¼•ç”¨ãŒé•·ããªã‚‹ã‘ã©ã€æ•¢ãˆã¦é€”ä¸ã®ã‚«ãƒƒãƒˆã¨ã‹ã‚’ã—ãªã„ã§è¼‰ã›ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ã€linux(CentOS) ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã™ã€‚ ã¾ãšã€å–å¾—ã—ãŸrpmã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # rpm -ivh MySQL-server-5.6.10-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]ã™ã‚‹ã¨ã€æ•°åˆ†é–“ã‹ã‘ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–‡å—åˆ—ãŒã¤ã‚‰ã¤ã‚‰ã¨è¡¨ç¤ºã•ã‚Œã¦ãã¾ã™ï¼ˆã“ã“ã§ã¯ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã„
Miyakey 2013/02/07
mysql56

MySQL5.6

MySQL

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

*è³‡æ–™
ãƒªãƒ³ã‚¯
MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ« my.cnf ã‚’githubã«ã¦å…¬é–‹ã—ã¾ã—ãŸ & ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã®ç´¹ä»‹ - blog.nomadscafe.jp
YAPC::Asiaã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§äºˆå‘Šã—ã¦ã„ãŸé€šã‚Šã€å®Ÿéš›ã«å¼Šç¤¾ã®ã„ãã¤ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã£ã¦ã„ã‚‹ my.cnf ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ github: https://github.com/kazeburo/mysetup/tree/master/mysql ä»Šå›žã€å…¬é–‹ã—ãŸç†ç”±ã¯MySQl Beginners Talksã®ç™ºè¡¨ã®ä¸ã§ã‚‚è§¦ã‚Œã¦ã„ã‚‹é€šã‚Šã§ã™ã€‚MySQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ä¸ã«å«ã¾ã‚Œã‚‹ã‚µãƒ³ãƒ—ãƒ«ã®my.cnfãŒæœ€è¿‘ã®ã‚µãƒ¼ãƒãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„é‹ç”¨ã«åˆã‚ãªããªã£ã¦æ¥ã¦ã„ã‚‹ã¨ã„ã†çŠ¶æ³ã§ã€è‡ªåˆ†ã®è¨å®šã«ã‚¤ãƒžã‚¤ãƒè‡ªä¿¡ãŒæŒã¦ã¦ã„ãªã„äººã¯å°‘ãªããªã„ã¯ãšã€‚ãã“ã§å„ç¤¾ç§˜ä¼ã®ã‚¿ãƒ¬çš„ãª my.cnf ã‚’Open & Shareã™ã‚‹ã“ã¨ã§ã€ãƒ¢ãƒ€ãƒ³ãªmy.cnfã‚’ä½œã‚Šä¸Šã’ã‚‹äº‹ãŒã§ãã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨ã„ã†è€ƒãˆã®ä¸‹ã€ä»Šå›ž github ã«ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã¯4ã¤ã‚ã‚Šã€ãã‚Œãžã‚Œ MySQL 4.0ã€5.1ã€5.5ã€ãã—ã¦ãƒ†ã‚¹ãƒˆä¸
Miyakey 2012/10/05
MySQL

ã‚µãƒ¼ãƒ

MySQL

github

server

è¨å®š

*è³‡æ–™

*é‡è¦

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
CodeIgniter STEP2, get data from mysql
codeigniter_testãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼†ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆ databaseæŽ¥ç¶šç”¨ã®configè¨å®š config/database.php $db['default'] = array( 'dsn' => '', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'codeigniter_test', 'dbdriver' => 'mysqli', 'dbprefix' => '', 'pconnect' => TRUE, 'db_debug' => TRUE, 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '
Miyakey 2012/08/06
model

codeigniter

MySQL
ãƒªãƒ³ã‚¯
MySQLæ—¥æœ¬èªžåˆ©ç”¨å¾¹åº•å…¥é–€
20210216 AWS Black Belt Online Seminar AWS Database Migration Service
Miyakey 2012/05/31
MySQL

*ã‚ã¨ã§èªã‚€

*è³‡æ–™

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
Free Dynamic DNS(DDNS) by POP3,IMAP4,FTP,HTTP-BASIC for Home Server, VPS | MyDNS.JP
myhome.munetika.mydns.jp is not accessible... Sorry. I do not know why this site is not working. If you know Administrator of this site, please contact directly. You may be able to see it in Google cache. For administrator ... MyDNS.JP did not received IP address from you over One week. Please check your notify system. If you restart notification of IP address, MyDNS.JP will apply your IP address
Miyakey 2011/08/26
*è³‡æ–™

MySQL

CentOS
ãƒªãƒ³ã‚¯
1