[B! tips] hattaraã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hattara id:hattara

tipsã«é–¢ã™ã‚‹hattaraã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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ã‚³ãƒžãƒ³ãƒ‰ã‚’ã‚ˆã‚Šä¾¿åˆ©ã«å®‰å…¨ã«ã™ã‚‹ãŸã‚ã®å°ç²’ãªTIPSé›†ï½œã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ å…¬å¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
åˆã‚ã¾ã—ã¦ã€‚2010å¹´ã®3æœˆã«å…¥ç¤¾ã—ãŸ oinume ã§ã™ã€‚æ–°å¹´1æœˆã‹ã‚‰ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã«ç½¹ã‚ŠãªãŒã‚‰ã‚‚ãªã‚“ã¨ã‹ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹è‡ªåˆ†ãŒä»Šã¾ã§å¦ã‚“ã ï¼†æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸç´°ã‹ã„å®Ÿè·µçš„ãªTIPSã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å°ç²’ã§ã™ãŒä½•ã‹ã®å½¹ã«ç«‹ã¦ã°å¹¸ã„ã§ã™ã€‚ edit (Â¥e)ã‚³ãƒžãƒ³ãƒ‰ mysqlãƒ—ãƒãƒ³ãƒ—ãƒˆã«ã„ãªãŒã‚‰ä»»æ„ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§SQLãŒç·¨é›†ã§ãã¡ã‚ƒã„ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã§ãƒ—ãƒãƒ³ãƒ—ãƒˆå¾…ã¡ã®çŠ¶æ…‹ã§ mysql> edit ã®ã‚ˆã†ã« edit ã¾ãŸã¯ Â¥e ã¨å…¥åŠ›ã™ã‚‹ã¨ã€ç’°å¢ƒå¤‰æ•°EDITORã§è¨å®šã—ã¦ã‚ã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãŒç«‹ã¡ä¸ŠãŒã‚ŠSQLãŒç·¨é›†å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ç·¨é›†ãŒçµ‚ã‚ã£ãŸã‚‰ã‚¨ãƒ‡ã‚£ã‚¿ã‚’çµ‚äº†ã—ã¦ ; ã¨ã‚„ã‚Œã°SQLãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚viãªã©ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§å‹•ãã‚¨ãƒ‡ã‚£ã‚¿ã«æ…£ã‚Œã¦ã„ã‚‹äººã¯é•·ã„SQLã‚’ç·¨é›†ã™ã‚‹æ™‚ã«é‡å®ã™ã‚‹æ©Ÿèƒ½ã§ã—ã‚‡ã†ã€‚ã“ã®æŠ€ã¯å‰è·ã®åŒåƒšã«æ•™ãˆã¦ã‚‚ã‚‰ã£ã¦ã€ä»¥é™ä¾¿
hattara 2011/01/31
ä¾¿åˆ©

æŠ€è¡“

tips

mysql

MySQL

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

é«˜é€ŸåŒ–

ã¾ã¨ã‚

tips

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã€ŒGoogleã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ãƒ©ãƒ³ã‚¯ä»˜ã‘ãªã©ã«é–¢ã™ã‚‹10ã®èª¤è§£ã€ã‚’GoogleãŒå…¬å¼ãƒ–ãƒã‚°ã«ã¦å…¬é–‹
Googleã‚„Yahooï¼ã®æ¤œç´¢çµæžœã®ä¸Šä½ã«æ¥ãªã„ãƒšãƒ¼ã‚¸ã‚„ã‚µã‚¤ãƒˆã¯å˜åœ¨ã—ã¦ã„ã¦ã‚‚å˜åœ¨ã—ã¦ã„ãªã„ã®ã¨åŒç‰ã®æ‰±ã„ã‚’å—ã‘ã¦ã—ã¾ã†ãŸã‚ã€æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³å¯¾ç–æœ€é©åŒ–ã€ã™ãªã‚ã¡ã€ŒSEO(Search Engine Optimization)ã€ã‚’å°‚é–€ã«è¡Œã†æ¥è€…ãŒç„¡æ•°ã«å˜åœ¨ã—ã¦ãŠã‚Šã€ã¾ã“ã¨ã—ã‚„ã‹ã«ã„ã‚ã„ã‚ãªå™‚ã‚„éƒ½å¸‚ä¼èª¬ã‚ã„ãŸèª¤è§£ãŒæµå¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ å½“ç„¶ãªãŒã‚‰ã“ã†ã„ã£ãŸèª¤è§£ã«ã‚ˆã£ã¦æœ€å¤§ã®è¢«å®³ã‚’å—ã‘ã‚‹ã®ã¯æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®åˆ©ç”¨è€…ã¨æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æä¾›ã™ã‚‹å´ã®åŒæ–¹ã§ã™ã€‚ãã®ãŸã‚ã€GoogleãŒã¤ã„ã«é‡ã„è…°ã‚’ä¸Šã’ã€ã€ŒGoogleã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ãƒ©ãƒ³ã‚¯ä»˜ã‘ãªã©ã«é–¢ã™ã‚‹10ã®èª¤è§£ã€ã«ã¤ã„ã¦å…¬å¼ãƒ–ãƒã‚°ã§èª¬æ˜Žã‚’ã—å§‹ã‚ã¾ã—ãŸã€‚ è©³ç´°ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ Webmaster Central æ—¥æœ¬ç‰ˆ å…¬å¼ãƒ–ãƒã‚°: Google ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ãƒ©ãƒ³ã‚¯ä»˜ã‘ãªã©ã«é–¢ã™ã‚‹ã€10 ã®èª¤è§£ Official Google Webmaster Centr
hattara 2009/08/27
*ã‚ã¨ã§èªã‚€

è³‡æ–™

google

SEO

tips

webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
CodeZineï¼šãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«å½¹ç«‹ã¤ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãŒæº€è¼‰ãªé–‹ç™ºè€…ã®ãŸã‚ã®å®Ÿè£…ç³»Webãƒžã‚¬ã‚¸ãƒ³
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
hattara 2009/04/02
ã‚ã¨ã§èªã‚€

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

é–‹ç™º

tips
ãƒªãƒ³ã‚¯
PHP Variable and Array Tests
PHP Variable Tests php version 5.4.16 version for 5.0.4 (as at 26/09/2005) NULL0FALSE""TRUE11.3-1"-1"-1.7"1""1.3""0"" ""string""123str""str123""12.3e16""229e193427790"array()array(1)new Object()fopen(__FILE__)unset($v)isset($v)
hattara 2009/03/24
Php

tips

è³‡æ–™
ãƒªãƒ³ã‚¯
PHPã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«é–¢ã™ã‚‹æœ€é©åŒ–TIPS 2009:phpspoté–‹ç™ºæ—¥èªŒ
PHP micro-optimization tips | Alex @ Net PHPã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«é–¢ã™ã‚‹æœ€é©åŒ–TIPS ã¨ã„ã†ã®ãŒã¾ã¨ã¾ã£ã¦ã„ã¾ã—ãŸã®ã§ã”ç´¹ä»‹ã€‚ å…ƒè¨˜äº‹ã§ã¯ã€micro-optimization ã¨ã„ã†ã“ã¨ã§ã€ã“ã‚Œã‚‰ã‚’ç›´ã™ã®ã‚‚ã‚‚ã¡ã‚ã‚“ã ã‘ã©ã€ãƒã‚¸ãƒƒã‚¯ã‚’ç›´ã™æ–¹ãŒãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯æ”¹å–„ã•ã‚Œã‚‹ã¨ã„ã†ã“ã¨ã‚’è¨€ã£ã¦ã‚‹ã‚ˆã†ã§ã™ã€‚ å€‹äººçš„ãªå‹‰å¼·ãŒã¦ã‚‰ã€ãƒ¡ãƒ¢ã¨ã—ã¦æ®‹ã—ã¾ã™ã€‚ ãƒ»__call ã®ãƒžã‚¸ãƒƒã‚¯ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã†ã¨é…ã„ ãƒ»staticãªãƒ¡ã‚½ãƒƒãƒ‰ã¯ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹åŒ–ã—ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚ˆã‚Šé€Ÿã„ ãƒ»é–¢æ•°å‘¼ã³å‡ºã—ã¯ã€staticãªãƒ¡ã‚½ãƒƒãƒ‰å‘¼ã³å‡ºã—ã‚ˆã‚Šé«˜é€Ÿ ãƒ»ãƒãƒ¼ã‚«ãƒ«å¤‰æ•°ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯ã‚°ãƒãƒ¼ãƒãƒ«å¤‰æ•°ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚ˆã‚Šé€Ÿã„ ãƒ»ã‚°ãƒãƒ¼ãƒãƒ«å¤‰æ•°ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚ˆã‚Šé€Ÿã„ ãƒ»ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ—ãƒãƒ‘ãƒ†ã‚£ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯ã€__get, __set ã‚’ä½¿ã†ã¨é…ã„ ãƒ»åˆæœŸåŒ–ã•ã‚ŒãŸå¤‰æ•°ã¯ãã†ã§ãª
hattara 2009/03/13
ã‚ã¨ã§èªã‚€

Php

tips

é«˜é€ŸåŒ–

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
Mozilla Re-Mix: åŠ¹æžœæ´ç„¶ï¼Firefoxã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨æ³•ã‚’å¤‰æ›´ã—ã¦è»½å¿«ã«å‹•ä½œã•ã›ã‚‹æ–¹æ³•ã€‚
Firefoxã¯å¤šæ©Ÿèƒ½ã§ã‚ã‚‹ä¸Šã«ã€æ‹¡å¼µæ©Ÿèƒ½ã‚’å¤šæ•°ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ãªã©ã§ã€æ—¥ã«æ—¥ã«ãƒ˜ãƒ“ãƒ¼ãªãƒ–ãƒ©ã‚¦ã‚¸ãƒ³ã‚°ç’°å¢ƒã«ãªã‚ŠãŒã¡ã§ã™ã€‚ æµ·å¤–ã®ãƒ–ãƒã‚°ã§ã¯ã€æ§˜ã€…ãªFirefoxã®å‹•ä½œè»½é‡åŒ–ã‚„é€Ÿåº¦å‘ä¸Šã«ã¤ã„ã¦ã®Tip'sãŒå¤šãæ›¸ã‹ã‚Œã¦ã„ã¾ã™ãŒã€ã‚ã¦ã«ãªã‚‰ãªã„ã‚‚ã®ã€ãã‚Œã¯ã¡ã‚‡ã£ã¨æ€–ã„ãªãƒ»ãƒ»ã¨ã„ã†ã‚«ã‚¹ã‚¿ãƒ ã‚‚å¤šã„ã®ã§ã†ã‹ã¤ã«ã¯æ‰‹ã‚’å‡ºã›ã¾ã›ã‚“ã€‚ ä¸€å¿œãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã—ã¦ä¸€é€šã‚Šè©¦ã—ã¦ã„ã¾ã™ãŒã€ãã®ä¸ã§ã‚‚ç°¡å˜ã§å®‰å…¨ã¨æ€ã‚ã‚Œã€åŠ¹æžœã‚’ä½“æ„Ÿã§ããŸãƒ¡ãƒ¢ãƒªãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆæ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ã”å˜ã˜ã®ã‚ˆã†ã«ã€Firefoxã‚’åˆ©ç”¨ã—ã¦ãƒ–ãƒ©ã‚¦ã‚¸ãƒ³ã‚°ã—ã¦ã„ã‚‹éš›ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã¨ã„ã†ã®ã¯ã‹ãªã‚Šã®ã‚µã‚¤ã‚ºã§ã€ä»–ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„Windowsã®å‹•ä½œã«ã‚‚å°‘ãªã‹ã‚‰ãšæ‚ªå½±éŸ¿ã‚’åŠã¼ã—ã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ä¸‹è¨˜ã®2ç‚¹ã®è¨å®šã¯ã€Firefoxã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨æ–¹æ³•ã‚’å°‘ã—ã‚«ã‚¹ã‚¿ãƒ ã™ã‚‹ã ã‘ã§ä½“æ„Ÿã§ãã‚‹ã»ã©è»½å¿«ã«å‹•ä½œã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹Tip'sã§ã™ã€‚ â– ãƒ¡ãƒ¢ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥
hattara 2009/01/27
ãƒ¡ãƒ¢ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã®è§£æ”¾æ–¹æ³•ã‚’å®Ÿè¡Œã—ã¦ã¿ãŸã€‚

firefox

é«˜é€ŸåŒ–

tips
ãƒªãƒ³ã‚¯
1