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

kishir id:kishir

mysqlã«é–¢ã™ã‚‹kishirã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

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

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
kishir 2009/11/16
mysql

tips
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: å›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã
ã“ã‚“ã«ã¡ã¯ã€‚ä¸æ‘ã§ã™ã€‚ MySQLã«ã¯MyISAMã€InnoDBã€CSVãªã©ã®ã„ãã¤ã‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€çš†ã•ã‚“ã¯Spiderã¨ã„ã†ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’èžã„ãŸã“ã¨ã¯ã‚ã‚Šã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚Spider Storage Engineã¯æ–¯æ³¢å¥å¾³ã•ã‚“ã«ã‚ˆã‚Šä½œæˆã•ã‚ŒãŸDatabase Shardingã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§MySQL 5.1ã§åˆ©ç”¨å¯èƒ½ã§ã™ã€‚ å…ˆæ—¥ã€æŸé›†ã¾ã‚Šã§æ–¯æ³¢ã•ã‚“ã¨ãŠä¼šã„ã—ãŸã¨ãã«Spiderã‚’ä½œã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€æ—©é€Ÿè©³ã—ã„å†…å®¹ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ â€»Spiderã«ã¤ã„ã¦ã®èª¬æ˜Žè³‡æ–™ã¯MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2009ã«ã¦æ–¯æ³¢ã•ã‚“ãŒç™ºè¡¨ã•ã‚ŒãŸã¨ãã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ã‚¹ãƒ©ã‚¤ãƒ‰ã®ç›´ãƒªãƒ³ã‚¯ï¼ˆzipï¼‰ Spider Storage Engine ã«ã¤ã„ã¦ posted by (C)ãƒ•ã‚©ãƒˆè”µ Spider Storage Engineã¨ã¯ï¼Ÿ
kishir 2009/07/17
mysql

database

db

storage

spider
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
kishir 2009/03/12
tips

mysql
ãƒªãƒ³ã‚¯
ä¸»ã‚ãƒ¼ã®å®šç¾©æ™‚ã®æ³¨æ„ - ã‚¹ã‚³ãƒˆãƒ—ãƒªã‚´ãƒ‹ã‚¨ãƒ•ã‚¹ã‚¯é€šä¿¡
auto_incrementã‚’ç„¡åŠ¹ã«ã™ã‚‹ã‚«ãƒ©ãƒ å®šç¾©ã«primary_key=Trueã‚’æŒ‡å®šã™ã‚‹ã¨SQLAlchemyã¯è‡ªå‹•çš„ã«auto_incrementã‚’ä½¿ç”¨ã™ã‚‹ã®ã§ã€ã“ã‚Œã‚’ç„¡åŠ¹ã«ã™ã‚‹ã«ã¯ã€ã‚«ãƒ©ãƒ å®šç¾©ã«autoincrement=Falseã‚’ã¤ã‘ã‚‹ã€‚ tbl = Table( 'table_name', metadata, Column('id', Integer, primary_key=True, autoincrement=False), # ... mysql_engine='InnoDB' ) ä»¥ä¸‹ã«è¨˜è¼‰ãŒã‚ã‚‹ã€‚http://www.sqlalchemy.org/docs/05/reference/dialects/mysql.html#keys unsigned intã‚’ä½¿ã†æ¬¡ã®ã‚ˆã†ã«ã€sqlalchemyãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒæä¾›ã™ã‚‹Integerã‚¯ãƒ©ã‚¹ã‚’ä½¿ã£ã¦unsigned=Tr
kishir 2009/03/02
mysql

sqlalchemy
ãƒªãƒ³ã‚¯
Free Coding PNG Images with Transparent Backgrounds - FastPNG.com
Download Coding PNG images for any device and screen size. High quality Coding PNG and images! Customize your desktop, mobile phone and tablet with our wide variety of cool and interesting Coding PNG in just a few clicks.
kishir 2009/02/26
python

mysql
ãƒªãƒ³ã‚¯
Life
kishir 2008/07/31
REPAIR TABLE tableName;

mysql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
æ–°ç±³ã¨ç§‹åˆ€éšã®ã‚ãŸç„¼ã ãŠåˆºèº«ç”¨ã®ç§‹åˆ€éšã‚’è²·ã„ã¾ã—ãŸã€‚1å°¾250å††ã§ã™ 3æžšã«ãŠã‚ã—ã¦ã€ç§‹åˆ€éšã®ã‚ãŸã«é…’ã€å‘³é†‚ã€é†¤æ²¹ã§èª¿å‘³ã—ã¦1æ™‚é–“ã»ã©æ¼¬ã‘è¾¼ã¿ã€ã‚°ãƒªãƒ«ã§ç„¼ãã¾ã—ãŸ ç§‹åˆ€éšã®ã‚ãŸç„¼ã ã‚ãŸã®ã€è‹¦å‘³ãŒç¨‹ã‚ˆããƒžã‚¤ãƒ«ãƒ‰ã«èª¿å‘³ã•ã‚Œã€ã‚¯ã‚»ã«ãªã‚‹å‘³ã‚ã„ã§ã™ è‰¶ã‚„ã‹ãªæ–°ç±³ã¨ä¸€ç·’ã« è‡ªå®¶è£½ãŠæ¼¬ç‰© åœŸâ€¦
kishir 2008/05/27
mysql
ãƒªãƒ³ã‚¯
memo.xight.org - 2005-01-17
kishir 2008/05/26
mysql
ãƒªãƒ³ã‚¯
MySQLã®çŠ¶æ…‹ãŒãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§ã‚ã‹ã‚‹MySQLç”¨topã‚³ãƒžãƒ³ãƒ‰ã€Œmytopã€ã¨ã€Œinnotopã€
ã‚µãƒ¼ãƒã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã™ã‚‹ä¸Šã§ã‹ãªã‚Šã‚„ã£ã‹ã„ãªã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã€‚ç‰¹ã«ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®é‡ãŒè†¨å¤§ã«ãªã‚‹ã¨å¾Œã‹ã‚‰ä¸èº«ã‚’è¦‹ã¦å•é¡Œã‚’åˆ†æžã™ã‚‹ã®ã‚‚ä¸€è‹¦åŠ´ã¨ã„ã†å ´åˆãŒã€‚ãã‚“ãªã¨ãã«ã“ã®MySQLç”¨topã‚³ãƒžãƒ³ãƒ‰ã€Œmytopã€ã‚’ä½¿ãˆã°ä¸€ä½“ä½•ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ãŒã™ãã«ã‚ã‹ã‚‹ã®ã§å•é¡Œç‚¹ã®æŠŠæ¡ãŒå®¹æ˜“ã«ãªã‚Šã¾ã™ã€‚ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã™ã‚‹ã¨ãã«ä½µç”¨ã™ã‚Œã°ã‹ãªã‚ŠåŠ¹çŽ‡ãŒè‰¯ããªã‚‹ã®ã§ã¯ãªã„ã‹ã¨ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ä½¿ã„æ–¹ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ ã¾ãšã¯ã€Œmytopã€ã‹ã‚‰ã€‚ä»¥ä¸‹ãŒå…¬å¼ã‚µã‚¤ãƒˆã€‚ mytop - a top clone for MySQL http://jeremy.zawodny.com/mysql/mytop/ ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¯ä»¥ä¸‹ã«ã‚ã‚Šã¾ã™ã€‚ mytop - display MySQL server performance info like `top' ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã«ã¯SSHãªã©ã‚’ä½¿ã£ã¦rootã§ãƒã‚°ã‚¤ãƒ³å¾Œã€wgetã§ãƒ•ã‚¡ã‚¤ãƒ«
kishir 2008/04/14
mysql

database
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/02/triton-embed-primary-key.php
kishir 2008/02/05
mysql

senna
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
kishir 2007/10/19
mysql
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºæ ªå¼ä¼šç¤¾
ã‚µã‚¤ãƒœã‚¦ã‚ºã¯ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã®ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ã‚„æ¥å‹™æ”¹å–„ã‚µãƒ¼ãƒ“ã‚¹ã‚’è»¸ã«ã€ç¤¾ä¼šã®ãƒãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯å‘ä¸Šã‚’æ”¯æ´ã—ã¦ã„ã¾ã™ã€‚
kishir 2007/10/02
mysql
ãƒªãƒ³ã‚¯
mysql-5.0.45-tritonn-1.0.5 ãƒªãƒªãƒ¼ã‚¹ - mir the developer
MySQL 5.0.45ã«å¯¾å¿œã—ãŸTritonnã®æ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ver1.0.5ã‚’ãƒªãƒªãƒ¼ã‚¹ã„ãŸã—ã¾ã—ãŸï¼ MySQL Users Conference Japan 2007ã®å‰å¤œã§ã™ãã€ã†ã»ã£ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰ï¼š http://sourceforge.jp/projects/tritonn/files/ æ©Ÿèƒ½è¿½åŠ KWIC(Keyword in Context)è¡¨ç¤ºã‚’è¡Œã†ãŸã‚ã®kwicé–¢æ•°(MySQLã®çµ„è¾¼ã¿SQLé–¢æ•°)ã‚’å®Ÿè£…ã€‚ã“ã‚Œã¯Sennaæœ¬ä½“ã«åŒæ¢±ã•ã‚Œã¦ã„ã‚‹snippetãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã‚’æ©Ÿèƒ½çš„ã«ç½®ãæ›ãˆã‚‹ãŸã‚ã®ã‚‚ã®ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½œæˆæ™‚ã«æŒ‡å®šå¯èƒ½ãªãƒ•ãƒ©ã‚°ã¨ã—ã¦ã€SPLIT_ALPHAã€SPLIT_DIGITã€SPLIT_SYMBOLã‚’è¿½åŠ ã€‚ã“ã‚Œã‚‰ã®ãƒ•ãƒ©ã‚°ã«ã‚ˆã‚Šã€Unicodeæ£è¦åŒ–æ©Ÿèƒ½ã‚’ä½¿ã†å ´åˆã®è‹±å˜èªžã®å–æ‰±ã„ã‚’è©³ç´°ã«æŒ‡å®šã§ãã‚‹ã€‚ æ©Ÿèƒ½æ”¹è‰¯ "SHOW SENNA ST
kishir 2007/09/13
mysql
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
kishir 2007/09/07
mysql
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: MySQL ã‚ªãƒšãƒŸã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãŒç ´æã—ã¦ã—ã¾ã£ãŸå ´åˆã®å¾©æ—§æ–¹æ³•
ã“ã‚“ã«ã¡ã¯ satoã§ã™ã€‚ ã‚ªãƒšãƒŸã‚¹ã§ update ã« whereå¥ã‚’ä»˜ã‘å¿˜ã‚ŒãŸã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒã‚°ã§ãƒ‡ãƒ¼ã‚¿ãŒç ´æã—ã¦ã—ã¾ã£ãŸã‚Šã—ãŸå ´åˆã§ã‚‚ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã«ã¯æ›´æ–°SQLãŒã™ã¹ã¦æ›¸ãè¾¼ã¾ã‚Œã‚‹ã®ã§ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ã‚ªãƒšãƒŸã‚¹ãŒèµ·ã“ã‚‹ã¾ã§ã®å…¨ã¦ã®SQLã‚’æµã—è¾¼ã‚ã‚Œã°ã€å…ƒã®çŠ¶æ…‹ã«æˆ»ã™ã“ã¨ã¯å¯èƒ½ã§ã™ã€‚ â€¢ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å–ã£ã¦ã„ã‚‹ â€¢ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã£ã¦ã„ã‚‹(mysqldumpã‚„MySQLã‚’æ¢ã‚ãŸçŠ¶æ…‹ã§ã®cpã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒã‚¤ãƒŠãƒªãƒã‚°) â€¢ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚ç‚¹ã§ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã®æ›¸ãè¾¼ã¿ä½ç½®ã‚’ä¿å˜ã—ã¦ã„ã‚‹ ä»¥ä¸Šã®ã‚ˆã†ãªçŠ¶æ…‹ã§ãƒ‡ãƒ¼ã‚¿ãŒå£Šã‚ŒãŸæ™‚ã®å¾©æ—§æ‰‹é †ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ã‚·ãƒŠãƒªã‚ªã¨ã—ã¦ â€¢ã‚ã‚‹1ã‚«ãƒ©ãƒ em ail ã‚’updateã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€é–“é•ã£ã¦where å¥ã‚’ä»˜ã‘å¿˜ã‚Œ å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’updateã—ã¦ã—ã¾ã£ãŸ â€¢æ°—ãŒã¤ã„ãŸã®ãŒåŠæ—¥å¾Œ ã¨ã„ã†ã‚ªãƒšãƒŸã‚¹ãŒç™ºç”Ÿã—ãŸã¨ã—ã¾ã™ 1) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
kishir 2007/08/21
[for:abelicious]

mysql
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MyISAM vs InnoDB
ã‚ãã¾ã§æ†¶æ¸¬ã§ä»®èª¬ã§ã—ã‹ãªã„ã‚“ã§ã™ãŒã€‚ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ã†ã¡ä»£è¡¨çš„ãªäºŒã¤ã€MyISAM ã¨ InnoDB ã¯ã‚ˆã MyISAM: Read ã¯é€Ÿã„ã‘ã©ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã®ãŸã‚ä¸¦è¡Œæ€§ãŒä½Žã„ã€‚é‹ç”¨ãŒç°¡å˜ã€‚ InnoDB: MyISAM ã‚ˆã‚Š Read ã¯é…ã„ã‘ã©ä¸¦è¡Œæ€§ãŒé«˜ã„ ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ã€‚ã‚ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã€‚é‹ç”¨ãŒ MyISAM ã‚ˆã‚Šã¡ã‚‡ã£ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ã¨ã„ã†åŒºåˆ¥ãŒã•ã‚Œã¾ã™ã€‚ã“ã“ã‹ã‚‰è»¢ã˜ã¦ã€ MyISAM ã¯å‚ç…§ç³»ã‚¯ã‚¨ãƒªãŒå¤§éƒ¨åˆ†ã‚’å ã‚ã‚‹å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ä¾‹ãˆã° blog ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€‚ InnoDB ã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå¤šã„å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ ã¨è¨€ã‚ãŸã‚Šã—ã¾ã™ã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ã§ã‚‚ç¬¬2ç« ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«åž‹) P.30 ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒãªãã€ä¸»ã« SELECT ã¾ãŸã¯ I
kishir 2007/08/12
MySQL
ãƒªãƒ³ã‚¯
GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
kishir 2007/08/12
MySQL
ãƒªãƒ³ã‚¯
1