EJB3+JBOSS4+mySQL²¿Êð·½Ê½
1¡¢Ð½¨Êý¾ÝÔ´Îļþmysql-ds.xml,ÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=GBK</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>123</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
ÆäÖГmydatabase”ÊÇÊý¾Ý¿âÃû³Æ£¬¸ÄÒ»ÏÂÓû§Ãû¡¢ÃÜÂëºÍÊý¾Ý¿âÃû³Æ£¬´ËÅäÖÃÎļþ¾Í¿ÉÒÔÓÃÁË¡£½«´ËÎļþ·ÅÔÚjboss°²×°Ä¿Â¼Ïµē\server\default\deploy”Ŀ¼Ï¼´¿É¡£
2¡¢È»ºóн¨Ò»¸öEJB¹¤³Ì£¬ÔÚMETA-INFÎļþ¼ÐÏÂÌí¼ÓÎļþpersistence.xml¡£
<?xml version="1.0" encoding="UTF-8"?>
<persistence>
<persistence-unit name="mydatabase">
<jta-data-source>java:/MySqlDS</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="update" />
</properties>
</persistence-unit>
</persistence>
ºìÉ«²¿·ÖµÄÃû³ÆÒª¶ÔÓ¦ÆðÀ´¡£
3¡¢½«ejb¹¤³ÌÓëpersistence.xmlÎļþ´ò°ü·¢²¼¼´¿É¡£
Èç¹ûÓõÄÊÇJBUILDER±àÒë»·¾³£¬Ð轫ÔÚbuildÊÇʱºöÂÔxmlÀàÐÍÎļþµÄÑ¡ÏîÈ¥µô£¬²»È»µÄ»°·¢²¼»á³öÏÖ
“Incomplete Deployment listing:
--- MBeans waiting for other MBeans --- ……”ÀàËÆµÄ´íÎ󡣸ü¸ÄJbulider±àÒëÑ¡ÏîµÄ·½Ê½Îª“window->preferences->java->compiler->building”,È»ºó½«Filetered resourcesÖеÄ*.xmlɾ³ý£¬»òÕß
Ïà¹ØÎĵµ£º
MySQL ±¸·ÝºÍ»Ö¸´
ÖÜÁù, 2006/09/30 - 14:21 — yejr
MySQL ±¸·ÝºÍ»Ö¸´
×÷/ÒëÕߣºÒ¶½ðÈÙ£¨Email:
£©£¬À´Ô´£ºhttp://imysql.cn
£¬×ªÔØÇë×¢Ã÷×÷/ÒëÕߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
ÈÕÆÚ£º2006/10/01
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖ ......
THREAD_CACHE MySQLÀïÃæÎªÁËÌá¸ß¿Í»§¶ËÇëÇó´´½¨Á¬½Ó¹ý³ÌµÄÐÔÄÜ,ÌṩÁËÒ»¸öÁ¬½Ó³ØÒ²¾ÍÊÇThread_Cache³Ø,½«¿ÕÏеÄÁ¬½ÓÏ̷߳ÅÔÚÁ¬½Ó³ØÖÐ,¶ø²»ÊÇÁ¢¼´Ïú»Ù.ÕâÑùµÄºÃ´¦¾ÍÊÇ,µ±ÓÖÓÐÒ»¸öеÄÇëÇóµÄʱºò,mysql²»»áÁ¢¼´È¥´´½¨Á¬½ÓÏß³Ì,¶øÊÇÏÈÈ¥Thread_CacheÖÐÈ¥²éÕÒ¿ÕÏеÄÁ¬½ÓÏß³Ì,Èç¹û´æÔÚÔòÖ±½ÓʹÓÃ,²»´æÔڲŴ´½¨ÐµÄÁ¬½ÓÏß³Ì. ÓÐ ......
ÔÚÁ¬½ÓMySQLʱ£¬¿ÉÒÔ¼ÓÉÏ-b²ÎÊý£¬ÓÃÒÔÈ¡ÏûÔÚSQLÃüÁîÖ´Ðгö´íʱµÄ±¨¾¯Éù£¬È磺
mysql -h127.0.0.1 -uroot -proot -b
ÕâÑùÔÚÊäÈëÃüÁî³ö´íʱ£¬±ã²»»áÔÙÌýµ½ÄÇÉùÄÑÌýµÄ"àÖ"ÁË¡£
ÁíÍ⻹ÓÐ2¸ö¹Ø±ÕMYSQLµÄBEEPÉù·½·¨
1. ʹÓÃMySQLµÄÃüÁîÖÕ¶Ëʱ£¬Èç¹ûÊäÈëSQLÓÐÎ󣬽«ÓÐbeepÉù¡£ÈôÒª¹Ø±Õ¸Ã¹¦ÄÜ£¬¸ù¾Ýmysql --help£¬Ê¹ÓÃmysql - ......
http://blog.163.com/mysqldba@126/blog/static/1315356342009931103834396/
×î½ü¿´ÁË¿´mysqlµÄ״̬±äÁ¿£¬¸Ð¾õºÃ¶à¸úÒÔǰ×Ô¼ºÏëÏóµÄ²»Ò»Ñù¡£ÎªÁËÒÔºóÄܼ°Ê±·¢ÏÖ×Ô¼ºµÄ´íÎó,¾ÍÏȼÇÏÂÀ´;
http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html
mysql> show status;
Com_xxx
Óï¾ä¼ÆÊý±äÁ¿±íʾÿ¸öxxx ......
ÒÔÏÂÊÇÉæ¼°µ½²åÈë±í¸ñµÄ²éѯµÄ5ÖָĽø·½·¨£º
1)ʹÓÃLOAD DATA INFILE´ÓÎı¾ÏÂÔØÊý¾ÝÕ⽫±ÈʹÓòåÈëÓï¾ä¿ì20±¶¡£
2)ʹÓôøÓжà¸öVALUESÁбíµÄINSERTÓï¾äÒ»´Î²åÈ뼸ÐÐÕ⽫±ÈʹÓÃÒ»¸öµ¥ÐвåÈëÓï¾ä¿ì¼¸±¶¡£µ÷Õûbulk_insert_buffer_size±äÁ¿Ò²ÄÜÌá¸ß£¨Ïò°üº¬Ðеıí¸ñÖУ©²åÈëµÄËÙ¶È¡£
3)¿ÉÒÔ¶Ômyisam±í²¢ÐвåÈëConcurrent_i ......