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£© Êý¾Ý¿âÁ¬½Ó³ØµÄÎÊÌ⣺
²âÊÔÊý¾Ý¿âÁ¬½ÓÐÔÄÜʱ£¬·¢ÏÖÊý¾Ý¿âÁ¬½ÓËٶȺÜÂý¡£Ã¿Ôö¼ÓһЩÓû§£¬Á¬½ÓÐÔÄܾͲîÁ˺ܶ
Ïà¹ØÎĵµ£º
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost]# mysql -u root -p
Enter password:
ERROR 2002 (H ......
mysql> SOURCE [·¾¶]ÎļþÃû
ÓÐÁ½ÖÖд·¨£º
1¡¢
mysql> SOURCE cr_pet_tbl.sql
Õâ¸öʱºò£¬cr_pet_tbl.sql±ØÐë·ÅÔÚÄãµÄmysql/binĿ¼ÏÂÃæ£¬¼´¸úmysql.exeͬһĿ¼
2¡£
mysql> SOURCE c:\cr_pet_tbl.sql
Õâ¸öʱºòλÖÃλÖÃÕýÈ·¼´¿É£¬ ......
DATE_FORMAT(date,format)
¸ù¾Ýformat×Ö·û´®¸ñʽ»¯dateÖµ¡£ÏÂÁÐÐÞÊηû¿ÉÒÔ±»ÓÃÔÚformat×Ö·û´®ÖУº %M ÔÂÃû×Ö(January……December)
%W
ÐÇÆÚÃû×Ö(Sunday……Saturday)
%D ÓÐÓ¢Óïǰ׺µÄÔ·ݵÄÈÕÆÚ(1st, 2nd, 3rd, µÈµÈ¡££©
%Y Äê, Êý×Ö, 4 λ
%y Äê, Êý×Ö, 2 λ
%a ËõдµÄÐÇÆÚÃû×Ö(Sun ......
½â¾ö°ì·¨£ºÔÚÁ¬½Ó×Ö·û´®ÖÐ˵Ã÷Á¬½Ó×Ö·ûµÄÊôÐÔ£¬È磺
<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 ......