ÊÖ²áÖÐÊÇÕâÑù˵µÄ If you link dynamically (without -static), the result is 13% slower on Linux. Note that you still can use a dynamically linked MySQL library for your client applications. It is the server that is most critical for performance.
·´¶øÃ»ÓгöÏÖ-all-static ¶øÇÒʹÓÃcat mysqlbug | grep CONFIGURE_LINE²é¿´ÏÂÔØÏÂÀ´µÄ¶þ½øÖưü£¬±àÒëÑ¡ÏîÖÐÒ²ÊÇ--with-mysqld-ldflags=-static If you link dynamically (without -static), the result is 13% slower on Linux. Ä¿µÄ¾ÍÊǼӿìɨÃè°É
ºÍÄǸö engine_condition_pushdown ²ÎÊýЧ¹ûÒ»Ñù°É mysql ¶þ½øÖưüÒ²ÊǾ²Ì¬±àÒëµÄ£¬ÎªÊ²Ã´¿ÉÒÔplugin·½Ê½¼Ó²Ãinnodb£¬¶øÎÒ×Ô¼º¾²Ì¬±àÒëµÄ¾Í²»ÐУ¿
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï. ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî SQL code: update ±í set introtxt=left(`fulltext`,300);