mysqlÊý¾ÝÒÆÖ²
1. ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2. ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä¿±ê»úÆ÷dataÏ¡£
3. Í£Ö¹mysql·þÎñ£¬½«ibdata1Õâ¸öÎļþ¿½±´µ½dataÎļþ¼ÐÏ£¬¸²¸ÇÔÀ´µÄibdata1Îļþ¡£
4. ÖØÐÂÆô¶¯mysql·þÎñ£¬²¢Ë¢Ð£¬´ËʱÔٲ鿴Êý¾Ý¿âÖеÄÊý¾Ý£¬¼´OK¡£
Ïà¹ØÎĵµ£º
MYSQL³£ÓÃÃüÁîÁбí
1¡¢ÏµÍ³¹ÜÀí
mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p
Á¬½ÓMYSQL£¨ÔÚmysql/bin£©
exit
Í˳öMYSQLÃüÁî
mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë
ÐÞ¸ÄÃÜÂ루ÔÚmysql/bin£©
grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost£¨"%"£¬ ±íʾÈκÎÖ÷»ú£©identifiedby " ......
֮ǰ£¬Ò»Ö±À§ÄպܾõÄMySQLµÄÎÊÌâÒòΪÓÐÁËtcmallocºóµÃÒÔ½â¾ö¡£
ÎÊÌâÊÇ£ºÍøÕ¾·ÃÎÊÁ¿²»¸ß£¬¸ß·åʱ²¢·¢ÊýÔÚ300-400Ö®¼ä¡£CPU±È½Ï¸ß£¬ÔÚ30-80%Ö®¼ä²¨¶¯µÃÀ÷º¦£¬Ê¹ÓÃtopÃüÁî¿ÉÒÔ¿´µ½ÊÇmysql½ø³Ìµ¼Ö£¬Í¬Ê±ÓÃiostatºÍsar²é¿´iowaitÖµºÜ¸ßÔÚ20-30Ö®¼ä¡£
µ«ÊÇϵͳ»¹¿ÉÒÔÎȶ¨ÔËÐУ¬È»ºóÖÜÆÚÐԵijöÏÖswap·ÖÇøÕ¼ÓÃÂÊÅÊÉý£¬Ö±½Óµ¼Ö ......
±¸·ÝÓë»Ö¸´ÔÚÈκÎÊý¾Ý¿âÀïÃæ¶¼ÊǷdz£ÖØÒªµÄÄÚÈÝ£¬ÌرðÊÇËæ×ÅÊý¾ÝÁ¿µÄÔö¼Ó£¬±¸·ÝÎÊÌâ»áÔ½À´Ô½Í»³ö£¬Òò´Ë£¬ºÃµÄ±¸·Ý·½·¨Ó뱸·Ý²ßÂÔÊǷdz£ÖØÒªµÄ¡£½áºÏÎÒËù×öµÄÏîÄ¿±¾Éí£¬ÏÂÃæÖ÷Òª¾Íwindowsƽ̨ÏÂMySQL(5.0)Êý¾Ý¿âµÄ³£Óñ¸·ÝÓë»Ö¸´×öһЩ×ܽᡣ
1 Ïà¹Ø×¼±¸¹¤×÷
......
Mysql怬
µÇ¼MySQLµÄÃüÁîÊÇmysql£¬ mysql µÄʹÓÃÓï·¨ÈçÏ£º
¡¡¡¡mysql [-u username] [-h host] [-p[password]] [dbname]
¡¡¡¡username Óë password ·Ö±ðÊÇ MySQL µÄÓû§ÃûÓëÃÜÂ룬mysqlµÄ³õʼ¹ÜÀíÕʺÅÊÇroot£¬Ã»ÓÐÃÜÂ룬עÒ⣺Õâ¸örootÓû§²»ÊÇLinuxµÄϵͳÓû§¡£MySQLĬÈÏÓû§ÊÇroot£¬ÓÉÓÚ³õʼûÓÐÃÜÂ룬µÚÒ»´Î½øÊ± ......
ÔÚaccessÖбíÖÐÊý¾Ýµ¼³öΪÎı¾Îļþµ½MySQLµÄÎÊÌ⣿
µ¼³öÎı¾Îļþʱºò£¬¿ÉÒÔÑ¡Ôñ×ֶηָô·û£¬À´°ÑÿһÁиô¿ª ºÍ Îı¾Ê¶±ð·û£¬À´°ÑcharÐÍÊý¾ÝÀ¨ÆðÀ´
ÎÒÏÖÔÚÓÓ£¬”×÷Ϊ×ֶηָô·û£¬²»Ê¹ÓÃÎı¾Ê¶±ð·û
Éú³ÉµÄÎı¾ÎļþÈçÏÂ
1£¬ÕÅÈý£¬ÄУ¬£¬Öйú ÉϺ££¬80501206
2£¬ÍõÎ壬Ů£¬Öйú ±±¾© ......