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

shozzy id:shozzy

MySQLã«é–¢ã™ã‚‹shozzyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

${{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ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
shozzy 2009/11/12
MySQL

DB

é‹ç”¨
ãƒªãƒ³ã‚¯
InnoDBã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºç®¡ç†
æœ€è¿‘ã€InnoDBã®ãƒ‡ãƒ¼ã‚¿é ˜åŸŸï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ï¼‰ãŒæˆé•·ã—ã¦ã—ã¾ã£ã¦å…ƒã«æˆ»ã™ã“ã¨ãŒå‡ºæ¥ãªã„å ´åˆã®å¯¾å‡¦ã«ã¤ã„ã¦ã‚ˆãè³ªå•ã•ã‚Œã‚‹ã®ã§ã€ä»Šæ—¥ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ãŒæˆé•·ã™ã‚‹ã“ã¨ã¸ã®å¯¾ç–ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ï¼ˆã“ã“ã®ã¨ã“ã‚MySQLãƒã‚¿ãŒç¶šã„ã¦ã„ã‚‹ãŒã€Planet MySQLæ—¥æœ¬èªžç‰ˆã‚’æ„è˜ã—ã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªã„ã®ã§ã‚ã—ã‹ã‚‰ãšï¼ï¼ï¼œï¼œãƒ›ãƒ³ãƒˆã‹ã‚ˆï¼Ÿï¼ï¼žä¿ºï¼‰ InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ãŒæˆé•·ã—ã¦ã—ã¾ã†ã®ã¯ã€ã‚ºãƒãƒªè‡ªå‹•æ‹¡å¼µã—ã¦ã„ã‚‹ã‹ã‚‰ã§ã‚ã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«å¯¾ã—ã¦ä½•ã‚‚ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã—ãªã„ã¨ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯æ¬¡ã®ã‚ˆã†ãªè¨å®šã¨åŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ãŒä½œæˆã•ã‚Œã‚‹ã€‚ [mysqld] innodb_data_file_path=ibdata1:10M:autoextend ã‚µã‚¤ã‚ºã¯10MBã—ã‹ãªã„ãŒã€è‡ªå‹•æ‹¡å¼µã™ã‚‹ã®ã§ã‚ã‚‹ã€‚è‡ªå‹•æ‹¡å¼µã—ã¦ã—ã¾ã†ã¨ä½•ãŒå•é¡Œãªã®ã‹ã¨ã„ã†ã¨ã€ãƒ‡ãƒ¼ã‚¿ãŒå¢—ãˆãŸå ´åˆã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ç©ºãé ˜åŸŸã‚’ä½¿ã„åˆ‡
shozzy 2009/01/16
DB

MySQL
ãƒªãƒ³ã‚¯
MySQL (InnoDB) ã«ãŠã‘ã‚‹è¡Œã®ã‚µã‚¤ã‚ºã¨é€Ÿåº¦ã®é–¢ä¿‚ã«ã¤ã„ã¦ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
é›†ç´„æ¼”ç®—ã‚’è¡Œã†ã‚±ãƒ¼ã‚¹ã§ã¯ã€è¡Œã®ã‚µã‚¤ã‚ºã‚’å°ã•ãä¿ã¤ã“ã¨ã¯ã¨ã¦ã‚‚é‡è¦ã€‚ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒä½Žã„ã‚³ãƒ©ãƒ ã¯åˆ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¿½ã„å‡ºã™ã¨ã‹ã—ãŸã»ã†ãŒã„ã„ãã‚‰ã„ã€‚ ä¸€æ–¹ã€é›†ç´„æ¼”ç®—ã‚’è¡Œã‚ãªã„ã‚±ãƒ¼ã‚¹ (å˜ä¸€è¡Œã® insert, update ç‰ã‚’å«ã‚€) ã®å ´åˆã¯ã€(ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã®é€šä¿¡ã®ãŸã‚ã®) ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ãŒã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã«ãªã‚‹ã®ã§ã€å°ã•ãªãƒ†ãƒ¼ãƒ–ãƒ«ã«ãŸãã•ã‚“ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã™ã‚‹ã‚ˆã‚Šã‚‚ã€é•·ã„è¡Œã‚’æŒã¤ãƒ†ãƒ¼ãƒ–ãƒ«ã«ï¼‘å›žã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã»ã†ãŒè‰¯ã„ã€‚ ãŸã¨ãˆã°æ‰‹å…ƒã®ç’°å¢ƒã§ã® insert on duplicate key update ã®é€Ÿåº¦ã¯ã€ è¡Œã®ã‚µã‚¤ã‚º å¿…è¦æ™‚é–“ 0KB 1 3KB 4 6KB 7 9KB 13 12KB 13 ã¨ã‹ãã‚“ãªæ„Ÿã˜ (ç’°å¢ƒã‚„ã‚¯ã‚¨ãƒªã«ã‚ˆã‚‹å¤‰ã‚ã‚‹ã®ã§è‡ªåˆ†ã§æ¸¬å®šã—ã¦ãã€‚9KB ã®é€Ÿåº¦ä½Žä¸‹ã¯ãƒšãƒ¼ã‚¸ã‚µã‚¤ã‚ºã®1/2ã‚’è¶…ãˆãŸã‹ã‚‰ã‹ãª)ã€‚ã¤ã¾ã‚Šã€è¡Œã®ã‚µã‚¤ã‚ºãŒ1KBç¨‹åº¦ã ã¨ã€é€šä¿¡ã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ãŒå¤§ãã„ã‹ã‚‰ã‚ã¾ã‚Šå•é¡Œã«
shozzy 2008/02/12
MySQL
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºæ ªå¼ä¼šç¤¾
ã‚µã‚¤ãƒœã‚¦ã‚ºã¯ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã®ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ã‚„æ¥å‹™æ”¹å–„ã‚µãƒ¼ãƒ“ã‚¹ã‚’è»¸ã«ã€ç¤¾ä¼šã®ãƒãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯å‘ä¸Šã‚’æ”¯æ´ã—ã¦ã„ã¾ã™ã€‚
shozzy 2007/10/01
ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™º

MySQL

ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯

æŠ€è¡“
ãƒªãƒ³ã‚¯
è¡æ’ƒ! informixã§ã‚‚ä»¶æ•°åˆ¶é™å‡ºæ¥ãŸ - ã¤ã‚Œã¥ã‚Œãƒãƒƒãƒˆæ•£æ©
shozzy 2007/07/09
ä»¶æ•°åˆ¶é™æ–¹æ³•ã„ã‚ã„ã‚

DB

Oracle

MySQL
ãƒªãƒ³ã‚¯
mysql -Xã§ã‚¯ã‚¨ãƒªãƒ¼ã®çµæžœã‚’XMLã§å–å¾— - æŠ€è¡“ãƒ¡ãƒ¢å¸³
mysql -X ã§ã‚¯ã‚¨ãƒªãƒ¼ã®çµæžœãŒXMLã§å–å¾—ã§ãã‚‹ã‚‰ã—ã„ã€‚ èˆˆå‘³æ·±ã„ã®ã§ã‚„ã£ã¦ã¿ãŸã€‚ ãªã‚“ã‹é©å½“ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã€‚ ã¨ã‚Šã‚ãˆãšã€4ã¤ã®ã‚«ãƒ©ãƒ ã‚’æŒã¤tã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ä½œã£ãŸã€‚ mysql> create table t(id int not null, name varchar(255), body text, updated_at datetime); mysql> insert into t values(1, 'name', 'body', current_timestamp); mysql> insert into t values(2, 'name2', 'body2', current_timestamp); ã¨ã‚Šã‚ãˆãšã€æ™®é€šã«SELECTã§è¡¨ç¤ºã—ã¦ã¿ã‚‹ã€‚ # mysql -e 'SQL' ã§ä»»æ„ã®SQLã‚’å®Ÿè¡Œå¯èƒ½ã€‚ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã«ä½¿ãˆã¾ã™ã€‚ $ mysql -e 'sele
shozzy 2007/02/20
MySQL

XML

ã¸ã‡
ãƒªãƒ³ã‚¯
InnoDB vs MyISAM (vs Falcon) ã‚’èªã‚“ã§èˆˆå‘³æ·±ã„ã¨æ€ã£ãŸç‚¹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
InnoDB vs MyISAM vs Falcon benchmarks - part 1 ã‚’èªã‚“ã ã€‚èˆˆå‘³æ·±ã‹ã£ãŸã€‚ ã ã‘ã ã¨ãƒŠãƒ³ãªã®ã§ã€æ€ã£ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã£ã¦ã¿ã‚‹ã€‚ ãŒã‚“ã°ã‚ŒFalcon ã¾ã ç”Ÿã¾ã‚ŒãŸã¦ãªã®ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®çµæžœã¯å‚è€ƒç¨‹åº¦ã«ã€‚ InnoDB vs MyISAM The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As you will see it is not always true. ã®é€šã‚Šã€ã©ã¡ã‹ã¨ã„ã†ã¨(Falconã‚ˆã‚Š)InnoDBã¨MyISAMã®æ€§èƒ½æ¯”è¼ƒã®æ–¹ãŒèˆˆå‘³æ·±ã„ç‚¹ãŒ
shozzy 2007/01/10
MySQL

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

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

Tips
ãƒªãƒ³ã‚¯
ã€ŒMySQLã¯æœ‰å„Ÿã®Enterpriseã¨ç„¡å„Ÿã®Community Serverã«åˆ†ã‹ã‚Œã‚‹ã€---MySQLç¤¾é•·
10æœˆ17æ—¥ï¼ŒMySQLã¯ã‚µãƒ–ã‚¹ã‚¯ãƒªãƒ—ã‚·ãƒ§ãƒ³ï¼ˆè³¼èªåˆ¶ï¼‰ã‚µãƒ¼ãƒ“ã‚¹ãŠã‚ˆã³æœ‰å„Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQL Enterpriseã€ã‚’ç™ºè¡¨ã—ãŸã€‚ï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚ç„¡å„Ÿç‰ˆã¯ã€ŒCommunity Serverã€ã¨ã„ã†åç§°ã«ãªã‚‹ã€‚ã©ã†å¤‰ã‚ã‚‹ã®ã‹ã€‚è©³ç´°ã‚’ï¼ŒMySQLå‰¯ç¤¾é•·ã§æ—¥æœ¬æ³•äººç¤¾é•·ã®ãƒ©ãƒªãƒ¼ãƒ»ã‚¹ãƒ†ãƒ•ã‚¡ãƒ‹ãƒƒã‚¯æ°ã«èžã„ãŸã€‚ ---MySQL EnterpriseãŒå‡ºãŸã“ã¨ã§ï¼Œä½•ãŒã©ã†å¤‰ã‚ã‚‹ã®ã‹ã€‚ MySQLã¯æœ‰å„Ÿã®Enterpriseã¨ç„¡å„Ÿã®Community Serverã«åˆ†ã‹ã‚Œã‚‹ã€‚MySQL Enterpriseã¯MySQL æœ¬ä½“ã«ï¼Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®šã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ã‚µãƒ¼ãƒ“ã‚¹ãªã©ãŒä»˜å±žã—ãŸã‚‚ã®ã€‚ç›£è¦–ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ç›£è¦–ãŒãƒ„ãƒ¼ãƒ«ã«ã‚ˆã£ã¦è¡Œã‚ã‚Œã‚‹ã€‚ MySQL Enterpriseã¯æ¯Žæœˆã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã¨ï¼Œå››åŠæœŸã”ã¨ã®ã‚µãƒ¼ãƒ“ã‚¹ãƒ»ãƒ‘ãƒƒã‚¯ã‚’æä¾›ã™
shozzy 2006/10/25
MySQL
ãƒªãƒ³ã‚¯
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
shozzy 2006/10/19
MySQL
ãƒªãƒ³ã‚¯
lc2004: heartbeat ã¨ MySQL ã§å®Ÿç¾ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ç’°å¢ƒã®æ§‹ç¯‰
shozzy 2006/10/17
MySQL
ãƒªãƒ³ã‚¯
ã€ç‰¹é›†ã€‘MySQL Clusterã‚’è©¦ã™ - ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã—ãŸåˆ†æ•£ã‚¢ãƒ‰ãƒ¬ã‚¹å¸³ã‚’ã¤ãã‚‹ (1) ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨é«˜å¯ç”¨æ€§ã¸ã®æŒ‘æˆ¦ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
Intelã®Xeonã‚„AMDã®Opteronã¨ã„ã£ãŸ64ãƒ“ãƒƒãƒˆã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãŒå®Ÿç”¨çš„ã«ãªã‚‹ã«ä¼´ã£ã¦ã€å¾“æ¥ãƒ¡ã‚¤ãƒ³ãƒ•ãƒ¬ãƒ¼ãƒ ã‚„RISCã‚µãƒ¼ãƒãŒæ‹…ã£ã¦ã„ãŸå¤§è¦æ¨¡ãªã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚·ã‚¹ãƒ†ãƒ ã‚’ã€ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸIAã‚µãƒ¼ãƒã§ç½®ãæ›ãˆã‚‹å‹•ããŒæ´»ç™ºåŒ–ã—ã€ã„ã‚ã‚†ã‚‹ã€Œã‚°ãƒªãƒƒãƒ‰ãƒ»ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€ã¸ã®ç§»è¡ŒãŒé€²ã¿ã¤ã¤ã‚ã‚‹ã€‚ä¸€èˆ¬çš„ã«ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã®ä¿¡é ¼æ€§ã‚’é«˜ã‚ã‚‹ãŸã‚ã«ã¯ã€2ã¤ã®ã‚¢ãƒ—ãƒãƒ¼ãƒãŒã‚ã‚‹ã€‚ã¾ãšã€ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹æˆã™ã‚‹ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢è‡ªä½“ã®å“è³ªã‚’é«˜ã‚ã‚‹ã“ã¨ãŒã²ã¨ã¤ã ãŒã€ä¸€å®šã®æ°´æº–ä»¥ä¸Šã®å“è³ªå‘ä¸Šã¯ã€ã©ã†ã—ã¦ã‚‚é«˜ã‚³ã‚¹ãƒˆã«ãªã‚Šã‚„ã™ã„ã®ãŒé›£ç‚¹ã ã€‚ãã“ã§ã€ç¾å®Ÿçš„ãªé¸æŠžè‚¢ã¨ã—ã¦é‡è¦ã¨ãªã‚‹ã®ãŒã€ã€Œã‚°ãƒªãƒƒãƒ‰ã€ã€Œã‚¯ãƒ©ã‚¹ã‚¿ã€ã¨ã„ã£ãŸå†—é•·åŒ–ã®æŠ€è¡“ã§ã‚ã‚‹ã€‚å˜ç‹¬ã®ã‚·ã‚¹ãƒ†ãƒ ã§ã¯æ€§èƒ½ã€ä¿¡é ¼æ€§ãŒè¦æ±‚ã«æº€ãŸãªã„ã¨ã—ã¦ã‚‚ã€è¤‡æ•°ã®ã‚·ã‚¹ãƒ†ãƒ ã®é›†åˆã¨ã—ã¦å†—é•·åŒ–ã•ã‚ŒãŸã‚°ãƒªãƒƒãƒ‰ã‚„ã‚¯ãƒ©ã‚¹ã‚¿ã§ã¯ã€å„æ§‹æˆã‚·ã‚¹ãƒ†ãƒ ãŒç›¸äº’ã«è£œå®Œã—ã‚ã„ãªãŒã‚‰å…¨ä½“ã¨ã—ã¦é«˜ã„ä¿¡é ¼æ€§
shozzy 2006/10/17
MySQL
ãƒªãƒ³ã‚¯
[ç´¹ä»‹][Rails] RadRailsã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸInstant Rails 1.4ãŒãƒªãƒªãƒ¼ã‚¹
Posted by masuidrive Tue, 10 Oct 2006 00:03:33 GMT Instant Rails 1.4 final released Windowsã§ç°¡å˜ã«Railsç’°å¢ƒã‚’æ§‹ç¯‰ã§ãã‚‹ã€Instant Rails ãŒãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã¾ã—ãŸã€‚ ä»Šå›žã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã§RadR ailsã¨é€£æºãŒå–ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã‚ˆã†ã§ã™ã€‚ åŽéŒ²ã‚½ãƒ•ãƒˆã¯ä¸‹è¨˜ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ Instant Rails Manager 1.4 Ruby 1.8.5 (from the One-Click Ruby Installer 1.8.5-21) Ruby on Rails 1.1.6 Apache 1.3.33 MySQL 4.1.9 MySQL/Ruby 2.7 (native driver) Mongrel 0.3.13.3 phpMyAdmin 2.6.1 Typo 2.6 P
shozzy 2006/10/11
phpMyAdminã¾ã§å…¥ã£ã¦ã‚‹ã‚“ã ã€‚æ–°è¦å°Žå…¥ã«ã¯ä¾¿åˆ©ãã†ã€‚

Ruby

Rails

MySQL
ãƒªãƒ³ã‚¯
oracleã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®å–å¾—ã®ä»•æ–¹ã«é–¢ã—ã¦ MySQLã§ã¯show full columns from *ãƒ†... - Yahoo!çŸ¥æµè¢‹
shozzy 2006/10/04
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®å–å¾—æ–¹æ³•

DB

MySQL

Oracle
ãƒªãƒ³ã‚¯
cl.pocari.org - æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³•
æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³• 2006-07-07-2: [MySQL] MySQL ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ InnoDB ãŒã‚ã‚Šã¾ã™ï¼Ž InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ï¼ŒMyISAM ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ç•°ãªã£ã¦ï¼Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ ibdata1 ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã¦ã„ãã¨ã“ã«ãªã‚Šã¾ã™ï¼Ž MySQL ã® datadir ã«è‡ªå‹•æ‹¡å¼µã™ã‚‹ 10 MB ã® ibdata1 ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 1 ã¤ã¨ã€5 MB ã® ib_logfile ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 2 ã¤ä½œæˆã•ã‚Œã¾ã™ - 7.5.3. InnoDB èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ http://dev.mysql.com/doc/refman/4.1/ja/innodb-start.html ã“ã® ibdata1 ã¯ï¼Œå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ã¦ã„ãã¨ï¼Œè‡ªå‹•çš„ã«ã‚µã‚¤ã‚ºã‚’æ‹¡å¼µã—ã¦ã„ãã¾ã™ï¼Ž ãŸã
shozzy 2006/10/03
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
BKCon 2006 - ã«ã½ãŸã‚“ç ”ç©¶æ‰€
æ˜¨æ—¥ã¯ BKCon 2006 ã«è¡Œã£ã¦ããŸã€‚ BK ã¨ã„ã†ã®ã¯ã€Œä¸€èˆ¬çš„ã«ã¯ãƒãƒƒãƒ‰ãƒŽã‚¦ãƒã‚¦ã®äº‹ã€ãªã‚“ã§ã™ãŒã€æ˜¨æ—¥ã®ã¯ã€BKCon ã¨è¨€ã£ã¦ã‚‚ã€ã‹ã¤ã¦é–‹å‚¬ã•ã‚ŒãŸ Bad Knowhow Conference 2004 ã®ç¶šç·¨ã¨ã‹ã§ã¯ãªãã€"B"atara "K"esuma "Con"ference 2006 ã§ã™ã€‚ â€»æ£ã—ãã¯æ¨ªæµœ Linux ãƒ¦ãƒ¼ã‚¶ã‚°ãƒ«ãƒ¼ãƒ—ä¸»å‚¬ã®ã€Œç¬¬ 65 å›žã‚«ãƒ¼ãƒãƒ«èªæ›¸ä¼šã€ã®ãƒ†ãƒ¼ãƒž "mixi.jp: Scaling Out With Open Source" ã§ã™ã€‚ ã¡ãªã¿ã«ã€Batara Kesuma ã•ã‚“ã¨ã„ã†ã®ã¯ã€æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ã®å–ç· å½¹ã€‚ mixi ã®è£å´ã‚’è¦‹ã›ã¾ã™ã¨ã„ã†ã‹ã€ã¡ã‚‡ã£ã¨ hip ãªè¨€ã„ã‹ãŸã‚’ã™ã‚Œã° "Inside mixi's backend" ã£ã¦ã‚«ãƒ³ã‚¸ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€ãƒ—ãƒ¬ã‚¼ãƒ³å†…å®¹ã¯ YAPC::Asia ã®æ™‚ã¨å¤§å‡¡åŒã˜ã§ã—ãŸãŒã€ãƒ—ãƒ¬ã‚¼ãƒ³ã®æŒã¡
shozzy 2006/10/03
mixi

MySQL

ã‚µãƒ¼ãƒ

é‹ç”¨
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºMySQLæŽ¡ç”¨ã«è¦‹ã‚‹ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
ã‚µã‚¤ãƒœã‚¦ã‚ºãŒãã‚Œã¾ã§ã®ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªãªå§¿å‹¢ã‹ã‚‰ã€MySQLã®æŽ¡ç”¨ã«è¸ã¿åˆ‡ã£ãŸèƒŒæ™¯ã«ã¯ä½•ãŒã‚ã‚‹ã®ã‹ã€‚ã‚µã‚¤ãƒœã‚¦ã‚ºã®ä»£è¡¨å–ç· å½¹ç¤¾é•·ã€é’é‡Žæ…¶ä¹…æ°ãŒãã®çœŸæ„ã‚’èªžã£ãŸã€‚ ã‚µã‚¤ãƒœã‚¦ã‚ºãŒè£½å“ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ä½¿ç”¨ã—ã¦ã„ã‚‹DBã‚’ç‹¬è‡ªDBã‹ã‚‰MySQLã«å¤‰æ›´ã—ãŸã€ãã®ç†ç”±ã‚’ç¤¾é•·è‡ªã‚‰ãŒèªžã‚‹ã¨ã„ã†è¨˜äº‹ã€‚å¸‚å ´ã«ãŠã‘ã‚‹MySQLã®ç¾åœ¨ã®çŠ¶æ³ãŒã‚ˆãåˆ†ã‹ã‚‹ã€éžå¸¸ã«æœ‰ç›Šãªè¨˜äº‹ã§ã™ã€‚ ä»¥å‰ã«NDO::Weblogã®æ–¹ã§'MySQL ã¯å•†ç”¨ RDBMS ã«ã¨ã£ã¦ã®ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³'ã¨é¡Œã—ã¦ã€ã¯ã¦ãªã«ãŠã‘ã‚‹MySQLã®ä½¿ã„æ–¹ã‚’ä¾‹ã«ã€MySQLãŒã©ã†ã—ã¦ç ´å£Šçš„ã‹ã¨ã„ã†ã“ã¨ã‚’è¿°ã¹ã¾ã—ãŸã€‚ã¯ã¦ãªã«ãŠã„ã¦ã¯ã€ ãã“ã¾ã§ã†ã¾ãã„ãã‹ã©ã†ã‹ã¯åˆ¥ã¨ã—ã¦ã€MySQL ã‚„ PostgreSQL ãŒã©ã†ã—ã¦ç ´å£Šçš„ãªã®ã‹ã¨ã„ã†å•ã„ã«é–¢ã—ã¦ã¯ã€ã¾ãšç¬¬ä¸€ã«ãƒ•ãƒªãƒ¼ã ã‹ã‚‰ã¨ã„ã†ç‚¹ãŒæŒ™ãŒã‚Šã¾ã™ã€‚ã—ã‹ã—å®Ÿã¯ã“ã“ã¯é‡è¦ãªãƒã‚¤ãƒ³ãƒˆã§ã¯ãªãã€ã‚³ã‚¹ãƒˆãŒåŠ‡çš„ã«ä¸‹ãŒã£ãŸã“ã¨
shozzy 2006/10/02
MySQL

ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
MySQLã§ã‚«ãƒ©ãƒ ã®æš—å·åŒ–ï¼å¾©å…ƒ (Nega Diary)
DBã‚’ä½œã‚‹ä¸Šã§å¿…ãšæ‚©ã‚“ã§ã—ã¾ã†å•é¡Œã€‚ ã‚‚ã—ã€ã‚‚ã—ã€ä»®ã«DBã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…¨éƒ¨ã¶ã£ã“ã¬ã‹ã‚ŒãŸå ´åˆã€ãã“ã«å€‹äººæƒ…å ±ãŒè¼‰ã£ã‹ã£ã¦ã‚‹ã¨éžå¸¸ã«ãƒžã‚ºã‚¤ã€‚ ã ã‹ã‚‰ã€ã‚‚ã—ã€ã‚‚ã—ã€ä»®ã«DBã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã¶ã£ã“ã¬ã‹ã‚Œã¦ã‚‚ã€ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦æ„å‘³ãŒå†…å®¹ã«ã€æš—å·åŒ–ã—ã¦ãŠã‘ãªã„ã‹ãƒ»ãƒ»ã¨ã€‚ DBã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹æ™‚ã¯æš—å·åŒ–ã•ã‚Œã¦ãŠã„ã¦ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‹ã‚‰å–ã‚Šå‡ºã—ãŸæ™‚ç‚¹ã§ã€å¾©å…ƒã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†æ„Ÿã˜ã€‚ MD5ã‚„CRYPTã¯ã€ä¸€æ–¹é€šè¡ŒãªãŸã‚ã€æš—å·åŒ–ã™ã‚‹å‰ã®ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‹ã£ã¦ãªã‘ã‚Œã°ä½¿ãˆãªã„ã€‚ ã©ã†ã—ãŸã‚‰ã„ã„ã‚‚ã®ã‹ã¨èª¿ã¹ãŸã®ã§ã€çµæžœã‚’ã“ã“ã«ã¾ã¨ã‚ã‚‹ã€‚ ç’°å¢ƒï¼šMySQL 4.0.2ä»¥é™ phoneã¨ã„ã†ã‚«ãƒ©ãƒ ãŒã‚ã‚Šã€ã“ã‚Œã‚’æš—å·åŒ–ã™ã‚‹ã€‚ INSERT INTO test( phone ) VALUES ( AES_ENCRYPT( '0120-000-1234', 'secret_key' ) )
shozzy 2006/06/05
æŠ€è¡“

ãƒ¡ãƒ¢

MySQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
MySQLã®å°æŠ€
This domain may be for sale!
shozzy 2006/04/12
MySQL
ãƒªãƒ³ã‚¯
http://pcweb.mycom.co.jp/news/2005/10/25/038.html
shozzy 2005/10/25
DB

MySQL

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1