[...] 原文作者： Peter Zaitsev原文æ¥æºï¼š http://www.mysqlperformanceblog.com/2006/08/31/derived-tables-and-views-performance译者：å¶é‡‘è£ï¼ˆEmail:），转载请注明译者和出处，并且ä¸èƒ½ç”¨äºŽå•†ä¸šç”¨é€”，è¿è€…必究。 [...]
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
May 3, 2009 By 57 Comments
[...] To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS? 事实è¯æ˜Žï¼Œå½“查询è¯å¥ä¸çš„WHEREå’ŒORDERçš„æ¡ä»¶æœ‰åˆé€‚的索引，选择两次查询而ä¸æ˜¯SQL_CALC_FOUND_ROWS [...]
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
November 27, 2008 By 57 Comments
…¨ä½¿ç”¨è¿žæŽ¥æ± 或者长连接的时候就ä¸å¤ªæ¸…楚了，还没有åšæµ‹è¯•ã€‚ ã…MYSQLå®˜æ–¹è¯´çš„é‚£æ ·æ•ˆçŽ‡æ›´é«˜ï¼Œå而从两次查询的效率更低，查了相关资料å‘现，这是MYSQL的一个BUG。详è…
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
… 作者：hywl51 å‘表于:2008-04-21 09:54:24 最åŽæ›´æ–°äºŽ:2008-04-21 09:54:24 版æƒå£°æ˜Ž:å¯ä»¥ä»»æ„转载，但请务必以超链接形å¼æ ‡æ˜Žæ–‡ç« 原始出处和作者信æ¯ã…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
March 28, 2008 By 57 Comments
[...] å¦å¤–从æ¤è´´ä¸ä¹Ÿå¯ä»¥åˆ†æžå¾—到，å˜åœ¨é€‚当的索引在查询æ¡ä»¶è¯å¥ä¸ï¼Œä½¿ç”¨2个å•ç‹¬çš„查询è¯å¥è¦æ¯”å•ç‹¬ä½¿ç”¨SQL_CALC_FOUND_ROWS快的多 [...]
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
[...] PS：在 Falcon Storage Engine Design Review 這篇有些 Falcon è¨è¨ˆä¸Šçš„解釋，也許å¯ä»¥ç¨å¾®è§£é‡‹ç‚ºç”šéº¼ Falcon 跑起來這麼慢… [...]
Comment: How fast can you sort data with MySQL ?
August 6, 2009 By 26 Comments
…°ä¸´æ—¶æ–‡ä»¶ä¸ï¼Œç‰ MySQL 找到所有记录之åŽï¼Œå†æŠŠä¸´æ—¶æ–‡ä»¶ä¸çš„记录åšä¸€æ¬¡æŽ’åºã€‚è¿™å†æ¬¡æŽ…¸´æ—¶æ–‡ä»¶æ•°çš„两å€ã€‚å› ä¸ºç”¨åˆ°äº†ä¸´æ—¶æ–‡ä»¶ï¼Œæ‰€ä»¥é€Ÿåº¦å¯èƒ½ä¼šæ¯”è¾ƒæ…¢ï¼Œå¢žåŠ Sort_buffer_size 会å‡å°‘ Sort_merge_passes å’Œ 创建临时æ…
Comment: How fast can you sort data with MySQL ?
March 25, 2009 By 26 Comments
…°ä¸´æ—¶æ–‡ä»¶ä¸ï¼Œç‰ MySQL 找到所有记录之åŽï¼Œå†æŠŠä¸´æ—¶æ–‡ä»¶ä¸çš„记录åšä¸€æ¬¡æŽ’åºã€‚è¿™å†æ¬¡æŽ…¸´æ—¶æ–‡ä»¶æ•°çš„两å€ã€‚å› ä¸ºç”¨åˆ°äº†ä¸´æ—¶æ–‡ä»¶ï¼Œæ‰€ä»¥é€Ÿåº¦å¯èƒ½ä¼šæ¯”è¾ƒæ…¢ï¼Œå¢žåŠ Sort_buffer_size 会å‡å°‘ Sort_merge_passes å’Œ 创建临时æ…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
June 9, 2009 By 117 Comments
…æˆ‘æ‰¾åˆ°ä¸€ç¯‡æ–‡ç« é‡å° MyIASM, InnoDB å’Œ Falcon 來åšæ¯”è¼ƒï¼Œåœ¨é€™è£¡é¢ MyIASMå’Œ InnoDB 表ç¾éƒ½æ²’有差很多，唯ç¨åœ¨æ¸¬ READ_PK_RANGE 兛掉了(ä¸éŽä¸»è§’其實是 Falcon å› ç‚ºå®ƒè¢«æ‰“è¶´äº†)ã€‚åŽŸå› æ˜¯ï¼šThere MyISAM shows bad…
