linuxϽâ¾ömysqlµÄ×Ö·û±àÂëÎÊÌâ
http://hi.baidu.com/emersonm/blog/item/ee230a36ca566fd7a2cc2b4a.html
linuxϽâ¾ömysqlµÄ×Ö·û±àÂëÎÊÌâ
2009-10-06 21:03
mysqlµÄ×Ö·û±àÂëÊDZȷ±ËöµÄÊÂÇ飬ÎÒÓõÄfedora11ĬÈϰ²×°mysql5.1
$mysql --user=root --password=²¼À²¼À²¼À
½øÈëºó
mysql>show variables like 'character%'; //²é¿´µ±Ç°Êý¾Ý¿âµÄ×Ö·û±àÂë
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | latin1 |
| character_sets_dir
Ïà¹ØÎĵµ£º
selectº¯ÊýÊÇÓÃÓÚ³ÌÐò¼àÊÓ¶à¸öÎļþÃèÊö·û(file descrīptor)µÄ״̬±ä»¯¡£³ÌÐò»áÍ£ÔÚselectÕâÀïµÈ´ý£¬Ö±µ½±»¼àÊÓµÄÎļþÃèÊö·ûÓÐijһ¸ö»ò¶à¸ö·¢ÉúÁË״̬¸Ä±ä¡£select()µÄ»úÖÆÖÐÌṩһfd_setµÄÊý¾Ý½á¹¹£¬Êµ¼ÊÉÏÊÇÒ»longÀàÐ͵ÄÊý×飬 ÿһ¸öÊý×éÔªËØ¶¼ÄÜÓëÒ»´ò¿ªµÄÎļþÃèÊö·û£¨²»¹ÜÊÇSocketÃèÊö·û,»¹ÊÇÆäËû Îļþ»òÃüÃû¹ÜµÀ» ......
Ŀ ¼
1.1 ǰÑÔ£º... 4
1.2 °²×°¼°ÅäÖò½Ö裺... 4
1.2.1 £º°²×°×¼±¸... 4
1.2.2 £º°²×°·½Ê½Ñ¡Ôñ... 4
1.2.3 £º¹âÅ̼ì²â... 5
1.2.4 £º»¶Ó½çÃæ... 5
1.2.5 £ºÑ¡Ôñ°²×°¹ý³ÌµÄÓïÑÔ¡£... 6
1.2.6 £º¼üÅ̺ÍÊó±êÉèÖÃ... 6
1.2.7 £º´ÅÅÌ·ÖÇø·½Ê½Ñ¡Ôñ... 7
1.2.8 £º¸ñʽ»¯È·ÈÏÐÅÏ¢... 8
1.2.9 £º½¨·ÖÇø... 8
1. ......
Ò»¡¢ÒýÑÔ
UDPÊÇTCP/IPÐÒéÖеĴ«Êä²ãÐÒéµÄÒ»ÖÖ£¬±¾ÎĽéÉÜÁËÔÚLinuxϱàд»ùÓÚUDPÐÒéµÄClient/ServerÄ£Ð͵ijÌÐòµÄ·½·¨£¬²¢¸ø³öÁËÒ»¸öecho Client/ServerÀý×Ó³ÌÐò¡£
¶þ¡¢UDPÐÒé¼ò½é
UDPÊÇÒ»ÖÖ¼òµ¥ ......
ÔÚ³ÌÐò²»Ñ°³£Í˳öʱ£¬Äں˻áÔÚµ±Ç°¹¤×÷Ŀ¼ÏÂÉú³ÉÒ»¸öcoreÎļþ£¨ÊÇÒ»¸öÄÚ´æÓ³Ïñ£¬Í¬Ê±¼ÓÉϵ÷ÊÔÐÅÏ¢£©¡£Ê¹ÓÃgdbÀ´²é¿´coreÎļþ£¬¿ÉÒÔָʾ³öµ¼Ö³ÌÐò³ö´íµÄ´úÂëËùÔÚÎļþºÍÐÐÊý¡£ 1.coreÎļþµÄÉú³É¿ª¹ØºÍ´óСÏÞÖÆ
1£©Ê¹ÓÃulimit -cÃüÁî¿É²é¿´coreÎļþµÄÉú³É¿ª¹Ø¡£Èô½á¹ûΪ0£¬Ôò±íʾ¹Ø±ÕÁ˴˹¦ÄÜ£¬²»»áÉú³ÉcoreÎļþ¡£ ......