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

ÈçºÎÐÞ¸ÄmysqlÊý¾Ý¿âµÄÁ¬½ÓÊý

а²×°ºóµÄmysqlÊý¾Ý¿â£¬ÆäĬÈϵÄ×î´óÁ¬½ÓÊýΪ100¡£
·½·¨Ò»£º
ÔÚmysql°²×°Â·¾¶Ï£¬ÕÒµ½my.ini»òÕßmy.cnfÎļþ£¬´ò¿ªËüÕÒµ½max_connections,ÉèÖóÉ1000; È»ºóÖØÆômysql·þÎñ¡£
·½·¨¶þ£º
ÔÚmysqlÔËÐл·¾³Ï£¬½øÈëmysqlÃüÁîÏ£º
mysql> set global max_connections=1000;
È»ºó¹Ø±ÕmysqlÖØÆôËü£»
ÔÚ./bin·¾¶Ï£¬Ê¹Óà # ./mysqladmin -uroot -p123456 variables | grep "max_connections"
¿´µ½ | max_connections | 1000 |
˵Ã÷ÐÂÐ޸ĵÄÁ¬½ÓÊýÒѾ­ÉúЧÁË¡£
Ò²¿ÉÒÔÔÚmysqlÔËÐл·¾³Ï£¬Ö´ÐУºmysql> show variables; ²é¿´max_connectionsµÄÖµ¡£
Ò²¿ÉÒÔÔÚmysqlÔËÐл·¾³Ï£¬Ö´ÐУºmysql> show status; ²é¿´µ±Ç°»î¶¯µÄÁ¬½ÓÏß³ÌÖµ£¬¼´ÕÒµ½threads_connectedµÄÖµ¾ÍÊÇÁË¡£
·½·¨Èý£º
±à¼­mysqld_safeÎļþ£º # vi /usr/local/mysql/bin/mysqld_safe
ÕÒµ½msyqldÆô¶¯µÄÄÇÁ½ÐУ¬ÔÚºóÃæ¼ÓÉϲÎÊý£º
-O max_connections=1500
È»ºóÖØÐÂÆô¶¯mysql·þÎñ£¬¾ÍOKÁË¡£


Ïà¹ØÎĵµ£º

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 ......

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

¹«Ë¾¿ª·¢ÁËÒ»¸öÍøÕ¾£¬¹À¼Æ×î¸ßÔÚÏßÈËÊýÊÇ3 Íò£¬²¢·¢ÈËÊý×î¶à100 ÈË¡£¿ª·¢µÄÍøÕ¾ÊÇ·ñÄÜ·ñ³ÐÊÜÕâ¸öѹÁ¦£¬ÈçºÎÈ·±£ÍøÕ¾µÄ¸ººÉûÓÐÎÊÌ⣬¾­¹ýÑо¿¾ö¶¨ÈçÏ£º
£¨1 £©²ÉÓøºÔØÆ½ºâºÍ¼¯Èº¼¼Êõ£¬³õ²½»ú¹¹²ÉÓÃApache Tomcat µÄ»úȺ¼¼Êõ¡£
£¨2 £©²ÉÓÃѹÁ¦²âÊÔ¹¤¾ß£¬²âÊÔѹÁ¦¡£¹¤¾ßÊÇLoadrunner.
Ó²¼þ»·¾³´î½¨£º
ΪÁËÄܹ»½øÐÐѹÁ¦² ......

mysql ÐÞ¸´ÃüÁî king of

MysqlÔÚÔËÐÐÒ»¶Îʱ¼äºó£¬Ëæ×Å¿âÈÝÁ¿µÄÔö´ó£¬±íµÄÔö¶à£¬ÓеÄʱºòÒòΪµôµç»òÕ߯äËûÔ­Òòµ¼ÖÂÊý¾Ý¿âËð»µ,±ÈÈ磺 ¼ì²éÓÅ»¯²¢ÐÞ¸´ËùÓеÄÊý¾Ý¿â£¬ÎÒÃÇ¿ÉÒÔʹÓÃmysql×Ô´øµÄmysqlcheckÃüÁîÀ´¿ìËÙÐÞ¸´ËùÓеÄÊý¾Ý¿â»òÕßÌØ¶¨µÄÊý¾Ý¿â; ½øÈëMysqlµÄBinĿ¼£ºd:\MySQL\MySQL Server 4.1\bin or /usr/bin/
(ls my* ÏÔʾmy¿ªÍ·µÄÎļþ£© ......

mysql noinstall°æ°²×°

mysql noinstall°æ°²×°
1¡¢Èí¼þµÄÏÂÔØ
¡¡¡¡µ½mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØMySQLµÄ½âѹ°ü£¬Èçmysql-noinstall-5.0.51b-win32.zip
¡¡¡¡È»ºó½«Æä½âѹµ½ÄãÏ£ÍûÊý¾Ý¿âËùÔÚµÄij¸öλÖã¬ÈçC:\
¡¡¡¡ÕâÑùÔÚC:ÅÌÏÂÃæ¾ÍÓÐÁËC:\mysql-5.0.51b-win32ÕâÑùµÄÒ»¸öĿ¼£¬ÀïÃæ¾ÍÊÇMySQLÊý¾Ý¿âµÄÈ«²¿ÄÚÈÝ¡£
2¡¢ÅäÖÃ
¡¡¡¡Ê×ÏÈÎÒÃÇÀ´¿´MySQLµÄ¸ùĿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ