Kazuho@Cybozu Labs: パフォーマンスã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“リティã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚テクãƒãƒ£ (BPStudy#25発表資料)
先週金曜日ã€BPStudy#25ã§ã€ã€Œãƒ‘フォーマンスã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“リティã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚テクãƒãƒ£ã€ã¨ã„ã†é¡Œç›®ã§è©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®éš›ã«ä½¿ç”¨ã—ãŸç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ 1. Happy Optimization 最åˆã«ã€æœ€é©åŒ–ã®è€ƒãˆæ–¹ã¨ã—ã¦ã€ä¸Šé™å€¤ã‚’予測ã—ã€ãれを元ã«ãƒªã‚½ãƒ¼ã‚¹é…分を考ãˆã‚‹ã€ã¨ã„ã†æ‰‹æ³•ã‚’説明ã—ã¾ã—ãŸã€‚
Web高速化 || パフォーマンスãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Blog: インターオフィス
AWSアドãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ートナーã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ュリティã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”相談ã«ä¹—らã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„æ案ãŒã‚‚らãˆãªã„ クラウドã®å°Žå…¥ã«ã‚»ã‚ュリティã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ 社内ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„る人ãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ 開発を詳ã—ã知りãŸã„
To be (free) or not to be (free)
Rambling thoughts about recent events in MariaDB / MySQL or Free software/Open source Tonight at 4:30 AM, USA Pacific time, my phone started to ring; it was a call from a Sun employee saying that Oracle has bought Sun and he wanted to join Monty Program Ab. Shortly after that I got a call from a Swedish newspaper, Computer Sweden, who asked me about my opinion about why Oracle would buy Sun. The r
Oracleã€Sunã‚’è²·åŽ
ç±³Oracleã¯4月20æ—¥ã€ç±³Sun Microsystemsã‚’ç´„74億ドルã§è²·åŽã™ã‚‹ã“ã¨ã«ã¤ã„ã¦ã€Sunã¨åˆæ„ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚Sunæ ªä¸»ã®åˆæ„ãªã©ã‚’経ã¦ã€æ£å¼ã«æ±ºå®šã™ã‚‹ã€‚ Sunæ ªå¼ã‚’ã€1æ ªå½“ãŸã‚Š9.5ドルã§è²·åŽã€‚「最高ã®ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ライズソフトウェアã¨ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªã‚³ãƒ³ãƒ”ューティングシステムãŒèžåˆã™ã‚‹ã€ã¨ã—ã€é¡§å®¢å´ã®ä½œæ¥è² æ‹…ãªã—ã§ä¸¡ç¤¾ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’çµ±åˆã™ã‚‹ã¨ã—ã¦ã„る。 Oracleã®ä¼æ¥ã‚µã‚¤ãƒˆãƒˆãƒƒãƒ—ページã«ã¯ã€ã€ŒOracle Buys Sunã€ã¨ã€Sunã®ã‚µã‚¤ãƒˆã«ã¯ã€ŒORACLE TO BUY SUNã€æ›¸ã‹ã‚ŒãŸå¤§ããªãƒãƒŠãƒ¼ãŒæŽ²è¼‰ã•ã‚Œã¦ã„る。 Sunã‚’ã‚ãã£ã¦ã¯ã€ç±³IBMã‚„ç±³Hewlett-Packard（HP）も買åŽæ案ã—ãŸã¨å ±ã˜ã‚‰ã‚Œã¦ã„ãŸã€‚HPã¨Oracleã§Sunã‚’2分割ã™ã‚‹æ¡ˆã‚‚ã‚ã£ãŸã¨ã•ã‚Œã‚‹ã€‚
Richard Jones | Anti-RDBMS: A list of distributed key-value stores | Richard Jones, Esq.
Please Note: this was written January 2009 - see the comments for updates and additional information. A lot has changed since I wrote this. Perhaps you’re considering using a dedicated key-value or document store instead of a traditional relational database. Reasons for this might include: You're suffering from Cloud-computing Mania. You need an excuse to 'get your Erlang on' You heard CouchDB was
mixiã®å¹´æœ«å¹´å§‹å¯¾ç– 日記投稿システムã®æ”¹å–„ - mixi engineer blog
æœæ™©å†·ãˆã¦ãã¾ã—ãŸã。風邪ãªã©å¼•ã„ã¦ã„ã¾ã›ã‚“ã§ã—ょã†ã‹ã€‚ã•ã¦ã€å¹´æœ«ãŒè¿‘ã¥ã„ã¦ãã‚‹ã“ã®æ™‚期ã«å¼Šç¤¾ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæœ€ã‚‚æ°—ã«ãªã‚‹ã®ã¯ã€ãŠæ£æœˆã€‚ãれもæ¥å¹´1月1日を迎ãˆãŸçž¬é–“ã§ã™ã€‚ 1æ—¥1æ—¥0時ã«ä½•ãŒã‚ã‚‹ã®ã§ã—ょã†ï¼Ÿãã†ã€mixiã®ã‚µãƒ¼ãƒ“スã§æœ€ã‚‚日記ãŒæ›¸ãè¾¼ã¾ã‚Œã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã«ãªã‚‹ã®ã§ã™ã€‚個人的ã«ã€Œã‚ã‘ãŠã‚ã“ã¨ã‚ˆã‚アタックã€ã¨å‘¼ã‚“ã§ã„ã¾ã™ã€‚今年ã¯æ—¥è¨˜ã ã‘ã§ã¯ãªãã€ã‚¨ã‚³ãƒ¼ã§ã‚‚メッセージãŒé£›ã³äº¤ã†ã“ã¨ã§ã—ょã†ã€‚ã“ã®æ™‚期ã¯æºå¸¯é›»è©±ã®ã‚ャリアã§ã‚‚ã•ã¾ã–ã¾ãªå¯¾ç–ã‚’è¡Œã£ã¦ã„ã¾ã™ãŒã€ãƒŸã‚¯ã‚·ã‚£ã§ã‚‚年末年始ã§ã‚‚ユーザã®æ–¹ã«å¿«é©ã«ã‚µãƒ¼ãƒ“スæä¾›ãŒã§ãるよã†ã«åŠªã‚ã¦ã„ã¾ã™ 以下ã¯æ˜¨å¹´ã®å¹´æœ«å¹´å§‹ã®æ—¥è¨˜æŠ•ç¨¿æ•°ã®æŽ¨ç§»ã§ã™ã€‚é’色ãŒ12/31ã‹ã‚‰1/1ã€èµ¤è‰²ãŒ1/1ã‹ã‚‰1/2ã«ãªã‚Šã¾ã™ 1/1ã®æ–¹ãŒå…¨ä½“çš„ã«å¤šã„ã§ã™ãŒã€ç‰¹ã«å¹´ãŒå¤‰ã‚ã‚‹å‰å¾Œã®æŠ•ç¨¿æ•°ã¯å€è¿‘ããªã£ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ã“ã®æ™‚ã«è² è·ã«ã‚ˆã‚Šæ—¥è¨˜ã®æŠ•ç¨¿ãŒã—ã¥ã‚‰ã„状態ã«ãªã£ã¦ã„ãŸã®
Apache Lucene - Wikipedia
Apache Lucene is a free and open-source search engine software library, originally written in Java by Doug Cutting. It is supported by the Apache Software Foundation and is released under the Apache Software License. Lucene is widely used as a standard foundation for production search applications.[2][3][4] Lucene has been ported to other programming languages including Object Pascal, Perl, C#, C+
全文検索エンジンSedueベンãƒãƒžãƒ¼ã‚¯
全文検索エンジン性能評価 (2006/08/19) æ¦‚è¦ å¼Šç¤¾ãŒé–‹ç™ºè‡´ã—ã¾ã—ãŸåœ§ç¸®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ–¹å¼å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSedueã€ï¼ˆSedue 24ã‚„Genome Sedueã§åˆ©ç”¨ã•ã‚Œã¦ã„るエンジンSedue コア）ã¨ã‚ªãƒ¼ãƒ—ンソースãªå…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³(HyperEstraier, Lucene, Senna)ã¨ã®æ€§èƒ½æ¯”較を行ã„ã¾ã—ãŸã€‚検索サーãƒãƒ¼ã«ã¯ãƒžã‚·ãƒ³1å°ã®ã¿ã‚’使用ã—ã¾ã—ãŸã€‚ æ›´æ–°å±¥æ´ 2006/09/13 インデクシングã®ä½œæˆæ–¹æ³•ã«é–¢ã—ã¦åˆ†ã‹ã‚Šã«ãã„表ç¾ã‚’è¨‚æ£ ä½¿ç”¨ç’°å¢ƒ ベンãƒãƒžãƒ¼ã‚¯ã‚’å–ã‚‹ã«éš›ã—ã¾ã—ã¦ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¹ãƒšãƒƒã‚¯ã®ãƒžã‚·ãƒ³ã‚’使用致ã—ã¾ã—ãŸã€‚ CPU: AMD Athlon(tm) 64 Processor 3000+ Memory: 2GB OS: Linux pfidev1 2.6.16-1.2111_FC4 #1 Sat May 20 20:00:28 EDT 2006 x8
カイãƒãƒ„ニッã‚(2005-09-26) 全文検索系
_ [ソフトウェア] 全文検索エンジン評価(Hyper Estraier / Rast / Senna) ç¾åœ¨(æµè¡Œæ°—味ã®)オープンソースã®å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€ãƒ¡ã‚¸ãƒ£ãƒ¼ã©ã“ã‚ã ã¨ã‚¿ã‚¤ãƒˆãƒ«ã«æŒ™ã’㟠Hyper Estraier Rast Senna) ã®3ã¤ãŒã‚ã‚Šã¾ã™ï¼ˆä»–ã«ã‚‚ã™ã’ーã®ãŒã‚ã£ãŸã‚‰æ•™ãˆã¦ãã ã•ã„ï¼ï¼‰ã€‚テã‚ストãŒé›†ã¾ã£ã¦ãる系（ã©ã‚“ãªç³»ã ）ã®ã‚¢ãƒ—リケーションã ã¨å…¨æ–‡æ¤œç´¢ã¯ã‹ãªã‚Šé‡è¦ãªè¦ç´ ã‚’å ã‚ã¦ãる技術è¦ç´ ã¨ãªã‚Šã¾ã™ã€ã®ã§çµæ§‹çœŸå‰£ã«è©•ä¾¡ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã‚ã‘ã§ã™ã€‚ã¨ã¯ã„ã£ã¦ã‚‚é‹ç”¨ã¨ã„ã†é¢ã§ã¯ã‚ã¾ã‚Šé«˜ã„サービスレベルã¯æ±‚ã‚られãªã„ã“ã¨ãŒãŠãŠã„ã®ã§ã€åˆ¥ã®ã‚¨ãƒ³ã‚¸ãƒ³ã«å…¥ã‚Œæ›¿ãˆã‚‹ã€ã£ã¦ã„ã†ã®ã‚‚çµæ§‹å‡ºæ¥ã¡ã‚ƒã„ãã†ã§ã™ã‘ã©ã。 ã•ã¦ã€è©•ä¾¡ã®ãƒã‚¤ãƒ³ãƒˆã¯ã„ã‚ã„ã‚ã‚ã‚‹ã‚“ã§ã™ãŒæ•¢ãˆã¦äº”月雨å¼ã«æ›¸ã㨠1インスタンスã§ã©ã‚Œãらã„大é‡ã®ãƒ†ã‚ストã«è€ãˆã‚‰ã‚Œã‚‹ã‹ ã©ã‚Œãらã„ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“リティãŒã‚ã‚‹ã‹ æ›´æ–°ã®ãƒ‘フォー
Fulltext index on SQLite
ã‚‚ã†ã™ã SQLite ã«å…¨æ–‡æ¤œç´¢ãŒã¤ã. Wiki を見ã¦ã„ã¦æ°—付ã„ãŸ. (Full-text Search for SQLite) ãªã‹ãªã‹é ‘å¼µã£ã¦ã‚‹ã¿ãŸã„. ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ—¢ã«å…¨æ–‡æ¤œç´¢ã‚’サãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹. 商用ã®ã‚‚ã®ã¯ã‚‚ã¡ã‚ã‚“, PostgreSQL ã‚„ MySQL ã‚‚ 対応済. 一方ã§, Java 製インプãƒã‚»ã‚¹ RDB ã® HSQL ã‚„ Derbyy ã¯å¯¾å¿œã—ã¦ã„ãªã„. (Wiki を見るã¨æ案ã•ã‚Œã¦ã¯ã„るよã†ã™.) 大物 DB ã«ã¯è¿½ã„ã¤ã‹ãªã„ã«ã›ã‚ˆ, ä»–ã®è»½é‡ DB よりã¯ä¸€è¶³å…ˆã‚’è¡Œãã‹ã‚“ã˜. æ•°ã‚ã‚‹ DB ã®è¦ä»¶ã‹ã‚‰å…¨æ–‡æ¤œç´¢ã‚’ãˆã‚‰ã¶ã‚ãŸã‚ŠãŒãƒ”ンãƒã‚¤ãƒ³ãƒˆã§ã„ã„. å°ã•ãªè¦æ¨¡ã®ã‚¢ãƒ—リケーションã§ã‚‚検索ãŒä½¿ãˆãŸã‚‰å¬‰ã—ã„よã. コード㯠CVS ã«å…¥ã£ã¦ã„ã‚‹. ã“ã®ã¸ã‚“. ã¨ã‚Šã‚ãˆãšãƒã‚§ãƒƒã‚¯ã‚¢ã‚¦ãƒˆã—ã¦è©¦ãã†ã¨æ€ã„レãƒã‚¸ãƒˆãƒªã‚’覗ã„ã¦ã¿ã‚‹ã¨, コードã¯ã‚ã‚‹ã‘ã© Makefile ãŒ
RDB ã® FTS æ‹¡å¼µ
2006-10-02 è¿‘æ³ sqlite を眺ã‚ã¦ã„ãŸã¨ãç§ãŒã‚‚ã¨ã‚‚ã¨ä½•ã‚’ã—ã¦ã„ãŸã‹ã¨ã„ã†ã¨, RDB ã¸ã®å…¨æ–‡æ¤œç´¢(Fulltext Search: FTS)ã‚’ã¤ãªãŽæ–¹ã‚’探ã—ã¦ã„ãŸ. flino ã§ä½¿ã£ãŸ HSQL 㯠FTS ã«å¯¾å¿œã—ã¦ã„ãªã„. ä»¥å‰ Lucene ã‚ãŸã‚Šã‚’繋ã’ãªã„ã‚‚ã®ã‹ã¨ã‚³ãƒ¼ãƒ‰ã‚’覗ã„ãŸã‘ã‚Œã©, æ•·å±…ã¯é«˜ãã†ã ã£ãŸ. (Java ã®ãã›ã« sqlite より modular ã§ãªã„æ°—ãŒã™ã‚‹.) よã見る㨠HSQL 㯠BLOB ã«ã‚‚対応ã—ã¦ã„ãªã„. çµå±€ãƒ•ã‚¡ã‚¤ãƒ«ã¨ Lucene をアプリケーションå´ã§ç®¡ç†ã—ã¦ã„ã‚‹. ã„ã¾ã„ã¡. ã§, 今回ã¯ãã®ãƒªãƒ™ãƒ³ã‚¸ã‚’目論んã§ã„ãŸã®ã ã£ãŸ. (çµå±€ sqlite ã‚’ã„ã˜ã£ã¦ã„ã‚‹ã†ã¡ã«ã‚¹ãƒˆãƒ¬ã‚¹è§£æ¶ˆã¯å®Œäº†.) 世ã®ä¸ã‚’眺ã‚ã¦ã¿ã‚‹ã¨, RDB ã« FTS を繋ã”ã†ã¨ã™ã‚‹è©¦ã¿ã¯å¤šã„. MySQL ã‚„ PostgreSQL 㯠FTS ã«å¯¾å¿œ
1
ãŠçŸ¥ã‚‰ã›
障害
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://www.docstoc.com/docs/2996433/Hadoop-and-HBase-vs-RDBMS
{{#tags}}- {{label}}
{{/tags}}