[B! MySQL] koji-watanabeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

koji-watanabe id:koji-watanabe

MySQLã«é–¢ã™ã‚‹koji-watanabeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

Google App Engine for Javaã§MySQLã‚’ä½¿ã£ã¦ã¿ã‚‹
ã¯ã˜ã‚ã« ç±³Googleã¯2011å¹´10æœˆ6æ—¥ã€Google App Engineï¼ˆä»¥ä¸‹ã€GAEï¼‰ã‹ã‚‰åˆ©ç”¨ã§ãã‚‹RDBï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã€ŒGoogle Cloud SQLã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ã“ã‚Œã¾ã§GAEã§ä½¿ç”¨ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ã€ã„ã‚ã‚†ã‚‹NoSQLã®Bigtableã ã‘ã§ã—ãŸãŒã€ã“ã‚Œã§NoSQLã¨SQLã®ä¸¡æ–¹ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸè¨³ã§ã€Googleã«ã‚ˆã‚Œã°ã€RDBã¯GAEãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰æœ€ã‚‚ãƒªã‚¯ã‚¨ã‚¹ãƒˆãŒå¤šã‹ã£ãŸæ©Ÿèƒ½ã ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€Google App Engineï¼ˆJavaï¼‰ã‚’ä½¿ã£ã¦ã€ã‚¯ãƒ©ã‚¦ãƒ‰ç’°å¢ƒä¸‹ã§ã®RDBã®ä½¿ç”¨æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ å¯¾è±¡èªè€… Google App Engine for Javaã«èˆˆå‘³ãŒã‚ã‚‹æ–¹ ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®RDBï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ä½¿ç”¨ã«èˆˆå‘³ãŒã‚ã‚‹æ–¹ å¿…è¦ãªç’°å¢ƒ Eclipse 3.5ï¼ˆGalileoï¼‰ï¼3.6ï¼ˆHeliosï¼‰ï¼
koji-watanabe 2012/03/26
ç¾åœ¨ã¯ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‚

ã‚ã¨ã§èªã‚€

gae

MySQL

cloudcomputing
ãƒªãƒ³ã‚¯
datetimeåž‹ã®ã‚«ãƒ©ãƒ ã‹ã‚‰æ—¥ä»˜ãƒ‡ãƒ¼ã‚¿ã‚’å¼•ã£å¼µã£ã¦ãã‚‹éš›ã®é«˜é€ŸåŒ– - é©å½“ãªæ—¥ã€…
ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã§webã®ä»•äº‹ã‚’ã—ãªãŒã‚‰webã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã‚’ä½œã£ãŸã‚Šä½œã‚‰ãªã‹ã£ãŸã‚Šã€æˆé•·ã¨æŒ«æŠ˜ã®è¨˜éŒ²ãƒ»ãƒ»ãƒ»ã‹ã‚‚ã—ã‚Œãªã„ã¡ã‚‡ã£ã¨MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ãŸã‚‰ã™ã”ãæ—©ããªã£ãŸã®ã§ã€ãƒ¡ãƒ¢ãƒ¡ãƒ¢ã€‚ datetimeåž‹ã®ã‚«ãƒ©ãƒ ã‹ã‚‰æ—¥ä»˜ã®ã¿ã‚’whereè¨³ã«ãƒ‡ãƒ¼ã‚¿ã‚’å¼•ã£å¼µã£ã¦ãã‚‹ã“ã¨ã¯ã‚ˆãã‚ã‚Šã¾ã™ã€‚ ã§ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒæ•°ä¸‡è¡Œã«ãªã£ã¦ãã‚‹ã¨ã‘ã£ã“ã†é…ããªã£ãŸã‚Šã™ã‚‹ã€‚ ãã—ã¦ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚å…¨ç„¶é€Ÿåº¦ãŒã‚ãŒã‚‰ãªã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ ã“ã‚Œã¯ã‚¯ã‚¨ãƒªãƒ¼ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ãªã„ã‹ã‚‰ãªã‚“ã§ã™ãã€‚ è‹¦ã—ã¾ãŽã‚Œã«dateåž‹ã®ã‚«ãƒ©ãƒ ã‚’ä½œã£ã¦æ—¥ä»˜ã ã‘ã‚’å…¥ã‚Œã‚‹ã¨ã„ã†æ‰‹æ³•ã‚‚ã‚ã‚Šã¾ã™ãŒã€ã¡ã‚‡ã£ã¨ã‚¹ãƒžãƒ¼ãƒˆã˜ã‚ƒãªã„ã§ã™ã€‚ datetimeåž‹ã‚’ç¶æŒã—ãŸã¾ã¾ã§é«˜é€ŸåŒ–ã§ãã¾ã™ã€‚ ä¾‹ãˆã°ã“ã†ã„ã†ã‚¯ã‚¨ãƒªãƒ¼ [sql ruler="true" lang_name="true"] select * from it em wher
koji-watanabe 2011/05/12
MySQL

query

tips
ãƒªãƒ³ã‚¯
ER Master
<body> <span>ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ å¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã”è¦§ãã ã•ã„ã€‚</span> </body>
koji-watanabe 2010/11/18
ERMasterã¯ã€ERå›³ç”¨GUIã‚¨ãƒ‡ã‚£ã‚¿ã§ã™ã€‚ Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦å‹•ä½œã—ã¾ã™ã€‚ ERå›³ã®ä½œæˆã€ERå›³ã®å°åˆ·ã€ERå›³ã‹ã‚‰ã®DDLå‡ºåŠ›ãªã©ã‚’ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ã¾ãŸã€DBã‹ã‚‰ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã€ã‚°ãƒ«ãƒ¼ãƒ—ç®¡ç†ã€å±¥æ´ç®¡ç†ãªã©ã‚’ã‚µ

database

db

design

development

eclipse

er

MySQL
ãƒªãƒ³ã‚¯
MAMP & MAMP PRO - your local web development solution for PHP and WordPress development
MAMP PRO for Windows MAMP PRO is the commercial, professional frontend for the classic local server environment: MAMP. With MAMP PRO you can create a separate host for each of your web projects. You can install WordPressÂ and other Extras like Joomla or Drupal with just a few clicks. This is just a small part of what you can do with MAMP PRO. Buy MAMP PRO for Windows MAMP for Windows MAMP is a free
koji-watanabe 2010/11/10
Macç”¨ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãƒ¼çµ±åˆã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã€‚

apache

apple

database

development

freeware

lamp

mac

MySQL

opensource
ãƒªãƒ³ã‚¯
MySQL :: MySQL Product Archives
This site provides archived versions of various MySQL products. We provide these as a courtesy to our users, who may need to duplicate an existing installation based on older versions of our software. Please note that these are old versions. New releases will have recent bug fixes and features! To download the latest releases of these products, please visit MySQL Downloads.
koji-watanabe 2010/11/05
MySQLã®éŽåŽ»ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆå±¥æ´

archive

database

db

development

download

MySQL
ãƒªãƒ³ã‚¯
ãƒ¡ãƒ¢ ï¼š MySQL root ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹ã«ã¯
ç®¡ç†è€…å°‚ç”¨ã®MySQLã‚¢ã‚«ã‚¦ãƒ³ãƒˆã§ phpMyAdmin ã‚’é•·ã‚‰ãæ“ä½œã—ã¦ã„ã¦ã€root ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ã«ãªã£ãŸæ™‚ã€å¿˜ã‚Œã¦ã—ã¾ã†ã¨ã„ã†äº‹ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚æœ¬ä»¶ã¨ã¯é–¢ä¿‚ã‚ã‚Šã¾ã›ã‚“ãŒã€å…ˆæ—¥ã€root ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹ç¾½ç›®ã«ãªã£ãŸã®ã§ã€ãã®æ™‚ã®ãƒ¡ãƒ¢ã§ã™ã€‚ æ³¨æ„ï¼ phpMyAdmin ã‚’å°Žå…¥ã—ã¦ã„ã‚‹å ´åˆã¯ã€ä¸€æ™‚çš„ã« Web ã‚µãƒ¼ãƒã‚’åœæ¢ã—ã¦ä¸‹ã•ã„ã€‚ã¾ãŸã€MySQL ã®ãƒãƒ¼ãƒˆã¯ Firewall ã§é–‰ã˜ã‚‹ãªã©ã®å¯¾ç–ã¯å…ˆã«è¬›ã˜ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä½œæ¥ä¸ã«å¤–éƒ¨ã‹ã‚‰ä¸æ£ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ MySQL root ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¿˜ã‚ŒãŸå ´åˆ ã²ã•ã—ã rootæ¨©é™ã‚’ä½¿ç”¨ã›ãšå¿˜ã‚Œã¦ã—ã¾ã£ãŸå ´åˆã¯ã€æ¨©é™ä¸è¦ãƒ¢ãƒ¼ãƒ‰ã§ MySQL ã‚’èµ·å‹•ã—ã€ä»¥ä¸‹ã®æ‰‹é †ã§ mysql ã® rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ mysql ãƒ‡ãƒ¼ãƒ¢ãƒ³ã‚’åœæ¢ã—ã¾ã™ã€‚
koji-watanabe 2009/12/05
tips

MySQL
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
koji-watanabe 2009/11/24
tools

programming

development

software

windows

Tool

MySQL

design

database

japanese
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½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
koji-watanabe 2009/10/28
blog

service

MySQL

server

cloudcomputing

database

cloud

amazon

ec2
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)
å…ˆé€±é‡‘æ›œæ—¥ã€BPStudy#25ã§ã€ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨ã„ã†é¡Œç›®ã§è©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®éš›ã«ä½¿ç”¨ã—ãŸç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ 1. Happy Optimization æœ€åˆã«ã€æœ€é©åŒ–ã®è€ƒãˆæ–¹ã¨ã—ã¦ã€ä¸Šé™å€¤ã‚’äºˆæ¸¬ã—ã€ãã‚Œã‚’å…ƒã«ãƒªã‚½ãƒ¼ã‚¹é…åˆ†ã‚’è€ƒãˆã‚‹ã€ã¨ã„ã†æ‰‹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚
koji-watanabe 2009/09/29
MySQL

server

performance

database

architecture

scalability

slide
ãƒªãƒ³ã‚¯
Create a Twitter-Like "Load More" Widget | Envato Tuts+
Both Twitter and the Apple App Store use a brilliant technique for loading more information; you click the link and fresh it ems magically appear on the screen. This tutorial teaches you to use AJAX, CSS, Javascript, JSON, PHP, and HTML to create that magic. This tutorial will also feature both jQuery and MooTools versions of the script. Assumptions There are a few assumptions and notes that we're
koji-watanabe 2009/08/21
programming

php

twitter

web

tutorial

MySQL

javascript

ajax

JSON

plugin
ãƒªãƒ³ã‚¯
MyDNSã‚’è©¦ã™ - Practice of Programming
DNSã‚µãƒ¼ãƒã‚’æŽ¢ã—ã¦ã¦ã€dnsmasqã¨ã‹å‡ºã¦ãã¦èª¿ã¹ã‚ˆã†ã‹ãªãã¨ã‹æ€ã£ãŸã‚‰ã€åŒåƒšã‹ã‚‰ã€MyDSNã£ã¦ã®ã‚’ã€DeNAã§ä½¿ã£ã¦ã„ã‚‹ã‚‰ã—ã„ã¨èžã„ãŸã®ã§ã€‚ ã§ã€DeNA æŠ€å¸«ã®ãƒ¡ãƒ¢(id:tokiharuã•ã‚“)ã®blogã«ã€DBãƒžã‚¬ã‚¸ãƒ³ã®6æœˆå·ã«ã€MyDNSã«ã¤ã„ã¦æ›¸ã„ã¦ã„ã‚‹ã¨ã®ã“ã¨ãªã®ã§ã€èªã‚“ã§ã¿ã¦ã‚„ã£ã¦ã¿ãŸã€‚ã¡ã‚‡ã†ã©ä½¿ã„ãŸã„ç”¨é€”ã‚‚åŒã˜ã§ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Debianã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒã‚ã£ãŸã®ã§ã€ % apt-get install mydns-common mydns-mysqlã‚’å®Ÿè¡Œã—ã¦ã€ã„ãã¤ã‹è¨å®šã«é–¢ã™ã‚‹è³ªå•ã«ç”ãˆã¦çµ‚ã‚ã‚Šã€‚ Debianã®å ´åˆ(?)ã€æ—¢ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ä½œã‚‰ã‚Œã¡ã‚ƒã£ã¦ã‚‹ã®ã§ã€å¾Œã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã‚‹ã ã‘ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ SOAãƒ†ãƒ¼ãƒ–ãƒ« +---------+------------------+------+-----+---------+--------------
koji-watanabe 2009/07/01
MySQL

dns

mydns

opensource
ãƒªãƒ³ã‚¯
ã€MySQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬8å›ž MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼šITpro
SlowLogã®è¨å®š ç’°å¢ƒè¨å®šãƒ•ã‚¡ã‚¤ãƒ«(Windowsã§ã¯my.iniï¼ŒLinuxã§ã¯my.cnf)ã«æ¬¡ã®ã‚ˆã†ãªè¨å®šã‚’åŠ ãˆã‚‹ã¨SlowLogãŒæœ‰åŠ¹ã«ãªã‚‹ã€‚ log-slow-queries SlowLogã®æœ‰åŠ¹åŒ–(ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šå¯èƒ½) long-query-time=2 SlowLogã«è¨˜éŒ²ã™ã‚‹å‡¦ç†æ™‚é–“ã®ä¸Šé™ log-long-format ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã®è¨˜éŒ² long-query-timeãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ï¼ŒSlowLogã«è¨˜éŒ²ã™ã‚‹ã—ãã„å€¤ã‚’ç§’å˜ä½ã§è¨å®šã™ã‚‹ã€‚ã“ã®å ´åˆã«ã¯ï¼Œ2ç§’è¶…ãˆã‚‹å‡¦ç†æ™‚é–“ã‚’è²»ã‚„ã—ãŸSQLæ–‡ã‚’è¨˜éŒ²ã™ã‚‹ã€‚ã¾ãŸï¼Œlog-long-formatã‚’æŒ‡å®šã™ã‚‹ã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã‚‚SlowLogã«è¨˜éŒ²ã™ã‚‹ã€‚ SlowLogã®ç¢ºèª SlowLogãŒå‹•ä½œã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã¯ï¼Œæ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã§ãã‚‹ã€‚log_slow_queriesãŒONã§ã‚ã‚Œã°æœ‰åŠ¹ã¨
koji-watanabe 2009/06/29
MySQL

tuning

slowquery

explain

tips
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 5.1.10 ã‚µãƒ¼ãƒãƒ¼ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°
MySQL ã‚µãƒ¼ãƒãƒ¼ã¯ã€ãã®æ“ä½œã«é–¢ã™ã‚‹æƒ…å ±ã‚’æä¾›ã™ã‚‹å¤šãã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°ã‚’ä¿æŒã—ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®å¤‰æ•°ãŠã‚ˆã³ãã®å€¤ã¯ã€SHOW [GLOBAL | SESSION] STATUS ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ã¦è¡¨ç¤ºã§ãã¾ã™ (ã‚»ã‚¯ã‚·ãƒ§ãƒ³13.7.7.37ã€ŒSHOW STATUS ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„)ã€‚ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã® GLOBAL ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã¯ã™ã¹ã¦ã®æŽ¥ç¶šã«ã‚ãŸã£ã¦å€¤ã‚’é›†è¨ˆã—ã€SESSION ã¯ç¾åœ¨ã®æŽ¥ç¶šã«ã¤ã„ã¦ã®å€¤ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ mysql> SHOW GLOBAL STATUS; +-----------------------------------+------------+ | Variable_name | Value | +-----------------------------------+------------+ | Aborted_clients | 0 |
koji-watanabe 2009/06/25
MySQL

status

analyze

reference
ãƒªãƒ³ã‚¯
mysqlã®ã‚¹ãƒãƒ¼ãƒã‚°ã®å–å¾—ï½œMySQLï½œãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¡ãƒ¢
MySQLã®ã‚¹ãƒãƒ¼ãƒã‚°ï¼ˆå®Ÿè¡Œã«æ™‚é–“ãŒã‹ã‹ã£ãŸSQLã‚¯ã‚¨ãƒªï¼‰ã‚’å–å¾—ã™ã‚‹ã«ã¯ 1. /etc/my.cnf ã«ä»¥ä¸‹ã®æ–‡ã‚’è¿½åŠ # 1ç§’ä»¥ä¸Šã‹ã‹ã£ãŸã‚¯ã‚¨ãƒªã‚’ mysql_slow.log ã«ä¿å˜ã™ã‚‹ log-slow-queries = /var/log/mysql_slow.log long_query_time = 1 # ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã‚ãªã„æ¤œç´¢ã‚’ ã‚¹ãƒãƒ¼ãƒã‚°ã«è¿½åŠ ã™ã‚‹ log-queries-not-using-indexes 2. æ¬¡ã«ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã€æ¨©é™ãƒ»ã‚°ãƒ«ãƒ¼ãƒ—ã‚’mysqlã«å¤‰æ›´ touch /var/log/mysql_slow.log chown mysql /var/log/mysql_slow.log chgrp mysql /var/log/mysql_slow.log 3. mysqlã®å†èµ·å‹• service mysqld stop service mysqld
koji-watanabe 2009/06/25
MySQL

log

analyze
ãƒªãƒ³ã‚¯
FrontPage - OpenPNE
ãƒžãƒ«ãƒãƒ‡ãƒã‚¤ã‚¹å¯¾å¿œ OpenPNEã¯PCã®ã¿ãªã‚‰ãšã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã€ãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ãƒ•ã‚©ãƒ³ã«å¯¾å¿œã—ã€ã„ã¤ã§ã‚‚å¥½ããªã¨ãã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ è‡ªç”±ã®FREEã€ç„¡å„Ÿã®FREE ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®OpenPNEã«ã¯2ã¤ã®FreeãŒã‚ã‚Šã¾ã™ã€‚ åˆ©ç”¨ã€é…å¸ƒã€é–‹ç™ºã¯ã™ã¹ã¦è‡ªç”±ã€‚ã—ã‹ã‚‚ç„¡å„Ÿã§ä½¿ãˆã¾ã™ã€‚
koji-watanabe 2009/05/21
blog

opensource

php

sns

MySQL

openpne
ãƒªãƒ³ã‚¯
WordPress
WordPress ã¨ã¯ ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã‚„ä¸å°ä¼æ¥ã‹ã‚‰å¤§ä¼æ¥ã«ã¾ã§ã€ä¸–ç•Œä¸ã®ä½•ç™¾ä¸‡ã‚‚ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã«é¸ã°ã‚Œã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‘ãƒ–ãƒªãƒƒã‚·ãƒ³ã‚°ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã™ã€‚ ãƒ‡ã‚¶ã‚¤ãƒ³ ã©ã‚“ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚‚ã€æŸ”è»Ÿãªãƒ‡ã‚¶ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã¨ãƒ–ãƒãƒƒã‚¯ã«ã‚ˆã£ã¦ä½œæˆã§ãã¾ã™ã€‚ãƒ†ãƒ¼ãƒžã‚’é¸ã¶ã‹ã€çœŸã£ç™½ãªã‚ãƒ£ãƒ³ãƒã‚¹ã‹ã‚‰å§‹ã‚ã¾ã—ã‚‡ã†ã€‚ç´°éƒ¨ã¾ã§ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã§ãã¾ã™ã€‚ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãå¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚
koji-watanabe 2009/05/21
blog

opensource

php

cms

MySQL

wordpress
ãƒªãƒ³ã‚¯
â‰¡ Drupal Japan â‰¡ | Drupal æ—¥æœ¬ã‚µã‚¤ãƒˆ
æœ¬æ—¥ã€å±é™ºåº¦ã®é«˜ã„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã®è„†å¼±æ€§ã‚’ä¿®æ£ã—ãŸ Drupal 7.70 ãªã‚‰ã³ã« 8.7.14/8.8.6 ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã®è„†å¼±æ€§ãŒå˜åœ¨ã™ã‚‹ãŸã‚ã€ã“ã‚Œä»¥å‰ã® 7.x/8.x ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ã¯æ—©æ€¥ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ã‚’ãŠå‹§ã‚ã„ãŸã—ã¾ã™ã€‚
koji-watanabe 2009/05/20
opensource

cms

php

MySQL

drupal
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
koji-watanabe 2009/05/12
tips

MySQL

db

database

oracle
ãƒªãƒ³ã‚¯
ãªãœMySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯é…ã„ã®ã‹ã€‚
ã‚ˆãMySQLã¯ã‚µãƒ–ã‚¯ã‚¨ãƒªãŒå¼±ã„ã¨è¨€ã‚ã‚Œã‚‹ãŒã€ã“ã‚Œã¯æœ¬å½“ã ã‚ã†ã‹ï¼ŸåŠåˆ†ã¯æœ¬å½“ã§åŠåˆ†ã¯å˜˜ã§ã‚ã‚‹ã€‚MySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã ã£ã¦ãªã‚“ã§ã‚‚ã‹ã‚“ã§ã‚‚é…ã„ã‚ã‘ã§ã¯ãªã„ã€‚è½ã¨ã—ç©´ã‚’ã—ã£ã‹ã‚Šé¿ã‘ã€ä½¿ã„ã©ã“ã‚ã‚’é–“é•ãˆãªã‘ã‚Œã°ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚‚é«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã®ã§ã‚ã‚‹ã€‚ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ EXPLAINã§å®Ÿè¡Œè¨ˆç”»ã‚’èª¿ã¹ãŸéš›ã«ã€select_typeã«ã¯ã‚¯ã‚¨ãƒªã®ç¨®é¡žãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã ãŒã€ä»£è¡¨çš„ãªã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¯æ¬¡ã®3ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ SUBQUERY DEPENDENT SUBQUERY DERIVED çµè«–ã‹ã‚‰è¨€ãŠã†ã€‚é…ã„ã®ã¯2ç•ªç›®ã€DEPENDENT SUBQUERYã§ã‚ã‚‹ã€‚DEPENDENT SUBQUERYã¨ã¯ã„ã‚ã‚†ã‚‹ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŠã„ã¦å¤–éƒ¨ã‚¯ã‚¨ãƒªã®ã‚«ãƒ©ãƒ ã‚’å‚ç…§ã—ã¦ã„ã‚‹ã‚µãƒ–ã‚¯ã‚¨ãƒªã®ã“ã¨ã§ã‚ã‚‹ã€‚ãã—
koji-watanabe 2009/03/25
ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚

tips

MySQL

tuning

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ç„¡æ–™ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ ç„¡æ–™ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ land.to
ç„¡æ–™ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ ç„¡æ–™ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã¯land.toï¼ ç„¡æ–™ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚¹ãƒšãƒ¼ã‚¹ã§ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚’ä½œã£ã¡ã‚ƒãŠï¼ ç„¡æ–™ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã®land.toã¯ã€ç„¡æ–™ã§ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ç’°å¢ƒã‚’æä¾›ã™ã‚‹ã€ç„¡æ–™ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã§ã™ã€‚ ç„¡æ–™ã§100MBã¾ã§ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ã‚’ã”æä¾›ã€‚å•†ç”¨ã‚µã‚¤ãƒˆã‹ã‚‰è¶£å‘³ã®ã‚µã‚¤ãƒˆã¾ã§ã„ã‚ã„ã‚ãªãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã«ã”åˆ©ç”¨ã„ãŸã ã‘ã¾ã™ã€‚
koji-watanabe 2009/03/25
ç„¡æ–™ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã®land.toã¯ã€ç„¡æ–™ã§ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ç’°å¢ƒã‚’æä¾›ã™ã‚‹ã€ç„¡æ–™ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã§ã™ã€‚ ç„¡æ–™ã§100MBã¾ã§ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ã‚’ã”æä¾›ã€‚å•†ç”¨ã‚µã‚¤ãƒˆã‹ã‚‰è¶£å‘³ã®ã‚µã‚¤ãƒˆã¾ã§ã„ã‚ã„ã‚ãªãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã« ã”åˆ©ç”¨ã„ãŸã ã‘ã¾ã™

webservice

php

perl

MySQL

free

ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒ

cgi

postgresql

ftp
ãƒªãƒ³ã‚¯
1