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

ÔÚÏßmysqlÊý¾Ý¿â·¢ÏÖ¸ºÔعý¸ß

·¢ÏÖÔÚÏßmysqlÊý¾Ý¿â·¢ÏÖ¸ºÔعý¸ß£¬
linux£¨centos£©¡¡£«mysql£µ¡¡
linuxÓÃtop·¢ÏÖÄڴ棳£°£¹£°£¹£¸£°k¡¡total£»
used¡¡£³£°£°£³£³£¶£°
£¿

ʲôԭÒò
ûÓÐÕÒµ½²éѯÓï¾ä

ÊDz»ÊÇÁ´½ÓÌ«¶àÁË µ¼ÖÂIO´óÁ¿ÏûºÄ

ÉèÖÃ max_connections          | 100
The number of simultaneous client connections allowed. By default, this is 151, beginning with MySQL 5.1.15.


    max_user_connections    | 0
The maximum number of simultaneous connections allowed to any given MySQL account. A value of 0 means ¡°no limit.¡±



ʵ¼ÊÉÏmax_connections £½£µ£°£°
max_user_connections  £½ 0


Óù¤¾ß¹Û²ì¡¡µ±Ç°Á¬½Óµ½Êý¾Ý¿âµÄ»úÆ÷¡¡ºÜÉÙ¡£
£¨±¾Ó¦Óüܹ¹ÊÇ¡¡¼¸Ì¨webserver¡¡£«¡¡£±db
²»´æÔÚÓû§Ö±½ÓÁ¬½Ó»úÆ÷µÄÇé¿ö
£©

3 core parameters:
read_buffer_size=16M read_rnd_buffer_size=26k sort_buffer_size=134M (rather big)

if 20 users are logging the system at the same time ,  prod1a's load will be
16M*20+26k*20+134*20=3000M



Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ