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

yagitoshiro id:yagitoshiro

MySQLã«é–¢ã™ã‚‹yagitoshiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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å…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
yagitoshiro 2010/11/25
architecture

rdbms

mysql

performance
ãƒªãƒ³ã‚¯
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/
yagitoshiro 2010/10/29
mysql

performance
ãƒªãƒ³ã‚¯
ï¼ ITï¼šAmazon RDSã®ä½¿ã„æ–¹ï¼ˆ1/3ï¼‰
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBã€ŒMySQLã€ã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§åˆ©ç”¨ã—ã€ãƒ‹ãƒ¼ã‚ºã«å¿œã˜ã¦ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’å¢—ã‚„ã›ã‚‹ã€ŒAmazon RDSã€ï¼ˆAmazon Relational Database Serviceï¼‰ã€‚ãã®ç‰¹å¾´ã¨ä½¿ã„æ–¹ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ TISæ ªå¼ä¼šç¤¾ SonicGarden ä¸¦æ²³ ç¥è²´ 2010/4/12 Amazon Web Servicesã®ãƒ‹ãƒ¥ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ å¤§æ‰‹ãƒ‘ãƒ–ãƒªãƒƒã‚¯ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã®1ã¤ã§ã‚ã‚‹Amazon Web Servicesã¯ã€2009å¹´ä»¥é™ã‚‚ç¶šã€…ã¨æ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚„æ©Ÿèƒ½ã‚’ç™ºè¡¨ã—ã€æ—¥æœ¬ã§ã‚‚ã¾ã™ã¾ã™æ³¨ç›®ã‚’é›†ã‚ã‚‹å˜åœ¨ã¨ãªã£ã¦ã„ã¾ã™ã€‚ Amazon Web Servicesã¯ã€ä»®æƒ³ã‚µãƒ¼ãƒã‚’1æ™‚é–“å˜ä½ã®å¾“é‡åˆ¶ã§åˆ©ç”¨ã§ãã‚‹Amazon EC2ã‚„ã€1GBå˜ä½ã‹ã‚‰ã®å¾“é‡åˆ¶ãªãŒã‚‰ã€é«˜ä¿¡é ¼æ€§ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒåˆ©ç”¨ã§ãã‚‹Amazon S3ãªã©ã‚’ä¸å¿ƒã¨ã—ãŸã€IaaSï¼ˆInfrastru
yagitoshiro 2010/04/15
amazon

aws

rds

mysql

database

cloud
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
yagitoshiro 2009/07/31
performance

mysql
ãƒªãƒ³ã‚¯
MySQL :: How to Monitor MySQL's performance
Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links. Here are some ideas, how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight probl ems or even dangerous situations.B
yagitoshiro 2009/07/07
database

performance

mysql
ãƒªãƒ³ã‚¯
Planet MySQL :: Planet MySQL - Archives - libdrizzle + SQLite hack
yagitoshiro 2009/06/15
libdrizzle

sqlite

mysql

drizzle
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
yagitoshiro 2009/04/02
mysql

performance
ãƒªãƒ³ã‚¯
Charming Python: Functional programming in Python, Part 3
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
yagitoshiro 2009/03/23
php

mysql

sphinx
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
yagitoshiro 2009/03/23
php

mysql

Solr
ãƒªãƒ³ã‚¯
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/
yagitoshiro 2009/03/05
friendfeed

mysql

nosql
ãƒªãƒ³ã‚¯
Drizzleã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ã„ã¦ã¿ãŸ (èªè¨¼ç³») - moriyoshiã®æ—¥è¨˜
Drizzleã®SASLãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ã„ã¦ã¿ãŸã€‚ Drizzleã¨ã¯ å‰å‚ã•ã‚“ã®ãƒ–ãƒã‚°è¨˜äº‹ã‚„@ITã®è¨˜äº‹ãªã©ã‚’å‚ç…§ã—ã¦ã‚‚ã‚‰ãˆã‚Œã°ã€‚ ä¸€è¨€ã§ã„ã†ã¨ã€ŒLean and Mean MySQLã€ã€‚ Drizzleã‚’ãƒ“ãƒ«ãƒ‰ã™ã‚‹ã«ã¯ 1æ¬¡æƒ…å ±ã®åž‚ã‚Œæµã—å¤±ç¤¼ã€‚ ã¾ãšã€Protocol Buffersã¨libeventã¨ã„ã†2å¤§ãƒã‚ºãƒ¯ãƒ¼ãƒ‰çš„ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã¨ã€PCREã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã“ã„ã¤ã‚‰ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¿…é ˆã€‚ ã‚ã¨ã¯éžå¿…é ˆã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã¨ã—ã¦ã€ OpenSSL zlib libintl (gettext) readline ãŒã‚ã‚‹ã€‚ ãƒ“ãƒ«ãƒ‰ã®ãŸã‚ã®ãƒ„ãƒ¼ãƒ«é¡žã¨ã—ã¦ã¯ä»¥ä¸‹ãŒå¿…è¦ã€‚ libtool automake autoconf bison g++ (gcc) ã¾ãŸã€ã‚½ãƒ¼ã‚¹ã¯Bazaarã‚’ä½¿ã£ã¦å¼•ã£å¼µã£ã¦ãã‚‹ãªã©ã™ã‚‹ã®ãŒã‚ˆã„ã¨æ€ã‚ã‚Œã‚‹ã®ã§ã€‚ã“ã‚Œã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ 1. ã‚½ãƒ¼ã‚¹ã®ã‚¯ãƒãƒ¼ãƒ³ Wikiã®èª¬æ˜Žã‚’è¦‹ã‚‹
yagitoshiro 2008/11/03
MySQL

Drizzle
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Introducing the Drizzle Project
ã“ã“ã—ã°ã‚‰ãã€æ°´é¢ä¸‹ã§Brian Akerã‚’ä»£è¡¨ã¨ã™ã‚‹MySQL/SUNã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã‚„ã€æ¥ç•Œã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒãƒƒã‚«ãƒ¼ãŸã¡ã¨MySQLã‚’ã‚¹ãƒªãƒ ãƒ€ã‚¦ãƒ³ã•ã›ãŸãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«RDBMSã‚’é–‹ç™ºã—ã¦ã„ãŸã®ã§ã™ãŒã€æœ¬æ—¥ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã•ã‚ŒãŸã®ã§ã€æ—¥æœ¬èªžã§ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Drizzleã¨ã¯ï¼Ÿ Drizzleã¨ã¯å¿…è¦ã®ãªã„ã‚‚ã®ã¯ä¸€åˆ‡å˜åœ¨ã—ãªã„ã€æœ€ä½Žé™ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é‡è¦–ãªã€ŒMySQLã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ã§ã€è»½ãã€å®‰å®šã—ã¦ã€é«˜é€Ÿãªã€ MySQLã®forkã§ã™ã€‚ãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ãŸã®ã§ã€å¿…è¦ã®ãªã„ã‚‚ã®ã¯å¾Œä»˜ã‘ã§ãã‚‹æ§‹æˆã§ã™ã€‚ã“ã†ã„ã£ãŸç›®æ¨™ã‚‚ã‚ã‚Šã€ç¾åœ¨ã€Drizzleã®é–‹ç™ºãƒãƒ¼ãƒ ã¯MySQLã‚’ãƒ‰ãƒ©ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã«ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã—ã¦ã„ã¾ã™ã€‚ ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ Drizzleã§å¤§äº‹ãªäº‹ã¯ã€Drizzleã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚ã‚‹ã¨ã„ã†äº‹ã§ã™ã€‚Montyã®ãƒ–
yagitoshiro 2008/11/03
database

MySQL

mixi
ãƒªãƒ³ã‚¯
MySQL and SQL Column Truncation Vulnerabilities | SuspeK
yagitoshiro 2008/09/10
PHP

security

MySQL
ãƒªãƒ³ã‚¯
MySQL Conf - Memcached Internals - igvita.com
By Ilya Grigorik on April 22, 2008 Brian Aker and Alan Kasindorf gave a great talk on Memcached - every developer's favorite caching layer - at MySQL User Conference earlier last week. The slides are available online, and they're well worth a bookmark. Brian and Alan promised to continue updating the deck as they hone out their presentation at OSCON and other events. In fact, their next iteration
yagitoshiro 2008/04/23
MySQL

memcached
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/04/q4m_crawler.php
yagitoshiro 2008/04/10
crawler

Perl

MySQL
ãƒªãƒ³ã‚¯
MySQLã€æ–°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³Mariaã‚’æŠ•å…¥- InnoDBã®ä»£ã‚ã‚Šã¨ãªã‚‹ã‹ - builder by ZDNet Japan
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æ´»ç”¨ã¯ã‚ãŸã‚Šã¾ãˆï¼ ãã‚“ãªä»Šã ã‹ã‚‰ã“ãæ”¹ã‚ã¦è€ƒãˆã‚‹ ä¼æ¥ITã«ãŠã‘ã‚‹OSSæ´»ç”¨ã®ãƒ¡ãƒªãƒƒãƒˆã¨ãƒªã‚¹ã‚¯ ã‚ªãƒ©ã‚¯ãƒ«ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆãŒèªžã‚‹ï¼ å¤šãã®ä¼æ¥ã§åˆ©ç”¨ã•ã‚Œã‚‹ã‚ªãƒ©ã‚¯ãƒ«DBã®èª²é¡Œ ã‚¢ã‚»ã‚¹ãƒ¡ãƒ³ãƒˆã®é‡è¦æ€§ã¨ã‚³ã‚¹ãƒˆæœ€é©åŒ– ãƒ“ã‚¸ãƒã‚¹ã®æŽ¨é€²ã«ã¯å¿…é ˆï¼ ZDNetÃ—ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒè´ˆã‚‹ç‰¹åˆ¥ä¼ç”» ä»Šã€å¿…è¦ãªæˆ¦ç•¥çš„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ã‚¬ãƒãƒŠãƒ³ã‚¹ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¢ãƒ€ãƒŠã‚¤ã‚º æ±‚ã‚ã‚‰ã‚Œã¦ã„ã‚‹èƒŒæ™¯ã«ã‚ã‚‹ãƒ“ã‚¸ãƒã‚¹ã®ä»Š ãã—ã¦ã€æˆåŠŸã®éµã‚’æ¡ã‚‹DevOpsã®çœŸã®æ„å‘³ ä»Šã‚’çŸ¥ã‚Šã€æœªæ¥ã‚’è¦‹æ®ãˆã‚‹ åŸ¹ã£ã¦ããŸãƒŽã‚¦ãƒã‚¦ã‚’æœ€æ–°æŠ€è¡“ã¸å¯¾å¿œã•ã›ã‚‹ ãƒ¬ã‚¬ã‚·ãƒ¼ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ¢ãƒ€ãƒ³åŒ–å®Ÿç¾ã¸ã®é“ è‡ªç¤¾åˆ©ç”¨ã®çŸ¥è¦‹ãƒ»çµŒé¨“ã‚’é¡§å®¢ã«æä¾› ã‚³ãƒ³ãƒ†ãƒŠæ´»ç”¨ã‚’æŽ¨é€²ã™ã‚‹æ—¥ç«‹è£½ä½œæ‰€ VMware Tanzuã‚’åˆ©ç”¨ã—ãŸãƒ¢ãƒ€ãƒŠã‚¤ã‚ºã‚’ä¼æŽˆ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ¢ãƒ‡ãƒ«ã¯å¤‰ã‚ã£ãŸï¼ ã‚¯ãƒ©ã‚¦ãƒ‰æ´»ç”¨ã€ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã¯ã‚ãŸã‚Šã¾ãˆ ã„ã¾æ±‚ã‚ã‚‰ã‚Œã‚‹ã‚¼ãƒãƒˆãƒ©ã‚¹ãƒˆå®Ÿç¾ã®ãŸã‚ã« ã‚³ãƒ³ãƒ†ãƒŠã‚’ã‚¨ãƒ³ãƒ—
yagitoshiro 2008/02/02
MySQL
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Q4M - MySQL ä¸Šã§å‹•ä½œã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼
yagitoshiro 2008/01/16
MySQL
ãƒªãƒ³ã‚¯
Q4M - a Message Queue for MySQL
Q4M (Queue for MySQL) is a message queue licensed under GPL that works as a pluggable storage engine of MySQL, designed to be robust, fast, flexible. It is already in production quality, and is used by several web services (see Users of Q4M). To start using Q4M, download either a binary or source distribution from the install page, and follow the installation instructions. A small tutorial is also
yagitoshiro 2008/01/16
MySQL
ãƒªãƒ³ã‚¯
SET NAMESã¯ç¦æ¢
(Last Updated On: 2018å¹´8æœˆ13æ—¥)MySQLã«ã¯æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹ã€ŒSET NAMESã€SQLæ–‡ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆPostgreSQLã‚‚åŒæ§˜ã®SQLæ–‡ã€SET CLIENT_ENCODINGãŒã‚ã‚Šã¾ã™ï¼‰ã“ã®æ©Ÿèƒ½ã¯SQLã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰ã¯ä½¿ã£ã¦ã‚ˆã„æ©Ÿèƒ½ã§ã™ãŒã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„æ©Ÿèƒ½ã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«è„†å¼±ã«ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Ruby on Railsã®æœ¬ã‚’èªã‚“ã§ã„ã¦ã€ActiveRecordã‚’èª¬æ˜Žã—ã¦ã„ã‚‹éƒ¨åˆ†ã«MySQLã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹å ´åˆã®ä¾‹ã¨ã—ã¦SET NAMESãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯SET NAMESã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„äº‹ã‚’å‘¨çŸ¥ã•ã›ã‚‹ã®ã¯çµæ§‹æ™‚é–“ãŒå¿…è¦ã‹ãªã¨æ€ã„ã¾ã—ãŸã€‚ PHPã‚‚5.2ã®é€”ä¸ã‹ã‚‰MySQLãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«libmysqlã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¨å®šAPIã®ãƒ©ãƒƒãƒ‘ãƒ¼é–¢æ•°ãŒ
yagitoshiro 2007/12/13
database

MySQL

PHP

rails

security

PostgreSQL
ãƒªãƒ³ã‚¯
Donâ€™t use addslashes for database escapes | Jansch.nl
yagitoshiro 2007/12/04
database

mysql

security

php
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸