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

hacked id:hacked

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

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

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜
â– ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(ç´¢å¼•)ã¨ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ é«˜é€Ÿã«å–ã‚Šå‡ºã™ç‚ºã®ä»•çµ„ã¿ã‚’æ„å‘³ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦SQLæ–‡ã®å¿œç”æ™‚é–“ãŒåŠ‡çš„ã«æ”¹å–„ ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¯B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¯ã˜ã‚ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ãŒã€ã“ã“ã§ã¯æœ€ã‚‚ä¸€èˆ¬çš„ã«ä½¿ã‚ã‚Œã€ã‹ã¤ ã»ã¨ã‚“ã©ã®DBMSã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ â€» CREATE INDEXæ–‡ã§ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã—ãªã„å ´åˆã¯é€šå¸¸B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒ ä½œæˆã•ã‚Œã¾ã™ã€‚ â– B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã—ãã¿ B-Tree(Balanced Tree)ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ¬¡ã®ã‚ˆã†ãªãƒ„ãƒªãƒ¼çŠ¶ã®æ§‹é€ ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ„ãƒªãƒ¼ã®å…ˆé ã¯ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã§ã¯ã€ã‚ãƒ¼å€¤ã® ç¯„å›²
hacked 2010/06/16
ãƒ†ãƒ¼ãƒ–ãƒ«

mysql

DB

index

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹
ãƒªãƒ³ã‚¯
ï¿½Linux/DB Tuning (DevSumi2010, Japanese)
1. é«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã® Linux/DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨æŠ€è¡“ æ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ ãƒ—ãƒªãƒ³ã‚·ãƒ‘ãƒ« MySQL ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆ 2. ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« 2006 å¹´ 9 æœˆã‹ã‚‰ MySQL->Sun(-> ã‚ªãƒ©ã‚¯ãƒ« ) ã§ MySQL ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã¨ã—ã¦å‹¤å‹™ ä¸»ãªè‘—æ›¸ Linux-DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨å…¥é–€ ç¾å ´ã§ä½¿ãˆã‚‹ MySQL Java ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ Twitter: matsunobu Blog: http://opendatabaselife.blogspot.com * ä»Šå›žã®è³‡æ–™ã¯å…¬é–‹ã—ã¾ã™ * MySQL ç”¨èªžãŒã‚ã¡ã“ã¡ã«å‡ºã¾ã™ãŒã€ çµŒé¨“ã®ç„¡ã„æ–¹ã«ã‚‚åˆ†ã‹ã‚‹ã‚ˆã†ã«é…æ…®ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ 3. å®‰å®šç¨¼åƒã¨é«˜æ€§èƒ½ã‚’æ”¯ãˆã‚‹è¦ç´ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å±¤ã«é–¢ã™ã‚‹æŠ€è¡“ ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨
hacked 2010/02/18
innodb

tuning

DB

mysql
ãƒªãƒ³ã‚¯
æœ€å¼·ã®MySQL HAåŒ–æ‰‹æ³• - Semi-Synchronous Replication
MySQL 6.0ã§æè¼‰ã•ã‚Œã‚‹äºˆå®šã®æ©Ÿèƒ½ã®ä¸€ã¤ã«ã€Semi-Synchronous Replicationã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ã‚³ã‚¤ãƒ„ã‚’ä½¿ã†ã¨ã¨ã‚“ã§ã‚‚ãªãå‡„ã„HAåŒ–ãŒã§ãã‚‹ã®ã§ã€ä»Šæ—¥ã¯ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ ã¾ãšã¯Semi-Synchronous Replicationã®æ©Ÿèƒ½èª¬æ˜Žã‹ã‚‰ã€‚ãã‚‚ãã‚‚Semi-Synchrounousã£ã¦ãƒŠãƒ‹ï¼Ÿã©ã†ã—ã¦å®Œå…¨ãªåŒæœŸã§ã‚‚ãªãéžåŒæœŸã§ã‚‚ãªãSemi-Synchronousãªã®ï¼Ÿã¨ã„ã†ç–‘å•ã‚’ã¾ãšã¯è§£æ¶ˆã—ãŸã„ã¨æ€ã†ã€‚ã•ã£ããæ¬¡ã®å›³ã‚’è¦‹ã¦æ¬²ã—ã„ã€‚ ã“ã‚Œã¯Semi-Synchronous Replicationã®å‹•ä½œã‚’å›³ã§è¡¨ã—ãŸã‚‚ã®ã§ã‚ã‚‹ã€‚å›³ã ã‘ã§ã¯ãªã‚“ã ã‹ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ä»¥ä¸‹ã«å„ã‚¹ãƒ†ãƒƒãƒ—ã®è©³ç´°ã‚’èª¬æ˜Žã™ã‚‹ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼‰ã‹ã‚‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’COMMITè¦æ±‚ã‚’å‡ºã™ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æ›´æ–°ã™ã‚‹ã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ã‚’æ›´æ–°ã™ã‚‹ã€‚
hacked 2009/12/25
mysql

DB
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
hacked 2009/10/23
mysql

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

DB

è² è·åˆ†æ•£

mysql
ãƒªãƒ³ã‚¯
mysql ã¨ drizzle ã®è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã€Œskyloadã€ãŒå‡„ã„ï¼ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
tmaesakaã•ã‚“ãŒã‚„ã£ã¦ãã‚Œã¾ã—ãŸã€‚ ãšã„ã¶ã‚“å‰ã‹ã‚‰SQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’æ¸¬å®šã™ã‚‹ã®ã«ä½¿ã„ã‚„ã™ã„ãƒ—ãƒã‚°ãƒ©ãƒ ãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã¾ã—ãŸã€‚å€‹äººçš„ã«ã¯mysqlslapã¨ã„ã†ã®ã‚’ä½¿ã£ã¦ãŸã®ã§ã™ãŒã€å¹¾ã‚‰ã‹æ°—ã«å…¥ã‚‰ãªã„æ‰€ãŒã‚ã£ãŸã‚Šã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒè¤‡é›‘ã§æ¯Žå›ž --help ã‚’èªã‚“ã ã‚Šã—ã¦ã„ã¾ã—ãŸã€‚ä½™è¨ˆãªæ©Ÿèƒ½ãªã‚“ã‹ãªãã¦ã€æŒ‡å®šã—ãŸSQLã‚’é«˜é€Ÿã«ãã‚Šã‹ãˆã—ã¦ãã‚Œã‚‹ç‰©ãŒæ¬²ã—ã„ãªãã£ã¦æ€ã£ã¦ãŸã‚“ã§ã™ã€‚ ã¨ã‚ã‚‹IRCã§ã“ã®å‰ã€tmaesakaã•ã‚“ã‹ã‚‰ã€Œã„ã¾ä½œã£ã¦ã‚‹ã€ã¨ã„ã†è©±ã‚’èžã„ã¦ã€ã„ã‚ã„ã‚è¦æœ›ã‚’è¨€ã£ã¦ãŸã‚“ã§ã™ãŒã€ã¤ã„ã•ã£ããƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚é€Ÿã„w åå‰ã¯skyloadã€‚ã¨ã¦ã‚‚å°ã•ãã€å®Ÿè£…ã‚³ãƒ¼ãƒ‰ã ã¨800è¡Œç¨‹åº¦ã§ã™ã€‚ã—ã‹ã‚‚ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒå°‘ãªã„ã®ã§ä½¿ã„æ–¹ãŒå˜ç´”ã§ã™ã€‚è©¦ã—ã«é©å½“ãª INSERT ã®é€Ÿåº¦ã‚’æ¸¬ã£ã¦ã¿ã¾ã—ãŸã€‚ $ skyload --server=localhost --mysql
hacked 2009/07/08
DB

mysql
ãƒªãƒ³ã‚¯
Using filesort
åŽ»å¹´ã‚½ãƒ¼ãƒˆã«é–¢ã™ã‚‹è¨˜äº‹ã‚’æ›¸ã„ãŸãŒã€ä»Šæ—¥ã¯ãã®ç¶šãã§ã‚ã‚‹ã€‚ MySQLã§EXPLAIN SELECT...ã‚’å®Ÿè¡Œã™ã‚‹ã¨Extraãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã§ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€ŒUsing filesortã€ã¨ã„ã†æ–‡å—åˆ—ã€‚Filesortã£ã¦ä¸€ä½“ãªã‚“ã ã‚ã†ï¼Ÿã¨æ€ã£ãŸã“ã¨ã¯ãªã„ã ã‚ã†ã‹ã€‚å˜åˆ€ç›´å…¥ã«è¨€ã£ã¦Filesortã®æ£ä½“ã¯ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆã§ã‚ã‚‹ã€‚ ã‚¯ã‚¨ãƒªã«ORDER BYãŒå«ã¾ã‚Œã‚‹å ´åˆã€MySQLã¯ã‚ã‚‹ç¨‹åº¦ã®å¤§ãã•ã¾ã§ã¯å…¨ã¦ãƒ¡ãƒ¢ãƒªå†…ã§ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆã‚’å‡¦ç†ã™ã‚‹ã€‚ã‚ã‚‹ç¨‹åº¦ã®å¤§ãã•ã¨ã¯sort_buffer_sizeã§ã‚ã‚Šã€ã“ã‚Œã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ã”ã¨ã«å¤‰æ›´å¯èƒ½ã§ã‚ã‚‹ã€‚ã‚½ãƒ¼ãƒˆã«å¿…è¦ãªãƒ¡ãƒ¢ãƒªãŒsort_buffer_sizeã‚ˆã‚Šå¤§ãããªã‚‹ã¨ã€ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ãªã„ï¼‰ãŒä½œæˆã•ã‚Œã€ãƒ¡ãƒ¢ãƒªã¨ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½µç”¨ã—ã¦ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆãŒå®Ÿè¡Œã•ã‚Œã‚‹ã€‚ Filesortã¯å…¨ã¦ã®ã‚½ãƒ¼ãƒˆå‡¦ç†ã«ãŠã„ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚å‰å›žã®è¨˜äº‹
hacked 2009/06/23
DB

mysql

performance

sort
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
hacked 2009/06/21
database

DB

mysql
ãƒªãƒ³ã‚¯
DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ã£ãã‚Šã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ï¼ï¼ˆ1/4ï¼‰ â€• ï¼ IT
é€£è¼‰ç¬¬5å›žã€ŒMySQLã®åŸºç¤Žã‚’å¦ã¼ã† ï¼»ã‚µãƒ³ãƒ—ãƒ«é–‹ç™ºç·¨ï¼½ã€ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¨é€£æºã—ãŸç°¡æ˜“ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆã‚¢ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ãŸã ã—ã€å›ºå®šã•ã‚ŒãŸå•†å“ã‚¢ã‚¤ãƒ†ãƒ ã®å–ã‚Šæ‰±ã„ã®ã¿ã§ã€å•†å“ã®è¿½åŠ ã‚„ä¾¡æ ¼ã®å¤‰æ›´ã‚’æŸ”è»Ÿã«è¡Œã†ã“ã¨ãŒã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ä»Šå›žã‹ã‚‰ã¯ã€å•†å“ã‚¢ã‚¤ãƒ†ãƒ ã‚‚MySQLã§ç®¡ç†ã§ãã‚‹ã‚ˆã†ã€Žç°¡æ˜“åœ¨åº«ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã€ã®ä½œæˆã«å–ã‚ŠæŽ›ã‹ã‚Šã¾ã™ã€‚ å„å•†å“ã‚¢ã‚¤ãƒ†ãƒ ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç™»éŒ²ã™ã‚‹ãŸã‚ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆã‚¢é–‹ç™ºä»¥ä¸Šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒç™ºç”Ÿã—ã¾ã™ã€‚ãã“ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã‚’ä¸€ã¾ã¨ã‚ã«ã—ãŸã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã—ã¦ã€ãã®ã‚¯ãƒ©ã‚¹ã‚’åˆ©ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ ã”å˜ã˜ã®ã¨ãŠã‚Šã€PHP5ã¯Javaã«åŒ¹æ•µã™ã‚‹ååˆ†ãªã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘æ€§ã‚’æœ‰ã—ã¦ã„ã¾ã™ã€‚ã€Œã‚¯ãƒ©ã‚¹åŒ–ã€ã€Œç¶™æ‰¿ã€ã€Œã‚ªãƒ¼ãƒãƒ©ã‚¤ãƒ‰ã€â€¦â€¦ã€‚ ã“ã†ã—ãŸç”¨èªžã«ã€Œã’ã£ï¼ã€ã¨æ€ã£ãŸæ–¹ã€ã”å®‰å¿ƒãã ã•ã„ã€‚ä»Šå›žã¯ã€ç°¡å˜ãªã‚µãƒ³ãƒ—ãƒ«ã‚’ä¾‹ã«ã€æœ€ä½Žé™å¿…
hacked 2009/06/05
DB

mysql

php

DAO
ãƒªãƒ³ã‚¯
mysqlã§ã„ã¡ã„ã¡show databasesã¨ã‹æ‰“ã¤ã®ãŒã‚ã‚“ã©ã„â†’readlineã®ãƒžã‚¯ãƒã§è§£æ±º - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã„ã¡ã„ã¡show tables;ã¨ã‹æ‰“ã¤ã®ãŒã ã‚‹ã„ã€‚\tã¿ãŸã„ãªaliasè¨å®šã§ããªã„ã®ã‹ãªã http://twitter.com/weboo/status/1658300902 ãŠã‰ã€readlineã®ãƒžã‚¯ãƒã‚’ä½¿ãˆã°ã„ã„ã®ã‹ãƒ¼ http://twitter.com/weboo/status/1658314333 ãªã‚‹ã»ï¼ã£ã¦ã“ã¨ã§ã¡ã‚‡ã£ã¨è¨å®šã—ã¦ã¿ã¾ã—ãŸã€‚ # ~/.inputrc $if mysql "\C-xd": "show databases;" "\C-xt": "show tables;" "\C-xu": "select user,host,password from mysql.user order by user,host;" "\C-xb": "select user,host,db from mysql.db order by user,host;"
hacked 2009/06/01
database

DB

mysql
ãƒªãƒ³ã‚¯
ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã§å¿«é©MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç”Ÿæ´»
MySQL 5.1ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ä¾¿åˆ©ãªæ©Ÿèƒ½ã¨ã—ã¦ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚MySQL 5.0ã§ã‚‚åˆ©ç”¨å‡ºæ¥ãŸã®ã ãŒã€å®Ÿé¨“çš„ãªæ©Ÿèƒ½ã¨ã„ã†ä½ç½®ã¥ã‘ã§ã‚ã‚Šã€æè¼‰ã•ã‚Œã¦ã„ãŸã®ã¯GPLç‰ˆã®MySQL Community Serveré™å®šã ã£ãŸã€‚MySQL 5.1ã‹ã‚‰ã¯å…¨ã¦ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã§ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã®çŠ¶æ…‹ï¼ˆç‰¹ã«çŠ¶æ…‹é·ç§»ã‚„ãƒªã‚½ãƒ¼ã‚¹ã®æ¶ˆè²»çŠ¶æ³ï¼‰ã‚’è©³ç´°ã«åˆ†æžã§ãã‚‹ã®ã§ã¨ã¦ã‚‚ä¾¿åˆ©ã ã€‚MySQL ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®æ©Ÿèƒ½ã¨ã„ã£ã¦è‰¯ã„ã ã‚ã†ã€‚ã¨ã„ã†ã‚ã‘ã§ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°æ©Ÿèƒ½ã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã—ã‚ˆã†ã€‚ MySQLã‚µãƒ¼ãƒã«ãƒã‚°ã‚¤ãƒ³ã—ãŸã‚‰ã€ã¾ãšã¯æ¬¡ã®ã‚ˆã†ã«ã—ã¦ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã€‚ mysql> SET profiling=1; ã™ã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã®æƒ…å ±ãŒè¨˜éŒ²ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚æ¬¡ã«ã€åˆ†æžã—ãŸã„ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã€‚ã‚¯ã‚¨ãƒªã¯ãªã‚“ã§ã‚‚ã„ã„
hacked 2009/03/01
DB

mysql
ãƒªãƒ³ã‚¯
ã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’è¦‹ã¦ããŸ - ã‚‚ãŽã‚ƒã‚ã
KOF2008ï¼šé–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹2008ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã«æ¥ã¦ã„ã¾ã™ã€‚ ã¯ã¦ãªã®ä¼Šè—¤ã•ã‚“ã®è¬›æ¼”ãŒã‚ã£ãŸã®ã§ã€è¬›æ¼”ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ ï¼ƒãƒœã‚¯ãŒãƒ¡ãƒ¢ã—ãŸå†…å®¹ã§ã‚ã£ã¦ã€100%è¨€ã£ãŸã¨ãŠã‚Šã«æ›¸ã„ã¦ã‚ã‚‹ã‚ã‘ã˜ã‚ƒãªã„ã®ã§ã€å‚è€ƒã¨ã—ã¦ã”è¦§ãã ã•ã„ã€‚ (ç¶šã) ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ OSã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ MySQLã®é‹ç”¨ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™º ãƒ‡ãƒ¼ã‚¿ã®ä¾‹ ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ‡ãƒ¼ã‚¿é‡ï¼šäº”åƒä¸‡ä»¶ãã‚‰ã„ã®ãƒ‡ãƒ¼ã‚¿é‡ ã“ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ä½•ç™¾ä¸‡äººãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã‚‹çŠ¶æ³ã§ã©ã†ã„ã†ä½œã‚Šã«ã™ã‚‹ã‹ ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 1073ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 3134ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 4143ä¸‡ã‚¿ã‚° ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º ã‚¨ãƒ³ãƒˆãƒªãƒ¼2.5GB ä½•ã®å·¥å¤«ã‚‚ãªãæ™®é€šã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨...200ç§’å¾…ã£ã¦ã‚‚çµæžœãŒå¸°ã£ã¦ã“ãªã„ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®é›£ã—ã„ã¨ã“ã‚ é–‹ç™ºã‚µãƒ¼ãƒã§é–‹ç™ºè€…ãŒä½œã£ã¦ã„ã‚‹æ™‚ã¯å¿«é©ã«å‹•ã„ã¦ã„ã¦ã‚‚ã€å¤šæ•°ã®äººé–“ãŒã‚¢ã‚¯
hacked 2009/02/17
mysql

è² è·åˆ†æ•£

DB
ãƒªãƒ³ã‚¯
MySQLã«ã¤ã„ã¦ã€€ä¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦
é€šå¸¸ã€MySQLã§ã¯ã€selectã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ãŸå ´åˆã€1ãƒ¬ã‚³ãƒ¼ãƒ‰ç›®ã‹ã‚‰æœ€çµ‚ãƒ¬ã‚³ãƒ¼ãƒ‰ã¾ã§ã€ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã«æ¤œç´¢ã‚’è¡Œã£ã¦ã„ãã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤§é‡ã«ãªã£ã¦ãã‚‹ã¨ã€æ¤œç´¢é€Ÿåº¦ã®å•é¡ŒãŒç”Ÿã˜ã¾ã™ã€‚ ãã“ã§ã€ã‚ˆã‚Šé«˜é€Ÿãªæ¤œç´¢ã‚’è¡Œã†ãŸã‚ã«ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€æ¤œç´¢é€Ÿåº¦ã¯åŠ‡çš„ã«æ”¹å–„ã•ã‚Œã¾ã™ã€‚ ä½†ã—ã€MySQLã§ã¯ã€1,000ä»¶ä»¥ä¸‹ã§ã‚ã‚Œã°ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã«æ¤œç´¢ã—ãŸæ–¹ãŒé€Ÿã„ã¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã•ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ã©ã®ã‚ˆã†ãªã‚‚ã®ã§ã‚ã‚‹ã‹ã¨ã„ã†ã¨ã€ç›´æ„Ÿçš„ã«ã¯ã€å›³æ›¸ã®å·»æœ«ã«ä»˜ã•ã‚Œã¦ã„ã‚‹ç´¢å¼•ï¼ˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼‰ã¨åŒã˜ã§ã™ã€‚ ç´¢å¼•èªžã¯ã‚¢ã‚¤ã‚¦ã‚¨ã‚ªé †ã€ã‚ã‚‹ã„ã¯ã€ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆé †ã«ä¸¦ã¹ã‚‰ã‚Œã¦ã„ã¦ã€å„ã€…ã®ç´¢å¼•èªžã«ã¯ã€ãã®ç´¢å¼•èªžãŒç™»å ´ã™ã‚‹ãƒšãƒ¼ã‚¸æ•°ï¼ˆä½ç½®æƒ…å ±ï¼‰ãŒç¤ºã•ã‚Œã¦ã„ã¾ã™ã€‚ èªè€…ã¯ãã®ä½ç½®æƒ…å ±ã‚’é ¼ã‚Šã«ã€ãƒšãƒ¼ã‚¸ã‚’æ²ã£ã¦ã€ç›®çš„ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®ã‚ã‚‹éƒ¨åˆ†ã‚’èª
hacked 2007/01/23
mysql

db

index

fulltext
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
hacked 2006/12/29
db

sql

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

mysql
ãƒªãƒ³ã‚¯
Ywcafe.net
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Credit Card Application Contact Lens Online classifieds Healthy Weight Loss Anti Wrinkle Creams Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy|Do Not Sell or Share My Personal Information
hacked 2006/06/18
DB

MySQL

postgreSQL
ãƒªãƒ³ã‚¯
1