[B! TIPS] kopugã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kopug id:kopug

TIPSã«é–¢ã™ã‚‹kopugã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (89)

${{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ã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã¯rows_examinedã§åˆ¤æ–ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ä»•äº‹ã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã§MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã€EXPLAINã®å†…å®¹ã ã‘ã ã¨ã©ã®ãã‚‰ã„è‰¯ããªã£ãŸã‚Šæ‚ªããªã£ãŸã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ SET long_query_time = 0; ã—ã¦rows_examined (ãã®ã‚¯ã‚¨ãƒªã§rows_sentè¡Œã®çµæžœã‚’è¿”ã™ãŸã‚ã«ä½•è¡Œã«è§¦ã£ãŸã®ã‹)ã‚‚ä¸€ç·’ã«æç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹(å°‘ãªãã¨ã‚‚MySQL 5.7æ™‚ç‚¹ã§ã¯rows_examinedã¯slow_query_logã§ã—ã‹ç¢ºèªã§ããªã„ã¯ãšperformance_schemaãŒæœ‰åŠ¹ãªã‚‰events_statements_historyã‚„ãã®ä»²é–“ãŸã¡ã§ç¢ºèªã§ãã‚‹ã¨ã®ã“ã¨*1 MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 22.9.6 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¤ãƒ™ãƒ³ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«)ã€‚ ä¾‹: ä¸Šã®ä¾‹ã®Beforeã¯ã€ã‚‚ã¨ã‚‚ã¨DBAãŒæ›¸ã„ãŸæ¸©ã‹ã¿ã®ã‚ã‚‹SQLã§O
kopug 2018/03/23
mysql

performance

tips
ãƒªãƒ³ã‚¯
ç‰©ç†ã‚µãƒ¼ãƒã‚’é¸å®šã™ã‚‹éš›ã®ãƒã‚¤ãƒ³ãƒˆ â€“ Eureka Engineering â€“ Medium
Eureka EngineeringLearn about Eurekaâ€™s engineering efforts, product developments and more.
kopug 2016/09/02
sql

tips
ãƒªãƒ³ã‚¯
PHPerã«çŸ¥ã£ã¦ã»ã—ã„RDBã®äº‹ ãã®3
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹é–¢è¥¿ 2016ã®è³‡æ–™ã§ã™ã€‚ http://conference.kphpug.jp/2016/
kopug 2016/08/15
MySQL

Tips
ãƒªãƒ³ã‚¯
æ¤œç´¢ã§ã¯ã‚ã‚“ã¾ã‚Šå‡ºãªã„bashã®ä¾¿åˆ©æŠ€ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
kopug 2015/09/21
bash

tips
ãƒªãƒ³ã‚¯
[Ruby on Rails]Active Job â€“ Sidekiqã‚’ä½¿ã£ã¦ã®Jobã®å®Ÿè¡Œ | DevelopersIO
ã¯ã˜ã‚ã« å…ˆæ—¥ã€Ruby on Rails 4.2ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ã“ã®ãƒªãƒªãƒ¼ã‚¹ã§æ–°ãŸã«è¿½åŠ ã•ã‚ŒãŸæ©Ÿèƒ½ã«Active JobãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã¯Active Jobã«ã¤ã„ã¦ã®ç°¡å˜ãªèª¬æ˜Žã¨ã€å®Ÿéš›ã«å‹•ã‹ã—ã¦ã¿ãŸã‚½ãƒ¼ã‚¹ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Active Jobã¨ã¯ Active Jobã«ã¤ã„ã¦ã€Rails Guideã‚ˆã‚Šä»¥ä¸‹ã®æ–‡ã‚’å¼•ç”¨ã—ã¾ã™ã€‚ Active Job is a new framework in Rails 4.2. It is a common interface on top of queuing systems like Resque, Delayed Job, Sidekiq, and more. Ruby on Rails 4.2 Release Notes Active Jobã¯ä¸€è¨€ã§è¡¨ã™ã¨ã€ã€Œã‚ãƒ¥ãƒ¼ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã€ã¨è¨€ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ã‚ãã¾ã§
kopug 2014/12/24
Ruby on Rails

Tips
ãƒªãƒ³ã‚¯
MacBookAirã§ä½¿ã£ã¦ã„ã‚‹ä¾¿åˆ©ãƒ„ãƒ¼ãƒ« vol.2 - Qiita
##æ¦‚è¦ ###Mac | Mavericks Mavericksã®è¨å®šã«ã¤ã„ã¦ã¯ã€ãƒ–ãƒã‚°ã§ã‚‚ä½•åº¦ã‹ç´¹ä»‹ã—ã¦ãã¾ã—ãŸã®ã§ã€å‰²ã¨ç°¡å˜ã«ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ä¸»ã«ã€ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’æ›¸ã„ã¦ã„ãã¾ã™ã€‚ ###Windows | Windows7 ç§ã®å ´åˆã€ãƒ¡ã‚¤ãƒ³ã¨ã—ã¦Cygwinã¨PowerShellã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ Windows7ã¯ã€ä»®æƒ³ç’°å¢ƒä¸Šã§å‹•ä½œã•ã›ã¦ã„ã¾ã™ã€‚ ã‚¢ãƒ—ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã€Chocolateyã§è¡Œã„ã¾ã™ã€‚ ãã®ä»–ã€Terminalã«Console Zã‚’ä½¿ã„ã¾ã™ã€‚ ###Linux | Manjaro Linux ç¾åœ¨ã€ã‚‚ã†ä¸€ã¤ã®MacBook Airã«ã¯ã€Manjaro Linuxã‚’ç›´æŽ¥ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚ ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ãƒžãƒãƒ¼ã‚¸ãƒ£ã¯ã€Awesomeã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ æœ€åˆã¯ã€Macã¨ã®ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ–ãƒ¼ãƒˆã—ã¦ã¿ãŸã®ã§ã™ãŒã€ã©ã†ã‚‚ã—ã£ãã‚Šæ¥ãªã‹ã£ãŸã®ã§ã€Macã¯æ¶ˆã—ã¾ã—ãŸã€‚éžå¸¸ã«å¿«é©
kopug 2014/04/19
ä¾¿åˆ©

Tips

mac

mavericks

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
installã‚³ãƒžãƒ³ãƒ‰ã§ã‚³ãƒžãƒ³ãƒ‰æ•°ã‚’æ¸›ã‚‰ã™ - @znz blog
mkdir ã¨ã‹ touch ã¨ã‹ chown ã¨ã‹ chmod ã¨ã‹å€‹åˆ¥ã«å®Ÿè¡Œã—ãªãã¦ã‚‚ install ã‚³ãƒžãƒ³ãƒ‰ã ã‘ã§ã¾ã¨ã‚ã¦å‡ºæ¥ã‚‹ã¨ã„ã†è©±ã§ã™ã€‚ å•é¡Œä¾‹ Dockerfile ã® RUN ãªã©ãŒå…¸åž‹çš„ãªä¾‹ã§ã™ãŒã€ä»–ã§ã‚‚ä¾‹ãˆã° mkdir -p /home/foo/.ssh; chown foo /home/foo/.ssh; chmod 0700 /home/foo/.ssh ã®ã‚ˆã†ãªã“ã¨ã‚’ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç‰¹ã« Dockerfile ã®å ´åˆã¯ RUN ã”ã¨ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒãŸã¾ã£ã¦ã„ãã“ã¨ã‚‚ã‚ã£ã¦ã€ ; ã‚„ && ã§ã¤ãªã’ã¦å˜ç‹¬ã® RUN ã«ã¾ã¨ã‚ã¦æ›¸ãã“ã¨ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ã€‚ install ã§ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œã‚‹ ãŸã¨ãˆã° mkdir -p /home/foo/.ssh chown foo /home/foo/.ssh chgrp users /home/foo/.ssh ch
kopug 2014/02/16
install

linux

tips
ãƒªãƒ³ã‚¯
Vimã§æ„å¤–ã«çŸ¥ã‚‰ãªã‹ã£ãŸ10ã¤ã®ã“ã¨ - ç´³å£«ãªãƒ–ãƒã‚°
ã™ã”ãã™ã”ãã™ã”ãä»Šã•ã‚‰ã§ã™ãŒã€vimtutorã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ ã¨ã¦ã‚‚ã‚ˆãã¾ã¨ã¾ã£ã¦ã„ã¦ã³ã£ãã‚Šã—ãŸã€‚ åŸºæœ¬çš„ãªå†…å®¹ã ã£ãŸã‘ã©ã€è‡ªå·±æµã§ã‚„ã£ã¦ã„ãŸã›ã„ã‹ æ„å¤–ã¨çŸ¥ã‚‰ãªã‹ã£ãŸã“ã¨ãŒã‚ã£ãŸã®ã§ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ä»Šã¾ã§ç„¡é§„ãªã“ã¨ã—ã¦ãŸãªã¨å°‘ã—åçœ(-_-;) % vimtutor ã‚ªãƒšãƒ¬ãƒ¼ã‚¿ã¨ãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ w - ã‚«ãƒ¼ã‚½ãƒ«ä½ç½®ã‹ã‚‰ç©ºç™½ã‚’å«ã‚€å˜èªžã®æœ«å°¾ã¾ã§ã€‚ e - ã‚«ãƒ¼ã‚½ãƒ«ä½ç½®ã‹ã‚‰ç©ºç™½ã‚’å«ã¾ãªã„å˜èªžã®æœ«å°¾ã¾ã§ã€‚ ãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½¿ç”¨ã™ã‚‹ 0ã‚’ã‚¿ã‚¤ãƒ—ã—ã¦è¡Œé ã«ç§»å‹• ^ã§ã‚‚æˆ»ã‚Œã¾ã™ãŒ0ã§ã‚‚æˆ»ã‚Œã‚‹ã¨ã„ã†ã“ã¨ã‚’ã™ã£ã‹ã‚Šå¿˜ã‚Œã¦ã„ãŸï¼å¾®å¦™ã«é•ã†ã®ã§å€‹äººçš„ã«ã¯^ãŒå¥½ãã§ã™ã€‚ å¤‰æ›´ã‚³ãƒžãƒ³ãƒ‰ ãƒŸã‚¹ã‚¿ã‚¤ãƒ—ã—ãŸå˜èªžã®é€”ä¸ã§cwã¨ã‚¿ã‚¤ãƒ—ã™ã‚‹ã¨ã€ãã®å˜èªžã®ã‚«ãƒ¼ã‚½ãƒ«ã‚ˆã‚Šå¾Œã‚ã®éƒ¨åˆ†ãŒæ¶ˆãˆã¦ã‚¤ãƒ³ã‚µãƒ¼ãƒˆãƒ¢ãƒ¼ãƒ‰ã«ãªã‚‹ã€‚ cw ã¯å˜èªžã‚’å¤‰æ›´ã™ã‚‹ã ã‘ã§ãªãã€æŒ¿å…¥ã‚‚è¡Œãˆã‚‹ç‚¹ãŒä¾¿åˆ©ã€‚ ä½ç½®ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã®æƒ…å ± ãƒ•ã‚¡ã‚¤ãƒ«å†…ã§ã®ä½ç½®ã¨ãƒ•ã‚¡ã‚¤
kopug 2013/04/21
vim

tips
ãƒªãƒ³ã‚¯
Photoshopã§40åˆ†ã‹ã‹ã£ã¦ã„ãŸä½œæ¥ãŒ5åˆ†ã§ã§ãã‚‹ã€Œç¥žé€ŸPhotoshopã€
çµæžœãŒåŒã˜ãªã‚‰éŽç¨‹ã¯ã©ã†ã§ã‚‚ã„ã„ã¨ã„ã†ã®ã¯å˜˜ã§ã€ã‚€ã—ã‚çµæžœãŒåŒã˜ãªã‚‰ç´ æ—©ã„æ–¹ãŒè‰¯ã„ã‚ã‘ã§ã™ã€‚ä½œæ¥ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã¨ã„ã†ã®ã¯ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã®ã‚¿ã‚¤ãƒ”ãƒ³ã‚°é€Ÿåº¦ã‚’ç‰©ç†çš„ã«é«˜é€ŸåŒ–ã—ãŸã‚Šã™ã‚‹ã“ã¨ã§ã¯ãªãã€ã€ŒåŠ¹çŽ‡åŒ–ã€ã™ã‚‹ã“ã¨ã§ç„¡é§„ã‚’çœãã€ã‚ˆã‚Šã‚¹ãƒžãƒ¼ãƒˆã«ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€Œæœ€å°é™ã®åŠ´åŠ›ã§æœ€å¤§é™ã®æˆæžœã‚’ä¸Šã’ã‚‹ã€ã“ã¨ã‚’å¯èƒ½ã«ã™ã‚‹æŠ€è¡“ã‚’ç¿’å¾—ã™ã‚‹ã“ã¨ã§ã‚ã‚Šã€ãã†ã„ã†ç‚¹ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã‚’çµžã‚Šè¾¼ã‚“ã æ›¸ç±ãŒã€Œç¥žé€ŸPhotoshopã€ã§ã™ã€‚ çŒ®æœ¬ã•ã‚ŒãŸå®Ÿç‰©ã®ãƒšãƒ¼ã‚¸ã‚’ã‚ãã‚‹ã¨æœ€åˆã«ç›®ã«é£›ã³è¾¼ã‚“ã§ãã‚‹ã®ãŒã“ã®ã€Œç¥žé€Ÿãƒ‡ã‚¶ã‚¤ãƒ³ äº”ã‚«æ¡ã€ã€‚ä¸èº«ã¯ã€Œã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚’æ´»ç”¨ã—ã‚ˆã†ã€ã€Œæœ€æ–°æ©Ÿèƒ½ã‚’ä½¿ã„ã“ãªãã†ã€ã€Œç›®çš„ã«ã‚ˆã£ã¦ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã„åˆ†ã‘ã‚ˆã†ã€ã€Œã€Œç›´ã—ã€ã«å¼·ã„ãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚ã†ã€ã€Œé¢å€’ãªä½œæ¥ã¯è‡ªå‹•åŒ–ã—ã‚ˆã†ã€ã¨ãªã£ã¦ãŠã‚Šã€ã©ã‚Œã‚‚ã“ã‚Œã‚‚ã†ãªãšã‘ã‚‹ã‚‚ã®ã°ã‹ã‚Šã€‚ ã€Œæœ¬æ›¸ã®ä½¿ã„æ–¹ã€ã®ã•ã‚‰ã«ä¸‹éƒ¨ã‚’è¦‹ã¦ã¿ã‚‹ã¨ã€Œæœ¬æ›¸ã®ä½œä¾‹ãƒ‡ãƒ¼ã‚¿ã¯ä»¥ä¸‹ã®URLã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™
kopug 2013/02/10
photoshop

ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ

TIPS

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
ã“ã‚Œã§ã‚ãªãŸã‚‚Macã‚®ãƒ¼ã‚¯ã«ãªã‚Œã‚‹ 30å€‹ã®ãƒãƒƒã‚¯é›† | Last Day. jp
ã¯ã˜ã‚ã«ã“ã‚Œã‚’èªã‚ã°åˆå¿ƒè€…ã®ã‚ãªãŸã‚‚Macã‚®ãƒ¼ã‚¯ã«ï¼ä¸Šç´šè€…ã®ã‚ãªãŸã‚‚çŸ¥ã‚‰ãªã„TipsãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ã€€ä»Šæ—¥ã¯30å€‹ã®Mac OSXã®Hacksã‚’ç´¹ä»‹è‡´ã—ã¾ã™ã€‚ Macã‚’æœ€å¤§é™ã«ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ãƒƒãƒ—ã•ã›ã‚‹23ã®æ–¹æ³• | Last Day. jp ã™ã¹ã¦ã®Macãƒ¦ãƒ¼ã‚¶ãƒ¼ã«è´ˆã‚‹ ä¾¿åˆ©ã§ã—ã‹ã‚‚ç„¡æ–™ãªMacã®ã‚¢ãƒ—ãƒª100å€‹ç´¹ä»‹ | Last Day. jp ã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„Macã®23ã®å°ãƒ¯ã‚¶é›† | Last Day. jp Dock Tricksæœ€è¿‘ä½¿ã£ãŸã‚¢ã‚¤ãƒ†ãƒ ã‚¹ã‚¿ãƒƒã‚¯æœ€è¿‘ä½¿ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è‡ªå‹•çš„ã«ã‚¹ã‚¿ãƒƒã‚¯ã«è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ï£¿ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ã€Žæœ€è¿‘ä½¿ã£ãŸé …ç›®ã€ã§ç¢ºèªã™ã‚‹ã€‚ã“ã‚Œã‚’ãƒ‰ãƒƒã‚¯ã«è¡¨ç¤ºã•ã›ã¾ã™ã€‚ ä¸Šè¨˜ç”»åƒã®ã‚ˆã†ã«ã™ã‚‹ã«ã¯ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’Terminalã«å…¥åŠ›ã—ã¦ãã ã•ã„ã€‚ Terminalã®å–ã‚Šæ‰±ã„ã«ã¯ã”æ³¨æ„ãã ã•ã„ã€‚ defaults write com.apple.d
kopug 2010/12/15
mac

tips
ãƒªãƒ³ã‚¯
less ã® tail -f ãƒ¢ãƒ¼ãƒ‰çš„ãªä½•ã‹ - å®‡å®™è¡ŒããŸã„
ä»Šã€è¡æ’ƒçš„ãªäº‹å®ŸãŒç¤¾å†… IRC ã«ä½•æ°—ç„¡ãæµã‚Œã¦ãŸã€‚ ã‚‚ã†ã€ã“ã‚Œã‚’çŸ¥ã‚‰ãªã‹ã£ãŸã›ã„ã§ç„¡é§„ã«ã—ãŸæ™‚é–“ã‚’æƒ³åƒã™ã‚‹ã ã‘ã§æ³£ããã†ã«ãªã£ãŸã€‚ id:sett-4 : (less ã§) shift+Fã§tail -fãƒ¢ãƒ¼ãƒ‰ã«ã€‚Ctrl+Cã§è„±å‡º ã‚‚ã†ã€æœ¬å½“ã©ã‚Œã ã‘ä»Šã¾ã§ã€ãã®äºŒã¤ã‚’è¡Œãæ¥ã—ã¦ã„ãŸã‹â€¦â€¦ orz
kopug 2010/12/09
linux

tips
ãƒªãƒ³ã‚¯
Macã‚’æœ€å¤§é™ã«ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ãƒƒãƒ—ã•ã›ã‚‹23ã®æ–¹æ³• | Last Day. jp
Macãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå¢—åŠ ã—ã¦ã„ã‚‹æœ€è¿‘ã¯iPhoneã®äººæ°—ã‚‚ã‚ã£ã¦Windowsãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰Macãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ãªã‚‹äººãŒåƒ•ã®å‘¨ã‚Šã§ã‚‚å¢—ãˆãŸã€‚åŸºæœ¬çš„ã«Mac OSã¯å®‰å®šã—ã¦ã„ã¦ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚‚ç”³ã—åˆ†ãªã„ã€‚ Macã‚’æ–°ã—ãæ¤œè¨Žã—ã‚ˆã†ã¨æ€ã£ã¦ã„ã‚‹æ–¹ã¯â†“ ãã‚“ãªMacã§ã‚‚é•·å¹´ä½¿ã£ã¦ã„ã‚Œã°èª¿åã®æ‚ªã„æ™‚ã‚‚ã§ã¦ãã‚‹ã ã‚ã†ã€‚ä»Šã¾ã•ã«è‡ªåˆ†ã®MacBook AirãŒè²·ã£ãŸã¨ãã«æ¯”ã¹ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒè½ã¡ã¦ã„ã‚‹ã®ã§è‰²ã€…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ãŸã‚‰å¤§åˆ†ã‚¹ãƒ”ãƒ¼ãƒ‰ã«å‘ä¸ŠãŒã¿ã‚‰ã‚ŒãŸã€‚MacãŒåƒ•ã®ã‚ˆã†ã«ä»¥å‰ã‚ˆã‚Šé…ããªã£ã¦ã—ã¾ã£ãŸæ–¹ã¯ä»¥ä¸‹ã®Tipsã‚’å‚è€ƒã—ã¦é ‚ã‘ãŸã‚‰å¹¸ã„ã§ã‚ã‚‹ã€‚ ã‚‚ã—ä¸‹è¨˜ã®ã™ã¹ã¦ã®æ–¹æ³•ã‚’è©¦ã—ã¦ã‚‚ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ãƒƒãƒ—ã—ãªã„å ´åˆã¯OSã®å†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚è¦–é‡Žã«å…¥ã‚ŒãŸæ–¹ãŒè‰¯ã„ã€‚ å†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚Œã°å¤§æŠµã®å•é¡Œã¯è§£æ±ºã•ã‚Œã‚‹ã€‚å†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ™‚ã«ã¯Time Machinesç‰ã‹ã‚‰ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å¾©å…ƒã™ã‚Œã°ç°¡å˜ã«ã§ãã‚‹ã€‚ 1.å®¹é‡ã®å¤§ãã„ãƒ•ã‚¡ã‚¤ãƒ«ã¯å¤–ä»˜ã‘ãƒ‡ãƒã‚¤
kopug 2010/09/21
mac

tips
ãƒªãƒ³ã‚¯
çŸ¥ã‚‰ãªã„äººã¯æã—ã¦ã‚‹ã¨æ€ã†Macã®ä½¿ã„æ–¹ Ctrl+2 - ã‚¹ãƒãƒ¼ãƒ é€Ÿå ±ã€€ï¼¶ï¼©ï¼°
ã‚¹ãƒãƒ¼ãƒ é€Ÿå ±ã€€ï¼¶ï¼©ï¼° ã‚ã®å¤ã®æ—¥ã€åƒ•ãŸã¡ã¯è¼ã„ã¦ã„ãŸã€‚
kopug 2010/09/20
mac

tips
ãƒªãƒ³ã‚¯
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰èªè¨¼
ã‚¹ãƒãƒ¼ãƒ é€Ÿå ±ã€€ï¼¶ï¼©ï¼° ã‚ã®å¤ã®æ—¥ã€åƒ•ãŸã¡ã¯è¼ã„ã¦ã„ãŸã€‚
kopug 2010/09/20
mac

tips
ãƒªãƒ³ã‚¯
JavaScriptã§iPhoneã‚¢ãƒ—ãƒªã‚’æ¥½ã€…ä½œæˆ
iPhoneã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ãŸã‚ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ãŒå¿…è¦ã ã¨æ€ã‚ã‚Œã¦ã„ã¾ã™ã€‚ Objective-Cã®çŸ¥è˜ (Cã®çŸ¥è˜ + ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜) iPhoneã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®çŸ¥è˜ ã“ã‚Œã‚‰ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ã®ã¯ã‹ãªã‚Šå¤§å¤‰ã§ã™ãŒã€ ã€ŒPhoneGapã€ã¨ã„ã†ã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ JavaScriptã ã‘ã‚’ä½¿ã£ã¦ç°¡å˜ã«ã‚¢ãƒ—ãƒªã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ iPhoneã®Safariã‹ã‚‰ JavaScriptãŒå‹•ãWebãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨iPhoneä¸Šã§JavaScriptãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å‹•ã‹ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªã€ŒWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¯Safariã®ä¸Šã§ã—ã‹å‹•ä½œã—ã¾ã›ã‚“ã—ã€ ãƒãƒƒãƒˆã«æŽ¥ç¶šã•ã‚Œã¦ã„ãªã„çŠ¶æ…‹ã§ã¯åˆ©ç”¨ã§ãã¾ã›ã‚“ã€‚ ã—ã‹ã—PhoneGapã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ JavaScriptãƒ—ãƒã‚°ãƒ©ãƒ ã¨Safariã‚’ã¾ã¨ã‚ã¦ã²ã¨ã¤ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç”Ÿæˆã™ã‚‹ã“ã¨ãŒã§ãã‚‹
kopug 2010/08/15
iphone

javascript

tips
ãƒªãƒ³ã‚¯
BLACKHOLEã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦InnoDBãªãƒ†ãƒ¼ãƒ–ãƒ«ã®æš–æ°—é‹è»¢ã‚’ã™ã‚‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ã©ã†ã‚‚ã“ã‚“ã«ã¡ã¯ã€‚å°å¤ªã‚Šç”·åä¸å¹´ã®ã‚µãƒ¼ãƒãƒ¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ å…ˆæ—¥è¡Œã‚ã‚ŒãŸhbstudy#13ã® [twitter:@nippondanji]ã•ã‚“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³(ã‚¹ãƒ©ã‚¤ãƒ‰) ã§ã€ã€ŒBLACKHOLEã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ãˆã°ã€InnoDBãªãƒ†ãƒ¼ãƒ–ãƒ«ã®æš–æ°—é‹è»¢(ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’ç©ºèªã¿ã—ã¦ã€buffer poolã«ä¹—ã£ã‘ã‚‹)ãŒã§ãã‚‹ã€ã¨ã„ã†è©±ãŒã‚ã£ãŸã®ã§ã€ã‚ãªã‚‹ã»ã©ãƒ¼ã¨æ€ã„è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ CREATE TABLE _preload LIKE huge_table; ALTER TABLE _preload ENGINE = BLACKHOLE; INSERT INTO _preload SELECT * FROM huge_table; DROP TABLE _preload;ãªã‚‹ã»ã©ãªã‚‹ã»ã©ã€‚
kopug 2010/08/12
mysql

tips

innodb
ãƒªãƒ³ã‚¯
Googleã‚¢ãƒ©ãƒ¼ãƒˆã§ä¸Šæ‰‹ã«ã‚µã‚¤ãƒˆã‚’ç®¡ç†ã™ã‚‹ä¾¿åˆ©ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | Moz - SEOã¨ã‚¤ãƒ³ãƒã‚¦ãƒ³ãƒ‰ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ã®å®Ÿè·µæƒ…å ±
ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®è¨å®šã«ã¤ã„ã¦å–ã‚Šä¸Šã’ãŸæŠ•ç¨¿ã‚„ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã¯ã€ã„ãã‚‰ã§ã‚‚ã‚ã‚‹ã€‚å¥½ã¿ã¯äººãã‚Œãžã‚Œã ãŒã€åƒ•ãŒæ°—ã«å…¥ã£ã¦ã„ã‚‹ã®ã¯ã€ãƒžãƒ¼ãƒ†ã‚£ãƒ»ãƒ¯ã‚¤ãƒ³ãƒˆãƒãƒ¼ãƒ–æ°ãŒaimClearã®ãƒ–ãƒã‚°ã«æŠ•ç¨¿ã—ãŸã€Œè©•åˆ¤ç®¡ç†ç”¨ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ä½œã‚Šæ–¹ã€ã¨ã„ã†è¨˜äº‹ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã ã€‚ ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã‚’æ‰±ã†æ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€Scout Labsã‚„Trackurãªã©æ•°ã‹æœˆã”ã¨ã«ç¶šã€…ã¨ç™»å ´ã—ã¦ã„ã¦ã€ãã®å¤šããŒéžå¸¸ã«å„ªã‚Œã¦ã„ã‚‹ã€‚ã—ã‹ã—å ´åˆã«ã‚ˆã£ã¦ã¯ã€ã“ã‚Œã‚‰ã®è£½å“ã‚’ä½¿ã†ã®ã¯ã€ã‚¹ãƒ¼ãƒ‘ãƒ¼ã«ç‰›ä¹³ã‚’è²·ã„ã«è¡ŒããŸã‚ã«ãƒ•ã‚§ãƒ©ãƒ¼ãƒªã‚’é‹è»¢ã—ã¦ã„ãã®ã¨åŒæ§˜ã®ã“ã¨ãŒã‚ã‚‹ã€‚ã¤ã¾ã‚Šã€ã™ã‚‹ã¹ãä½œæ¥ã¨æ¯”è¼ƒã—ã¦ãƒ‘ãƒ¯ãƒ¼ãŒã‚ã‚Šã™ãŽã€ä¸è¦ãªåŠ´åŠ›ãŒã‹ã‹ã£ã¦ã—ã¾ã†ã€‚å½“é¢ã®å¿…è¦æ€§ã«é©ã—ãŸã€æ‰‹æ—©ãç°¡å˜ãªã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã ã‘ã‚ã‚Œã°ã„ã„ã¨ã„ã†å ´åˆã‚‚ã‚ã‚‹ã‚“ã ã€‚ãã‚“ãªæ™‚ã«åƒ•ãŒä½¿ã£ã¦ã„ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ å¤§ä¼æ¥ã®ä¼šè¨ˆè²¬ä»»è€…ã¨ã‹ã€å€‹äººäº‹æ¥ã®è²¬ä»»è€…ãªã‚‰ã€ç¹°ã‚Šè¿”ã—
kopug 2010/08/09
google

seo

tips
ãƒªãƒ³ã‚¯
ã€å®Œå…¨ç‰ˆã€‘ã‚¢ãƒƒãƒ—ãƒ«éžå…¬é–‹ã€ŽiPhoneã€ã®éš ã—ã‚³ãƒžãƒ³ãƒ‰å…¨éƒ¨è¦‹ã›ã¾ã™ï¼ ãƒãƒƒãƒ†ãƒªå¯¿å‘½ãŒã®ã³ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚‚ã‚¢ãƒª â€“ ãƒã‚±ãƒƒãƒˆãƒ‹ãƒ¥ãƒ¼ã‚¹24ï¼ˆÎ²ï¼‰
2010å¹´8æœˆ7æ—¥ ã„ã¾ã¾ã§ã€Žã‚¢ãƒƒãƒ—ãƒ«ç¤¾ãŒå…¬é–‹ã—ã¦ã„ãªã„iPhoneã®éš ã—ã‚³ãƒžãƒ³ãƒ‰ã€ã¨ã€ŽiPhoneã«è£ãƒ¢ãƒ¼ãƒ‰ãŒå˜åœ¨ã—ãŸï¼ è£ãƒ¢ãƒ¼ãƒ‰çªå…¥ã®éš ã—ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¬é–‹ã€ã¨ã„ã†è¨˜äº‹ã‚’æŽ²è¼‰ã—ã¦ããŸãŒã€ã‚ã¾ã‚Šã«åéŸ¿ãŒå¤§ãã‹ã£ãŸãŸã‚å½“ç·¨é›†éƒ¨ã¯å¾¹åº•ã—ã¦éš ã—ã‚³ãƒžãƒ³ãƒ‰ã‚’èª¿æŸ»ï¼ã€€ã»ã¼ã™ã¹ã¦ã®éš ã—ã‚³ãƒžãƒ³ãƒ‰ã‚’ç™ºè¦‹ã—ãŸã®ã§ã€ã“ã“ã«ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚éš ...ã€å®Œå…¨ç‰ˆã€‘ã‚¢ãƒƒãƒ—ãƒ«éžå…¬é–‹ã€ŽiPhoneã€ã®éš ã—ã‚³ãƒžãƒ³ãƒ‰å…¨éƒ¨è¦‹ã›ã¾ã™ï¼ ãƒãƒƒãƒ†ãƒªå¯¿å‘½ãŒä¼¸ã³ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚‚ã‚¢ãƒª 2010å¹´8æœˆ7æ—¥ ã„ã¾ã¾ã§ã€Žã‚¢ãƒƒãƒ—ãƒ«ç¤¾ãŒå…¬é–‹ã—ã¦ã„ãªã„iPhoneã®éš ã—ã‚³ãƒžãƒ³ãƒ‰ã€ã¨ã€ŽiPhoneã«è£ãƒ¢ãƒ¼ãƒ‰ãŒå˜åœ¨ã—ãŸï¼ è£ãƒ¢ãƒ¼ãƒ‰çªå…¥ã®éš ã—ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¬é–‹ã€ã¨ã„ã†è¨˜äº‹ã‚’æŽ²è¼‰ã—ã¦ããŸãŒã€ã‚ã¾ã‚Šã«åéŸ¿ãŒå¤§ãã‹ã£ãŸãŸã‚å½“ç·¨é›†éƒ¨ã¯å¾¹åº•ã—ã¦éš ã—ã‚³ãƒžãƒ³ãƒ‰ã‚’èª¿æŸ»ï¼ã€€ã»ã¼ã™ã¹ã¦ã®éš ã—ã‚³ãƒžãƒ³ãƒ‰ã‚’ç™ºè¦‹ã—ãŸã®ã§ã€ã“ã“ã«ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚ éš ã—ã‚³ãƒžãƒ³ãƒ‰ã¨ã¯ã€ã€ŽiPhoneã€ã®é›»è©±ç•ªå·è¨˜å…¥
kopug 2010/08/08
iphone

tips
ãƒªãƒ³ã‚¯
Firebugã®æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ç´¹ä»‹ï¼ˆãƒ—ãƒã‚°ãƒ©ãƒžå‘ã‘ï¼‰ - KAYAC Engineers' Blog
ç¾Šæ¯›å¸ƒå›£ã‚’æ´—æ¿¯æ©Ÿã«ã‹ã‘ã‚‰ã‚Œãªã„ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚agoï¼ˆ@kyo_agoï¼‰ã§ã™ã€‚ æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ãŒå¤šã„ï¼ï¼ŸFirebugã®ä½¿ã„æ–¹ã‚’è¦‹ã¦ã€ãƒ—ãƒã‚°ãƒ©ãƒžå‘ã‘ã‚‚æ¬²ã—ããªã£ãŸã®ã§æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ 1. ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§ ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã§Firebugã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ http://getfirebug.com/wiki/index.php/Keyboard_and_Mouse_Shortcuts å–ã‚Šåˆãˆãšä»¥ä¸‹ã®äºŒã¤ã ã‘ã§ã‚‚è¦šãˆã¦ãŠãã¨åŠ¹çŽ‡çš„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ F12ã§Firebugã®æœ‰åŠ¹ã€ç„¡åŠ¹ã®åˆ‡ã‚Šæ›¿ãˆ åºƒã„ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ¢ãƒ¼ãƒ‰æ™‚ã«Ctrl+Enterã§ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œ ã¾ãŸã€ä»¥ä¸‹ã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã®å¤‰æ›´ã‚‚è¡Œãˆã‚‹ã®ã§ã€ä»–ã®æ‹¡å¼µç‰ã¨ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãŒã‹ã¶ã£ãŸå ´åˆã§ã‚‚åˆ¥ã®ã‚ãƒ¼ã§ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ 2. Firefoxæœ¬ä½“ã®ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã«ã€Œè¦ç´ ã‚’èª¿æŸ»ã€ãƒœã‚¿ãƒ³ Fi
kopug 2010/07/30
firebug

firefox

javascript

tips

debug
ãƒªãƒ³ã‚¯
æœ€è¿‘çŸ¥ã£ãŸLinux/UNIXã®å°æŠ€ - harryâ€™s memorandum
æœ€è¿‘çŸ¥ã£ã¦çµæ§‹ã‚·ãƒ§ãƒƒã‚¯ã‚’å—ã‘ãŸã€‚ touch hoge.txt ã¨ä¼¼ãŸã‚ˆã†ãªæ©Ÿèƒ½ã€‚*1 $ > hoge.txt $ ls -l hoge.txt -rw-r--r-- 1 root root 0 Jul 10 03:15 hoge.txt lessã§tail -f ãŒã§ãã‚‹ã€‚ $ sudo less +F /var/log/messages SSHã§ãƒªãƒ¢ãƒ¼ãƒˆã‚µãƒ¼ãƒã«å¯¾ã—ã¦è‰²ã€… ãƒªãƒ¢ãƒ¼ãƒˆå…ˆã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’sortã—ã¦æ¯”è¼ƒã€‚ãƒ‘ã‚¹ãƒ•ãƒ¬ãƒ¼ã‚ºãªã—ã«ã™ã‚‹ã‹ã€ssh-agentã‚’ä½¿ç”¨ã™ã‚‹ã‹ã—ã¦ãã ã•ã„ã€‚ $ diff <(sort /home/user/.bashrc) <(ssh user@hostname "sort /home/user/.bashrc") ãƒªãƒ¢ãƒ¼ãƒˆã‚µãƒ¼ãƒã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç·¨é›† $ vim scp://user@hostname//home/user/.bashrc sambaã®ã‚³ãƒžãƒ³ãƒ‰ã§
kopug 2010/07/11
linux

tips

command
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸