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

nohohon_x id:nohohon_x

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

${{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ãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
nohohon_x 2012/03/07
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
CentOSã®P
WordPressã®ç®¡ç†ç”»é¢ã‚’é–‹ã„ãŸã‚‰ WordPress 3.2 ãŒåˆ©ç”¨å¯èƒ½ã§ã™ ! æ›´æ–°ã—ã¦ãã ã•ã„ã€‚ ã¨ã‚ã£ãŸã€‚ã¾ã æ—¥æœ¬èªžç‰ˆãŒå…¬é–‹ã•ã‚Œã¦ãªã„æ§˜ã ã‘ã©ã€ã¡ã‚‡ã£ã¨å•é¡Œã€‚ [blackbirdpie id=â€88387791431544833â€³] CentOS5.5ã«ä»˜å±žã®PHPã‚’æ°—ã«ã›ãšä½¿ã£ã¦ã„ãŸã‘ã©ã€ç´”æ£ã®ãƒ¬ãƒã‚¸ãƒˆãƒªã¯ä»Šã‚‚PHP 5.1.6ã§æ¢ã¾ã£ã¦ã‚‹ã€‚ ã ã‚ã ã“ã„ã¤ã€‚ã¯ã‚„ããªã‚“ã¨ã‹ã—ãªã„ã¨ã€‚ ã¨ã„ã†ã‚ã‘ã§ã‚°ã‚°ã‚ŠãªãŒã‚‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã€‚å®Ÿéš›ã«ã¯CentOS 5.5 ã« PHP 5.3 ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ å‰æº–å‚™ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—&ãƒ‡ãƒ¼ãƒ¢ãƒ³åœæ¢ # mysqldump -u root -p â€“all-databases > dump.sql # /etc/init.d/httpd stop # /etc/init.d/mysqld stop PHPæœ€æ–°ãƒã‚¤ãƒŠãƒªã‚’å…¬é–‹ã—ã¦
nohohon_x 2011/07/11
php

mysql
ãƒªãƒ³ã‚¯
Ruby/MySQL - Ruby
Rubyã§MySQLã‚’ä½¿ç”¨ã™ã‚‹ã«ã¯ã€2ã¤ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒã‚ã‚Šã¾ã™ã€‚ Ruby/MySQL é•·æ‰€ Pure Rubyãªã®ã§ã€ã‚³ãƒ”ãƒ¼ã™ã‚‹ã ã‘ã§ä½¿ç”¨ã§ãã¾ã™ã€‚ çŸæ‰€ MySQL/Rubyã‚ˆã‚Šã‚‚ä½Žé€Ÿã§ã™ã€‚ MySQL/Rubyã§ä½¿ç”¨ã§ãã‚‹æ©Ÿèƒ½ã®ä¸€éƒ¨ãŒä½¿ç”¨ã§ãã¾ã›ã‚“ã€‚ MySQL/Ruby é•·æ‰€ MySQL/Rubyã‚ˆã‚Šã‚‚é«˜é€Ÿã§ã™ã€‚ çŸæ‰€ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«Cã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã¨ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒ¦ãƒ¼ã‚¶ã®æ¨©é™ãŒå¿…è¦ã§ã™ã€‚ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã«äº’æ›æ€§ãŒã‚ã‚Šã¾ã™ã€‚ Ruby/MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’å±•é–‹ã—ã€install.rb ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ # ruby install.rb mysql.rbã‚’æ‰‹å‹•ã§ã‚³ãƒ”ãƒ¼ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ ä½¿ç”¨æ–¹æ³• mysq.rbã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ require 'mysql' ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ #db = Mysql::new("host", "user",
nohohon_x 2008/07/30
ruby

mysql
ãƒªãƒ³ã‚¯
MySQLãƒŽã‚¦ãƒã‚¦
ã„ã‚ã„ã‚ãªæœ¬ã‹ã‚‰ãƒ¡ãƒ¢ã£ã¦ããŸãƒ¡ãƒ¢ã®ãƒ¡ãƒ¢ã€‚å‡ºå…¸ã‚’æ›¸ã„ã¦ãŠãã®ã‚’å¿˜ã‚ŒãŸã€‚æ€ã„å‡ºã—æ¬¡ç¬¬è£œå®Œã™ã‚‹ã‹ã‚‚ã€‚ deleteã®ã‚³ã‚¹ãƒˆã¯é«˜ã„ã®ã§ã€ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã£ã¦updateã™ã¹ã slow query logã«è¦æ³¨æ„ å¤šãã®ã‚¨ãƒ³ãƒˆãƒªã§ã»ã¨ã‚“ã©ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒåŒã˜å€¤ã‚’æŒã¤å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå°ã•ã„ â†’è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå¤§ãã„ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æŒ‡å®šã®é †ç•ªãŒå¤§åˆ‡ã€‚Aã¨Bã¨ã„ã†æŒ‡å®šã®å ´åˆã€Aå˜ç‹¬ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒã‚ã‚‹ã€‚é€†ã¯çœŸã§ãªã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹å ´é¢ã¯ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã‚’å®šæ•°ã¨æ¯”è¼ƒã™ã‚‹ã¨ã (where name = 'hogehoge') ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã§JOINã™ã‚‹ã¨ã (where a.name = b.name) ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã®ç¯„å›²ã‚’æ±‚ã‚ã‚‹ã¨ã (<,>,between) LIKEå¥ãŒæ–‡å—åˆ—ã‹ã‚‰å§‹ã¾ã‚‹ã¨ã (where name like 'hoge%') min(),
nohohon_x 2007/07/12
mysql
ãƒªãƒ³ã‚¯
MySQLï¼‹Apacheï¼‹PHPã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã‚ˆã†ï¼ˆ2/3ï¼‰ â€• ï¼ IT
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®šï¼ˆ2ï¼‰ Apacheã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æ¬¡ã¯ã€Apacheã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã™ã€‚MySQLã¨åŒæ§˜ã«ã€ApacheãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã‹ã©ã†ã‹ã‚’rpmã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã—ã¾ã™ã€‚ # rpm -qa *http* httpd-manual-2.2.3-5 system-config-httpd-1.4.1-1.fc6 httpd-2.2.3-5
nohohon_x 2007/05/17
php

apache

mysql
ãƒªãƒ³ã‚¯
CentOS4.4ã§ã‚µãƒ¼ãƒæ§‹ç¯‰ - Lism.in * blog - nekoya (id:studio-m)
ä¼šç¤¾ã«ç½®ã„ã¦ãŸAOpenã®XCcube PC EZ65ã‚’ã‚µãƒ¼ãƒã«ã—ã‚ˆã†ã¨æŒã£ã¦å¸°ã£ã¦ãã¾ã—ãŸã€‚ã‚‚ã¨ã‚‚ã¨ã†ã‚‹ã•ã„ã®ãŒç†ç”±ã§ãŠè”µå…¥ã‚Šã—ã¦ãŸã‚“ã ã‘ã©ã€ã‚„ã£ã±ã‚Šè‡ªå®…ã§ä½¿ã†ã«ã¯ã†ã‚‹ã•ã„ã€‚ç‰¹ã«å¤œé–“ã¯æ°—ã«ãªã‚Šã¾ã™ã€‚ä¼šç¤¾ã§è²·ã£ãŸDellã®PowerEdge SC430ãŒäºˆæƒ³å¤–ã«é™ã‹ã ã£ãŸã®ã§æƒ¹ã‹ã‚Œã‚‹ãŒã€äºˆç®—ã‚’æ³¨ãŽè¾¼ã¿ãŸããªã„ã®ã§ã€ä½•ã¨ã‹ã“ã„ã¤ã§ã“ãªã™ã“ã¨ã‚’è€ƒãˆã¾ã™ã€‚å«ã¯ç‰¹ã«æ°—ã«ãªã‚‰ã‚“ã‚‰ã—ã„ã®ã§ã€ã²ã¨ã¾ãšå°æ‰€ã«è¨ç½®ã€‚ã¤ã„ã†ã£ã‹ã‚Šæœ¬ä½“ã«è¹´ã‚ŠãŒå…¥ã£ãŸã‚Šã€ã‚±ãƒ¼ãƒ–ãƒ«ã«è¶³ã‚’ã‹ã‘ãŸã‚Šã—ãªã„ã‹ã¯çµŒéŽã‚’è¦‹å®ˆã‚‹å¿…è¦ã‚ã‚Šã§ã™ã€‚LANã‚±ãƒ¼ãƒ–ãƒ«ã¯ã¨ã‚‚ã‹ãã€é›»æºã‚±ãƒ¼ãƒ–ãƒ«ã¯æ–‡å¥ãŒå‡ºã‚‹ã‹ã‚‚ã€‚ã¨ã¯è¨€ãˆã€å°æ‰€ã®é›»æºã‹ã‚‰å–ã‚‹ã¨UPSé€šã›ãªã„ã—ã€ã“ã‚Œã‹ã‚‰ãƒ–ãƒ¬ãƒ¼ã‚«ãƒ¼ã‚‚è½ã¡ã‚„ã™ã„å£ç¯€ãªã®ã§ä½•ã¨ã‹å–ã‚Šå›žã—ã§å·¥å¤«ã—ãŸã„ã¨ã“ã‚ã€‚ ã¡ãªã¿ã«ã€ã¾ã ã‚ã¾ã‚Šå©ã„ã¦ãªã„ã‘ã©SC430ã¯ã‹ãªã‚Šã®å¥½å°è±¡ã§ã™ã€‚PowerEdgeã¨ã„ã†ã¨ã€Œã†ã‚‹ã•ã„ã€ã€Œãƒ€ã‚µã„ã€ã€Œã‘ã©å®‰ã„ã€
nohohon_x 2007/05/17
MySQL

PHP5

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
https://www.kuroduction.com/doc/linux_centos_mysql.shtml
nohohon_x 2007/05/01
mysql
ãƒªãƒ³ã‚¯
mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã€ mysqladmin -u root -p hogehoge ã¨ã—ãŸã‚‰ mysql -u root -p ã¨ã—ã¦ã‚‚mysqlã«æŽ¥ç¶šã§ããªããªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚â€¦
mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã€ mysqladmin -u root -p hogehoge ã¨ã—ãŸã‚‰ mysql -u root -p ã¨ã—ã¦ã‚‚mysqlã«æŽ¥ç¶šã§ããªããªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ï¼ˆãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯ãã¡ã‚“ã¨å…¥åŠ›ã—ã¦ã„ã¾ã™ã€‚ï¼‰ç†ç”±ã¨å¯¾ç–ã‚’æ•™ãˆã¦ãã ã•ã„ã€‚æã‚‰ãã¨ã¦ã‚‚åˆæ©çš„ãªã“ã¨ã ã¨æ€ã†ã®ã§ã™ãŒã‚ã‹ã‚Šã¾ã›ã‚“ãƒ»ãƒ»ãƒ» ç’°å¢ƒã¯ ubuntu6.10 mysql5.0 ã§ã™ã€‚
nohohon_x 2007/04/29
mysql
ãƒªãƒ³ã‚¯
1