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

MySQLѧϰ(6)SHOW,USER

1.SELECT USER();
»ñµÃµ±Ç°µÇ½Óû§µÄÓû§ÃûÓëÖ÷»úÐÅÏ¢£¬Ê¹ÓøÃÃüÁî»áÏÔʾÀàËÆÓÚÈçÏÂÐÅÏ¢£ºroot@zxj.lest.vicp.cc£¬@Ç°ÃæÊÇÓû§Ãû£¬ºóÃæÊÇÖ÷»úÃû¡£
2.SHOWÓ÷¨£¬
SHOW DATABASES--ÏÔʾ¶àÉÙ¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔ½Ð×ö±í¿Õ¼ä¡£
SHOW TABLES--ÏÔʾÓжàÉÙ¸ö±í¡£
SHOW VARIABLES--ÏÔʾÊý¾Ý¿â±äÁ¿¡£
SHOW MASTER STATUS.
SHOW CREATE TABLE£¬SHOW CREATE DATABASE£¬
SHOW PROCEDURE CODE proc_name.
³£ÓõĻ¹ÓУ¬
USE DATABASE,SHOW @@i,@@ÊÇÏÔʾϵͳ±äÁ¿¡£
CREATE EVENT E_SHOW ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SHOW DATABASES.
һСʱºóÖ´ÐÐSHOW DATABASES²Ù×÷¡£


Ïà¹ØÎĵµ£º

java¶ÔmysqlÊý¾Ý¿âµÄµ¼Èëµ¼³ö

//µ¼³ö
String mysql="mysqldump -uroot -proot  --opt databasename > d:/test.sql";    
java.lang.Runtime.getRuntime().exec("cmd /c "+mysql);   
//µ¼Èë
String mysql="mysqladmin -uroot -proot create databasename";    
java.lang.Runt ......

Mysql EngineÀàÐÍ

¿´MySQL²Î¿¼ÊÖ²á ·¢ÏÖCREATE TABLE ʱÓжàÖÖÊý¾Ý¿â´æ´¢ÒýÇ棺
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
ÍøÉϲéÁËϾÝ˵MyISAM¡¢InnoDBÁ½ÖÖÒýÇæ³£ÓÃ
´óÖÁÇø±ðÈçÏÂ[²»ÖªÊÇ·ñ׼ȷ]£º
¸ß¼¶´¦Àí:
MyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£
Ö´ÐÐËÙ¶È:
MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐ ......

MySQL°²×°ÓëÓ¦Óá¾LinuxϵݲװÓëÅäÖá¿

LinuxϵݲװÓëÅäÖÃ
Èç¹ûËù°²×°µÄLinuxϵͳûÓÐÄÚÖõÄMySQL£¬±ÊÕß½¨ÒéÔÚLinuxÖÐʹÓÃRPM°üÀ´°²×°MySQL£¬Í¬ÑùÕâÒ²ÊÇMySQL¹Ù·½ÌṩµÄ½¨Òé¡£±ÊÕß½Ó´¥×î¶àµÄLinuxϵͳÊÇRadhatµÄ“½üÇ×”£ºCentOS£¬ÓÉÓÚCentOS½Ïеİ汾¶¼ÄÚÖÃÁËMySQL£¬Òò´ËÔÚ°²×°ÏµÍ³Ê±¾Í½«MySQL°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²» ......

mysqlÃüÁî

²âÊÔ»·¾³£ºmysql 5.0.45
¡¾×¢£º¿ÉÒÔÔÚmysqlÖÐͨ¹ýmysql> SELECT VERSION();À´²é¿´Êý¾Ý¿â°æ±¾¡¿
ÕûÀí£ºleo
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓп ......

nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ


nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄܼà¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»Äܼà¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾ­Í£Ö¹£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ