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

kanouk id:kanouk

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

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

ï¼»é€Ÿå ±ï¼½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
kanouk 2009/10/28
Small DB Instanse($0.11 per hour) 1.7GB memory 1 ECU.

amazon

mysql
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
kanouk 2009/02/20
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æ–¹æ³•ã€‚å‚è€ƒã«ãªã‚Šã¾ã™ã€‚

mysql
ãƒªãƒ³ã‚¯
MySQLç”Ÿã¿ã®è¦ªMichael 'Monty' Wideniusæ°ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’åŽ»ã‚‹ | ã‚¹ãƒ©ãƒ‰
MySQLã®ç”Ÿã¿ã®è¦ªã¨ã„ã‚ã‚Œã¦ã„ã‚‹Michael 'Monty' Wideniusæ°ãŒã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’åŽ»ã‚Šã€Monty Program Abã¨ã„ã†æ–°ã—ã„ä¼šç¤¾ã‚’ç«‹ã¡ä¸Šã’ãŸï¼ˆ@ITãƒ»æœ¬å®¶è¨˜äº‹ã‚ˆã‚Šï¼‰ã€‚ åŒæ°ã¯è‡ªèº«ã®ãƒ–ãƒã‚°ã§ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’åŽ»ã‚‹ä¸»ãªç†ç”±ã¨ã—ã¦åŒç¤¾ã®MySQLã‚µãƒ¼ãƒã®é–‹ç™ºæ–¹é‡ã«å¯¾ã™ã‚‹ä¸æº€ãŒã‚ã£ãŸã¨è¿°ã¹ã¦ã„ã‚‹ã€‚åŒæ°ã¯æ˜¨å¹´5.1 GAï¼ˆGenerally Availableï¼‰ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸæ™‚ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã§ã“ã®ãƒªãƒªãƒ¼ã‚¹ãŒãƒã‚°ã ã‚‰ã‘ã§ã‚ã‚‹ã¨æ³¨æ„ã‚’ä¿ƒã—ã¦ã„ãŸã€‚ã“ã®5.1 GAã®ãƒªãƒªãƒ¼ã‚¹æ™‚æœŸã‚„ã‚µãƒ¼ãƒé–‹ç™ºãªã©ã«é–¢ã™ã‚‹æ„è¦‹ã®ç›¸é•ãŒã‚ã‚Šã€ã“ã‚Œã‚’è§£æ¶ˆã™ã‚‹ãŸã‚ã®è©¦ã¿ãªã©ã‚‚ã‚ã£ãŸãŒä¸Šæ‰‹ãã„ã‹ãšã€é€€è·ã«è‡³ã£ãŸã¨ã®ã“ã¨ã€‚æœ€çµ‚çš„ã«åŒæ–¹åˆæ„ã®ä¸Šã§é€€è·ã®é‹ã³ã¨ãªã£ãŸã¨ã®ã“ã¨ã§ã€ä»Šå¾Œã‚‚ãƒ“ã‚¸ãƒã‚¹é¢ã§ãŠäº’ã„ã«é–¢ã£ã¦ã„ããã†ã ã€‚ æ–°ã—ãç«‹ã¡ä¸Šã’ãŸä¼šç¤¾ã¯ã€ŒçœŸã«ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãªä¼šç¤¾ï¼ˆa true ope
kanouk 2009/02/06
ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã«å–ã‚Šè¾¼ã¾ã‚Œã‚‹ã¨ã„ã¤ã‚‚ã“ã‚“ãªæ„Ÿã˜ã€‚

opensource

mysql

sun
ãƒªãƒ³ã‚¯
http://blog.thebadtiming.com/archives/002335.htm
kanouk 2008/01/02
ãœã²ä½¿ã£ã¦ã¿ãŸã„ã€‚

mysql

php
ãƒªãƒ³ã‚¯
[å°±è·ãƒ»è»¢è·] All Aboutï½œå°±è·è»¢è·ã®ãƒŽã‚¦ãƒã‚¦
kanouk 2008/01/02
ä¾¿åˆ©ã ã€‚

mysql
ãƒªãƒ³ã‚¯
ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬
ã“ã®æ–‡æ›¸ã¯ã€æŠ€è¡“è©•è«–ç¤¾åˆŠã€ŽWEB+DB PRESS Vol.22ã€ã«åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æŠ€è¡“è©•è«–ç¤¾ã® è¨±å¯ã‚’å¾—ã¦WWWã§å…¬é–‹ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®WWWç‰ˆã¯æ ¡æ£å‰ã®åŽŸç¨¿ã‚’å…ƒã«ã—ã¦ã„ã‚‹ç‚¹ã€WWWå…¬é–‹å¾Œã«å¿…è¦ãŒã‚ã‚Œã°ä¿®æ£ã™ã‚‹ç‚¹ã§ã€é›‘èªŒç‰ˆã®æ–‡ç« ã¨ã¯ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å›³è¡¨ã‚‚é›‘èªŒç‰ˆã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚ äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã¾ãŸã€ã“ã®æ–‡ç« ãŒå¯¾è±¡ã—ã¦ã„ã‚‹ã®ã¯MySQL 4.0ç³»ãªã®ã§ã€æœ€æ–°ã®ãƒªãƒªãƒ¼ã‚¹ç‰ˆã¨æ¯”ã¹ã‚‹ã¨èª¬æ˜Žä¸è¶³ãªç‚¹ãªã©ãŒå¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºæœ¬ã‚’ãŠã•ãˆã‚‹ã«ã¯ã€ã“ã®æ–‡æ›¸ã¯ã¾ã æœ‰ç›Šã ã¨æ€ã„ã¾ã™ãŒã€è¨å®šãƒ¬ãƒ™ãƒ«ã®èª¬æ˜Žã¯æœ€æ–°ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚
kanouk 2008/01/02
ã‹ãªã‚Šã—ã£ã‹ã‚Šã—ãŸè¨˜äº‹ã€‚å‚è€ƒã«ã—ãŸã„ã€‚

mysql
ãƒªãƒ³ã‚¯
MySQL/Ruby
[English] ã“ã‚Œã¯ MySQL ã® Ruby API ã§ã™ã€‚MySQL ã® C API ã¨ã»ã¼åŒç‰ã®æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ RubyForge tmtm.org å¿…è¦ãªã‚‚ã® MySQL 5.0.67 Ruby 1.8.7, 1.9.1 ã“ã‚Œã‚‰ä»¥å¤–ã§ã‚‚ make ã§ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ç¢ºèªã—ã¦ã¾ã›ã‚“ã€‚ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ ã“ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ Ruby ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ ã«å¾“ã„ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æ¬¡ã‚’å®Ÿè¡Œã—ã¦ãã ã•ã„ã€‚ % ruby extconf.rb ã¾ãŸã¯ % ruby extconf.rb --with-mysql-dir=/usr/local/mysql ã¾ãŸã¯ % ruby extconf.rb --with-mysql-config ãã‚Œã‹ã‚‰ % make extconf.rb ã«ã¯æ¬¡ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã§ãã¾ã™ã€‚ --with-mysql-include=dir MySQL
kanouk 2008/01/02
ruby

mysql
ãƒªãƒ³ã‚¯
http://tokuhirom.dnsalias.org/~tokuhirom/tokulog/2106.html
kanouk 2008/01/02
ruby

mysql
ãƒªãƒ³ã‚¯
Herzlich Willkommen!
Dies ist die Standard-Index-Seite Ihres Webs. Sie kÃ¶nnen sie probl emlos lÃ¶schen oder durch eine andere Seite ersetzen. Es handelt sich hierbei um die Datei index.html im Verzeichnis web. Bei Fragen oder Probl emen wenden Sie sich bitte an den Support.
kanouk 2008/01/02
ä½¿ã„å‹æ‰‹ã‚ˆã—ã€‚æ—¥æœ¬èªžå¯¾å¿œã€‚è³¼å…¥æ¤œè¨Žã—ã‚ˆã†ã€‚

mysql
ãƒªãƒ³ã‚¯
[ã´] - ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ æ¬¡ä¸–ä»£ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚»ãƒŸãƒŠãƒ¼
_ [ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨] ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ æ¬¡ä¸–ä»£ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚»ãƒŸãƒŠãƒ¼ ã‚ã–ã‚ã–åˆå¾ŒåŠã—ãŸã®ã«é€€ç¤¾ã™ã‚‹ã®ãŒé…ã‚ŒãŸã‚Šå®¶ã«è²¡å¸ƒå¿˜ã‚ŒãŸã‚Šã§20åˆ†é…åˆ»ã€‚ è‰²ã€…æŠœã‘ãŒã‚ã‚‹ã‘ã©ã¨ã‚Šã‚ãˆãšã–ã£ãã‚Šã¨ãƒ¡ãƒ¢ã€‚ ä½¿ã£ã¦ã‚‹ OS ã¯ã»ã¨ã‚“ã© (9å‰²æ–¹) FreeBSD 4ã€ä¸€éƒ¨ Turbolinux 8 ãƒ»FreeBSD 4.x (5.x ã¯ Perl ã®æ‰±ã„ãŒâ€¦) ãƒ»Apache 1.3 (2.0ã¯ mod_perl ã®äº’æ›æ€§ãŒâ€¦) ãƒ»MySQL 4.0 (4.1ã¯æ—¥æœ¬èªžã®å–ã‚Šæ‰±ã„ãŒâ€¦) ãƒ»Perl 5.8 (ã“ã‚Œã ã‘ã¯æœ€æ–°ã® Stable ã§ã‚‚å•é¡Œãªã„)ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ã¯å»¶ã¹13äººã® CPAN Author ã‚’è¼©å‡º (ã§ã‚‚ä»Šæ®‹ã£ã¦ã‚‹ã®ã¯3äººã ã‘)ã‚ªãƒ³ãƒ»ã‚¶ãƒ»ã‚¨ãƒƒã‚¸ (å¾Œã«ã‚¨ãƒƒã‚¸ã«æ”¹å) ã®é ƒã¯ Total Internet Solution ã¨ã„ã†ã‚ãƒ£ãƒƒãƒã§ã€ä¸»ã« Web ã‚µã‚¤ãƒˆæ§‹ç¯‰ã®å—è¨—ã€‚ã“ã®ä¸ã§ã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ Sled
kanouk 2008/01/02
si

livedoor

mysql
ãƒªãƒ³ã‚¯
Installing Ruby on Rails with Lighttpd and MySQL on Fedora Core 4
Installing Ruby on Rails with Lighttpd and MySQL on Fedora Core 4 Contents Introduction Getting Fedora Core 4 Installing Fedora Core Linux Administration Yum Installing additional Yum Repositories Installing Yum Extened GUI Updating FC4 Installing Ruby on Rails Installing Ruby Installing Ruby Gems Installing Rails Installing Lighttpd Installing mySQL Configuring mySQL Installing FastCGI Develop
kanouk 2008/01/02
ã‚ˆã†ã‚„ãè¦‹ã¤ã‘ãŸã€‚linux(fedora)+lighttpd+fastcgi+railsã®ãƒ•ãƒ«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †æ›¸ã€‚

lighttpd

fastcgi

rails

mysql

fedora
ãƒªãƒ³ã‚¯
MySQL :: MySQL Workbench 6.0
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. Design MySQL Workbench enables a DBA, developer, or data architect to visually design
kanouk 2008/01/02
MySQLã®ãƒ•ãƒãƒ³ãƒˆã‚¦ã‚§ã‚¢ã€‚æœ¬å®¶ã«ã‚ã£ãŸã˜ã‚ƒã‚“ã€‚

mysql
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®MySQLè²·åŽã«å¤±æ•—
ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ç™º--å¤§æ‰‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ™ãƒ³ãƒ€ãƒ¼OracleãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¡ãƒ¼ã‚«ãƒ¼ã®MySQLè²·åŽã‚’è©¦ã¿ãŸã€‚ã“ã‚Œã¯ã€OracleãŒã€é‡è¦æ€§ã®é«˜ã¾ã‚‹å”èª¿ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ç†å¿µã«åˆã‚ã›ã¦å¤§ããå¤‰ã‚ã‚ã†ã¨ã—ã¦ã„ã‚‹ã“ã¨ã‚’ç¤ºã—ã¦ã„ã‚‹ã€‚ å¤šè§’åŒ–ã‚’é€²ã‚ã¦ã¯ã„ã‚‹ãŒã€Oracleã®æœ¬æ¥ã¯è‡ªç¤¾é–‹ç™ºã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’è²©å£²ã™ã‚‹ã“ã¨ã ã€‚ã“ã‚Œã¨ã¯å¯¾ç…§çš„ã«ã€ç«¶åˆã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹è£½å“ã®å•†æ¥åŒ–ã‚’ç›®æŒ‡ã™è¤‡æ•°ã®ä¼æ¥ã®ãƒˆãƒƒãƒ—ã‚’èµ°ã‚‹ã®ãŒMySQLã ã€‚ MySQLã®æœ€é«˜çµŒå–¶è²¬ä»»è€…ï¼ˆCEOï¼‰ã€Marten Mickosã¯ã€å½“åœ°ã§é–‹å‚¬ä¸ã®Open Source Business Conferenceã§ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã«ç”ãˆã€è²·åŽã®è©¦ã¿ãŒã‚ã£ãŸã“ã¨ã‚’æ£å¼ã«èªã‚ãŸã€‚ã ãŒã€äº¤æ¸‰ã®æ™‚æœŸã‚„ã€Oracleã®æç¤ºé¡ãªã©ã€ãã®è©³ç´°ã«ã¤ã„ã¦ã¯æ˜Žã‹ã•ãªã‹ã£ãŸã€‚ ã—ã‹ã—ã€åŒæ°ã¯ã€Oracleã®æç¤ºã‚’æ–ã£ãŸç†ç”±ã‚’ã€è‡ªèº«ã®ä¼šç¤¾ãŒæŒã¤ç‹¬ç«‹æ€§ã‚’ç¶æŒã—
kanouk 2008/01/02
oracle

mysql
ãƒªãƒ³ã‚¯
mysql:12071ã€€éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†
From: zen kishimoto <zen kishimoto <zen@xxxxxxxxxx>> Date: Sat, 03 Sep 2005 09:24:15 -0700 Subject: [mysql 12071] éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†ã€€ï¼ˆManaging Hierarchical Data in MySQLï¼‰ http://dev.mysql.com/tech-resources/articles/hierarchical-data.html ï¼ˆå›³ã¯ã“ã®ã‚µã‚¤ãƒˆã‚’å‚ç…§ã®ã“ã¨ï¼‰ Mike Hillyerè‘— åˆã‚ã« å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ä¸€å›žãã‚‰ã„ã¯SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ã€éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ æ‰±ã£ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ç”¨ã«é–‹ç™ºã•ã‚Œãªã‹ã£ãŸã¨è€ƒãˆãŸã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯éšŽå±¤åŒ–ã•ã‚Œã¦ãŠã‚‰ãš
kanouk 2008/01/02
ãƒ„ãƒªãƒ¼ã‚’DBã«å…¥ã‚Œã‚‹

mysql
ãƒªãƒ³ã‚¯
YappoLogs: Tagã®æ¤œç´¢ã‚’Senna+MySQLã§
Tagã®æ¤œç´¢ã‚’Senna+MySQLã§ kazeburoã•ã‚“ã®æ‰€ã§fulltextä½¿ã£ã¦tagã‚’å®Ÿè£…ã™ã‚‹ãƒã‚¿ãŒã‚¢ãƒ„ã‚ãªã®ã§ã¡ã‚‡ã‚ã£ã¨æ›¸ã„ã¦ã¿ã‚‹ã€‚ Sennaã®MySQL 2indãƒ‘ãƒƒãƒã‚’ä½¿ã†ã¨ã€æ—¢å˜ã®indexã¨Sennaã®indexä¸¡æ–¹ã‚’åŒæ™‚ã«ä½¿ã†ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ãã‚ŒãŒå‡ºæ¥ã‚‹ã¨ä½•ãŒè‰¯ã„ã¨è¨€ã†ã¨ã€user idã§çµžã‚Šè¾¼ã¿ã¤ã¤tagæ¤œç´¢ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ create table ft_tags( id int unsigned not null auto_increment primary key, user_id int unsigned not null, tags text, index user_id(user_id), fulltext tags(tags) )ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç”¨æ„ã—ã¦ãŠãã€‚ user idãŒ2ã®äººã®ã‚¿ã‚°æ¤œç´¢ã‚’ã™ã‚‹ã¨ãã«select id from ft_tag
kanouk 2008/01/02
mysql

tagging

search
ãƒªãƒ³ã‚¯
MySQLã®å°æŠ€
This domain may be for sale!
kanouk 2008/01/02
mysql
ãƒªãƒ³ã‚¯
dublish.com - Simple Optimization for PHP and MySQL
Simple Optimization for PHP and MySQL Saturday April 29 2006 03:23 Here is a list of a few very simple tips for optimizing your php/mysql applications. Keep these in mind while developing. MySQL MySQL is interpreted from right to left so you should put the most significant limiters as far to the right as possible. Only select fields you need, instead of selecting * (everything). Don't put things t
kanouk 2008/01/02
mysql

php
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MyISAM vs InnoDB
ã‚ãã¾ã§æ†¶æ¸¬ã§ä»®èª¬ã§ã—ã‹ãªã„ã‚“ã§ã™ãŒã€‚ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ã†ã¡ä»£è¡¨çš„ãªäºŒã¤ã€MyISAM ã¨ InnoDB ã¯ã‚ˆã MyISAM: Read ã¯é€Ÿã„ã‘ã©ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã®ãŸã‚ä¸¦è¡Œæ€§ãŒä½Žã„ã€‚é‹ç”¨ãŒç°¡å˜ã€‚ InnoDB: MyISAM ã‚ˆã‚Š Read ã¯é…ã„ã‘ã©ä¸¦è¡Œæ€§ãŒé«˜ã„ ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ã€‚ã‚ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã€‚é‹ç”¨ãŒ MyISAM ã‚ˆã‚Šã¡ã‚‡ã£ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ã¨ã„ã†åŒºåˆ¥ãŒã•ã‚Œã¾ã™ã€‚ã“ã“ã‹ã‚‰è»¢ã˜ã¦ã€ MyISAM ã¯å‚ç…§ç³»ã‚¯ã‚¨ãƒªãŒå¤§éƒ¨åˆ†ã‚’å ã‚ã‚‹å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ä¾‹ãˆã° blog ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€‚ InnoDB ã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå¤šã„å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ ã¨è¨€ã‚ãŸã‚Šã—ã¾ã™ã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ã§ã‚‚ç¬¬2ç« ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«åž‹) P.30 ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒãªãã€ä¸»ã« SELECT ã¾ãŸã¯ I
kanouk 2008/01/02
mysql
ãƒªãƒ³ã‚¯
O'Reilly Media - Technology and Business Training
More than 60% of all Fortune 100 companies trust Oâ€™Reilly to help their teams learn the techno logies of todayâ€”and be ready for whatâ€™s next. We can help yours too. See why Addison loves our learning platform Addison always appreciated Oâ€™Reilly books, but the learning platform helped take her skills to the next level. Amir trusts Oâ€™Reilly to find the answers he needs. See why. For over eight years A
kanouk 2008/01/02
mysql
ãƒªãƒ³ã‚¯
mysql ã®ãƒ¡ã‚¿ã‚³ãƒžãƒ³ãƒ‰ã€ŽGã€
mysql ã®ãƒ¡ã‚¿ã‚³ãƒžãƒ³ãƒ‰ã«ã€Ž\Gã€ã£ã¦ã„ã†ä¾¿åˆ©ãªã®ãŒã‚ã‚‹ã®ã‚’ä»Šæ—¥ã€ã¨ã„ã†ã‹ã•ã£ãçŸ¥ã£ãŸã€‚ SQLæ–‡ã®æœ€å¾Œã«ã€Œ\Gã€ã£ã¦ã¤ã‘ã‚‹ã¨ã€å•ã„åˆã‚ã›çµæžœã‚’ãŸã¦ã«è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ mogilefs> select * from device; +-------+--------+--------+--------+----------+---------+------------+ | devid | hostid | status | weight | mb_total | mb_used | mb_asof | +-------+--------+--------+--------+----------+---------+------------+ | 1 | 1 | alive | 100 | 2015 | 756 | 1158770599 | | 2 | 1 | alive |
kanouk 2008/01/02
ã“ã£ã¡ã¯çŸ¥ã£ã¦ãŸã‘ã©ã„ã¡ãŠã†ã€‚

mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸