mysqlÊý¾ÝÒÆÖ²
1. ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2. ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä¿±ê»úÆ÷dataÏ¡£
3. Í£Ö¹mysql·þÎñ£¬½«ibdata1Õâ¸öÎļþ¿½±´µ½dataÎļþ¼ÐÏ£¬¸²¸ÇÔÀ´µÄibdata1Îļþ¡£
4. ÖØÐÂÆô¶¯mysql·þÎñ£¬²¢Ë¢Ð£¬´ËʱÔٲ鿴Êý¾Ý¿âÖеÄÊý¾Ý£¬¼´OK¡£
Ïà¹ØÎĵµ£º
±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > backu ......
֮ǰ£¬Ò»Ö±À§ÄպܾõÄMySQLµÄÎÊÌâÒòΪÓÐÁËtcmallocºóµÃÒÔ½â¾ö¡£
ÎÊÌâÊÇ£ºÍøÕ¾·ÃÎÊÁ¿²»¸ß£¬¸ß·åʱ²¢·¢ÊýÔÚ300-400Ö®¼ä¡£CPU±È½Ï¸ß£¬ÔÚ30-80%Ö®¼ä²¨¶¯µÃÀ÷º¦£¬Ê¹ÓÃtopÃüÁî¿ÉÒÔ¿´µ½ÊÇmysql½ø³Ìµ¼Ö£¬Í¬Ê±ÓÃiostatºÍsar²é¿´iowaitÖµºÜ¸ßÔÚ20-30Ö®¼ä¡£
µ«ÊÇϵͳ»¹¿ÉÒÔÎȶ¨ÔËÐУ¬È»ºóÖÜÆÚÐԵijöÏÖswap·ÖÇøÕ¼ÓÃÂÊÅÊÉý£¬Ö±½Óµ¼Ö ......
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü Chinaz.com
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1011£ºÉ¾³ýÊý¾Ý¿âÎļþʧ°Ü
1012£º²»ÄܶÁȡϵͳ±íÖеļǼ
1020£º¼Ç¼Òѱ»ÆäËûÓû§ÐÞ¸Ä
10 ......
±¾ÎÄÖ÷Òª½éÉÜÁ˲ÉÓÃProxoolÀ´Á¬½ÓmysqlµÄ·½·¨£¬Í¨¹ýjava application·½Ê½¿ÉÒÔÑéÖ¤Êý¾Ý¿âµÄÁ¬½Ó¼°»ñÈ¡±íÖеÄÊý¾Ý¡£ÎªÁËÄܹ»Ó봫ͳµÄJDBC·½Ê½µÄÁ¬½Ó½øÐбȽϣ¬±¾ÎIJÉÈ¡ÁËÁ½ÖÖ·½Ê½½øÐÐÊý¾Ý¿âµÄÁ¬½Ó£¬´úÂëÈçÏ¡£
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java ......
½â¾ömysql“Access denied for user
ÎÒµÄϵͳÊÇubuntu6.06£¬×î½üÐÂ×°ºÃµÄmysqlÔÚ½øÈëmysql¹¤¾ßʱ£¬×ÜÊÇÓдíÎóÌáʾ:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ʹÓÃÍøÉϽéÉܵķ½·¨ÐÞ¸ÄrootÓû§µÄÃÜÂ룺
# mysqladmin -uroot -p p ......