MySQL¼à¿Ø
ÔÎÄÍøÖ·£ºhttp://knowhow.innovatedigital.com/mysql-monitoring.html
MySQLÊÇ×îÁ÷ÐеĿª·ÅÔ´´úÂë¹ØϵÊý¾Ý¿âϵͳ¡£ÆäÐÔÄܺÍÒ×ÓÃÐÔ£¬Ê¹Æä³ÉΪLAMP¼Ü¹¹µÄÖÐÐÄÖ§ÖùÖ®Ò»¡£
MySQL¼à¿ØÒ»Ö±ÊǹØ×¢MySQLÊý¾Ý¿âÐÔÄܺÍMySQLÊý¾Ý¿âÔËά¹ÜÀí¼¼ÊõÈËÔ±µÄ·Ç³£¸ÐÐËȤ»°Ìâ¡£ÈçºÎÈÃÄúµÄMySQLÊý¾Ý¿â°²È«¿ìËÙµÄÔËÐУ¬Hyperic HQ¾Í¿ÉÒÔͨ¹ý¼à¿ØMySQL£¬Í¨¹ý±¨¾¯·½Ê½¼°Ê±·¢ÏÖMySQLÊý¾Ý¿â´æÔÚµÄÎÊÌ⣡
Hyperic HQ ¶Ô¿ªÔ´¼¼ÊõµÄÈ«ÃæÖ§³ÖÒâζ×ÅÄú¿ÉÒÔÇáËɹÜÀíMySQLÒÔ¼°Í¨¹ýHQ½Ó¿Ú¹ÜÀíÆäÓàµÄLAMP¶ÑÕ» ¡£Hyperic HQ¾ßÓÐÖ±¹ÛÐԺͿɼûÐÔ£¬ÕâÖֿɼûÐÔÓÉMySQLÊý¾Ý¿âÒýÇæÒÔ¼°Ã¿¸ö±íµÄ´óÁ¿¶ÈÁ¿ÖµÇý¶¯¡£
´ËÍ⣬HQͨ¹ý×Ô¶¯»¯ºÍÐèÇó¹ÜÀíÈÎÎñ¿ØÖÆMySQL£¬Õ⽫ÓÐÖúÓÚ±£³ÖMySQLÊý¾Ý¿âµÄ¸ßÐÔÄÜÔËÐС£ÆäÇ¿´óµÄÓ¦ÓøÅÄÄú¿ÉÒÔÖ±¹ÛµØ¼à²âÄãµÄÒµÎñÂß¼ºÍÊý¾Ý¿â²ã±íʾ²ã£¬Í¨¹ý²âÁ¿Êý¾Ý¿ÉÒÔºâÁ¿ÄãµÄÓ¦ÓóÌÐò»ù´¡¼Ü¹¹µÄ¸÷¸ö²ãÃæÈçºÎÔÚ¿Í»§¶ËµÄ»î¶¯¡£
Hyperic HQ ¶ÔMySQL¼à¿ØÖ÷ÒªÌåÏÖÔÚ£º
×Ô¶¯·¢ÏÖÄúµÄÓ²¼þºÍMySQL·þÎñÆ÷
¼à¿ØMySQL×ÊÔ´µÄÿһ¸ö¶ÈÁ¿Öµ£¬ÈÕÖ¾£¬ÅäÖÃ
ÓÃ×Ô¶¯µÄ¶ÈÁ¿Öµ»ùÏßʶ±ðÎÊÌâ
¿ØÖÆËùÓÐMySQL×ÊÔ´ÉϵÄÃüÁµ÷¶È£¬»ò¾¯±¨»ØÓ¦
¾¯±¨MySQL»·¾³µÄÔÚÈκβâÁ¿£¬ÈÕÖ¾£¬»ò°²È«ÐÔʼþ
Hyperic HQ--ÓÅÐãµÄMySQLÊý¾Ý¿â¼à¿ØÈí¼þ ,ÏàÐÅÄܸøÄú´øÀ´¸ü¶à¼ÛÖµ£¬ÈÃÄú´Ó·±ÖصŤ×÷ÖнâÍѳöÀ´£¬µÃµ½Ò»·ÝÇáËɺÍÓä¿ì£¡
Hyperic HQÏÂÔØ£ºhttp://knowhow.innovatedigital.com/node/326
Hyperic HQ FAQÓë½â´ð http://knowhow.innovatedigital.com/hyperic-hq
Hyperic HQ ¼¼ÊõÂÛ̳£ºhttp://g.51cto.com/hyperichq
Ïà¹ØÎĵµ£º
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
Èç¹û°´ÕÕpowerdesignerµÄĬÈÏÑ¡Ïî,Éú³ÉµÄsql²»ÄÜÔÚmysqlÖÐÕýÈ·ÔËÐÐ.]
¾¹ý±¾ÈËÑо¿·¢ÏÖÒª×öÈçÏÂÐÞ¸Ä:
1.aftercreateÑ¡Ïî¸ÄΪ
.foreach_item(OutReferences)
.ifnot (%hasFKIndex%)
/*==============================================================*/
/* Index: ......
1. ¿ªÊ¼->¿ØÖÆÃæ°å->Ìí¼Ó»òɾ³ý³ÌÐò->жÔØmysql
2. ¼ÙÉè֮ǰmysqlµÄ°²×°Ä¿Â¼ÊÇC:\Program Files\MySQL\MySQL Server 5.1/, ÄÇôÕâ¸öÏÂÃ滹±£ÁôÁËһЩ¶«Î÷£¬´ò¿ªmy.ini
3. ÕÒµ½#Path to the database root£¬ È»ºó°´ÕÕÕâ¸öPathÕÒµ½mysql,ɾµô
4. °ÑC:\Program Files\MySQLҲɾµô
5. ¿ªÊ¼->ÔËÐÐ ÊäÈër ......
http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root&rsq ......
ÔÚÉú²úÓ¦ÓÃÖУ¬Ä³Ì¨“Nginx+PHP+MySQL”½Ó¿ÚÊý¾Ý·þÎñÆ÷£¬°çÑݵĽÇÉ«Ê®·ÖÖØÒª£¬Èç¹û·þÎñÆ÷Ó²¼þ»òNginx¡¢MySQL·¢Éú¹ÊÕÏ£¬¶ø¶Ìʱ¼äÄÚÎÞ·¨»Ö¸´£¬ºó¹û½«·Ç³£ÑÏÖØ¡£ÎªÁ˱ÜÃâµ¥µã¹ÊÕÏ£¬ÎÒÉè¼ÆÁË´ËÌ×·½°¸£¬±àдÁËfailover.sh½Å±¾£¬ÊµÏÖÁËË«»ú»¥±¸¡¢È«×Ô¶¯Çл»£¬¹ÊÕÏתÒÆʱ¼äÖ»Ð輸ʮÃë¡£
¡¡¡¡Ò»¡¢Ë«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½ ......