Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ±àÒëÑ¡ÏîÎÊÌâ

ÇëÎʸ÷λ´ó¸ç£¬¾²Ì¬±àÒëʱ£¬mysql±àÒëÑ¡Ïî--with-mysqld-ldflagsºóÃæÓÃ-all-staticºÍ-staticÓÐʲô²»Í¬Âð£¿


ÒýÓÃ
-all-static ¼ûµ½¹ý£¬ÊÇËùÓеÄÎļþΪ¾²Ì¬LINK£¬ÕâÑùmysqldµÄÔËÐÐЧÂÊ»á±È½Ï¸ß£¬Í¬Ñù³ß´ç»á±È½Ï´ó¡£
-static û¼û¹ý¡£


ÊÖ²áÖÐÊÇÕâÑù˵µÄ
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£¬¶øÎÒ×Ô¼º¾²Ì¬±àÒëµÄ¾Í²»ÐУ¿


ÎÒʹÓÃ-staticÖØÐ±àÒëÁËһϣ¬¿ÉÒÔ¼Ó²ÃpluginÁË£¬Ö®Ç°ÓÃ-all-static±àÒëµÄ²»ÐС£¡£¡£¡£¡£


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

ÇóÒ»mysql sql

ÓÐÁ½ÕÅ±í£º¹«Ë¾±ícompany(id,name...)£¬ºÏͬ±íhetong(id,title,companyid,type...)
Ò»¸ö¹«Ë¾¿ÉÄÜÓж೤ºÏͬ£¬typeΪ1-10µÇ¼Ç
ÀýÈ磺company±í
                id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ