CentOSÏÂÎÞ·¨Õý³£»ñÈ¡MySQLÊý¾Ý¿â±íÊý¾ÝµÄÎÊÌâ
֮ǰ£¬ÓÉÓÚ¿Í»§ÒªÇóÔÚcentOSϰ²×°ÏµÍ³Ó¦Óã¬Òò´ËÓлú»á½Ó´¥ÁËÒ»ÏÂCentOS£¬Ë³±ãÒ²Á˽âÁËÏÂCentOSµÄ³£¹æ²Ù×÷£¬»¹ÓÐÔÚCentOSϵÄMySQLÏà¹Ø²Ù×÷¡£
Ŀǰ¼¼Êõ¿ò¼ÜʹÓÃJSF£¨richfaces¡¢facelets£©+Spring+JPA£¨OpenJPA£©£¬²»Ê¹ÓÃÊý¾Ý¿âÒÀÀµµÄ´¥·¢Æ÷»ò´æ´¢¹ý³Ì£¬ËùÓÐÒµÎñÂß¼ÔÚweb·þÎñÆ÷ÉÏÖ´ÐУ¬Òò´ËÊý¾Ý¿â»ù±¾²»Óÿ¼ÂÇÒÆÖ²ÎÊÌâ¡£µ«ÊDZ¾À´ÔÚwindowsÏÂÔËÐÐÕý³£µÄϵͳ£¬ÔÚlinuxÏÂȴû·¨»ñȡһЩ±íµÄÄÚÈÝ¡£ÓÉÓÚÊý¾Ý¿âµÄ³õʼ»¯£¬×î³õÖ»ÊÇÌåÏÖÔÚ¼¸¸öÐèÒªÊÖ¹¤Î¬»¤µÄ±íÊý¾ÝÉÏ£¬×îÖÕÈ´·¢ÏÖÔÀ´ÊÇÒòΪÊý¾Ý¿â±íÃû´óСдµÄÎÊÌ⣡
¾ßÌå²Ù×÷¹ý³Ì£º
ÔÚwindowsÏ£¬Ê¹ÓÃMySQLµÄ¿Í»§¶Ë¹¤¾ß“Navicat”£¬½«µ±Ç°µÄÊý¾Ý¿âµ¼³öµ½test.sqlÎļþÖС£ËµÃ÷£ºµ¼³öµÄ.sqlÎļþÖУ¬ËùÓеıíÃû¶¼ÊÇСд¡£
½«µ¼³öµÄ.sqlÎļþ¿½±´ÖÁlinuxÏ£¬µ¼ÈëÐèҪʹÓõÄÊý¾Ý¿âÖÐ
Æô¶¯web·þÎñÆ÷£¬·ÃÎÊ·þÎñ¡£ÎÊÌâ³öÏÖ£ºÐí¶à±íÎÞ·¨·ÃÎÊ¡£
ÔÚmysqlÖÐʹÓÓshow
tables;”ÃüÁ·¢ÏÖ±íÃûÓÐÖØ¸´£¬Öظ´µÄ±íÃûÇø±ðÔÚÓÚ´óСд£¬´óдµÄ±íÃûÓë¶ÔÓ¦µÄʵÌåbeanÃûÏàͬ¡£ÕÒµ½ÎÊÌ⣺±íÃû´óСдÔì³ÉµÄÊý¾ÝÎÞ·¨·ÃÎÊ¡££¨linux Ï嵀 MySQL °²×°Íêºó£¬Ä¬ÈÏÇø·Ö±íÃûµÄ´óСд£¬²»Çø·ÖÁÐÃûµÄ´óСд£»WindowsÏÂĬÈϲ»Çø·Ö´óСд £©
ÉÏÊöÎÊÌâÓÐÁ½ÖÖ½â¾ö·½°¸£º
ÔÚJPAµÄʵÌåbeanµÄÉùÃ÷ÖУ¬Ê¹ÓÓTable”µÄ“name”ÊôÐÔ£¬Ö¸¶¨±íÃû£¬±íÃû¾¡Á¿È«²¿Ê¹ÓÃСд£¬²»Í¬µ¥´ÊÖ®¼äʹÓÃÏ»®ÏßÁ¬½Ó£¨ÀýÈ磺@Table(name="sys_user")
£©
ʹÓÃLinuxÏÂMySQLµÄÏà¹Ø²ÎÊý£¬Ê¹MySQL²»Çø·Ö´óСд£¨
lower_case_table_names=1
£©
ÉÏÊöÁ½ÖÖ·½·¨£¬µÚÒ»ÖÖÊǽÏΪͨÓõĽâ¾ö·½°¸£¬µ«ÊÇÐèÒª¿ª·¢ÈËÔ±¸ü¸ÄÈ«²¿µÄʵÌåbean£¬È»ºóÖØÐ±àÒ룻µÚ¶þÖÖ·½°¸ÊʺÏÓÚϵͳÒѾ½øÈëÉú²ú»·¾³µÄ×´¿ö£¬²¢ÇÒ¶ÔÈçºÎÐÞ¸ÄlinuxϵÄMySQLÅäÖÃÐèÒªÒ»¶¨µÄרҵ֪ʶ¼°¾Ñ飬¶ÔʵʩÈËÔ±¼¼ÊõÒªÇó½Ï¸ß¡£
¹ØÓÚÈçºÎÐÞ¸ÄCentOSϵÄMySQL²»Çø·Ö´óСдµÄ¾ßÌå²Ù×÷·½·¨£º
Óà root ÕʺŵǼºó£¬ÔÚ /etc/my.cnf ÖÐµÄ [mysqld] ºóÌí¼ÓÌí¼Ó lower_case_table_names=1 £¬ÖØÆôMysqld ·þÎñ¡£·þÎñÖØÐÂÆô¶¯Ö®ºó£¬ÒÑÉèÖóɹ¦£º²»Çø·Ö±íÃûµÄ´óСд
¹ØÓÚlower_case_table_names ²ÎÊýÏê½â£º lower_case_table_names²ÎÊýÓÐÁ½¸öÖµ£º[0¡¢1 ]ÆäÖÐ 0 £ºÇø·Ö´óСд£¬ 1 £º²»Çø·Ö´óСд
²¹³ä˵Ã÷£º
¹ØÓڳ־ò㣬ʹÓÃSpring×Ô¶¯Éú³ÉµÄDDLÀ´´´½¨¶ÔÓ¦µÄ³Ö¾Ã²ãÊý¾Ý¿â±í¼°Ë÷ÒýµÈÊý¾Ý£¬¼ò»¯ÊµÊ©¹¤×÷µÄ¸´ÔÓ¶È
Ïà¹ØÎĵµ£º
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......
×î½üµÄÒ»¸öÏîÄ¿ÔÚʹÓÃC3P0µÄÁ¬½Ó³Ø£¬Êý¾Ý¿âΪMysql¡£¿ª·¢²âÊÔûÓÐÎÊÌ⣬ÔÚÔËÐÐÖÐÿ¸öÒ»¶Î³¤µÄ¿ÕÏÐʱ¼ä¾Í³öÏÖÒì³£Communications link failure due to underlying exception:
java ´úÂë
²é¿´ÁËMysqlµÄÎĵµ£¬ÒÔ¼°Connector/JµÄÎĵµÒÔ¼°ÔÚÏß˵Ã÷·¢ÏÖ£¬³öÏÖÕâÖÖÒì³£µÄÔÒòÊÇ£º
Mysql·þÎñÆ÷ĬÈϵēwait_timeout&rdquo ......
ÆÕͨMySQLÔËÐУ¬Êý¾ÝÁ¿ºÍ·ÃÎÊÁ¿²»´óµÄ»°£¬ÊÇ×ã¹»¿ìµÄ£¬µ«Êǵ±Êý¾ÝÁ¿ºÍ·ÃÎÊÁ¿¾çÔöµÄʱºò£¬ÄÇô¾Í»áÃ÷ÏÔ·¢ÏÖMySQLºÜÂý£¬ÉõÖÁdownµô£¬ÄÇô¾ÍÒª¿¼ÂÇÓÅ»¯ÎÒÃǵÄMySQLÁË¡£
ÓÅ»¯ÎÞ·ÇÊÇ´ÓÈý¸ö½Ç¶ÈÈëÊÖ£º
µÚÒ»¸öÊÇ´ÓÓ²¼þ£¬Ôö¼ÓÓ²¼þ£¬Ôö¼Ó·þÎñÆ÷
µÚ¶þ¸ö¾ÍÊǶÔÎÒÃǵÄMySQL·þÎñÆ÷½øÐÐÓÅ»¯£¬Ôö¼Ó»º´æ´óС£¬¿ª¶à¶Ë¿Ú£¬¶Áд·Ö¿ª
µÚÈý¸ö ......
1¡¢¿´»úÆ÷ÅäÖã¬Ö¸Èý´ó¼þ£ºcpu¡¢ÄÚ´æ¡¢Ó²ÅÌ
2¡¢¿´mysqlÅäÖòÎÊý
3¡¢²éϵmysqlÐÐ״̬£¬¿ÉÒÔÓÃmysqlreport¹¤¾ßÀ´²é¿´
4¡¢²é¿´mysqlµÄÂý²éѯ
ÒÀ´Î½â¾öÁËÒÔÉÏÎÊÌâÖ®ºó£¬ÔÙÀ´²éÕÒ³ÌÐò·½ÃæµÄÎÊÌâ
my.cnf»º´æÓÅ»¯
ÔÚ my.cnf ÖÐÌí¼Ó/ÐÞ¸ÄÒÔÏÂÑ¡Ïî:
#È¡ÏûÎļþϵͳµÄÍâ²¿Ëø
skip-locking
#²»½øÐÐÓòÃû·´½âÎö,×¢Òâ ......
1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
mysqladmin start
/ect/init.d/mysql start (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
mysqladmin shutdown
/ect/init.d/mysql&nbs ......