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

pisuta id:pisuta

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

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

DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
pisuta 2011/07/21
è² è·åˆ†æ•£

mysql
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºã‹ã‚‰å¦ã‚“ã PHPï¼†MySQLå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
OSC 2011 Hokkaidoã®ç™ºè¡¨ã§ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰è³‡æ–™ã§ã™ã€‚ å¼Šç¤¾ãŒã€Œãƒ–ãƒ©ã‚¦ã‚¶ä¸‰å›½å¿—ã€ã‚„ã€Œè‹±é›„ã‚¯ã‚¨ã‚¹ãƒˆã€ã¨ã„ã£ãŸã‚²ãƒ¼ãƒ ã‚’ã€PHPï¼‹MySQLã§æ§‹ç¯‰ã—ã¦ããŸä¸Šã§ã€èº«ã«ã¤ã‘ãŸãƒŽã‚¦ãƒã‚¦ã‚„ã€æ³¨æ„ã™ã¹ãç®‡æ‰€ã€æŒ‡é‡ãªã©ã‚’ã¾ã¨ã‚ãŸè³‡æ–™ã¨ãªã£ã¦ã„ã¾ã™ã€‚Read less
pisuta 2011/06/14
php

è² è·åˆ†æ•£

MySQL
ãƒªãƒ³ã‚¯
Mac OS Xï¼ˆLeopardï¼‰ã®ãƒãƒ¼ã‚«ãƒ«ã«Wordpressã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ãã®ãƒ¡ãƒ¢ - Webtech Walker
Home Archive Mac OS Xï¼ˆLeopardï¼‰ã®ãƒãƒ¼ã‚«ãƒ«ã«Wordpressã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ãã®ãƒ¡ãƒ¢ Mac OS Xï¼ˆLeopardï¼‰ã®ãƒãƒ¼ã‚«ãƒ«ã«Wordpressã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ãã®ãƒ¡ãƒ¢ 2008å¹´06æœˆ09æ—¥ category:Mac, CMS Comment(0) Trackback(0) æœ€è¿‘MacBookã‚’è²·ã£ã¦è‰²ã€…ã•ã‚ã£ã¦ã‚‹ã‚“ã§ã™ãŒã€ãƒãƒ¼ã‚«ãƒ«ã«Wordpressã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ãã®æ‰‹é †ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ PHPã¨Apacheã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã€ã™ã°ã‚‰ã—ã„ç’°å¢ƒãªã®ã§Mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚Œã°ã‚ã¨ã¯ç°¡å˜ã§ã™ã€‚æ™®é€šã«Mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã‚‚ã„ã„ã‚“ã§ã™ãŒã€å‹‰å¼·ã‚‚å…¼ãã¦FreeBSDã®portsã«ä¼¼ãŸMacPortstã¨ã„ã†ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½¿ã£ã¦Mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ Xco
pisuta 2011/05/20
macports

mac

MySQL

python

django
ãƒªãƒ³ã‚¯
Macportsã§ã¾ãŸMySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã‚‹ - chulip.org
å‰å›žã€çµå±€ä¸é€”åŠç«¯ãªã¨ã“ã‚ã§å°Žå…¥ã™ã‚‹ã®ã‚„ã‚ãŸæ°—ãŒã™ã‚‹ã‘ã©æ©Ÿä¼šãŒã§ããŸã®ã§ã¾ãŸã„ã‚Œã¦ã¿ãŸ éŽåŽ»ã®è¨˜äº‹ï¼šMacportsã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - chulip.org ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ## install sudo port install mysql5-server ## installå®Œäº†å¾Œãªã‚“ã‹å‡ºã‚‹ ########################################################### # A startup it em has been generated that will aid in # starting mysql5-server with launchd. It is disabled # by default. Execute the following command to start it, # and to cause it to l
pisuta 2011/05/20
MySQL

mac

mysql

django

python
ãƒªãƒ³ã‚¯
Macã§Djangoã‚’ä½¿ã†ã¾ã§ã®ãƒ¡ãƒ¢ - bojovs blog
ç’°å¢ƒ Mac OS X 10.5.6 MacPorts 1.700 Python 2.5.4 Django 1.0.2 Python Python æœ¬ä½“ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æœ€åˆã‹ã‚‰å…¥ã£ã¦ã‚‹Pythonã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒä½Žã„ã®ã§ã€MacPortsã§æœ€æ–°ç‰ˆï¼ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³2.5ç³»ï¼‰ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ $ sudo port install python25 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸPythonã‚’ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã«æŒ‡å®šã—ã¾ã™ã€‚ $ sudo port install python_select $ sudo python_select python25 å†èµ·å‹•ã™ã‚‹ãªã‚Šã—ã¦ã‹ã‚‰ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ç¢ºèªã—ã¾ã™ã€‚ $ python -V Python 2.5.4 py25-mysqlã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã®ã¾ã¾ã ã¨Djangoã§MySQLã‚’ä½¿ã†éš›ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã®ã§ã€py25-mysqlãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ $
pisuta 2011/05/20
python

MySQL

django
ãƒªãƒ³ã‚¯
Macbook (OS X 10.5)ã«MySQL + Pythonã®ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ - ã‚„ã•ã—ã„ãƒ‡ã‚¹ãƒžãƒ¼ãƒ
Djangoç”¨ã«ç’°å¢ƒã‚’ä½œã‚ã†ã¨æ€ã£ãŸã‚‰ã€ã™ã”ããƒãƒžã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ æ–¹é‡ã¨ã—ã¦ã¯ãªã‚‹ã¹ãç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ãŒä½¿ãˆã‚Œã°ãƒ™ã‚¹ãƒˆãªæ–¹å‘ã§æ§‹ç¯‰ã€‚ MySQL Serverã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ http://dev.mysql.com/downloads/mysql/5.1.html#macosx-dmg ä»Šå›žã¯MySQL Community Serverã®5.1ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ãŸãŒã€ãƒã‚¤ãƒ³ãƒˆã¯64bitã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãªã„äº‹ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯å¯èƒ½ã§ã™ãŒã€ã“ã‚Œã¯Pythonå´ãŒ32bitãªãŸã‚ã«å®Ÿè¡Œæ™‚ï¼ˆimportæ™‚ï¼‰ã«ã‚¨ãƒ©ãƒ¼ã¨ãªã‚Šã¯ã¾ã‚‹ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãªã‚‰ã°ãƒžã‚¦ãƒ³ãƒˆã—ã€ mysql-5.1.36-osx10.5-x86.pkg MySQLStartupIt em.pkg ã®é †ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã«å¾“ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ å°šã€MyS
pisuta 2011/05/05
MySQL

python

django
ãƒªãƒ³ã‚¯
ã€Œå–«èŒ¶åº—ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ã®ãŸã‚ã®ç’°å¢ƒæ§‹ç¯‰(VMwarePlayer + CentOS5.5+Apache2.2.3+MySQL5.5.8+PHP5.3.5+Ruby1.8.7+ãŠã¾ã‘) - [email protected]
ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ Windows 7 Home Premium (64bit)VMware Player 3.1.3 build-324285Tera Term 4.67 ä½œã‚‹ç‰© CentOS # cat /etc/redhat-release CentOS release 5.5 (Final) # uname -a Linux localhost.localdomain 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:52:25 EST 2011 x86_64 x86_64 x86_64 GNU/Linux Apache # /usr/sbin/httpd -v Server version: Apache/2.2.3 Server built: Aug 30 2010 12:28:40 MySQL # mysql --version mysql Ver 1
pisuta 2011/01/19
CentOS

MySQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Linux

ç’°å¢ƒæ§‹ç¯‰

ã‚µãƒ¼ãƒãƒ¼
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã®VPS(CentOS)ã§Apacheï¼‹PHPï¼‹MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³• Â» ã¨ã‚Šã‚ãˆãš9JP
ã•ãã‚‰ã®VPSã€ã¨ã„ã†ã‹CentOSã§yumã‚’ä½¿ç”¨ã—ã€ã¨ã‚Šã‚ãˆãšApacheï¼‹PHPï¼‹MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•ã€‚ ã¾ãšã€Apacheé–¢é€£ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ yum install httpd httpd-devel -y Apacheè‡ªå‹•èµ·å‹•ã®è¨å®šã€‚ chkconfig --level 345 httpd on æ¬¡ã«PHPé–¢é€£ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ yum install php php-devel php-mbstring php-mysql php-pdo php-mcrypt php-pear php-xml -y â€»å€‹äººçš„ã«å…¥ã‚Œã¦ãŠã„ãŸæ–¹ãŒè‰¯ã„ã¨è€ƒãˆã‚‹ã‚‚ã®ã‚’åŒæ™‚ã«å…¥ã‚Œã¦ã„ã¾ã™ã€‚ è¶³ã‚Šãªã„ã‚‚ã®ã‚„ä¸è¦ãªã‚‚ã®ãŒã‚ã‚Œã°é©å®œä¿®æ£ã—ã¦ä¸‹ã•ã„ã€‚ æ›´ã«MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ yum install mysql-server MySQLè‡ªå‹•èµ·å‹•è¨å®š chkconfig --level 345 m
pisuta 2011/01/08
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ

apache

MySQL

php

vps
ãƒªãƒ³ã‚¯
CakePHP + MySQL + phpMyAdmin ã®çµ„ã¿åˆã‚ã›ã§æ–‡å—åŒ–ã‘ã™ã‚‹å ´åˆã®å¯¾å‡¦æ³• | WEBã‚µã‚¤ãƒˆåˆ¶ä½œ WEBã‚·ã‚¹ãƒ†ãƒ é–‹ç™º | HAPPY*TRAP
pisuta 2010/03/16
*a-clip

MySQL

CakePHP
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Amazonã‚¯ãƒ©ã‚¦ãƒ‰ãŒMySQLã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã€ãƒ‘ãƒƒãƒã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚‚ãŠã¾ã‹ã›
Amazon Web ServicesãŒã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§MySQLã‚’ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã™ã‚‹ã€ŒAmazon Relational Database Service (Amazon RDS)ã€ã®Î²å…¬é–‹ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸è¦ã§MySQLã®åˆ©ç”¨ã‚’é–‹å§‹ã§ãã€ãƒ‘ãƒƒãƒå½“ã¦ã‚„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã©ã‚‚Amazonã‚¯ãƒ©ã‚¦ãƒ‰å´ã§å®Ÿè¡Œã—ã¦ãã‚Œã‚‹ãŸã‚ã€MySQLã®å°Žå…¥ã‚„é‹ç”¨ã®æ‰‹é–“ã‚’å¤§å¹…ã«å‰Šæ¸›å¯èƒ½ã§ã™ã€‚ MySQLã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯è¦æ¨¡ã«å¿œã˜ã¦5ç¨®é¡žãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ Small DB Instance : ï¼ˆ1æ™‚é–“ã‚ãŸã‚Š0.11ãƒ‰ãƒ«ï¼‰ 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform Large DB Instance : ï¼ˆ1æ™‚é–“ã‚ãŸã‚Š0.44ãƒ‰ãƒ«ï¼‰ 7.5 GB memory, 4 ECUs (2 virtual cores with
pisuta 2009/10/28
MySQL

amazon
ãƒªãƒ³ã‚¯
MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹
Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—MyISAMã«ã—ã‹ç„¡ã„æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„å ´åˆã¯MyISAMã‚’ä½¿ã†ã—ã‹ãªã„ ãƒ»å…¨æ–‡æ¤œç´¢ (Tritonnã‚„Sphinx) ãƒ»GIS â—InnoDBã®åˆ©ç‚¹(MyISAMã®æ¬ ç‚¹) â–²éšœå®³å¯¾å¿œç³» ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚‚å†èµ·å‹•ã™ã‚‹ã ã‘ã§ãƒªã‚«ãƒãƒªãŒã§ãã‚‹ ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã«ã‹ã‹ã‚‹æ™‚é–“ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«æ¯”ä¾‹ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯ãªãã€ã‚³ãƒŸãƒƒãƒˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¿®å¾©ã§ãã‚‹ (å·¨å¤§ãªMyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®REPAIRã«ã¯æ•°æ—¥å˜ä½ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚‹) ãƒ»ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã§ãã‚‹ ãƒ»INSERTã‚„LOAD DATAãªã©ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹é€”ä¸ã§Ctrl+Cã§ãã®æ›´æ–°ç³»SQLæ–‡ã‚’æ¢ã‚ã¦ã‚‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å£Šã‚Œãªã„ã—ã€ä¸é€”åŠç«¯ãªçŠ¶æ…‹ã§æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã‚‚ç„¡ã„ã—ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒæ¢ã¾ã‚‹ã“ã¨ã‚‚ç„¡ã„ â–²æ€§èƒ½ç³» ãƒ»è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ä¸¦åˆ—æ€§ãŒé«˜ã„(MyISAMã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯)ã€‚ã¾ãŸSEL
pisuta 2009/10/28
MySQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
pisuta 2009/05/25
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
pisuta 2009/05/17
MySQL

é«˜é€ŸåŒ–

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
pisuta 2009/02/18
MySQL
ãƒªãƒ³ã‚¯
æº€è¶³ã›ã‚‹è±šã€‚çœ ãŸã’ãªãƒãƒã€‚:å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®é‹ç”¨äº‹ä¾‹ã¾ã¨ã‚
ã“ã“æ•°å¹´ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸã®ã§å‚ç…§ã—ãŸãƒšãƒ¼ã‚¸ã‚„ãƒ•ã‚¡ã‚¤ãƒ«ã€æœ¬ã¸ã®ãƒªãƒ³ã‚¯ã‚’ã¾ã¨ã‚ã¦ãŠãã€‚PDF ã¸ã®ãƒªãƒ³ã‚¯ã‚‚å¤šæ•°å«ã¾ã‚Œã¦ã„ã‚‹ã®ã§ã”æ³¨æ„ã‚’ã€‚ æ™‚ä»£ãŒæ™‚ä»£ãªã‚‰ä¼æ¥ã®ãƒŽã‚¦ãƒã‚¦ã¨ã—ã¦éš ã•ã‚Œã¦ã„ãŸã‚ˆã†ãªæƒ…å ±ãŒã“ã‚Œã ã‘å…¬é–‹ã—ã¦ã‚‚ã‚‰ãˆã¦ã„ã‚‹ã¨ã„ã†ã®ãŒéžå¸¸ã«ã‚ã‚ŠãŒãŸã„ã€‚å…¬é–‹ã—ã¦ãã‚Œã¦ã„ã‚‹å„ä¼æ¥ã‚„å…¬é–‹ã—ã¦ãã‚Œã¦ã„ã‚‹äººã«æ„Ÿè¬ã€‚ ã‚ã¨ã§æ°—ä»˜ã„ãŸãŒã€Google ã‚„ Facebook ã®äº‹ä¾‹ã‚‚æŽ¢ã—ã¦ãŠã‘ã°ã‚ˆã‹ã£ãŸã€‚Thrift ã¨ã‹ã‚ã£ãŸã®ã«ã€‚ã€Œã“ã‚“ãªæƒ…å ±ã‚‚ã‚ã£ãŸã‚ˆã€ãªã©ã‚ã‚Œã°ãœã²æ•™ãˆã¦ãã ã•ã„ã€‚è¿½è¨˜ã—ã¦ã„ãã¾ã™ã€‚ youtube http://d.hatena.ne.jp/stanaka/20070427/1177651323 digg http://d.hatena.ne.jp/stanaka/20070427/1177651323 livedoor http://labs.cybo
pisuta 2009/01/31
*webã‚µãƒ¼ãƒ“ã‚¹

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

ã‚µãƒ¼ãƒ

MySQL

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
DBã®å®¹é‡ã«ã¤ã„ã¦
ã‚ã£ã·ã‚ã£ã·ã«ãªã‚Šãã†ã§ã™ã€‚ã€‚ï¼ˆç¬‘ æ°—ã«ãªã£ãŸã®ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ MyIsamã«å¯¾ã—ã¦ã¯ã‚„ã¯ã‚Šã€OSã«ä¾å˜ã—ã¦ã„ã¾ã™ã€‚ ãŸã ã€ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆæ™‚ã«Row_sizeã‚’æ±ºã‚ã‚Œã‚‹ã‚ˆã†ã§ ãã‚Œã‚’æŒ‡å®šã—ã¦ã„ã‚Œã°ã€ã‚µã‚¤ã‚ºã«åˆ¶é™ãŒã‹ã‹ã£ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ å‚è€ƒURLã«è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¢ºèªã§ã™ãŒã€ show table status like 'TABLE_NAME' \G ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€Data_lengthãƒ»Max_data_length ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚Data_lengthãŒç¾åœ¨ã§Maxãƒ»ãƒ»ãŒæœ€å¤§å€¤ã®ã¯ãšã§ã™ã€‚ã€‚ ãã‚ŒãŒã€ã©ã®çŠ¶æ…‹ã«ãªã£ã¦ã„ã¾ã™ã§ã—ã‚‡ã†ã‹ï¼Ÿ è¿‘ã„ã®ã§ã‚ã‚Œã°ã€Maxã‚’å¢—ã‚„ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ãã®å ´åˆã€alteræ–‡ã§ãƒ»ãƒ» alter table TABLE_NAME max_rows=ã“ã“ã«rowæ•°è¨˜å…¥; Avg_row_lengthã¨ã€max_rowsã§Max_da
pisuta 2008/10/08
MySQL
ãƒªãƒ³ã‚¯
MySQL ã® MERGE ãƒ†ãƒ¼ãƒ–ãƒ«ã§å·¨å¤§ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åŠ¹çŽ‡çš„ã«é‹ç”¨ã™ã‚‹
naoya.dyndns.org is currently offline. Please try again later. Questions about our services? Learn more at Dyn.com.
pisuta 2008/10/08
MySQL
ãƒªãƒ³ã‚¯
MySQL ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ - ã¨ã¿ãžãƒ¼ãƒŽãƒ¼ãƒˆ
MySQLã®MyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã›ãšã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨ã‚µã‚¤ã‚ºã®ä¸Šé™ã¯4GBã¨ãªã‚‹(*1)ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®è¨å®šã«é–¢ã™ã‚‹ãƒ¡ãƒ¢ã€‚ (*1) å¯¾è±¡Ver.ã¯4.0ã€œã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºä¸Šé™ã«ã‚ˆã‚Š4GBã¾ã§ä½¿ãˆãªã„å ´åˆã‚‚ã‚ã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ã®è¡¨ç¤º ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™ã¯'SHOW TABLE STATUS'ã§è¡¨ç¤ºã§ãã‚‹ã€‚Max_data_lengthã®ã‚«ãƒ©ãƒ ãŒãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™å€¤ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’æŒ‡å®šã—ã¦è¡¨ç¤ºã—ãŸã„å ´åˆã¯ã€SHOW TABLE STATUS FROM DBå LIKE 'ãƒ†ãƒ¼ãƒ–ãƒ«å'ã§è¡¨ç¤ºã§ãã‚‹ã€‚ mysql> SHOW TABLE STATUS FROM test LIKE 'sample' \G *************************** 1. row ***************************
pisuta 2008/10/08
MySQL
ãƒªãƒ³ã‚¯
1