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

TamaC id:TamaC

MySQLã¨DBã«é–¢ã™ã‚‹TamaCã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

HonestyWorks TechNote Â» MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä¸æ•´åˆã«ãªã£ã¦ã—ã¾ã£ãŸã¨ãã®å†æ§‹ç¯‰æ‰‹é †
æ¦‚è¦ å…ˆæ—¥MySQLã®Master-Slaveãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä½•ã‹ã®æ‹åã«æ©Ÿèƒ½ã—ãªããªã£ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚ ã“ã®ã‚ˆã†ãªçŠ¶æ³ã«é™¥ã£ãŸã¨ãã®ä¿®æ£æ‰‹é †ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ç’°å¢ƒï¼š Debian lenny MySQL 5.0.51 1å°ã®ãƒžã‚¹ã‚¿ã‹ã‚‰1å°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«å¯¾ã—ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã„ã‚‹æ§‹æˆ ä¿®æ£å‰ã®SlaveçŠ¶æ…‹ ã¾ãšã€ç¾åœ¨ã®Slaveã®çŠ¶æ…‹ã‚’ç¢ºèªã—ã¾ã™ã€‚ mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: xxx.xxx.xxx Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin
TamaC 2013/02/04
DB

MySQL
ãƒªãƒ³ã‚¯
mysqlã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å¤‰æ›´ã™ã‚‹ - ã‚ˆã‹ã‚ã†ã‚‚ã‚“ï¼
ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã«ã€BLOBåž‹ã‚„ãã®æ‹¡å¼µã®MEDIUMBLOBåž‹ã‚’åˆ©ç”¨ã™ã‚‹ã‚·ãƒ¼ãƒ³ãŒæ™‚æŠ˜ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ BLOBåž‹ã‚’åˆ©ç”¨ã—ã¦ã„ã¦ã€ã‚µã‚¤ã‚ºã®å¤§ããªãƒ‡ãƒ¼ã‚¿ã‚’DBã«æ ¼ç´ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€MySQLã®ãƒã‚°ã«ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãƒã‚°ãŒå‡ºåŠ›ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ 100906 00:00:00 InnoDB: ERROR: the age of the last checkpoint is 9440228, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10 times bigger than the InnoDB:
TamaC 2010/09/07
ã‚ã¨ã§ã‚ˆã‚€

MySQL

DB
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸé«˜é€ŸåŒ–ã«ã¤ã„ã¦(ORDERD BYã«ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ä¾‹) - LukeSilviaâ€™s diary
ä»Šå›žã¯ã€MySQLã®é«˜é€ŸåŒ–ã®ãƒ¡ãƒ¢ - @luke_silvia.diaryã®æ–¹æ³•ã«å¾“ã£ã¦ã‚¯ã‚¨ãƒªã®é«˜é€ŸåŒ–ã‚’ã—ãŸéš›ã«ã€MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ãŸã“ã¨ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é«˜é€ŸåŒ–å¯¾è±¡ã®ã‚¯ã‚¨ãƒª ä»Šå›žé«˜é€ŸåŒ–ã—ãŸã„ã‚¯ã‚¨ãƒªã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã€‚ SELECT users.*, students.school, workers.school FROM users LEFT JOIN students ON users.id = students.user_id LEFT JOIN workers ON users.id = workers.user_id WHERE (users.status= 1 AND ((kind = 0 AND students.school = 'test') OR (kind = 1 AND workers.school = 'test'))) ORDER BY
TamaC 2010/08/26
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

MySQL
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒ
ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãªã‚‰ã€Œã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã€ï¼ æœˆé¡æ›ç®—ã§ã‚ãšã‹131å††ã€ç¼¶ã‚¸ãƒ¥ãƒ¼ã‚¹1æœ¬åˆ†ã®ãŠå€¤æ®µã§ä½¿ãˆã‚‹æ ¼å®‰ãƒ—ãƒ©ãƒ³ã‹ã‚‰ã€ãƒ“ã‚¸ãƒã‚¹ã«ã‚‚ä½¿ãˆã‚‹å¤šæ©Ÿèƒ½ï¼†å¤§å®¹é‡ãƒ—ãƒ©ãƒ³ã¾ã§ã€ ç”¨é€”ã¨äºˆç®—ã«åˆã‚ã›ã¦ãƒ—ãƒ©ãƒ³ã‚’é¸ã¹ã¾ã™ã€‚ ã•ã‚‰ã«ãƒžãƒ«ãƒãƒ‰ãƒ¡ã‚¤ãƒ³å¯¾å¿œã§ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚‚ç„¡åˆ¶é™ã€‚ç„¡æ–™ã‚¦ã‚¤ãƒ«ã‚¹ã‚¹ã‚ãƒ£ãƒ³ã‚„ç„¡æ–™é›»è©±ã‚µãƒãƒ¼ãƒˆã‚‚ã‚ã‚‹ã®ã§å®‰å¿ƒã—ã¦ ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹å…±ç”¨ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚
TamaC 2010/02/02
mysql

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

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

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

DB

å‹‰å¼·
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
TamaC 2010/01/31
mysql

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

DB

å‹‰å¼·
ãƒªãƒ³ã‚¯
1