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

terurou id:terurou

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

${{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ã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
14. MySQLã®â¾¯å€’ã‚’â¾’ã‚‹ #ã¨ã¯ DBã«ç‰¹åŒ–ã—ãŸï¼ˆåºƒç¾©ã®ï¼‰ã‚¤ãƒ³ãƒ•ãƒ©ãƒ‡ã‚¶ã‚¤ãƒ³ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é »åº¦, ä¿ç®¡å…ˆ, ..etc. + ãã®å®Ÿè£…- ç›£è¦–, ãƒªã‚½ãƒ¼ã‚¹ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°, ..etc. + ãã®å®Ÿè£…- mikasafabric for MySQL + MySQL Router- ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æ¤œè¨¼ã¨ã‹ã€Percona Serverã¨ã‹ MariaDBã¨ã‹ - DBã«ç‰¹åŒ–ã—ãŸã‚·ãƒ§ãƒƒãƒˆä½œæ¥ åŠã‚‹ã—ã® ALTER TABLE ä»¥å¤–ã‚’ä½¿ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®æ›´æ–° < 5.6 ã ã£ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ãŒâ¼¤ãã™ãŽã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒè©°ã¾ã£ãŸã‚Šã™ã‚‹ã‚±ãƒ¼ã‚¹ - ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°- ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—- 13/63
terurou 2017/09/06
mysql

ã‚¤ãƒ³ãƒ•ãƒ©

é‹ç”¨

ç›£è¦–
ãƒªãƒ³ã‚¯
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ¼æ´©ã—ãªã„ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã®ä½œã‚Šæ–¹ ã€œ ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã§æº€è¶³ã™ã‚‹å‰ã«è€ƒãˆã‚‹ã¹ãã“ã¨
â– â– åºè«– å¾³ä¸¸ã•ã‚“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã€Œã„ã¾ã•ã‚‰èžã‘ãªã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å–ã‚Šæ‰±ã„æ–¹ã€ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã€æ˜¨ä»Šã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆè¦ä»¶ã¨ã—ã¦ã€ã‚µãƒ¼ãƒå†…ã«ä¾µå…¥ã•ã‚ŒãŸå ´åˆã§ã‚‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã§ãã‚‹ã ã‘ä¿è·ã™ã¹ãã¨ã„ã†è«–èª¿ãŒè¦‹å—ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ä¸ŠæŽ²ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã¯ã€ãã®æ‰‹æ³•ã¨ã—ã¦ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥åŒ–ã‚’å‹§ã‚ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã‚¹ãƒ©ã‚¤ãƒ‰ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã¨ãŠã‚Šã€ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã«ã¯ã€è¤‡é›‘ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®è§£èªã¯å›°é›£ã«ãªã‚‹ã‚‚ã®ã®ã€å˜ç´”ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã«ã¤ã„ã¦ã¯ååˆ†ãªä¿è·ã‚’æä¾›ã§ããªã„ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯é©åˆ‡ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰é‹ç”¨ãŒã§ããªã„ã€ã¨ã„ã†ã®ãŒæ‚²ã—ã„ç¾å®Ÿã§ã™ã€‚ ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã‚’ä½¿ã£ãŸæ‰‹æ³•ã§ã“ã®ã‚ˆã†ãªå•é¡ŒãŒæ®‹ã‚‹ã®ã¯ã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã«ä¾µå…¥ã—ãŸæ”»æ’ƒè€…ãŒãƒ¦ãƒ¼ã‚¶ãƒ¼ã®èªè¨¼æƒ…å ±ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã€èªè¨¼æƒ…å ±ã‚’ã‚ªãƒ•ãƒ©ã‚¤ãƒ³æ”»æ’ƒã™ã‚‹ã“
terurou 2013/11/21
security

password

mysql

SQL
ãƒªãƒ³ã‚¯
SQLã«å¯¾ã™ã‚‹MySQLã¨ã€NoSQLã«å¯¾ã™ã‚‹MongoDBã¯ä¼¼ã¦ã„ã‚‹â€•â€•ä¸»ã«æœ‰å®³ãªæ„å‘³ã§ | Yakst
MySQLã®ã‚¸ãƒ§ã‚¤ãƒ³ãŒé…ã„ã“ã¨ã§SQLå…¨èˆ¬ã®ã‚¸ãƒ§ã‚¤ãƒ³ãŒé…ã„ã¨æ€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚‹ã‚ˆã†ã«ã€NoSQLã®ä¸ã§ã‚‚Mongo DBãŒæ¯”è¼ƒçš„åºƒãä½¿ã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸä»Šã€Mongo DBã®æ¬ ç‚¹ãŒNoSQLã®æ¬ ç‚¹ã ã¨å‹˜é•ã„ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ã€‚ã€ŒSQL Performance Explainedã€è‘—è€…Markus Winandæ°ã®æŒ‡æ‘˜ã€‚ æ˜¨æ—¥(9/30)ã®å¤•æ–¹ã€ç§ã¯ã€ŒSQLã«å¯¾ã™ã‚‹MySQLã®ã‚ˆã†ã«ã€NoSQLã«å¯¾ã™ã‚‹Mongo DBã«ã¯ã‚ˆããªã„é¢ãŒã‚ã‚‹ã€ã¨ãƒ„ã‚¤ãƒ¼ãƒˆã‚’ã—ãŸã€‚ã‚ã„ã«ããã®ãƒ„ã‚¤ãƒ¼ãƒˆã«ã¯èª¬æ˜ŽãŒæ¬ ã‘ã¦ã„ãŸã€‚ã¨ã¯ã„ãˆ1ã¤ã®ãƒ„ã‚¤ãƒ¼ãƒˆã«å…¨ã¦ã®å¿…è¦ãªèª¬æ˜Žã‚’å«ã‚€ã“ã¨ã¯ã§ããªã„ã ã‚ã†ã‹ã‚‰ã€ã“ã®è¨˜äº‹ã§èª¬æ˜Žã—ã‚ˆã†ã€‚ãƒ„ã‚¤ãƒ¼ãƒˆã¸ã®è¿”äº‹ã¨ã—ã¦å—ã‘å–ã£ãŸã„ãã¤ã‹ã®ç–‘å•ã«ç”ãˆã‚‰ã‚Œã‚Œã°ã¨æ€ã†ã€‚ ã¾ãšæœ€åˆã«ã€ç§ã¯å¤šè¨€èªžæ°¸ç¶šåŒ–ã®è€ƒãˆæ–¹ã«è³›åŒã¯ã™ã‚‹ãŒã€NoSQLã®ç†±ç‹‚çš„æ”¯æŒè€…ã§ã¯ãªã„ã¨ã„ã†ã“ã¨ã‚’çŸ¥ã£ã¦ãŠã„ã¦ã»ã—ã„ã€‚
terurou 2013/10/17
MongoDB

NoSQL

mysql
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
terurou 2013/09/20
mysql

MariaDB

database
ãƒªãƒ³ã‚¯
Announcing MySQL-MHA: "MySQL Master High Availability manager and tools"
I have published "MySQL MHA" that fully automates MySQL master failover. You can also get commercial support from SkySQL. Let's try MHA today! Today I'm happy to announce that I have released MySQL-MHA: MySQL Master High Availability manager and tools as an open source software (GPL v2 license). The below is a part of documentation of MHA. I'm glad if you are interested in MHA. A primary objective
terurou 2011/08/04
mysql

MySQL-MHA
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2010/07/11/20100709twitter-analytics-mysql/
terurou 2010/07/12
Cassandra

twitter

mysql
ãƒªãƒ³ã‚¯
TwitterãŒã€Cassandraã®æœ¬æŽ¡ç”¨ã‚’æ–å¿µã€‚ã€Œã„ã¾ã¯åˆ‡ã‚Šæ›¿ãˆã®æ™‚æœŸã§ã¯ãªã„ã€
ã€Œã„ã¾ã¯æ–°ã—ã„æŠ€è¡“ã¸ã®å¤§è¦æ¨¡ãªç§»è¡Œã‚’ã™ã‚‹æ™‚æœŸã§ã¯ãªã„ã¨ç¢ºä¿¡ã—ã¦ã„ã‚‹ã€ã€‚Twitterã¯ã€ã‚µãƒ¼ãƒ“ã‚¹ã®æ ¸ã¨ãªã‚‹ãƒ„ã‚¤ãƒ¼ãƒˆã‚’ä¿å˜ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€MySQLã«ã‚ˆã‚‹å¤§è¦æ¨¡åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹Cassandraã¸ç§»è¡Œã—ã‚ˆã†ã¨ã—ã¦ã„ã¾ã—ãŸã€‚ã—ã‹ã—Cassandraã¸ã®ç§»è¡Œä½œæ¥ã‚’ä¸æ¢ã—ã€å¼•ãç¶šãMySQLã§ã®é‹ç”¨ã‚’ç¶™ç¶šã™ã‚‹ã¨ã€Twitter Engineering Blogã¸ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒCassandra at Twitter Todayã€ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¯æˆ¦ç•¥ã®å¤‰æ›´ã Twitterã¯åˆ©ç”¨è€…ã‹ã‚‰ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’ã€Scalaã«ã‚ˆã£ã¦ç‹¬è‡ªé–‹ç™ºã—ãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã€ŒGizzardã€ã¨MySQLã€ãã—ã¦memcachedã‚’ç”¨ã„ãŸå¤§è¦æ¨¡åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã—ã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã“ã†ã—ãŸè¤‡é›‘ãªã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã‚‹é‹ç”¨ã¯éžå¸¸ã«æ‰‹é–“ãŒã‹ã‹ã‚Šã€äººçš„ã‚³ã‚¹ãƒˆã‚’ä¸å¿ƒã¨ã—ãŸã‚³ã‚¹ãƒˆã®å¢—åŠ ãŒéžå¸¸ã«å¤§ãããª
terurou 2010/07/12
ã€ŒCassandraã‚ˆã‚Šã‚‚MySQLã®æ–¹ãŒã™ã’ãƒ¼ï¼ã€ã£ã¦èª¤èªã™ã‚‹äººé–“ã®å‰²åˆãŒæ°—ã«ãªã‚‹ / ã¾ãã€ç¾çŠ¶ã®Cassandraã¯å®‰å®šã—ã¦ã„ã‚‹ã¨ã¯åˆ°åº•è¨€ãˆãªã„ãƒ¬ãƒ™ãƒ«ã ã—ãªã

twitter

Cassandra

mysql
ãƒªãƒ³ã‚¯
ã¼ããŒPDOã‚’æŽ¡ç”¨ã—ãªã‹ã£ãŸã‚ã‘(Shift_JISã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³)
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´7æœˆ1æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚ è¿½è¨˜(2011/06/19) ã“ã“ã«æ¥ã¦æ€¥ã«ãƒ–ã‚¯ãƒžãŒè¿½åŠ ã•ã‚Œã¯ã˜ã‚ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰çŠ¶æ³ãŒæ”¹å–„ã—ã¦ã„ã¾ã™ã€‚PHP5.3.6(2011/03/17)ã«ã¦ã€PDOã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ç‰ˆã§ã€UNIXç‰ˆã®PHPã§ã¯è§£æ±ºã—ã¾ã—ãŸãŒã€Win
terurou 2010/07/03
php

PDO

security

mysql
ãƒªãƒ³ã‚¯
HeidiSQL - MariaDB/MySQL, MSSQL, PostgreSQL, SQLite and Interbase/Firebird made easy
What is HeidiSQL? HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and M
terurou 2010/05/13
mysql
ãƒªãƒ³ã‚¯
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£é¨’ç„¶ï¼MySQL 5.5.4ãŒä¸Žãˆã‚‹ã‚¤ãƒ³ãƒ‘ã‚¯ãƒˆã€‚
å…ˆé€±ã€MySQL Conference & Expo 2010ãŒé–‹å‚¬ã•ã‚Œã€ç››æ³ã®ã†ã¡ã«çµ‚äº†ã—ãŸã€‚ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«åˆã‚ã›ã‚‹å½¢ã§ã€MySQL 5.5.3ãŠã‚ˆã³5.5.4ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã®ã ãŒã€ã“ã‚ŒãŒç›®ã‚’è¦‹å¼µã‚‹ã‚ˆã†ãªé€²åŒ–ã‚’é‚ã’ã¦ã„ã‚‹ã€‚ç‰¹ã«æ€§èƒ½é¢ã§ã®é€²åŒ–ã«ã¯ç›®ã‚’è¦‹å¼µã‚‹ã‚‚ã®ãŒã‚ã‚‹ï¼Jeremy Zawodnyã‚„Mark Calleghanã¨ã„ã£ãŸã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®é‡éŽ®ãŸã¡ã‚‚ã€Œéžå¸¸ã«ã‚¨ã‚ã‚µã‚¤ãƒ†ã‚£ãƒ³ã‚°ãªãƒªãƒªãƒ¼ã‚¹ã ï¼ã€ãªã©ã¨è¡¨ã—ã¦æ“è¿Žã®æ„ã‚’è¡¨ã—ã¦ã„ã‚‹ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€æœ¬æ—¥ã¯MySQL 5.5.3/5.5.4ã®æ–°æ©Ÿèƒ½ãŠã‚ˆã³å¤‰æ›´ç‚¹ã«ã¤ã„ã¦ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ã¦ã¿ã‚ˆã†ï¼ ãŠã•ã‚‰ã„ã€‚ ã€œ MySQL 5.5ã®æ—¢å˜ã®æ©Ÿèƒ½ ã€œMySQL 5.5ãŒç™»å ´ã—ãŸã¨ãã€ãã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã¯ä»¥å‰ã«ã‚‚ã‚¨ãƒ³ãƒˆãƒªã§ç´¹ä»‹ã—ãŸãŒã€ã“ã“ã§æ”¹ã‚ã¦ãŠã•ã‚‰ã„ã—ã¦ã¿ã‚ˆã†ã€‚MySQL 5.5ã¯ã€æ£ç¢ºã«ã„ã†ã¨ç¾åœ¨æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.1ã®ã€Œæ¬¡ã®æ¬¡ã€ã®ãƒ
terurou 2010/04/19
mysql
ãƒªãƒ³ã‚¯
FriendFeedã§ã¯My-SQLã‚’ä½¿ã„ã€ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ | gihyo.jp
æ¿ƒç¸®é‚„å…ƒã‚ªãƒ¬ãƒ³ã‚¸ãƒ‹ãƒ¥ãƒ¼ã‚¹ FriendFeedã§ã¯My-SQLã‚’ä½¿ã„ã€ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ FriendFeedã®å‰µæ¥è€…ã§ã‚ã‚Šé–‹ç™ºè€…ã§ã‚ã‚‹Bret Tayloræ°ã«ã‚ˆã‚‹ãƒ–ãƒã‚°è¨˜äº‹ã®ç¿»è¨³ã§ã™ã€‚FriendFeedã¯Twitterã‚„YouTubeã€Flickrãªã©ã®å„ç¨®Webã‚µãƒ¼ãƒ“ã‚¹ã®æ›´æ–°ã‚’é›†ç´„ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚è¨˜äº‹ã§ã¯FriendFeedã§ä½¿ã‚ã‚Œã¦ã„ã‚‹My-SQLã®ç‹¬ç‰¹ãªã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆã«ã¤ã„ã¦ã€DDLï¼ˆData Definition Languageï¼‰ã‚’ç¤ºã—ãªãŒã‚‰è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ FriendFeedã¯2å„„5åƒä¸‡ã‚‚ã®ã‚¨ãƒ³ãƒˆãƒªã‚„ã‚³ãƒ¡ãƒ³ãƒˆãªã©ã€å¤šãã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã—ã¦ã„ã¾ã™ã€‚ã‚¹ã‚ãƒ¼ãƒžã‚’å¤‰æ›´ã™ã‚‹ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ›´æ–°ãŒå¿…è¦ã«ãªã‚Šã€ãƒ‡ãƒ¼ã‚¿é‡ãŒå·¨å¤§ã§ã‚ã‚‹ãŒã‚†ãˆã«ã€æ€§èƒ½ã‚„ç¨¼åƒæ€§ã‚’ç¢ºä¿ã—ãªãŒã‚‰ã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã‚’è¡Œã†ã“ã¨ãŒã‹ãªã‚Šã®é‹ç”¨è² è·ã«ãªã£ã¦ã„ãŸã‚ˆã†ã§ã™ã€‚ã§ã‚‚ã€CouchDBãªã©ã®ã‚¹
terurou 2010/03/05
Pythonã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã—ã¦BLOBã¸ã¶ã¡ã“ã‚€ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒæ¬²ã—ã„å ´åˆã¯å¯¾è±¡ã®ã‚ãƒ¼ã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã€‚çµåˆã¯ã‚¢ãƒ—ãƒªã§è¡Œã†ã€‚

friendfeed

mysql

schemaless

python
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
terurou 2009/10/20
è¦ã¯Key-Value Storageçš„ãªã€‚

friendfeed

database

PaaS

mysql
ãƒªãƒ³ã‚¯
GitHub - DbLinq/dblinq2007: LINQ provider for Oracle, PostgreSQL, MySQL, Ingres, SQLite, Firebird and ... SQL Server
Archived project: this project is not maintained anymore. #Welcome to DbLinq ##LINQ provider for Oracle, PostgreSQL, MySQL, Ingres, SQLite, Firebird and ... SQL Server (C# 3.0) DbLinq is THE LINQ provider that allows to use common databases with an API close to Linq to SQL. It currently supports (by order of appearance): MySQL, Oracle, PostgreSQL, SQLite, Ingres, Firebird... And still SQL Server.
terurou 2008/12/14
SQL Serverä»¥å¤–ã®DBç”¨ã®LINQãƒ‰ãƒ©ã‚¤ãƒ

.net

LINQ

database

C#

oracle

postgresql

SQLite

mysql

Firebird
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/mysql_direct_access.php
terurou 2008/06/21
SQLã‚’ä»‹ã•ãšã«ç›´æŽ¥APIå©ã‘ã°æ—©ã„ã‚ˆã€ã¨ã€‚

c++

database

mysql

performance

storage
ãƒªãƒ³ã‚¯
MySQL :: MySQL Workbench
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. Design MySQL Workbench enables a DBA, developer, or data architect to visually design
terurou 2008/04/24
ã¡ã‚ƒã‚“ã¨èª¿ã¹ã¦ãªã„ã‘ã©ã€DBDesigner4ã®å¾Œç¶™ï¼Ÿãƒ‡ãƒ¼ã‚¿ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã‚‚ã§ãã‚‹ã—ã€UIã‚‚ä¼¼ã¦ã‚‹ã€‚

mysql

database

modeling

software

windows

linux

mac
ãƒªãƒ³ã‚¯
MySQL Conference 2008ã«è¡Œã£ã¦æ¥ãŸ - stanaka's blog
ä»Šå¹´ã‚‚MySQL Conference 2008ã«è¡Œã£ã¦ãã¾ã—ãŸã€‚ç¤¾å†…å‘ã‘ã®å ±å‘Šè³‡æ–™ã¨é›‘å¤šãªãƒ¡ãƒ¢ã§ã™ãŒã€ã‚ˆã‚ã—ã‘ã‚Œã°å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ *1 æ¦‚è¦ MySQLãŒSunã«è²·åŽã•ã‚Œã¦å§‹ã‚ã¦ã®Conference 8ã‚»ãƒƒã‚·ãƒ§ãƒ³ä¸¦åˆ—ã§ã€OSCONã®è¦æ¨¡ã«ã ã„ã¶è¿‘ã„ MySQLãŒæ‰±ã†ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯é‡ãƒ»ãƒ‡ãƒ¼ã‚¿é‡ãŒã©ã‚“ã©ã‚“å¤§ãããªã£ã¦ãã¦ãŠã‚Šã€ãã‚Œã«ã©ã†è¿½å¾“ã™ã‚‹ã‹ã€ã¨ã„ã†è¦³ç‚¹ã®è©±ãŒå¤šã„ è²·åŽã®è©±ã¨ã‹ "MySQLã€æ–°æ©Ÿèƒ½è¿½åŠ ã¯æœ‰å„Ÿç‰ˆã®ã€ŒMySQL Enterpriseã€ã ã‘ã‚’å¯¾è±¡ã«"ã¨ã„ã†ã®ã¯ã€ã‹ãªã‚ŠãƒŸã‚¹ãƒªãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãªè¨˜äº‹ å®Ÿä½“ã¯ä¸€éƒ¨ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å½¢ã®æ©Ÿèƒ½ã‚„native storage engine-specific driverã‚’MySQL Enterpriseã¨ã—ã¦å‡ºã™ã€ã¨ã„ã†è©± Backupæ©Ÿèƒ½ã‚„ã€Falcon, Mariaã¨ã„ã£ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®é–‹ç™ºã§ã¯ã€Community Serverã¨E
terurou 2008/04/22
mysql

database

report

event

scalability

å®Ÿç¸¾
ãƒªãƒ³ã‚¯
VertrigoServ WAMP
VertrigoServ is a complete free WAMP server allowing PHP development for Windows. It installs Apache 2.4, PHP, MySQL and PhpMyAdmin, both installing and setting up the environment. An uninstaller allows you to remove Vertrigo from hard disc. Vertrigo is a freeware compilation of free software (under GPL, Apache License). Main aplication has closed source code. For license details please take a loo
terurou 2008/03/25
XAMPPã‚ˆã‚Šãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ãªç®¡ç†ãƒ»è¨å®šã‚³ãƒ³ã‚½ãƒ¼ãƒ«ä»˜ãã®ã‚ªãƒ¼ãƒ«ã‚¤ãƒ³ãƒ¯ãƒ³ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€‚

windows

VertrigoServ

apache

php

mysql

SQLite

Zend Optimizer
ãƒªãƒ³ã‚¯
ã¤ã¿ãWeb
terurou 2008/03/18
æ±Žç”¨DBæ“ä½œãƒ„ãƒ¼ãƒ«ã€‚SQLã®å‹•ä½œãƒã‚§ãƒƒã‚¯ã‚’ã¡ã‚‡ã„ã¡ã‚‡ã„ã‚„ã‚‹æ™‚ã«ä½¿ã†

windows

software

database

mysql

postgresql

oracle

odbc

sql
ãƒªãƒ³ã‚¯
Developer Tools Bitnami Application Catalog
These software listings are packaged by Bitnami. The respective trademarks mentioned in the offerings are owned by the respective companies, and use of them does not imply any affiliation or endorsement. The software is licensed to you subject to one or more open source licenses and VMware provides the software on an AS-IS basis. If you are looking to use our images in production environments, VMw
terurou 2008/03/17
JRubyé–‹ç™ºç’°å¢ƒã®ä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚XAMPPã¿ãŸã„ãªã‚‚ã‚“ã€‚

java

ruby

JRuby

mysql

svn

apache

tomcat

SQLite

é–‹ç™ºç’°å¢ƒ
ãƒªãƒ³ã‚¯
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
terurou 2008/01/23
tips

mysql

database

é–‹ç™ºç’°å¢ƒ
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸