Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²Ù×÷Àà

×î½üдÁËÒ»¸ö¼òµ¥µÄMysql²Ù×÷À࣬ÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬»¹Çë¸÷λ¸ßÊÖÖ¸ÕýÒ»ÏÂÎö¹¹º¯ÊýµÄÓ÷¨£º
<?php
/*
* Created on 2010-5-25
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*
* class mysql
* made by S71ENCE
*/
class mysql ......

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

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

MySQLÖÐÊý¾Ý½á¹û¼¯·ÖÒ³¹¦ÄܵÄʵÏÖ·½·¨

---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ­´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄǰÌáϽøÐÐ×ªÔØ£»
---- ×ªÔØÎñ±Ø×¢Ã÷ԭʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 18:46:12
---- ¹Ø¼ü×Ö£º  MySQL ·ÖÒ³  limit
----------------------- ......

MySQL Master Slave Replication

MySQL±¾ÉíûÓÐÌṩreplication failoverµÄ½â¾ö·½°¸(¼ûHow can I use replication to provide redundancy or high availability?)
ÈçºÎʹReplication·½°¸¾ßÓÐHA£¿
´ð°¸ÊÇMMM(MySQL Master-Master Replication Manager)
MMM¶ÔMySQL Master-Slave Replication¾ø¶ÔÊÇÒ»¸öºÜÓÐÒæµÄ²¹³ä!
ÒýÑÔ
Master-SlaveµÄÊý¾Ý¿â»ú¹¹ ......

MySqlÈÕÆÚ¸ñʽ»¯

DATE_FORMAT(date,format)
¸ù¾Ýformat×Ö·û´®¸ñʽ»¯dateÖµ¡£ÏÂÁÐÐÞÊηû¿ÉÒÔ±»ÓÃÔÚformat×Ö·û´®ÖУº %M ÔÂÃû×Ö(January……December)
%W
ÐÇÆÚÃû×Ö(Sunday……Saturday)
%D ÓÐÓ¢Óïǰ׺µÄÔ·ݵÄÈÕÆÚ(1st, 2nd, 3rd, µÈµÈ¡££©
%Y Äê, Êý×Ö, 4 λ
%y Äê, Êý×Ö, 2 λ
%a ËõдµÄÐÇÆÚÃû×Ö(Sun ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ