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Êý¾Ý¿âÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨
·½·¨Ò»£º
ÔʼÃÜÂëÊÇ ckh
mysql -uroot -pckh
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
my ......
JAVAµ÷ÓÃMYSQL´æ´¢¹ý³Ì
¹¤³ÌÊÓͼ£º
´úÂëÇåµ¥£º
myconn.java
package org.apache.sh_mysql.test;
import java.sql.*;
public class MyConn {
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost/test?useUnicode=true&characterEn ......
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×Ö·û´®º¯ÊýµÄÓ¦ÓÃÓë×¢ÒâÊÂÏî
ÒÔϵÄÎÄÕÂÖ÷ÒªÏò´ó¼ÒÃèÊöµÄÊÇMySQL×Ö·û´®º¯ÊýµÄʵ¼ÊÓ¦ÓÃÓëÆäʵ¼Ê²Ù×÷´úÂëµÄÃèÊö£¬Í¬Ê±±¾ÎÄ»¹¶ÔÆäÔÚʵ¼ÊÓ¦ÓÃÖУ¬Ò»Ð©ÖµµÃÎÒÃÇ´ó¼Ò×¢ÒâµÄÏà¹ØÊÂÏîµÄÃèÊö£¬ÒÔϾÍÊÇÎÄÕµÄÖ÷ÒªÄÚÈÝÃèÊö£¬ÍûÄã»áÓÐËùÊÕ»ñ¡£
CHARSET(str) ·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2 [,& ......
---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄǰÌáϽøÐÐ×ªÔØ£»
---- ×ªÔØÎñ±Ø×¢Ã÷Ôʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 18:46:12
---- ¹Ø¼ü×Ö£º MySQL ·ÖÒ³ limit
----------------------- ......