Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......

CentOS LAMP»·¾³´î½¨ºÍ²âÊÔphpÓëmysqlµÄÁ¬½Ó


    * ÕªÒª£ºCentOS LAMP×÷Ϊ·þÎñÆ÷£¬²»°²×°²»ÐèÒªµÄ×é¼þ£¬ËùÒÔÔÚÑ¡Ôñ×é¼þµÄʱºò£¬²»ÒªÑ¡web·þÎñÆ÷£¬ÒòΪÎÒÃǺóÃæÒªÊÖ¶¯±àÒë°²×°¡£CentOS LAMPϵͳԼ¶¨RPM°üºÍÔ´Âë°ü´æ·ÅλÖÃ
    * ±êÇ©£ºCentOS LAMP
    *
      Oracle°ïÄú׼ȷ¶´²ì¸÷¸öÎïÁ÷ ......

ÈÃpowerdesignerÉú³ÉµÄsqlÔÚmysqlÏÂÕýÈ·ÔËÐÐ

Èç¹û°´ÕÕpowerdesignerµÄĬÈÏÑ¡Ïî,Éú³ÉµÄsql²»ÄÜÔÚmysqlÖÐÕýÈ·ÔËÐÐ.]
¾­¹ý±¾ÈËÑо¿·¢ÏÖÒª×öÈçÏÂÐÞ¸Ä:
  1.aftercreateÑ¡Ïî¸ÄΪ
.foreach_item(OutReferences)
   .ifnot (%hasFKIndex%)
/*==============================================================*/
/* Index: ......

MySQL ´¥·¢Æ÷ ´æ´¢¹ý³Ì Ò»µãСÓÃ

      Í¬ÊÂÀëÖ°£¬ÓÖÒ»¸öÒ»¸öÀÃ̯×ÓÒªÊÕʰ¡£ÕâÀïÐÞÐÞ£¬ÄÇÀï²¹²¹¶¼Ã»Óо«Á¦À´Ð´µã¶«Î÷¡£
      Ã÷Ìì»Ø¼Ò£¬ÉÏÎçÕûÀíºÃÎĵµ¡£ÏÂÎç¾ö¶¨³éµãʱ¼ä£¬°Ñ×î½üµÄ¶«Î÷¾¡Á¿ÀíÒ»Àí¡£ºÜ¶àÁé¸Ð¶¼ÒѾ­ÒÅÍü¡£ÎÒÃÇ×ÜÔÚ²»¶ÏÃæ¶Ô£¬ËùÒÔÎÒÃDz»¶ÏÒÅÍü¡£¡¾syslog¡¢mysqlÓÅ»¯¡¢´¥·¢Æ÷¡¢´æ´¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ