… each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is exaggerated, so we…
Comment: Sphinx search performance optimization: attribute-based filters
June 12, 2013 By 11 Comments
Comment: Sphinx search performance optimization: multi-threaded search
May 24, 2013 By 10 Comments
Hi Robert, – you don’t actually need to merge sphinx indexes – it does that on the fly. If you are …
Comment: How fast can you sort data with MySQL ?
August 6, 2009 By 26 Comments
…‰ MySQL 找到所有记录之åŽï¼Œå†æŠŠä¸´æ—¶æ–‡ä»¶ä¸çš„记录åšä¸€æ¬¡æŽ’åºã€‚è¿™å†æ¬¡æŽ’åºå°±ä…¸´æ—¶æ–‡ä»¶æ¥å˜å†æ¬¡æŽ’åºçš„结果，所以通常会看到 Sort_merge_passes å¢žåŠ çš„æ•°å€¼æ˜¯å»ºä¸´æ—¶æ–‡ä»¶æ•°çš„ä¸¤å€ã€‚å› ä¸ºç”¨åˆ°äº†ä¸´æ—¶æ–‡ä»¶ï¼Œæ‰€ä»¥é€Ÿåº¦å¯èƒ…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
June 9, 2009 By 117 Comments
…¨åœ¨æ¸¬ READ_PK_RANGE å’Œ READ_KEY_POINT 時候， MyIASM 爛掉了(ä¸éŽä¸»è§’其實是 Falcon å› ç‚ºå®ƒè¢«æ‰“è¶´äº†)ã€‚åŽŸå› æ˜¯ï…
Comment: How fast can you sort data with MySQL ?
March 25, 2009 By 26 Comments
…‰ MySQL 找到所有记录之åŽï¼Œå†æŠŠä¸´æ—¶æ–‡ä»¶ä¸çš„记录åšä¸€æ¬¡æŽ’åºã€‚è¿™å†æ¬¡æŽ’åºå°±ä…¸´æ—¶æ–‡ä»¶æ¥å˜å†æ¬¡æŽ’åºçš„结果，所以通常会看到 Sort_merge_passes å¢žåŠ çš„æ•°å€¼æ˜¯å»ºä¸´æ—¶æ–‡ä»¶æ•°çš„ä¸¤å€ã€‚å› ä¸ºç”¨åˆ°äº†ä¸´æ—¶æ–‡ä»¶ï¼Œæ‰€ä»¥é€Ÿåº¦å¯èƒ…
Comment: Derived Tables and Views Performance
August 28, 2008 By 16 Comments
…½“åŠå¨±ä¹ã€åœ¨çº¿ç”¨æˆ·ä»˜è´¹å¢žå€¼/æ— çº¿å¢žå€¼æœåŠ¡å’Œç”µå政务解决方案ç‰åœ¨å†…的一系列æœåŠ¡ã€‚ 专业ç å®é—¨æˆ·â€”—ä¸å›½ç å®ç½‘站预计2008年在全çƒèŒƒå›´å†…注册用户è…
Comment: Kickfire Kickfire Kickfire
June 7, 2008 By 5 Comments
…¶æž„是开放的，其他的公å¸å¯ä»¥åœ¨MySQL上åšå¾ˆå¤šå¢žå€¼çš„应用，比如å˜å‚¨å¼•æ“Žæ–¹é¢çš„InnoDB；专注于数æ®ç´¢å…‰‡æŠ€æœ¯å’ŒMySQL相结åˆï¼Œä½¿å¾—æ•°æ®èƒ½ç»™è·‘得更快，也能进行更快速的索引ç‰ã…
Comment: Thoughts on MySQL Replication
April 28, 2008 By 18 Comments
[...] 2008-04-29 作者：hywl51 å‘表于:2008-04-29 14:02:42 最åŽæ›´æ–°äºŽ:2008-04-29 14:02:42 版æƒå£°æ˜Ž:å¯ä»¥ä»»æ„转载，但请务必以超链接形å¼æ ‡æ˜Žæ–‡ç« 原始出处和作者信æ¯ã€‚http://www.sitearchitect.cn/?p=691 Thoughts on MySQL Replication [...]
Comment: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…-21 作者：hywl51 å‘表于:2008-04-21 09:54:24 最åŽæ›´æ–°äºŽ:2008-04-21 09:54:24 版æƒå£°æ˜Ž:å¯ä»¥ä»»æ„转载，但请务必以超链接形å¼æ ‡æ˜Žæ–‡ç« 原始出处和作者信æ…
Comment: MySQL Performance Blog now uses Sphinx for Site Search
February 19, 2008 By 52 Comments
Paolo, Please check presentation page. It has full text search benchmarks for Sphinx/Lucene/MySQL FT. Though all of them are somethat improved and we need to redo them the general idea stays the same.
