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

mysql×î´óÁ¬½ÓÊýÎÊÌâ

ÏëÎÊÏÂMySQL max_connections×î´óÄÜÉèÖóɶàÉÙ£¿¿É²»¿ÉÒÔÉèÖü¸Ç§Íò¼¸ÒÚ»òÕ߸ü´óµÄ£¬»òÕßÊDz»ÏÞÖÆ
Òª×öʲô? ÀíÂÛÉÏʱ¿ÉÒԵġ£ÐèÒªÄÚ´æ×ã¹»¡£

ÊÜÄãµÄÄÚ´æÏÞÖÆ

max_connections
¾ÍÊÇͬʱÓÖ¶àÉÙÈË·ÃÎÊÄãµÄweb

ÀàËÆÄ³Ð©ÍøÕ¾µÄÔÚÏßÈËÊý

Ö÷ÒªÊÇ×öÌõÐÎÂë´òÓ¡µÄ£¬SEVER¶Ë¼àÌý¿Í»§¶ËÊäÈëµÄÌõÐÎÂ룬²¢µ¼ÈëÊý¾Ý¿â£¬Èç¹ûÁ¬½ÓÊý̫СÃ÷ÏÔ²»¹»Ó㬶øÎҸijɸö¼¸Ê®ÍòµÄÊýÖ®ºó³öÀ´Õâ¸ö£¬ÓйØÏµÃ´£¿
090917 15:31:06 [Warning] Changed limits: max_open_files: 2048  max_connections:
1910  table_cache: 64


ËûÉÏÃæÌáʾ×î´óÁ¬½ÓÊý1910£¬Ã÷ÏÔ²»¹»Óã¬ÓÐûÓÐʲô°ì·¨ÄØ

mysql> show global variables like '%max_connections%';
mysql> set global max_connections=10000;
mysql> show global variables like '%max_connections%';


Ïà¹ØÎÊ´ð£º

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

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

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

ÔõÑù°Ñmysql 4.0µÄ×Ö·û¼¯¸ÄΪgbk?

ÔõÑù°Ñmysql 4.0µÄ×Ö·û¼¯¸ÄΪgbk?
mysql 4.0µÄ×Ö·û¼¯¿ÉÒÔÑ¡gbkÂð?

ÔõÑù°Ñmysql 4.0µÄ×Ö·û¼¯¸ÄΪgbk?
------------------------------
ÔÚÅäÖÃÎļþÀïÃæ¿´¿´ÊÇ·ñ¿ÉÒÔÌí¼Ó£º
default-character-set=g ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ