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

ʹÓÃC3P0Á¬½ÓMysqlµÄÒ»¸öÎÊÌâµÄ½â¾ö¹ý³Ì


×î½üµÄÒ»¸öÏîÄ¿ÔÚʹÓÃC3P0µÄÁ¬½Ó³Ø£¬Êý¾Ý¿âΪMysql¡£¿ª·¢²âÊÔûÓÐÎÊÌ⣬ÔÚÔËÐÐÖÐÿ¸öÒ»¶Î³¤µÄ¿ÕÏÐʱ¼ä¾Í³öÏÖÒì³£Communications link failure due to underlying exception:
java ´úÂë
²é¿´ÁËMysqlµÄÎĵµ£¬ÒÔ¼°Connector/JµÄÎĵµÒÔ¼°ÔÚÏß˵Ã÷·¢ÏÖ£¬³öÏÖÕâÖÖÒì³£µÄÔ­ÒòÊÇ£º
Mysql·þÎñÆ÷ĬÈϵēwait_timeout”ÊÇ8Сʱ£¬Ò²¾ÍÊÇ˵һ¸öconnection¿ÕÏг¬¹ý8¸öСʱ£¬Mysql½«×Ô¶¯¶Ï¿ª¸Ãconnection¡£Õâ¾ÍÊÇÎÊÌâµÄËùÔÚ£¬ÔÚC3P0 poolsÖеÄconnectionsÈç¹û¿ÕÏг¬¹ý8Сʱ£¬Mysql½«Æä¶Ï¿ª£¬¶øC3P0²¢²»ÖªµÀ¸ÃconnectionÒѾ­Ê§Ð§£¬Èç¹ûÕâʱÓÐClientÇëÇóconnection£¬C3P0½«¸ÃʧЧµÄConnectionÌṩ¸øClient£¬½«»áÔì³ÉÉÏÃæµÄÒì³£¡£
½â¾öµÄ·½·¨ÓÐ3ÖÖ£º
Ôö¼Ówait_timeoutµÄʱ¼ä¡£
¼õÉÙConnection poolsÖÐconnectionµÄlifetime¡£
²âÊÔConnection poolsÖÐconnectionµÄÓÐЧÐÔ¡£
µ±È»×îºÃµÄ°ì·¨ÊÇͬʱ×ÛºÏʹÓÃÉÏÊö3ÖÖ·½·¨£¬¼ÙÉèwait_timeoutΪĬÈϵÄ8Сʱ
C3P0Ôö¼ÓÒÔÏÂÅäÖÃÐÅÏ¢:
//»ñÈ¡connnectionʱ²âÊÔÊÇ·ñÓÐЧ
testConnectionOnCheckin = true
//×Ô¶¯²âÊÔµÄtableÃû³Æ
automaticTestTable=C3P0TestTable
//set to something much less than wait_timeout, prevents connections from going stale
idleConnectionTestPeriod = 18000
//set to something slightly less than wait_timeout, preventing 'stale' connections from being handed out
maxIdleTime = 25000
//if you can take the performance 'hit', set to "true"
testConnectionOnCheckout = true
¸ü¶àµÄÅäÖÃÐÅÏ¢´ó¼Ò¿ÉÒԲ鿴C3P0Îĵµ£¬Connector/JÎĵµ£¬


Ïà¹ØÎĵµ£º

MYSQLÔÚWindows 2003ÉÏÁ¬½Ó²»ÉϵĽâ¾ö·½·¨

½ñÌì´î½¨mysqlÊý¾Ý¿â,Á¬½ÓÁ˰ëÌì,¶¼Ìáʾ10061´íÎó,ÒÔΪÃÜÂë³öÁËÎÊÌâÊÔÁ˰ëÌì,ѹ¸ùÁ¬·þÎñ¶¼Á¬½Ó²»ÉÏ,æ»îÁ˰ë¸ö¶àСʱ,²Å·¢ÏÖÊÇϵͳ²¹¶¡´òÁËÖ®ºó³öÏÖµÄÎÊÌâ(kb967723)
ÓÚÊÇÍøÉÏÕÒÁËÒ»ÏÂ×ÊÁÏ
×î½üÒ»¸ö¿Í»§·þÎñÆ÷µÄMYSQLƵ·±ÌáʾÁ¬½Ó²»ÉÏ£¬ÐÞ¸ÄÁËMYSQLµÄ×î´óÁ¬½ÓÊý»¹ÊÇÕâÑù£¬ÓÚÊÇ¿ªÊ¼ÎÊÍòÄܵÄËÑË÷ÒýÇæ´óÈË£¡ÖÕÓÚÔÚ΢ÈíÕÒµ½ÁË ......

mysql ÈÕÆÚĬÈÏϵͳʱ¼ä mysql ĬÈÏÖµ²»Ö§³Öº¯Êý

ÓÉÓÚMySQLĿǰ×ֶεÄĬÈÏÖµ²»Ö§³Öº¯Êý£¬ËùÒÔÒÔ
create_time datetime default now()
µÄÐÎʽÉèÖÃĬÈÏÖµÊDz»¿ÉÄܵġ£
´úÌæµÄ·½°¸ÊÇʹÓÃTIMESTAMPÀàÐÍ´úÌæDATETIMEÀàÐÍ¡£
TIMESTAMPÁÐÀàÐÍ×Ô¶¯µØÓõ±Ç°µÄÈÕÆÚºÍʱ¼ä±ê¼ÇINSERT»òUPDATEµÄ²Ù×÷¡£
Èç¹ûÓжà¸öTIMESTAMPÁУ¬Ö»ÓеÚÒ»¸ö×Ô¶¯¸üС£
×Ô¶¯¸üеÚÒ»¸öTIMESTAMPÁÐÔÚÏ ......

mysql ÃüÁî

1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......

mysql Éè¼Æ±éÀú²éѯ½á¹ûÖеÄÿÐÐÊý¾ÝÓöµ½µÄÖî¶àÎÊÌâ

²»Í¬Êý¾Ý¿âÖ®¼äµÄÓï·¨²îÒì»¹Õæ²»ÉÙ~Òª±ÀÀ£ÁË¡£
1.´´½¨´ø×ÔÔöÁÐÁÙʱ±í£ºcreate TEMPORARY table t(id int AUTO_INCREMENT PRIMARY key, u_name varchar(50));--Ϊʲô±ØÐëÒªÖ÷¼ü£¿£¡
ÏòÕâ¸öÁÙʱ±íÖвåÈëÊý¾Ý£ºinsert into t values(null, 'zdy');--Ϊʲôһ¶¨Òª¼Ónull£¿£¡
2.°ÑÒ»ÕűíµÄ²éѯ½á¹û²åÈëÁÙʱ±í£ºinsert into t ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ