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

wozozo id:wozozo

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

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

ãƒªãƒ¢ãƒ¼ãƒˆã®ãƒžã‚·ãƒ³ã§ã€iptablesã§ãªã‚“ã‹ã„ã˜ã‚‹å‰ã«ä¿é™ºã‚’ã‹ã‘ã¦ãŠã - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
#!/bin/sh # ä¿é™ºã‚’ã‹ã‘ã‚‹ # echo '/root/clear-iptab' | at now + 3min # ã¨ã‹ # echo '/root/clear-iptab' | at 13:00 # ã§ã€‚ # # ãã—ãŸã‚‰ iptables ã§ãªã‚“ã‹ã„ã˜ã£ã¦ã€ # iptables ... (as you like) # æˆåŠŸã—ãŸã‚‰ at ã® job ã‚’å‰Šé™¤ã—ã¦ãŠã‚ã‚Šã€‚ # atq # atrm N # å¤±æ•—ã—ãŸã‚‰æ£åº§ã—ã¦ç¥ˆã‚‹ã€‚ iptables -F iptables -X iptables -Z iptables -P INPUT ACCEPT iptables -P OUTPUT ACCEPT iptables -P FORWARD ACCEPT è¿½è¨˜: 2010-01-09 http://ya.maya.st/d/201001a.html#s20100107_1 ã§è¨€
wozozo 2010/01/09
iptables

tips
ãƒªãƒ³ã‚¯
https://hgtip.com/
wozozo 2009/12/01
mercurial

tips
ãƒªãƒ³ã‚¯
rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãå ´åˆã®æ³¨æ„ç‚¹ - ã‚¹ã‚³ãƒˆãƒ—ãƒªã‚´ãƒ‹ã‚¨ãƒ•ã‚¹ã‚¯é€šä¿¡
MySQLã®rootãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãå ´åˆã€ #!/bin/bash mysqladmin -uroot -ptiger ping ã®ã‚ˆã†ã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆè‡ªä½“ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã§ã¯ãªãã€rootã®HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®.my.cnf(/root/.my.cnf)ã®ä¸ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æ›¸ãã€rootãƒ¦ãƒ¼ã‚¶ã«ã—ã‹èªã‚ãªã„ã‚ˆã†ã«600ã«ã—ã¦ãŠãã€‚ # cat > /root/.my.cnf [client] user = root password = tiger [mysqladmin] user = root password = tiger # chown root:root /root/.my.cnf # chmod 600 /root/.my.cnf ã¨ã€ã“ã“ã¾ã§ã¯ã„ã„ã®ã ãŒã€ãƒ†ã‚¹ãƒˆã¨ã—ã¦ã€ $ sudo mysqladmin ping mysqladmin: co
wozozo 2009/11/16
sudo -H .my.cnf

mysql

tips
ãƒªãƒ³ã‚¯
MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹
Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—MyISAMã«ã—ã‹ç„¡ã„æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„å ´åˆã¯MyISAMã‚’ä½¿ã†ã—ã‹ãªã„ ãƒ»å…¨æ–‡æ¤œç´¢ (Tritonnã‚„Sphinx) ãƒ»GIS â—InnoDBã®åˆ©ç‚¹(MyISAMã®æ¬ ç‚¹) â–²éšœå®³å¯¾å¿œç³» ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚‚å†èµ·å‹•ã™ã‚‹ã ã‘ã§ãƒªã‚«ãƒãƒªãŒã§ãã‚‹ ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã«ã‹ã‹ã‚‹æ™‚é–“ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«æ¯”ä¾‹ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯ãªãã€ã‚³ãƒŸãƒƒãƒˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¿®å¾©ã§ãã‚‹ (å·¨å¤§ãªMyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®REPAIRã«ã¯æ•°æ—¥å˜ä½ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚‹) ãƒ»ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã§ãã‚‹ ãƒ»INSERTã‚„LOAD DATAãªã©ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹é€”ä¸ã§Ctrl+Cã§ãã®æ›´æ–°ç³»SQLæ–‡ã‚’æ¢ã‚ã¦ã‚‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å£Šã‚Œãªã„ã—ã€ä¸é€”åŠç«¯ãªçŠ¶æ…‹ã§æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã‚‚ç„¡ã„ã—ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒæ¢ã¾ã‚‹ã“ã¨ã‚‚ç„¡ã„ â–²æ€§èƒ½ç³» ãƒ»è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ä¸¦åˆ—æ€§ãŒé«˜ã„(MyISAMã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯)ã€‚ã¾ãŸSEL
wozozo 2009/10/29
mysql

tips
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®ä½¿ç”¨ä¾‹ - ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ãŒä½Žã„ã‚«ãƒ©ãƒ ã‚’ä½¿ã£ã¦æ¤œç´¢ã™ã‚‹å ´åˆ
MySQL 5.1ã§è¿½åŠ ã•ã‚ŒãŸæ©Ÿèƒ½ã«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ãŒã‚ã‚‹ã€‚ã“ã‚Œã¯é©åˆ‡ã«åˆ©ç”¨ã™ã‚Œã°éžå¸¸ã«å¼·åŠ›ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã“ã¨ã¯é–“é•ã„ãªã„ã®ã ãŒã€ä½¿ã„ã©ã“ã‚ãŒé›£ã—ã„ã€‚ãªãœãªã‚‰ã€ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚‹ã ã‘ã§ã‚«ãƒãƒ¼å‡ºæ¥ã‚‹å ´åˆãŒå¤šã„ã€‚ ãƒ‘ãƒ¼ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’ä½¿ã‚ãšã«ã€å˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ†ã‘ã¦ã—ã¾ãˆã°ã„ã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå·¨å¤§ã«ãªã‚‰ãªã„ã¨ã‚ã¾ã‚ŠåŠ¹æžœã‚’å®Ÿæ„Ÿã§ããªã„ã€‚ ä½¿ã„æ–¹ã‚’é–“é•ãˆã‚‹ã¨æ€§èƒ½ãŒè½ã¡ã¦ã—ã¾ã†ã€‚ ãªã©ã®å•é¡ŒãŒã‚ã‚‹ã‹ã‚‰ã ã‚ã†ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šæ—¥ã¨æ˜Žæ—¥ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ãŒå½¹ã«ç«‹ã¤ã‚·ãƒ¼ãƒ³ã‚’2ã¤ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã†ã€‚ä»Šæ—¥ã¯ä¸€ã¤ç›®ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ãŸã„ã‚«ãƒ©ãƒ ã®ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ãŒä½Žã„å ´åˆã ã€‚ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ã¨ã¯æ—¥æœ¬èªžã«è¨³ã™ã¨æ¿ƒåº¦ã¨ã‹è¨³ã•ã‚Œã‚‹ãŒã€è¦ã¯å€¤ã®ç¨®é¡žï¼ˆåˆ†æ•£å…·åˆï¼‰ã®ã“ã¨ã§ã‚ã‚‹ã€‚ä¾‹ãˆã°ã€Yesã‹Noã®2ã¤ã®å€¤ã—ã‹ã¨ã‚‰ãªã„ã‚«ãƒ©ãƒ ã¯éžå¸¸ã«ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ãŒä½Žãã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚‹ã¨ã¨ã¦ã‚‚åŠ¹çŽ‡ãŒæ‚ªã„ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦ç›®çš„ã®è¡Œã‚’
wozozo 2009/10/09
mysql

performance

tips
ãƒªãƒ³ã‚¯
ï¼»Snow Leopardï¼½âŒ˜+ã‚¹ãƒšãƒ¼ã‚¹ã§å…¥åŠ›åˆ‡ã‚Šæ›¿ãˆã™ã‚‹éš›ã«è¡¨ç¤ºã•ã‚Œã‚‹ã€Œã‚¹ã‚¯ãƒªãƒ—ãƒˆåˆ‡ã‚Šæ›¿ãˆã€ã‚’æ¶ˆã™æ–¹æ³• ãã®2 - ãƒã‚¿ãƒ•ãƒ«
å…ˆã»ã©ã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ãŸå¾Œã«ã€ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã§æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ â–¼Twitter / Yusuke Narita: @kogure ç§ã®ç’°å¢ƒã§ã¯ã€Œã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®š â€“ â€¦ ç§ã®ç’°å¢ƒã§ã¯ã€Œã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®š â€“ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ â€“ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ â€“ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã¨æ–‡å—å…¥åŠ›ã€ã§ã€ã€Œå…¥åŠ›ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã®æ¬¡ã®ã‚½ãƒ¼ã‚¹ã‚’é¸æŠžã€ã«âŒ˜+ã‚¹ãƒšãƒ¼ã‚¹ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€Œã‚¹ã‚¯ãƒªãƒ—ãƒˆåˆ‡ã‚Šæ›¿ãˆã€ãŒæ¶ˆãˆã¾ã—ãŸã‚ˆãƒ¼ã€‚ â–¼Twitter / Yusuke Narita: @kogure è¿½è¨˜: ã€Œã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®š â€“ è¨€èªž â€¦ è¿½è¨˜: ã€Œã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®š â€“ è¨€èªžã¨ãƒ†ã‚ã‚¹ãƒˆ â€“ å…¥åŠ›ã‚½ãƒ¼ã‚¹ã€ã§ã‚«ã‚¿ã‚«ãƒŠã‚’OFFï¼ˆè‹±å—ã¨ã²ã‚‰ãŒãªã®ã¿ãƒã‚§ãƒƒã‚¯ã•ã‚ŒãŸçŠ¶æ…‹ï¼‰ã«ã™ã‚‹å¿…è¦ã‚‚ã‚ã‚Šã¾ã™ã€‚ â–¼Twitter / Yusuke Narita: @kogure ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§ã€Œå‰ã®å…¥åŠ› â€¦ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§ã€Œå‰ã®å…¥åŠ›ã‚½ãƒ¼ã‚¹ã‚’é¸æŠžã€ã«
wozozo 2009/09/02
ime

mac

tips
ãƒªãƒ³ã‚¯
Top 10 tips to a new django developer : Dpeepul Blog
1.Donâ€™t put project nameÂ in the imports For example suppose say you have an app â€œxyzâ€ inÂ the project say â€œproject3â€ then donâ€™t sayÂ 1: from project3.xyz.models import Author It ties the project name to your app which has several disadvantages like 1.You canâ€™t easily reuse the app. 2.In future if you want to change the project name it becomes difficult. Instead do this. 1: from xyz.models import
wozozo 2009/08/31
django

tips
ãƒªãƒ³ã‚¯
ç´°ã‹ã™ãŽã¦ä¼ã‚ã‚‰ãªã„jQueryã®æ©Ÿèƒ½5é¸ - KAYAC Engineers' Blog
å®Ÿã¯æŠ€è¡“éƒ¨ã§ã¯ãªãã€æ¼”å‡ºéƒ¨æ‰€å±žã®agoã§ã™ã€‚ å…ˆæ—¥jQuery 1.3.2ã®ã‚½ãƒ¼ã‚¹ã‚’èªã‚€æ©Ÿä¼šãŒã‚ã‚Šã€ãã®ã¨ãã„ãã¤ã‹æ°—ã¥ã„ãŸã“ã¨ãŒã‚ã£ãŸã®ã§ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ 1 .addClass, removeClassã¯ã‚¹ãƒšãƒ¼ã‚¹åŒºåˆ‡ã‚Šã§è¤‡æ•°ã®classã‚’æ¸¡ã›ã‚‹ .addClass, removeClassã«ã¯ã‚¹ãƒšãƒ¼ã‚¹åŒºåˆ‡ã‚Šã§è¤‡æ•°ã®class nameãŒæ¸¡ã›ã¾ã™ã€‚ //classã®é †ç•ªã¯ä¿æŒã—ã¾ã™ã€‚ //<div class="hoge gege">ãŒã‚ã£ãŸå ´åˆã€<div class="hoge gege huga">ã«ãªã‚Šã¾ã™ã€‚ $('div').addClass('hoge huga'); //<div class="hoge gege huga">ãŒã‚ã£ãŸå ´åˆã€<div class="gege">ã«ãªã‚Šã¾ã™ã€‚ $('div').removeClass('hoge huga'); ãŸã ã—ã€hasC
wozozo 2009/08/15
jquery

tips
ãƒªãƒ³ã‚¯
JavaScriptæ£è¦è¡¨ç¾ãƒ¡ãƒ¢ã€‚ (JavaScriptã§ã‚ˆãä½¿ã†æ›¸ãæ–¹ã€‚) - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ã‚¿ã‚¤ãƒˆãƒ«å¤‰ãˆã¾ã—ãŸã€‚æ—§ã‚¿ã‚¤ãƒˆãƒ«ã€ŒJavaScriptã§ã‚ˆãä½¿ã†æ›¸ãæ–¹ã€ã€‚ã‚ˆãä½¿ã†ã‘ã©æ¯Žå›žå¿˜ã‚Œã‚‹ã€‚ æ£è¦è¡¨ç¾ã«ãƒžãƒƒãƒã™ã‚‹ã‹ã©ã†ã‹ã€‚ RegExp#testã‚’ä½¿ã†ã€‚ /abc/.test("abcdefg") // => true String#searchã¯ãƒžãƒƒãƒã—ãŸä½ç½®ã‚’è¿”ã™ã€‚ãƒžãƒƒãƒã—ãªã„å ´åˆã¯-1ã€‚å…ˆé ã«ãƒžãƒƒãƒã™ã‚‹ã¨0ã§falseãªã®ã§æ³¨æ„ã€‚çœŸå½å€¤ãŒæ¬²ã—ã„å ´åˆã¯String#searchã‚’ä½¿ã‚ãªã„ã€‚ "abcdefg".search(/xxx/) // => -1 "abcdefg".search(/def/) // => 3 "abcdefg".search(/abc/) == false // => true æ£è¦è¡¨ç¾ã®éƒ¨åˆ†ãƒžãƒƒãƒã‚’å¾—ã‚‹ã€‚ éƒ¨åˆ†ãƒžãƒƒãƒã‚’å¾—ã‚‹ã«ã¯ã€RegExp#execã‹String#matchã‚’ä½¿ã†ã€‚execã¨matchã®é€Ÿåº¦ã¯å¤§ã—ã¦å¤‰ã‚ã‚‰ãªã„ã€‚ æ£è¦è¡¨ç¾ã®ãƒ™ãƒ³ãƒãƒžãƒ¼
wozozo 2009/06/01
javascript

tips
ãƒªãƒ³ã‚¯
PostgreSQL ã®åˆæ©çš„ Tips 3ã¤ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
æœ€è¿‘ãªã‚“ã ã‹èƒƒã®èª¿åãŒæ‚ªã„ã®ã§ã‚µãƒ—ãƒªãƒ¡ãƒ³ãƒˆãªã‚‹ã‚‚ã®ã«æ‰‹ã‚’å‡ºãã†ã¨ã—ã¦ã„ã‚‹ kimoto ã§ã™ã€‚ ã‚ã¨é‹å‹•ã‚‚ã—ã¦ã¾ã™ã€‚ã‚„ã›ã‚‹ãžï¼ ã¾ã‚ãã‚Œã¯å‰²ã¨ã©ã†ã§ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ä»¥å‰ã«MySQL ã®åˆæ©çš„ Tips 3ã¤ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã€PostgreSQL ã ã¨ã©ã†ã™ã‚‹ã‚“ã ã‚ï¼Ÿã£ã¦ã„ã†è³ªå•ãŒã‚ã‚Šã¾ã—ãŸã®ã§ã€ã¡ã‚‡ã£ã¨æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã®è¡¨ç¤ºã‚’ç«‹ã¦ä¸¦ã³ã«ã™ã‚‹ ã“ã‚Œã¯ã€MySQL ã®å ´åˆã¯ã‚¯ã‚¨ãƒªã®æœ€å¾Œã«ã€Œ\Gã€ã‚’ä»˜ã‘ã‚‹äº‹ã§å¯èƒ½ã§ã—ãŸã€‚ ã“ã¡ã‚‰ã€PostgreSQL ã®å ´åˆã¯ã€Œ\xã€ã‚’ã‚³ãƒžãƒ³ãƒ‰ã—ã¾ã™ã€‚ãƒã‚¤ãƒ³ãƒˆã¯ã€ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã¯ã‚¹ã‚¤ãƒƒãƒã«ãªã£ã¦ã„ã¦ã€æœ€å¾Œã«ä»˜ã‘ã‚‹ã®ã§ã¯ãªãã“ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’æ‰“ã¤ãŸã³ã« on ã¨ off ãŒåˆ‡ã‚Šæ›¿ã‚ã‚‹ã¨ã„ã†äº‹ã§ã™ã€‚ dbname=# SELECT * FROM member; id | name | gender | age | blood | pos
wozozo 2009/04/22
postgresql

tips
ãƒªãƒ³ã‚¯
postgreSQLã§ï¼¤ï¼¢ã®ã‚µã‚¤ã‚ºã‚’ç¢ºèªã—ãŸã„å ´åˆ - PictNotes - ãƒ”ã‚¯ãƒˆãƒŽãƒ¼ãƒ„
vacuumedb -f (full)ã€€ã¯ã€ã§ããªã„ã‘ã©ã€ï¼¤ï¼¢ã®å†åˆ©ç”¨é ˜åŸŸã¯çŸ¥ã‚ŠãŸã„å ´åˆ pg_database_sizeã€€ã¨ pgstattuple (contribã«ã‚ã‚Šã¾ã™) ã®2ã¤ã®ã‚³ãƒžãƒ³ãƒ‰ ã‚’ä½¿ã†ã¨ã„ã„ ä½¿ã„æ–¹ã¯ã€ï¼¤ï¼¢ã«å…¥ã£ã¦ã€ dbname=# select pg_database_size('databasename'); pg_database_size ------------------ 49801171592 dbname=#select * from pgstattuple('tablename'); table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free
wozozo 2009/04/01
postgresql

tips
ãƒªãƒ³ã‚¯
MacBookã®ãƒ¡ãƒ¢ãƒªã‚’4GBã«ã€‚
2011/07/30:Â [è¿½è¨˜11]ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2011/07/22: [è¿½è¨˜10]ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ å…ˆæ—¥è³¼å…¥ã—ãŸMacBookï¼ˆlate 2008ï¼‰ã€‚è³¼å…¥æ™‚ã«RAMã‚’4GBã«ã™ã‚‹è€ƒãˆã‚‚ã‚ã£ãŸã®ã§ã™ãŒã€Xcodeãƒ¡ã‚¤ãƒ³ã§ä½¿ã†åˆ†ã«ã¯2GBã§ååˆ†ã ã‚ã†ã¨æ€ã£ã¦ã„ã¦ã€ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ãªã—ã«è³¼å…¥ã—ã¾ã—ãŸã€‚å®Ÿéš›ã€ãƒ¡ãƒ¢ãƒªã¯2GBã§ååˆ†ã ã£ãŸã‚“ã§ã™ãŒã€Safariã‚’èµ·å‹•ã—ãŸã‚Šã€Versionsï¼ˆsubversionã®GUI ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ï¼‰ã€ãã®ä»–ã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ãƒãƒ¼å¸¸é§ã‚¢ãƒ—ãƒªã‚’åŒæ™‚ã«ä½¿ã£ã¦ã„ã‚‹ã¨ã€ã©ã†ã—ã¦ã‚‚æœ€å¤§ãƒ¡ãƒ¢ãƒªã®75%ãã‚‰ã„ã¯æ¶ˆè²»ã—ã¦ã—ã¾ã†ã®ã§ã€ã“ã‚Œã¯é…ã‹ã‚Œæ—©ã‹ã‚Œå¢—è¨ã—ãŸæ–¹ãŒã„ã„ãªã¨æ€ã„ã€è‡ªåˆ†ã§ç°¡å˜ã«å¢—è¨ã§ãã‚‹ã“ã¨ã‹ã‚‰ã€ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£è£½ãƒ¡ãƒ¢ãƒªã‚’è³¼å…¥ã—ã¦4GBã«ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ç²¾å¯†ãƒ‰ãƒ©ã‚¤ãƒã‚‚è²·ã†ãƒãƒ¡ã«ãªã‚Šã¾ã—ãŸãŒã€ã‚ã‚Œã°ã‚ã£ãŸã§ä¾¿åˆ©ãªã®ã§ã€ãã‚Œã¯è‰¯ã—ã¨ã—ã¾ã—ã‚‡ã†ã€‚ å¢—è¨å¾Œã¯æ°—åˆ†çš„ã«ï¼ˆç¬‘ï¼‰éžå¸¸ã«å¿«é©ã§
wozozo 2009/02/18
PRAMÃ£Â‚Â’Ã£Â‚Â¯Ã£ÂƒÂªÃ£Â‚Â¢

mac

tips
ãƒªãƒ³ã‚¯
æºå¸¯3ã‚ãƒ£ãƒªã‚¢ã®è¿·æƒ‘ãƒ¡ãƒ¼ãƒ«ãƒ•ã‚£ãƒ«ã‚¿ãƒ¼è¨å®šURL | Apelog
DoCoMo http://imutl.ezweb.ne.jp/cgi2001/utl_menu.cgi AU http://docomo.ne.jp/cp/mailsetst.cgi SoftBank http://elinks.softbank.ne.jp/selfcare
wozozo 2009/02/15
è¿·æƒ‘ãƒ¡ãƒ¼ãƒ«ãƒ•ã‚£ãƒ«ã‚¿ è¨å®šURL

mobile

tips
ãƒªãƒ³ã‚¯
void GraphicWizardsLair( void ); // wwwæŠœãã®ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’wwwä»˜ãã«ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã™ã‚‹httpd.conf
wozozo 2009/02/13
apache

redirect

tips
ãƒªãƒ³ã‚¯
iPython ã§ã¡ã‚‡ã£ã¨ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã¨ã‹ - äººç”Ÿã„ãã‚ãŸã‚Šã°ã£ãŸã‚Šã§ç”Ÿãã¦ã¾ã™@ã¯ã¦ãª
ãªã‚“ã‹è‰²ã€…ä¾¿åˆ©ãã†ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã¨ã‹ã‚³ãƒžãƒ³ãƒ‰è¦‹ã£ã‘ã¦ãŸã®ã§å‚™å¿˜éŒ²çš„ã«ãƒ¡ãƒ¢ã€‚% ã¤ã„ã¦ã‚‹ã‚„ã¤ã¯ Magic Function ã¨ã‹ã„ã†ã‚‰ã—ã„ã€‚ é–¢æ•°å®Ÿè¡Œã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ ã‹ã£ã“ã¯çœç•¥ã§ãã‚‹ã‚‰ã—ã„ã€‚åˆã‚ã¦çŸ¥ã£ãŸã€‚ ã€Œ/ã€ã§ã•ã‚‰ã«å¼•æ•°ã®ã€Œ,ã€ã‚’çœç•¥ã€‚ã€Œ,ã€ã§å¼•æ•°ã‚’æ–‡å—åˆ—ã«å¤‰æ›ã€‚ # ã‹ã£ã“çœç•¥ã§å®Ÿè¡Œ In [23]: sample 1, 2 -------> sample(1, 2) # ã•ã‚‰ã«å¼•æ•°ã®ã€Œ,ã€çœç•¥ã§å®Ÿè¡Œ In [24]: /sample 1 2 -------> sample(1,2) # å¼•æ•°ã‚’æ–‡å—åˆ—ã«å¤‰æ›ã—ã¦å®Ÿè¡Œ In [25]: ,sample 1 2 -------> sample("1", "2") åå‰ç©ºé–“é–¢é€£ %who, %whos, %who_ls, %reset ã‚’ä½¿ã†ã€‚ ã©ã®å¤‰æ•°ã«ä½•ã‚’å…¥ã‚ŒãŸã®ã‹å¿˜ã‚Œã¦ã—ã¾ã£ãŸã¨ãã¨ã‹ä¾¿åˆ©ã€‚ã‚ã‚“ã©ããªã£ãŸã‚‰ãƒªã‚»ãƒƒãƒˆã‚‚å¯èƒ½ã€‚ #
wozozo 2009/02/07
python

shell

tips
ãƒªãƒ³ã‚¯
Flashã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãª16å€‹ã®é–“é•ã£ãŸä½¿ã„æ–¹ | ClockMaker Blog
Photoshopã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãª12å€‹ã®é–“é•ã£ãŸä½¿ã„æ–¹ â€“ GIGAZINEãŒé¢ç™½ã‹ã£ãŸã®ã§ã€Flashç‰ˆã¨ã—ã¦ã€ŒFlashã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãª16å€‹ã®é–“é•ã£ãŸä½¿ã„æ–¹ã€ã¨ã—ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ 1.ã‚·ãƒ³ãƒœãƒ«åŒ–ã—ãªã„ã¾ã¾ãƒˆã‚¥ã‚¤ãƒ¼ãƒ³ã‚’ä½œæˆã—ã¦ã„ã‚‹ ã¾ãšã¯èª°ã§ã‚‚ä¸€åº¦ã¯ã‚„ã£ãŸã“ã¨ãŒã‚ã‚‹ã§ã‚ã‚ã†ã€ã‚·ãƒ³ãƒœãƒ«åŒ–ã—ãªã„ã¾ã¾ã®ãƒˆã‚¥ã‚¤ãƒ¼ãƒ³ä½œæˆã€‚ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã€Œãƒˆã‚¥ã‚¤ãƒ¼ãƒ³â—‹ã€ã¨ã„ã†åã‚‚ãªãã‚·ãƒ³ãƒœãƒ«ãŒä½œæˆã•ã‚Œã€å¾Œã§è¦‹è¿”ã—ãŸã¨ãã‚„ä»–ã®å…±åŒä½œæ¥è€…ãŒéžå¸¸ã«å›°ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ 2.ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«ç›´æŽ¥ãƒªãƒ³ã‚¯URLã‚’è¨å®šã—ã¦ã„ã‚‹ getURLã‚„navigateToURLãªã‚“ã¦ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’çŸ¥ã‚‰ãªã„åˆå¿ƒè€…ã®ã“ã‚ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«URLã‚’ã„ã‚Œã¦ãƒ†ã‚ã‚¹ãƒˆãƒªãƒ³ã‚¯ã‚’ä½œã£ã¦ã„ã¾ã—ãŸã€‚ã“ã‚Œã¯æ¼”å‡ºãŒä½œã‚Œãªã„ã®ã§ã€æ…£ã‚Œã¦ãã‚‹ã¨ä½¿ã†ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ 3.æ–‡å—ã‚’ãƒœã‚¿ãƒ³ã«å«ã‚ãŸã¨ãã«å¾Œã‚ã«ã‚·ã‚§ã‚¤ãƒ—ã‚’æ•·ã„ã¦ã„ãªã„ ãƒœã‚¿ãƒ³ã‚’ä½œã£ãŸã¨ã
wozozo 2009/01/17
tips

flash
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
wozozo 2009/01/10
javascript

tips
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨ä½¿ãˆã‚‹MySQLã®å°æŠ€5ã¤+1
ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ã‚¬ã‚¹ã‚’æ¢ã‚ã‚‰ã‚Œæ¸©ã‚‚ã‚Šã®ç„¡ã„ç”Ÿæ´»ã‚’é€ã£ã¦ã„ã‚‹æ¾ç”°ã§ã™ã€‚ ä»Šå›žã¯æœ€è¿‘è‡ªåˆ†ãŒçŸ¥ã£ãŸMySQLã®å°æŠ€ã‚’ã„ãã¤ã‹æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ã‚“ãªã‚‚ã‚“å¸¸è˜ã ã‚ï¼ã£ã¦ãƒã‚¿ãŒã‚ã£ã¦ã‚‚å„ªã—ãè¦‹å®ˆã£ã¦ã‚ã’ã¦ãã ã•ã„ã€‚ ã¾ãšä»Šå›žã®å®Ÿè¡Œã‚µãƒ³ãƒ—ãƒ«ã«ã¯ä»¥ä¸‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦ã¾ã™ã€‚ mysql>Â SELECTÂ *Â FROMÂ user_m; +---------+----------+---------------------+ |Â user_idÂ |Â nameÂ Â Â Â Â |Â create_datetimeÂ Â Â Â Â | +---------+----------+---------------------+ |Â Â Â Â Â Â Â 1Â |Â atsushiÂ Â |Â 2007-05-17Â 21:53:40Â | |Â Â Â Â Â Â Â 2Â |Â joeÂ Â Â Â Â Â |Â 2007-05-17Â 21:53:59Â | |Â Â Â Â Â Â Â 3Â |Â masah
wozozo 2009/01/10
mysql

tips

sql
ãƒªãƒ³ã‚¯
FireBugã®ä¾¿åˆ©ãªæ©Ÿèƒ½
æœã ã€æœã ã€æ™¦æ—¥ãªã®ã«æœã ã€å°å ¤ã§ã™ã€‚ ExtJSã ã‘ã§ãªãã€JavaScriptã§ã®é–‹ç™ºã«ã¯FireBugæ¬ ã‹ã›ã¾ã›ã‚“ãã€‚ ã—ã‹ã—ã€Console APIã€console.logã¨ã‹console.debugä»¥å¤–ä½¿ã£ã¦ã„ã¾ã™ã‹ï¼Ÿ å…ˆæ—¥ã€ExtJSã®å‹‰å¼·ä¼šã§console.dirã«ã¤ã„ã¦ã¡ã‚‡ã“ã£ã¨çµ‚ã‚ã£ãŸå¾Œã«ãƒ‡ãƒ¢ã£ãŸã‚“ã§ã™ãŒã€å¥½è©•ã§ã—ãŸã®ã§ã€è¿½è¨˜ã£ã¦ã“ã¨ã§ã€‚ console.dirã¯ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’DOMã‚¿ãƒ–ã§è¡¨ç¤ºã—ã¦ã„ã‚‹ã‚ˆã†ã«ã€ãƒ„ãƒªãƒ¼ä¸Šã«ä¸€æ°—ã«è¡¨ç¤ºã—ã¦ãã‚Œã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ç¢ºèªæ™‚ã€æ·±ã„ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ã„ã¡ã„ã¡ã‚¯ãƒªãƒƒã‚¯ã—ãªã„ã§ã€ã¾ã¨ã‚ã¦è¡¨ç¤ºã§ãã‚‹ã£ã¦ã‚ã‘ã§ã™ã‚ã€‚ ã‚“ã§ã€ä»Šæ—¥ã¯ã€ï¼“ã¤ã»ã©ã€‚ ã‚°ãƒ«ãƒ¼ãƒ—ã«ã¾ã¨ã‚ã¦è¡¨ç¤º å®Ÿè¡Œæ™‚é–“ã‚’è¨ˆæ¸¬ã™ã‚‹ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã™ã‚‹ ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚°ãƒ«ãƒ¼ãƒ—ã«ã¾ã¨ã‚ã¦è¡¨ç¤º console.group(Â â€˜ã‚°ãƒ«ãƒ¼ãƒ—åâ€™ ); ï½žFireBugã®ConsoleAPIã‚’å®Ÿè¡Œï½ž
wozozo 2008/12/30
firebug

tips
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
ç§ã®å°ã•ãªãƒ©ã‚¤ãƒ•ãƒ¯ãƒ¼ã‚¯ã€‚è‡ªåˆ†ãŒæ’®ã£ãŸå†™çœŸã§ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚’ä½œã‚‹ã€‚ æ¯Žå¹´ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚’ä½œã£ã¦ã¾ã™ 2024å¹´ã‚‚æ®‹ã‚Š10æ—¥ã€‚æ—©ã„ã§ã™ãã€‚å¹´æœ«ã«ãªã‚‹ã¨ã€ç§ã¯ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚’åˆ¶ä½œã—ã¦ã„ã¾ã™ã€‚è‡ªåˆ†ãŒæ’®å½±ã—ãŸå†™çœŸã‚’é¸ã‚“ã§ã€ç¿Œå¹´ã®ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã«ã™ã‚‹ã®ã§ã™ãŒã€ã‹ã‚Œã“ã‚Œ10å¹´ä»¥ä¸Šç¶šã„ã¦ã„ã¾ã™ã€‚2025å¹´ã®ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚‚ç„¡äº‹ï¼ˆï¼Ÿï¼‰å®Œæˆã—ã¾ã—ãŸã€‚ å†™çœŸã‚’é¸ã‚“â€¦
wozozo 2008/12/23
flex

tips
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 æ¬¡ã®ãƒšãƒ¼ã‚¸