[B! Tips][mysql] dgdgã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

dgdg id:dgdg

Tipsã¨mysqlã«é–¢ã™ã‚‹dgdgã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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ã®è‡ªå‹•å¤‰æ›ã‚’ä¸é‡ã«ãŠæ–ã‚Šã™ã‚‹ãŸã‚ã®ãŸã£ãŸï¼‘ç¨®é¡žã®å‘ªæ–‡ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
å…ˆæ—¥ã®ã€Žã“ã‚Œã ã‘ã¯è¦šãˆã¦ãŠããŸã„!!MySQL ã®ï¼–ã¤ã®è‡ªå‹•å¤‰æ›ã€ http://d.hatena.ne.jp/sakaik/20100225/mysqlautochange ã«ã¯ãŸãã•ã‚“ã®åéŸ¿ã‚’ã„ãŸã ã„ãŸã€‚ æ™‚ã«ã“ã¡ã‚‰ã®æ„å›³ã¨é•ã£ã¡ã‚ƒã†ã“ã¨ã‚‚ã‚ã‚‹ã‘ã‚Œã©ã‚‚ã‚±ãƒŠã‚²ã«æ°—ã‚’ä½¿ã£ã¦ãã‚Œã‚‹ MySQL ãŒã€ã“ã‚Œã»ã©ã«çš†ã•ã‚“ã«ã‚‚æ„›ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒåˆ¤ã‚Šã€MySQLãƒ•ã‚¡ãƒ³ã®ä¸€äººã¨ã—ã¦å¬‰ã—ã„é™ã‚Šã§ã‚ã‚‹ã€‚ ã•ã¦ã€ãã®ã‚¨ãƒ³ãƒˆãƒªã®æœ€å¾Œã«ã€ ãªãŠã€ã€ŒSQLãƒ¢ãƒ¼ãƒ‰ã€ã‚’æŒ‡å®šã™ã‚‹ã¨ã“ã‚Œã‚‰ã®å‹•ä½œã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚SQLãƒ¢ãƒ¼ãƒ‰ã«ã¤ã„ã¦ã¯æ°—ãŒå‘ã„ãŸã‚‰ã„ã¤ã‹ç´¹ä»‹ã—ã¦ã¿ãŸã„ã€‚ ã¨æ›¸ã„ãŸã¨ã“ã‚ã€é€Ÿæ”»ã§ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ã®æœ¨æ‘æ˜Žæ²»æ°ãŒè£œè¶³ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ã¦ãã ã•ã£ãŸã€‚ â—‹ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ãƒ–ãƒã‚° [å‹æ‰‹ã«è£œè¶³]ã“ã‚Œã ã‘ã¯è¦šãˆã¦ãŠããŸã„!!MySQL ã®ï¼–ã¤ã®è‡ªå‹•å¤‰æ› http://blog.kimuradb.com/?eid=83851
dgdg 2010/08/30
-

mysql

tips
ãƒªãƒ³ã‚¯
mysql [paulownia.jp]
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆB-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼‰ã‚’ä½¿ã£ãŸæ¤œç´¢ã§ã¯ã€çµžã‚‰ã‚Œã‚‹ä»¶æ•°ãŒå°‘ãªã„ã»ã©é«˜é€Ÿã«ãªã‚‹ã€‚ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼ã®ã‚ˆã†ã«1ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç‰¹å®šã§ãã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«ã«1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚ã£ã¦ã‚‚å¾…ã¡æ™‚é–“ã¯ã»ã¼ã‚¼ãƒã§ã‚ã‚‹ã€‚ ã—ã‹ã—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœã¯ã€æ¡ä»¶ã«ä¸€è‡´ã™ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå¢—ãˆã‚‹ã»ã©æ¸›å°‘ã™ã‚‹ã€‚ä¾‹ãˆã°æ€§åˆ¥ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã®ç¨®é¡žãŒ2ãƒ‘ã‚¿ãƒ¼ãƒ³ã—ã‹ãªã„ã‚ˆã†ãªã‚‚ã®ã¯å…¨ãåŠ¹æžœãŒæœŸå¾…ã§ããªã„ã€‚ã“ã®ã‚ˆã†ãªã‚«ãƒ©ãƒ ã‚’ã€Œã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£åº¦ãŒä½Žã„ã€ã¨ã„ã†ã€‚B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£åº¦ãŒé«˜ã„ã‚«ãƒ©ãƒ ã«å¯¾ã—ã¦ä½¿ã†ã“ã¨ã§åŠ¹æžœã‚’ç™ºæ®ã™ã‚‹ã€‚ MySQLã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®30ï¼…ä»¥ä¸Šã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå–å¾—ã•ã‚Œãã†ã ã¨äºˆæƒ³ã™ã‚‹ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã‚ãªã„ã€‚ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£åº¦ã®ä½Žã„ã‚«ãƒ©ãƒ ã«å¯¾ã™ã‚‹whereæ¡ä»¶ã®æ¤œç´¢ã§ã¯å¤šãã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå–å¾—ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã€MySQLã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„ã“ã¨ã‚’é¸ã¶å¯èƒ½æ€§ãŒé«˜ã„ã€‚ ä½Žã‚«ãƒ¼ãƒ‡ã‚£ãƒŠ
dgdg 2010/08/26
-

mysql

tips
ãƒªãƒ³ã‚¯
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;"
dgdg 2009/06/01
-

linux

mysql

tips

readline
ãƒªãƒ³ã‚¯
mysqlã‚³ãƒžãƒ³ãƒ‰ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‹ã‚«ãƒ©ãƒ åã®è£œå®Œ(completion)ã‚’ã™ã‚‹æ–¹æ³• - (ã²)ãƒ¡ãƒ¢
è¿½è¨˜: rehash(auto-rehashã‚‚å«ã‚€)ã™ã‚‹ã¨ã€SQLæ–‡ã®è£œå®Œ(seleã§ã‚¿ãƒ–æ‰“éµã¨ã‹)ãŒåŠ¹ã‹ãªããªã‚‹ã‚ˆã¨ã€ã¯ã™å‘ã‹ã„ã®äººã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ å€‹äººçš„ã«ã¯ã€SQLã¯ã€Œmysql> help selectã€ã¨ã‹ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ˜ãƒ«ãƒ—ãŒã³ã‚‡ã£ã¨å‡ºã‚‹ã®ã§ã€ã‚¹ã‚ãƒ¼ãƒžã®è£œå®ŒãŒã§ãã‚‹ã‚“ãªã‚‰SQLã®è£œå®Œã¯ã¨ã‚Šã‚ãˆãšã‚ãã‚‰ã‚ã¦ã‚‚ã„ã„ã‹ãªã¨æ€ã£ã¦ã„ã¾ã™ã€‚ å¸¸ã€…ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‹è£œå®Œã§ãã‚‹ã¨ã„ã„ãªãƒ¼ã¨æ€ã£ã¦ã„ãŸã®ã§ã€ãƒœãƒã£ã¨ãã„ã¦ã¿ãŸã‚‰æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ã‚ã–ãƒ¼ãƒ¼ãƒ¼ãƒ¼ã£ã™ï¼ id:mikihoshi++ id:tokuhirom++ id:precuredaisuki++ ãŠã‹ã’ã§åŠ¹çŽ‡ãŒ300%ä¸ŠãŒã‚Šã¾ã—ãŸã€‚(Benchmark::Stopwatchã§è¨ˆæ¸¬) http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option
dgdg 2008/01/23
mysql --auto-rehash

mysql

tips
ãƒªãƒ³ã‚¯
1