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

ʹÓÃtcmallocºóµÄMySQL·þÎñÆ÷±äÎȶ¨ÁË£¨Linux£©

֮ǰ£¬Ò»Ö±À§ÄպܾõÄMySQLµÄÎÊÌâÒòΪÓÐÁËtcmallocºóµÃÒÔ½â¾ö¡£
ÎÊÌâÊÇ£ºÍøÕ¾·ÃÎÊÁ¿²»¸ß£¬¸ß·åʱ²¢·¢ÊýÔÚ300-400Ö®¼ä¡£CPU±È½Ï¸ß£¬ÔÚ30-80%Ö®¼ä²¨¶¯µÃÀ÷º¦£¬Ê¹ÓÃtopÃüÁî¿ÉÒÔ¿´µ½ÊÇmysql½ø³Ìµ¼Ö£¬Í¬Ê±ÓÃiostatºÍsar²é¿´iowaitÖµºÜ¸ßÔÚ20-30Ö®¼ä¡£
µ«ÊÇϵͳ»¹¿ÉÒÔÎȶ¨ÔËÐУ¬È»ºóÖÜÆÚÐԵijöÏÖswap·ÖÇøÕ¼ÓÃÂÊÅÊÉý£¬Ö±½Óµ¼ÖÂÓ¦ÓóÌÐòÎÞ·¨Á¬½ÓÊý¾Ý¿â¡£²»ÖªµÀÕâÊDz»ÊÇmysqlµÄswapµßô¤µÄÎÊÌ⡣û½â¾ö°ì·¨µÄʱºòÖ»ºÃ¾­³£¼à¿ØÄÚ´æµÄʹÓÃÇé¿ö£¬Åöµ½swap¿ªÊ¼ÅÊÉýµÄʱºòÖØÆôMySQL·þÎñ¡£Ò»°ãÕâ¸öÖÜÆÚÔÚÒ»¸öÐÇÆÚ×óÓÒ¡£
ºóÀ´ÔÚÍøÉÏËѵ½ÁËtcmalloc£¬ËµÊÇÕâ¸ö¶«Î÷¿ÉÒÔÈÃMySQLÔڸ߲¢·¢ÏÂÐÔÄÜÒ²ºÜÎȶ¨£¬Í¬Ê±Ò²ËµÁËMySQLÕâ¸öÎÊÌâÊÇÒòΪmallocÄÚ´æ·ÖÅ亯ÊýµÄbug£¬Õâ¸öbug»áʹ¸ß²¢·¢µÄMySQLÐÔÄܼ±¾çϽµ¡£
¾ö¶¨ÊÔÊÔ¡£
ϵͳÊÇ64λµÄRedHat Enterprise Linux 5.0 ¡£ÔÚ64λϵͳÏÂÐèÒª°²×°ÁíÍâÒ»¸ö°ülibunwind¡£È»ºóÏÂÔØtcmalloc°ü£¬°´Ä¬ÈÏ·½Ê½±àÒëºÍ°²×°³É¹¦ºóÔÚ mysqld_safe ÖмÓÈë
LD_PRELOAD="/usr/local/lib/libtcmalloc.so"
ÖØÆôMySQL¡£Ã»Óа취¿ÉÒÔÑéÖ¤tcmallocÊÇ·ñÆðЧ£¬Ö»ÄÜÔÙ¼ÌÐø¼à¿ØÏµÍ³µÄÔËÐÐ×´¿ö¡£
¾­¹ýÒ»¸ö¶àÀñ°ÝÁË£¬Äã¿ÉÒÔ¿´¿´ÏÂÃæÒ»¸ö×¥×ÔmrtgµÄͼ£º
ÉÏÃæÁ½¸öͼÖУ¬µÚÒ»¸öÊÇCPUµÄͼ£¬µÚ¶þ¸öÊÇÄÚ´æµÄͼ¡£¿ÉÒÔ¿´³ö´Ó»»ÉÏtcmallocºó£¬CPUÕ¼ÓÃÂÊϽµ·Ç³£Ã÷ÏÔ£¬Ô­À´Ò»Ö±Î¬³ÖÔÚ30%×óÓÒ£¬ÏÖÔÚÖ»Õ¼²»µ½10%¡£¶øÄÚ´æ·½Ãæ£¬Ô­À´ÎïÀíÄÚ´æÒ»Ö±Õ¼ÓÃ100%£¬swapÕ¼ÓÃÂʲ¨¶¯µÃºÜÀ÷º¦£¬Ï½µµãÒ»°ãÊÇÖØÆôMySQLºóµ¼Öµģ¬¶ø»»ÉÏtcmallocºó£¬ÄÚ´æÎ¬³ÖÔÚ80-90%Ö®¼ä£¬¶øswapÕ¼ÓÃÂʾͷdz£Îȶ¨£¬¿ÉÒÔ°´Áã¼Æ¡£
¶øÇÒÒѾ­³ÖÐøÁËÒ»¸ö¶àÀñ°ÝÁË¡£¿ÉÒÔ˵Ч¹ûÏ൱Ï൱µÄÃ÷ÏÔ£¬·Ç³£ÁîÈËÂúÒâ¡£ÔÙÒ²²»ÓÃÀÏÈ¥¶¢×Åmrtg¿´ÁË¡£µ±È»ÕâÊÇÎҵĻúÆ÷ÉÏÏÖʵµÄÇé¿ö£¬²»ÖªµÀÆäËûϵͳÔõÑù¡£
libunwind: http://www.nongnu.org/libunwind/
tcmalloc: http://goog-perftools.sourceforge.net/doc/tcmalloc.html
ÏêϸµÄ°²×°²½Ö裺
#tar zxvf libunwind-0.98.6.tar.gz
#cd libunwind-0.98.6
#./configure
#make
#make install
#tar zxvf google-perftools-0.94.1.tar.gz
#cd google*
#./configure
#make
#make install
´ò¿ª mysqld_safe ½Å±¾ (ĬÈÏÔÚ/usr/bin/mysqld_safe)
Ôڴ˽ű¾Îļþ¿ªÊ¼¼ÓÈë
LD_PRELOAD="/usr/local/lib/libtcmalloc.so"
#service mysql restart


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì£¨ËÄ£© L2CAP²ã±à³Ì

£¨L2CAPЭÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPЭÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼­Á¬½Ó¿ØÖƺÍÊÊÅäЭÒé (L2CAP) ΪÉϲãЭÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àЭÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãЭÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......

ʹÓÃMySQL connector/C++Á´½ÓMySQLÊý¾Ý¿â

Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔØµÚ¶þ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼Ðϵ ......

Moto LinuxÓ¦Óÿª·¢£¨Î壩£ºframe buffer

moto linuxÖ§³ÖframebufferдÆÁ£¬SDKÖаüº¬ÁËÒ»¸ösample£¬Ö±½ÓдframebufferÏÔʾºìÉ«ºÍÂÌÉ«¡£²»¹ýÔÚдframebuffer֮ǰÐèÒªÁ˽âÒ»ÏÂframebufferµÄÏà¹ØÌØÐÔ¡£ÒÔÏÂÊÇÎÒµÄA1200eµÄframebufferÐÅÏ¢£º
framebuffer info: bits_per_pixel(18), xres(240), yres(320)
·Ç³£Ææ¹ÖµÄÊÇ£¬Ã¿¸öÏñËØ18¸öbits¡£ÉÏÍø²éÁËһϣ¬Ô­À´ºÜ¶àÊÖ»ú ......

linuxÃæÊÔÌâ²Î¿¼´ð°¸£¨×ª£©


Ò»£®Ìî¿ÕÌ⣺
1. ÔÚLinuxϵͳÖУ¬ÒÔ Îļþ

·½Ê½·ÃÎÊÉ豸 ¡£
2. LinuxÄÚºËÒýµ¼Ê±£¬´ÓÎļþ
/etc/fstab
ÖжÁȡҪ¼ÓÔØµÄÎļþϵͳ¡£
3. LinuxÎļþϵͳÖÐÿ¸öÎļþÓÃ
i½Úµã
À´±êʶ¡£
4. È«²¿´ÅÅÌ¿éÓÉËĸö²¿·Ö×é³É£¬·Ö±ðΪÒýµ¼¿é ¡¢×¨ÓÃ¿é ¡¢ i½Úµã±í¿é ºÍÊý¾Ý´æ´¢¿é
¡£
5.
Á´½Ó·ÖΪ£º Ó²Á´½Ó ºÍ ·ûºÅÁ´½Ó
......

LinuxϵÄUltraEdit°²×°¼°È¥µô30ÌìÏÞÖÆ

1.download UltraEdit
http://www.ultraedit.com/downloads/uex.html
2.install  rpm -ivh UltraEdit-1.0-0.13.i386.rpm
3.ÉèÖÃalias,½â³ý30ÌìÏÞÖÆ
alias ue='rm -rf ~/.idm/uex/*.*|rm -rf ~/.idm/uex/.dat |/usr/local/bin/uex &' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ