Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±àÒëµÄ²»ÐС£¡£¡£¡£¡£


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

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

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysql µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......

ÇóÖúMySQL²éѯ

select *from tabA limit (2*pagesize)
ÎÒÏëÔÚ´æ´¢¹ý³ÌÀïʵÏÖÒÔÉϹ¦ÄÜ£¬pagesizeÊÇint²ÎÊý£¬
ÔõÃ´ÅªÄØ£¿
ÆäʵÊÇÏëŪ¸ö·ÖÒ²µÄ´æ´¢¹ý³Ì ²ÎÊýÊÇ µ±Ç°Ò³Êý¡¢Ò³ÃæÏÔʾÌõÊý

²»¶®£¬°ï¶¥

ûÓа취£¬Ö»ÄÜÓÃ
......

Ïòmysql²åÈëÊý¾Ý³ö´í

java.sql.SQLException: Incorrect string value: '\xA9z </sp...' for column 'Content' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.j ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ