±à¼MYSQLʱ³ö´í£ºNo curses/termcap library found
»·¾³£ºCentOS linux 5.2
ϵͳֻ°²×°VI±à¼Æ÷Ó뿪·¢¹¤¾ß
ÔÚ±à¼MYSQLʱ£º
#./configure --prefix=/usr/local/mysql --with-charset=gb2312 --with-extra-charsets=all
Ö´Ðкó³öÏÖÈçÏ´íÎó£º
checking for tgetent in -ltermcap… no
checking for termcap functions library… configure: error: No curses/termcap library found
½â¾ö·½·¨£º
±àÒëʱ¼ÓÉÏ·¾¶¼´¿É½â¾ö£¬¼´
#./configure --prefix=/usr/local/mysql --with-charset=gb2312 --with-extra-charsets=all --with-named-curses-libs=/usr/lib/libncurses.so.5
Èç¹ûÊÇUbuntu£¬ÐèÒª°²×°.sudo apt-get install libncurses5-dev
Èç¹ûUbuntuÉÏ°²×°ÁËVMwareTools-°æ±¾ºÅ.tar.gzÔò²»ÐèÒª°²×°libncurses5-dev,ÔÚ±àÒëʱ¼ÓÉÏ
--with-named-curses-libs=/usr/lib/libncurses.so.5
¾Í¿ÉÒÔ
Ïà¹ØÎĵµ£º
×öÏîĿʱÓÉÓÚÒµÎñÂß¼µÄÐèÒª£¬±ØÐë¶ÔÊý¾Ý±íµÄÒ»Ðлò¶àÐмÓÈëÐÐËø£¬¾Ù¸ö×î¼òµ¥µÄÀý×Ó£¬Í¼Êé½èÔÄϵͳ¡£¼ÙÉè id=1 µÄÕâ±¾Êé¿â´æΪ 1 £¬µ«ÊÇÓÐ 2 ¸öÈËͬʱÀ´½èÕâ±¾Ê飬´Ë´¦µÄÂ߼Ϊ :
Select restnum from book where id =1 ;
-- Èç¹û restnum ´óÓÚ 0 £¬Ö´ÐÐ update
Update boo ......
ÔÚ¹¤×÷ÖÐÅöµ½Ò»¸öMysql×ֶθüÐÂÎÊÌâ
ÔÚcustom±íÖÐÓÐÒ»¸ötariffurlµÄÖµÖÐÓÐÈçÏÂÇé¿ö£º
uploadfiles ariff2007031172720306698.jpgÒÔ¼°uploadfiles ariff2007031172720306690.jpg;uploadfiles ariff2007031172720306691.jpgÐÎʽ
Òª¸ü¸Ä³Éuploadfiles/tariff/200703/1172720306698.jpg¼° uploadfiles/tariff/200703/11727 ......
ÔÚ½üÆÚµÄÏîĿά»¤¹¤×÷ÖУ¬Ê±³£³öÏÖÖ÷¼üÖظ´µÄÒì³£¡£¾¹ýһϵÁÐ×ÊÁϵIJéѯ֮ºó£¬·¢ÏÖʱhibernateÓ³ÉäÎļþÅäÖÃÎÊÌâ¡£
mysqlÌṩÖ÷¼ü“×Ô¶¯ÔöÁ¿”µÄÅäÖã¬Ö¸¶¨¸ÃÀàÐ͵ÄÖ÷¼ü£¬mysqlÄܹ»×Ô¶¯¼ÓÒ»¡£
ÔÚhibernateÓ³ÉäÎļþÖУ¬¹ØÓÚÖ÷¼üµÄÅäÖò»ÄÜÊÇ
<generator class="increment"&g ......
MySQLÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬ÒªÐÞ¸Ämy.cnf»òÕßÔÚMySQLÆô¶¯µÄʱºò¼ÓÈëһЩ²ÎÊý¡£
Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 1
log-slow-queries =
log-queries-not-using-indexes
long_query_time ÊÇÖ¸Ö´Ðг¬¹ý¶à¾ÃµÄsql»á±»logÏÂÀ´£ ......
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇInnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙÄ¿Ç°²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL 4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØϵµÄÁ½¸ö±íµÄÁбØÐëÊÇÊý¾ÝÀàÐÍÏàËÆ£¬Ò²¾ÍÊÇ¿ÉÒÔÏ໥ת»»ÀàÐ͵ ......