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

apache tomcat mysql ¸ºÔØƽºâºÍ¼¯Èº¼¼Êõ

¹«Ë¾¿ª·¢ÁËÒ»¸öÍøÕ¾£¬¹À¼Æ×î¸ßÔÚÏßÈËÊýÊÇ3 Íò£¬²¢·¢ÈËÊý×î¶à100 ÈË¡£¿ª·¢µÄÍøÕ¾ÊÇ·ñÄÜ·ñ³ÐÊÜÕâ¸öѹÁ¦£¬ÈçºÎÈ·±£ÍøÕ¾µÄ¸ººÉûÓÐÎÊÌ⣬¾­¹ýÑо¿¾ö¶¨ÈçÏ£º
£¨1 £©²ÉÓøºÔØƽºâºÍ¼¯Èº¼¼Êõ£¬³õ²½»ú¹¹²ÉÓÃApache Tomcat µÄ»úȺ¼¼Êõ¡£
£¨2 £©²ÉÓÃѹÁ¦²âÊÔ¹¤¾ß£¬²âÊÔѹÁ¦¡£¹¤¾ßÊÇLoadrunner.
Ó²¼þ»·¾³´î½¨£º
ΪÁËÄܹ»½øÐÐѹÁ¦²âÊÔ£¬ÐèÒª´î½¨Ò»¸ö»·¾³¡£¸Õ¿ªÊ¼Ê±£¬²âÊÔÔÚ¹«Ë¾¾ÖÓòÍøÄÚ½øÐУ¬µ«ºÜ¿ì·¢ÏÖÁËÒ»¸öÎÊÌ⣬¼´Ò»¸ö½Å±¾µÄѹÁ¦²âÊÔ½á¹ûÿ´Î¶¼²»Ò»Ñù£¬²¢ÇÒ²î±ðºÜ´ó¡£Ô­À´ÊÇÊܹ«Ë¾ÍøÂçµÄÓ°Ï죬ÓÚÊǾö¶¨´î½¨Ò»¸öÍêÈ«¸ôÀëµÄ¾ÖÓòÍø²âÊÔ¡£´î½¨ºóµÄ¾ÖÓòÍøÅäÖÃÈçÏ£º
£¨1£© ÍøÂçËٶȣº100M
£¨2£© Èý̨
·þÎñÆ÷
£º
¸ºÔØ
·þÎñÆ÷
£º²Ù×÷ϵͳwindows2003£¬
Tomcat·þÎñÆ÷£º²Ù×÷ϵͳwindows2000 Professional
Êý¾Ý¿â·þÎñÆ÷£º²Ù×÷ϵͳwindows2000 Professional
Èý̨»úÆ÷µÄcpu 2.4 G, ÄÚ´æ 1G¡£
Èí¼þ»·¾³´î½¨£º
Èí¼þµÄ°æ±¾ÈçÏ£º
Apache °æ±¾£º2.054£¬
Tomcat5.0.30,
mysql £º4.1.14.
JDK1.5
ѹÁ¦²âÊÔ¹¤¾ß£ºLoadrunner7.8¡£
¸ºÔØƽºâ·½°¸ÈçÏ£º
һ̨»úÆ÷£¨²Ù×÷ϵͳ2003£©°²×°apache£¬×÷Ϊ¸ºÔØ·þÎñÆ÷£¬²¢°²×°tomcat×÷Ϊһ¸öworker£»Ò»¸öµ¥¶À°²×°tomcat£¬×÷ΪµÚ¶þ¸öworker£»Ê£ÏµÄһ̨µ¥¶À×÷ΪÊý¾Ý¿â·þÎñÆ÷¡£
ApacheºÍtomcatµÄ¸ºÔØƽºâ²ÉÓÃJK1.2.14£¨Ã»ÓвÉÓÃ2.0£¬Ö÷ÒªÊÇ2.0²»ÔÙά»¤ÁË£©¡£
¼¯Èº·½°¸£º
²ÉÓÃTomcat±¾ÉíµÄ¼¯Èº·½°¸¡£ÔÚserver.xmlÅäÖá£
ѹÁ¦²âÊÔÎÊÌ⣺
ѹÁ¦²âÊԺ󣬷¢ÏÖÁËһЩÎÊÌ⣬ÏÖÒ»Ò»ÁгöÀ´£º
£¨1£© ²ÉÓÃTocmat¼¯Èººó£¬ËٶȱäµÃºÜÂý¡£ÒòΪ¼¯Èººó£¬Òª½øÐÐsession¸´ÖÆ£¬µ¼ÖÂËٶȽÏÂý¡£TomcatdµÄ¸´ÖÆ£¬Ä¿Ç°²»Ö§³Öapplication¸´ÖÆ¡£¸´ÖƵÄ×÷Óã¬Ö÷ÒªÓÃÀ´ÈÝ´íµÄ£¬¼´Ò»Ì¨»úÆ÷ÓйÊÕϺó£¬apache¿ÉÒÔ°ÑÇëÇó×Ô¶¯×ª·¢µ½ÁíÍâÒ»¸ö»úÆ÷¡£ÔÚÈÝ´íºÍËٶȵĿ¼ÂÇÉÏ£¬ÎÒÃÇ×îÖÕÑ¡ÔñËٶȣ¬È¥µôÁËTomcat¼¯Èº¡£
£¨2£© ²Ù×÷ϵͳ×î´ó²¢·¢Óû§µÄÏÞÖÆ£º
ΪÁ˲ÉÓÃÍøÕ¾µÄѹÁ¦£¬ÎÒÃÇ¿ªÊ¼µÄʱºò£¬½ö²âÊÔTomcatµÄ×î´ó¸ºÔØÊý¡£Tomcat·þÎñÆ÷°²×°µÄ²Ù×÷ϵͳÊÇwindows2000 Professional¡£µ±ÎÒÃÇÓÃѹÁ¦²âÊÔ¹¤¾ß£¬²¢·¢²âÊÔʱ£¬·¢ÏÖÖ»Òª³¬¹ý15¸ö²¢·¢Óû§£¬»á¾­³£³öÏÖÎÞ·¨Á¬½Ó·þÎñÆ÷µÄÇé¿ö¡£¾­¹ýÑо¿£¬·¢ÏÖÊDzÙ×÷ϵͳµÄÎÊÌ⣺windows2000 Professional Ö§³ÖµÄ²¢·¢·ÃÎÊÓû§ÓÐÏÞ£¬Ä¬ÈϵĺÃÏñÊÇ15¸ö¡£ÓÚÊÇÎÒÃǰѲÙ×÷ϵͳȫ²¿²ÉÓÃwindows2003 server°æ±¾¡£
£¨3£© Êý¾Ý¿âÁ¬½Ó³ØµÄÎÊÌ⣺
²âÊÔÊý¾Ý¿âÁ¬½ÓÐÔÄÜʱ£¬·¢ÏÖÊý¾Ý¿âÁ¬½ÓËٶȺÜÂý¡£Ã¿Ôö¼ÓһЩÓû§£¬Á¬½ÓÐÔÄܾͲîÁ˺ܶ


Ïà¹ØÎĵµ£º

MySql ±íµÄÖ÷¼üË÷ÒýÎÊÌâ

²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆ京Òå¼°×÷Óã ......

mysqlÖ÷´ÓÊý¾Ý¿â²Ù×÷

Ö÷£º
show master status;
+-----------------+------------+-------------------+-----------------------+
| File                |
Position     | Binlog_Do_DB   | Binlog_Ignore_DB |
+------------ ......

hibernate mysql ´æ´¢¶þ½øÖÆÎļþÎÊÌâ×ܽá

ÏÈ˵Ã÷Ò»ÏÂBlobµÄÀàÐÍ£¬Ö±½Ó´ÓÍøÉÏÕª³­ÁË£¡£¡£¡
1¡¢MySQLÓÐËÄÖÖBLOBÀàÐÍ:
¡¡¡¡·tinyblob:½ö255¸ö×Ö·û
¡¡¡¡·blob:×î´óÏÞÖƵ½65K×Ö½Ú
¡¡¡¡·mediumblob:ÏÞÖƵ½16M×Ö½Ú
¡¡¡¡·longblob:¿É´ï4GB
2¡¢³ýÁËÀàÐͶԺóÃæ´æÈ¡Îļþ´óСÓÐÏÞÖÆ£¬»¹ÒªÐÞ¸ÄmysqlµÄÅäÖÃÎļþ¡£
¡¡¡¡Windows¡¢linux»ù±¾Ò»Ñù ......

MySQLн¨Óû§,ÊÚȨ,ɾ³ýÓû§,ÐÞ¸ÄÃÜÂë²Ù×÷

Ê×ÏÈÒªÉùÃ÷һϣºÒ»°ãÇé¿öÏ£¬ÐÞ¸ÄMySQLÃÜÂ룬ÊÚȨ£¬ÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ġ£
×¢£º±¾²Ù×÷ÊÇÔÚWINÃüÁîÌáʾ·ûÏ£¬phpMyAdminͬÑùÊÊÓá£
    Óû§£ºphplamp  Óû§Êý¾Ý¿â£ºphplampDB
1.н¨Óû§¡£
//怬MYSQL
@>mysql -u root -p
@>ÃÜÂë
//´´½¨Óû§
mysql> insert into mysql.user ......

½â¾öÖÐÎÄ´æÈëMySql³öÏÖÂÒÂëÎÊÌâ

½â¾ö°ì·¨£ºÔÚÁ¬½Ó×Ö·û´®ÖÐ˵Ã÷Á¬½Ó×Ö·ûµÄÊôÐÔ£¬È磺
    <add name="server_mysql" connectionString="server=127.0.0.1;user id=root; password=123; database=baiduemail; pooling=false;charset=gbk"/>
»òÕßÊÇ;charset=gb2312
ÁíÍâ×¢Ò⣺ÔÚ´´½¨mysqlÊý¾Ý¿âµÄ±íµÄʱºòÑ¡Ôñ±àÂ뼯gbk ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ