ÔÚÏß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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......