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');
Ïà¹ØÎĵµ£º
0.Introduction
һ˵Æð²Ù×÷ϵͳ, ÎÒÃǵÄÄÔº£ÂíÉϾͻáÉÁ³öWindows, ¾Ý˵WindowsÒѾ±»°²×°µ½ÁË1.5ÒŲ́¼ÆËã»úÉÏ.
È»¶øÔÚÕâÀïÎÒ»¹ÒªÌáµ½ÁíÒ»ÖÖ²Ù×÷ϵͳ, ¾Ý¹À¼ÆÕâÖÖÀàÐ͵IJÙ×÷ϵͳÒѾ±»°²×°µ½ÁËÈ«Çò30ÒÚµ½40ÒŲ́¼ÒÓõç×Ó²úÆ·ÖÐ.
Èç¹ûÆÕ¼°³Ì¶È°´ÕÕ»úÆ÷ÊýÁ¿À´¼ÆµÄ»°, ËüµÄÆÕ¼°³Ì¶È¾¹È»ÊÇWindowsµÄÊýÊ®±¶. Õâ¿î²Ù×÷ϵͳ½Ð×öTR ......
Another Look at MySQL 5.1's SQL Diagnostic Tools
http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html Êý¾Ý¿âµÄÐÔÄܾö¶¨ÒòËØ£º
£¨1£©Êý¾Ý¿âµÄÉè¼Æ
£¨2£©SQL´úÂë ¿ÉÒÔÓÃÒÔϼ¸ÖÖ·½·¨À´½â¾öһЩÐÔÄÜÎÊÌ⣺
£¨1£©Ë÷Òý
£¨2£©Ë®Æ½·ÖÇø
£¨3£©ÁÐÊÊÓ¦µÄ±í
colum ......
Advanced MySQL Replication Techniques
http://dev.mysql.com/tech-resources/articles/advanced-mysql-replication.html
ÔÚ¶à¸ömasterÖи´ÖƵÄÎÊÌ⣬Ö÷ÒªÊÇ×ÔÔöÖ÷¼üÎÊÌâ¡£
¿ÉÒÔÓÃauto_increment_incrementºÍauto_increment_offset²ÎÊý½â¾ö
£¨1£©auto_increment_increment£º¿ØÖÆÔö³¤µÄ¼ä¸ô
£¨2£©auto_increment_of ......
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ÅäÖÃjava¿ª·¢Æ½Ì¨
Ò»¡¢°²×°jdk
1.ÏÂÔØ°²×°jdk
£¨1£©¡¢Ê×ÏÈ£¬ÔÚhttp://java.sun.com
ÕÒµ½ÒªÏÂÔØµÄjdk£¬ÏÂÔØ×Ô¼ºÐèÒªµÄjdk°æ±¾¡£ÎÒÕâÀïʹÓõÄÊÇjdk6£¬µÃµ½µÄÊÇÒ»¸öÃûΪjdk-6u6-linux-i586-rpm.binµÄÎļþ¡£´ËÎļþµ±Ç°Îª²»¿ÉÔËÐеÄshell script¡£
£¨2£©¡¢¸ü¸ÄȨÏÞ£¬ÌáÈ¡jdk°²×°Îļþ£º
´ò¿ªÖÕ¶ËÔËÐ ......