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

makotokaga id:makotokaga

mysqlã«é–¢ã™ã‚‹makotokagaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«MySQLãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹ä»¶ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
2012å¹´7æœˆ1æ—¥ã®ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«ã€MySQLã‚„Javaãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹äº‹è±¡ãŒå ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ CPU %user %nice %system %iowait %steal %idle 08æ™‚30åˆ†01ç§’ all 0.02 0.00 0.02 0.04 0.00 99.91 08æ™‚40åˆ†01ç§’ all 0.02 0.00 0.02 0.08 0.00 99.88 08æ™‚50åˆ†01ç§’ all 0.02 0.00 0.02 0.03 0.00 99.92 09æ™‚00åˆ†01ç§’ all 0.11 0.00 0.13 0.04 0.00 99.72 09æ™‚10åˆ†01ç§’ all 23.02 0.00 29.09 0.11 0.00 47.78 09æ™‚20åˆ†01ç§’ all 23.11 0.00 29.08 0.06 0.00 47.75 09æ™‚30åˆ†01ç§’ all 22.85 0.00
makotokaga 2012/07/02
linux

MySQL
ãƒªãƒ³ã‚¯
Why PostgreSQL Instead of MySQL 2009 - PostgreSQL wiki
Comparing Reliability and Speed This is an unfinished work in progress; see the 2007 version for a consistent but earlier version. Introduction For years, the common industry perception has been that MySQL is faster and easier to use than PostgreSQL. PostgreSQL is perceived as more powerful, more focused on data integrity, and stricter at complying with SQL specifications, but correspondingly slow
makotokaga 2011/06/16
PostgreSQL

database

MySQL
ãƒªãƒ³ã‚¯
Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007 - PostgreSQL wiki
makotokaga 2011/06/16
PostgreSQL

database

MySQL
ãƒªãƒ³ã‚¯
Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server
UPDATE: Oracle officially released memcached daemon plugin that talks with InnoDB. I'm glad to see that NoSQL+MySQL has become an official solution. It's still preview release but will be very promising. Let's try it to make it better! Most of high scale web applications use MySQL + memcached. Many of them use also NoSQL like TokyoCabinet/Tyrant. In some cases people have dropped MySQL and have sh
makotokaga 2010/10/27
ã“ã‚Œã¯ã™ã”ã„ãªã€‚ã€ŒNo benefit for HDD bound workloadsã€ã£ã¦ã€ãã‚Šã‚ƒãã†ã‹ã€‚

mysql

handlersocket

memcached

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
makotokaga 2010/10/27
mysql

nosql
ãƒªãƒ³ã‚¯
Art of MySQL Replication.
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902
makotokaga 2010/07/27
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
makotokaga 2010/07/23
mysql

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Semisynchronous Replication (åŠåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³?)ã‚’è©¦ã—ã¦ã¿ãŸ - yoshifumi1975's diary
ä»Šã¾ã§ã®éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€åŒæœŸå®Œäº†å‰ã«ãƒžã‚¹ã‚¿ãƒ¼ãŒæ»ã‚“ã å ´åˆã«ã€ãƒ‡ãƒ¼ã‚¿ã®ãƒã‚¹ãƒˆãŒèµ·ãã‚‹ãŒã€MySQL5.5ã‹ã‚‰å°Žå…¥ã•ã‚ŒãŸ Semisynchronous Replicationï¼ˆåŠåŒæœŸï¼Ÿï¼‰ã‚’ä½¿ã†ã¨ã€ã‚¹ãƒ¬ãƒ¼ãƒ–å´ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã®æ›´æ–°ã¾ã§ãŒåŒæœŸã§è¡Œã‚ã‚Œã‚‹ã®ã§ãƒ‡ãƒ¼ã‚¿ã®ãƒã‚¹ãƒˆã®å¯èƒ½æ€§ãŒãã£ã¨æ¸›ã‚‹ã€‚ä»Šå›žã¯MySQL5.5.5_m3 ã¨ã„ã†ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã£ã¦æ¤œè¨¼ã—ãŸã€‚ OSã¯ã€CentOS5.5-64bitã€‚RPMã¯Oracle ã®ã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ MySQL-client-5.5.5_m3-1.rhel5.x86_64.rpm MySQL-server-5.5.5_m3-1.rhel5.x86_64.rpm MySQL-devel-5.5.5_m3-1.rhel5.x86_64.rpm MySQL-shared-compat-5.5.5_m3-1.rhel5.x86_64.rpmãƒ†ã‚¹ãƒˆ
makotokaga 2010/07/23
mysql

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•
MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†è¨˜äº‹ãŒã¨ã¦ã‚‚å¥½è©•ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚è¨˜äº‹ã‚’èªã‚“ã§é ‚ã„ãŸçš†ã•ã‚“ã€ã‚ã‚ŠãŒã¨ã†ã€‚ ã“ã®è¨˜äº‹ã«å¯¾ã™ã‚‹ä¾¿ä¹—ï¼ˆï¼Ÿï¼‰ã§Webå±‹ã®ãƒã‚¿å¸³: PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦é ‚ã„ãŸã‚ˆã†ã ãŒã€ãã¡ã‚‰ã®æ–¹ã‚‚ã‹ãªã‚Šäººæ°—ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚ä»–äººãŒä½œã£ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ”¹è‰¯ã‚’åŠ ãˆã‚‹ã¨ã„ã†ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ç²¾ç¥žã‚‚åŸºæœ¬ã¯ä¾¿ä¹—ã§ã‚ã‚‹ã®ã§ã€ä¾¿ä¹—ã«ã¤ã„ã¦ã¯å¤§ã„ã«è³›æˆã—ãŸã„ã¨ã„ã†ã‹ã‚€ã—ã‚å–ã‚Šä¸Šã’ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ï¼ï¼ã¨æ€ã†ã‚ã‘ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã•ã‚‰ã«ä¿ºã¯ã“ã†è€ƒãˆã‚‹ã€‚ ã¨ã€‚ Webå±‹ã®ãƒã‚¿å¸³ã•ã‚“ã®è¨˜äº‹ã§ã¯16ã®ãƒã‚¤ãƒ³ãƒˆãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãŒã€æ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã®è¨˜äº‹ã¯10ã®æ–¹æ³•ã ã£ãŸã®ã§ã‚ã¨6ã¤è¶³ã‚Šãªã„ã€‚ã‚ªãƒˆã‚³ã¯æ•°ã§å‹è² ï¼ï¼ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ãƒã‚¿ã‚’æŒ¯ã‚Šçµžã£ã¦ã•ã‚‰ã«7ã¤ã®MySQLé«˜é€ŸåŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ 1. ã‚¤ãƒ³ãƒ†ãƒ«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©
makotokaga 2010/07/23
mysql

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ç›®è¦šã¾ã—ã„é€²åŒ–ã‚’è¦‹ã›ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ - PBXTæ”¹å–„ã®è»Œè·¡
PBXTã¨ã„ã†ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã‚ã‚‹ã€‚ã“ã‚Œã¯ã€PrimeBaseç¤¾ã«ã‚ˆã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸæœ¬æ ¼çš„ãªã‚‚ã®ã§ã‚ã‚‹ã€‚ï¼ˆã¤ã¾ã‚Šã€InnoDBã‚„Falconã®ä»£æ›¿ã¨ã—ã¦ä½¿ã†ã“ã¨ã‚’ç›®æŒ‡ã—ãŸã‚¨ãƒ³ã‚¸ãƒ³ãªã®ã§ã‚ã‚‹ã€‚ï¼‰PBXTã¯æ¬¡ã®ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¯èƒ½ã ã€‚ http://www.primebase.org/ ä¸Šè¨˜ã®ãƒšãƒ¼ã‚¸ã«ã‚‚æ›¸ã„ã¦ã‚ã‚‹ãŒã€PBXTã®ç‰¹å¾´ã¯æ¬¡ã®é€šã‚Šã€‚ MVCCï¼ˆMulti Version Concurrency Controlï¼‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚µãƒãƒ¼ãƒˆACIDæº–æ‹ è¡Œãƒ¬ãƒ™ãƒ«ã®ãƒãƒƒã‚¯ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯æ¤œçŸ¥å¤–éƒ¨ã‚ãƒ¼ã®ã‚µãƒãƒ¼ãƒˆWrite Onceï¼ˆè¿½è¨˜åž‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ï¼‰BLOBã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚° æœ€å¾Œã®2ã¤ä»¥å¤–ã¯InnoDBã¨åŒã˜ã§ã‚ã‚‹ã€‚Write Onceã¨ã¯è¿½è¨˜åž‹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã€InnoDBã®ã‚ˆã†ã«ç‹¬ç«‹ã—ãŸãƒã‚°ãŒå˜åœ¨ã—ãªã„ã¨ã„ã†æ„å‘³ã§ã‚ã‚‹ã€‚ï¼ˆPostgreSQL
makotokaga 2010/07/23
mysql

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
makotokaga 2010/07/04
ãƒªãƒªãƒ¼ã‚¹ã‚’æŽ§ãˆã‚‹PostgreSQL 9.0ã¨MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒã€‚

PostgreSQL

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

tips

hack
ãƒªãƒ³ã‚¯
TwitterãŒCassandraã‚’ä½¿ã£ãŸç†ç”±ã¨ç§»è¡Œæ–¹æ³•
ã€Œæ‰èƒ½ã‚’éžç”Ÿç”£çš„ãªäº‹ã«æµªè²»ã—ã¦ã“ãã€çœŸã®ãƒ²ã‚¿ã‚¯ã§ã‚ã‚‹ã€ ã“ã®åè¨€ã«ã‹ãªã†ç‚ºã«æ—¥ã€…è‰²ã€…å¦ã¶æ—¥ã€…(å¤šåˆ†)ã€‚ ç›¸å¤‰ã‚ã‚‰ãšã®æ„è¨³ãªä¸Šã«è¦ç‚¹ã®ã¿ã®æŠœãå‡ºã—ã§ã™ã€‚ é–“é•ã£ã¦ã„ãŸã‚‰Twitterã§ã‚‚ã‚³ãƒ¡ãƒ³ãƒˆã§ã„ã„ã®ã§ãŒã‚“ãŒã‚“æŒ‡æ‘˜ã—ã¦ãã ã•ã„ã€‚ =============== Twitterã§ã¯ãƒ‡ãƒ¼ã‚¿é‡ã€ãƒ‡ãƒ¼ã‚¿å¢—åŠ é‡ãŒæ€¥åŠ é€Ÿã—ã¦ã„ã‚‹ã€‚ ä»Šã¾ã§ã¯MySQLã¨memcashedã§é‹ç”¨ã—ã¦ããŸãŒã€ç‰¹ã«é‹ç”¨è¦å“¡ã®é¢ã§è²»ç”¨ãŒèŽ«å¤§ã«ãªã£ã¦ã—ã¾ã£ãŸã€‚ ãã®ç‚ºã«ã‚ˆã‚Šè‡ªå‹•çš„ã§ã‚ˆã‚Šé«˜ã„åˆ†æ•£å®¹æ˜“æ€§ã€ã‚ˆã‚Šé«˜ã„å¯ç”¨æ€§ã‚’å¿…è¦ã¨ã—ãŸã€‚ é¸æŠžè‚¢ã¨ã—ã¦ä¸Šã£ãŸã®ãŒä¸‹è¨˜ã®äºŒã¤ã€‚ ãƒ»MySQL Clusterã®ä»Šä»¥ä¸Šã®è‡ªå‹•åŒ– ãƒ»KVS(HBaseã€Voldemortã€Mongo DBã€MemcacheDBã€Redisã€Cassandraã€HyperTa ble)ã¸ã®ç§»è¡Œ æ¬¡ã®æ¤œè¨¼ã‚’è¡Œã†äº‹ã§é¸æŠžè‚¢ã®çµžã‚Šè¾¼ã¿ã‚’è¡Œã£ãŸ ãƒ»æ–°è¦Nodeè¿½åŠ ã®å®¹æ˜“æ€§ ãƒ»SP
makotokaga 2010/03/03
twitter

mysql

rdbms

kvs
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ 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ã¨ã¯ï¼Ÿ
makotokaga 2009/12/04
mysql

database
ãƒªãƒ³ã‚¯
DOMAIN ERROR
ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚¦ã‚§ãƒ–ã®è¨å®šãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ è€ƒãˆã‚‰ã‚Œã‚‹åŽŸå› ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚¦ã‚§ãƒ–ã®è¨å®šãŒã¾ã è¡Œã‚ã‚Œã¦ã„ãªã„ã€‚ ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚¦ã‚§ãƒ–ã®è¨å®šãŒã¾ã åæ˜ ã•ã‚Œã¦ã„ãªã„ã€‚(åæ˜ ã«ã¯æ•°æ™‚é–“ï½ž24æ™‚é–“ã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™) ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚¦ã‚§ãƒ–ãƒ»DNSã®è¨å®šãŒèª¤ã£ã¦ã„ã‚‹ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆãŒå˜åœ¨ã—ãªã„ã€å¥‘ç´„ãŒçµ‚äº†ã—ã¦ã„ã‚‹ã€å‰Šé™¤ã•ã‚Œã¦ã„ã‚‹ã€‚
makotokaga 2009/05/01
mysql

PostgreSQL

database

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
mysqlã§æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã™ã‚‹ã«ã¯ï¼Ÿ (Nega Diary)
è‡ªåˆ†ãƒ¡ãƒ¢ã€‚ MySQLè‡ªä½“ã«ã¯ã€Full Textã¨ã„ã†å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ãŒã‚ã‚‹ã“ã¨ã¯ã‚ã‚‹ãŒã€æ—¥æœ¬èªžã«ã¯å¯¾å¿œã—ã¦ãªã„ã€‚ ã„ã¾ã‚“ã¨ã“ã‚ã€LIKE %hoge%ã§ã‚„ã£ãŸã‚Šã—ã¦ã‚‹ã‚“ã ã‘ã‚Œã©ã€å½“ç„¶ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ã®ã§é…ã„ã€‚ ãªã‚“ã¨ã‹MySQLã«ãŠã„ã¦ã€ï¼ˆç°¡å˜ã«ï¼‰æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã™ã‚‹æ–¹æ³•ãŒãªã„ã‹èª¿ã¹ã¦ã¿ãŸã€‚ MySQLã«ã¤ã„ã¦ã€€ä¼ã‚ˆã‚Š MySQLã§æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã‚’è¡Œã†ãŸã‚ã«ã¯ã€ã¾ãšã€å½¢æ…‹ç´ è§£æžã‚„N-gramã«ã‚ˆã£ã¦ã€æ–‡å—åˆ—ã‚’ãƒ¯ãƒ¼ãƒ‰ã”ã¨ã«åˆ†å‰²ã—ã¦ã€ã‚¹ãƒšãƒ¼ã‚¹ã§åŒºåˆ‡ã‚Šã€ã•ã‚‰ã«ã€16é€²æ•°æ–‡å—ã«å¤‰æ›ã—ãŸã‚Šã—ã¦ã€ã‚ãŸã‹ã‚‚æ—¥æœ¬èªžã§ã¯ãªã„ã‹ã®ã‚ˆã†ã«è£…ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ MySQLã§ãŠæ°—æ¥½å…¨æ–‡æ¤œç´¢ ã§ã¯ã€chasenã‚’ä½¿ã£ã¦ã€æ—¥æœ¬èªžã‚’å˜èªžã«åˆ†å‰²ã—ã€DBã«ç™»éŒ²ã—ã¦ã„ã‚‹ã®ã ã‘ã‚Œã©ã€Perlãªã®ã§èªã‚€ããŒã—ãªã„ãƒ»ãƒ» æ–¹æ³•ã¨ã—ã¦ã€ï¼’ã¤ã‚ã‚‹ã‚ˆã†ã§ã™ã€‚ ï¼‘ï¼‰chasenãªã©ã‚’ä½¿ã£ã¦ã€æ—¥æœ¬èªžã‚’å˜èªžã«åˆ†å‰²ã—ã¦ã€ã‚³ãƒ¼ãƒ‰åŒ–
makotokaga 2007/09/14
mysql

å…¨æ–‡æ¤œç´¢

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
makotokaga 2007/09/12
mixi

mysql
ãƒªãƒ³ã‚¯
MySQL
HeatWave Use automated and integrated generative AI and machine learning (ML) in one cloud service for transactions and lakehouse scale analytics. Get faster insights from all your data with unmatched performance and deploy apps in your choice of cloud providers. Learn More Â» MySQL Enterprise Edition The most comprehensive set of advanced features, management tools and technical support to achieve
makotokaga 2007/08/07
mysql
ãƒªãƒ³ã‚¯
1