Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ѧϰ±Ê¼Ç

mysql·þÎñÆ÷°²×°ÅäÖãº
1. sudp apt-get install mysql-server-5.0
2. ´´½¨¿âsecond_proxy, ΪsecProxyÌí¼ÓÓû§£ºgrant all privileges on second_proxy.* to secProxy@'%' identified by 'passwd';
3. ÉèÖÃmysql.user±íÈçÏ£º
+-----------+------------------+-------------------------------------------+
| Host& ......

ARM+LinuxÖÐÎÞ·¨ÏìÓ¦ctrl+cÊÇÔõô»ØÊÂ

µ½×îºó»¹ÊÇ×Ô¼º½â¾öÁË£¬µ¼Ö¸ÃÎÊÌâµÄÔ­ÒòÊÇÔÚlinuxÆô¶¯µ½×îºó³öÏÖ£º
/bin/sh: can't access tty; job control turned off
¶ø³öÏָôíÎóµÄÔ­ÒòºÍ½â¾ö·½·¨googleºóÓÐǧ°ÙÖÖ£¬³¢ÊÔÁ˺ܶàÖÖ¶¼Ã»ÓаïÎÒ½â¾öÎÊÌâ¡£
ÏÂÃæÊÇÎÒ×Ô¼ºµÄ½â¾ö·½·¨£º
1. vi /etc/inittab µÚÒ»ÐÐÌí¼Ó
    console::sysinit:/etc/init.d ......

LinuxµÄ½»Ò×Ñ­»·£¨barter cycle£©






<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
       ÔÚÎÒÃǹúÄÚ£¬²»ÉÙ
Linux
µÄÏÈÐÐÕß¶¼ÒÔʧ°Ü¶ø¸æÖÕ£¬ÏÖÔÚ£¬ËûÃÇÔÚÄÄÀÔõô²»³öÀ´Ëµ»°ÁË£¿µ«ÊÇ£¬ÕâЩÏÈÐÐÕßÏë¸æËßÎÒÃÇÊ²Ã´ÄØ£¿ÄãÏëÖªµÀÂð£¿
 
      ¸ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ