mysql ½«±íÖÐÊý¾Ýµ¼³ö £¨linux£©
½ñÌìÓöµ½Òªµ¼³öÊý¾Ý¿âÖбíµÄÊý¾Ý¡£ÏÂÃæÕâ¸ö¾Í¿ÉÒԸ㶨¡£¡£
#µ¼³öÖ¸¶¨µÄ±í #µ¼³öÃüÁî -uÓû§Ãû -pÃÜÂë -hÖ÷»úIPµØÖ· Êý¾Ý¿âÃû ±íÃû1 ±íÃû2 > µ¼³öÎļþ.sql
mysqldump -uroot -proot -h192.168.0.88 ok_db oktable1 oktable2 > ok_db.sql
ÁíÍâÔÚ¸ü¸ÄmysqlÃÜÂëʱºò£¬ÍøÉÏÓÐЩÃüÁî²»¶Ô£º
ÎÒÓÃÈçÏ£ºset password=password('malware_qazws');
Ïà¹ØÎĵµ£º
ÔÚLinux£¬¿ÉÒÔ¿¼ÂÇÓÃGTK(The GIMP Toolkit)À´×öGUI(Graphic User interface)¿ª·¢£¬¿ª·¢¹¤¾ß½¨ÒéʹÓÃanjuta + glade(Ã²ËÆeclipse+cdtÒ²¿ÉÒÔ)¡£
½¨Ò飺
Ò»¡¢ÏÈѧϰGTK+ 2.0±¾Éí£¬±ÈÈçÓÃvim+gcc+gdb+make+automake+autoconf...ÕâÑù¶Ô»ùÓÚGTKµÄͼÐοª·¢¹ý³Ì¾ÍÓÐÁË»ù±¾Á˽⣬ÒÔºóÓÃanjuata+glade×Ô¶¯Éú³É´úÂëµÄʱºòÈÝÒ×ÔĶÁºÍ· ......
ÓÃÌØÊâµÄMySQLÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ
Èç¹ûÄãÔÚ×î½ü½øÐйýSELECT»òUPDATE²éѯ£¬ÄÇôÄãºÜ¿ÉÄÜÓõ½¹ýÒ»¸ö»òÕß¶à¸öMySQLµÄ±È½ÏÔËËã·ûÀ´ÏÞÖÆ²éѯµÄÊä³ö½á¹û¡£±È½ÏÊÇ´ó¶àÊýSELECT²éѯ²»¿É·Ö¸îµÄÒ»²¿·Ö£¬¶øMySQLΪÕâÒ»¹¦ÄÜÌṩÁ˺ܶຯÊý£»¸ù¾Ý×î½üÒ»´Îͳ¼Æ£¬ËüÓг¬¹ý20¸öÕâÑùµÄÔËËã·ûºÍº¯Êý£¬´ÓÖøÃûµÄ=ºÍLIKEµ½¸ü¼ÓÄѶ®µÄNO ......
Why you should ignore MySQL’s key cache hit ratio
http://www.mysqlperformanceblog.com/2010/02/28/why-you-should-ignore-mysqls-key-cache-hit-ratio/
²»ÒªÏàÐÅmysqlµÄkey cache hit ratio£º
key cache hit ratio = 1 - key_reads / key_read_requests
key_reads:´Ó´ÅÅÌÖжÁ¿éµÄÊýÁ¿
key_read_request ......
LinuxµÄϵͳµ÷ÓÃÊÇͨ¹ýÖжÏÀ´ÊµÏֵ쬴ÓÓû§Ì¬½øÈëϵͳ̬¡£Óû§Ì¬ºÍϵͳ̬ÓкÜÇåÎúµÄÇø·Ö£¬±£Ö¤Á˰²È«¡£ÏµÍ³µ÷ÓñíÊÇϵͳµ÷ÓõÄÌø×ª±í¡£Ê¹ÓüĴæÆ÷´«µÝ²ÎÊý£¬¶ø²»ÊÇÕ»£¬ÒòΪÓû§Ì¬ÊÇÎÞ·¨·ÃÎÊϵͳջµÄ¡£µØÖ·´íÎóÊÇͨ¹ýÒ³ÃæÒì³£À´´¦ÀíµÄ¡£
LinuxÄں˲¢²»Ö§³ÖÕæÕýÒâÒåÉϵÄỊ̈߳¬
LinuxThreads
ÊÇÓÃÓëÆÕͨ½ø³Ì¾ßÓÐͬÑùÄÚºË ......