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

MySQLÊý¾Ý¿âÈÕÖ¾

MySQLÊý¾Ý¿âÈÕÖ¾
selectÈÕÖ¾
slow selectÈÕÖ¾
±ä¸üÈÕÖ¾
¶þ½øÖƱä¸üÈÕÖ¾(binlog)
¸æ¾¯ÈÕÖ¾
´íÎóÈÕÖ¾¡£
¿ÉÒÔÔÚmy.cnfÖÐÅäÖÃ
²ÎÊý
˵Ã÷
log
Îı¾selectÈÕÖ¾£¬¼ÇÏÂËùÓеÄMySQLµÄÃüÁî²Ù×÷£¬
log-update
Îı¾±ä¸üÈÕÖ¾
log-bin
Õâ¸ö¶¼ÖªµÀÁË£¬Êý¾Ý¿â¸´ÖƵÄʱºò±Ø±¸
binlog_cache_size
ÁÙʱ´æ·Åij´ÎÊÂÎñµÄSQLÓï¾ä»º³å³¤¶È
max_binlog_cache_szie
×î´ó¶þ½øÖÆCacheÈÕÖ¾»º³åÇø³ß´ç
max_binlog_size
×î´óµÄ¶þ½øÖÆÈÕÖ¾³ß´ç
log-error
ÑÏÖØ´íÎóÈÕÖ¾
log-warnings
¾¯¸æ¼¶±ðµÄÈÕÖ¾£¬µÍÓÚerror
long_query_time
³¬¹ý¶àÉÙÃë¾ÍÊÇÂý²éѯÓï¾ä
log-queries-not-using-indexes
ûÓÐʹÓÃË÷Òý²éѯµÄÈÕÖ¾,
log-slow-queri
Âý²éѯ£¬Õâ¸öÒ»¶à¾ÍÒªÓÅ»¯ÁË


Ïà¹ØÎĵµ£º

LinuxÏÂMysql ÃüÁîÐÐÏÔʾÂÒÂëÎÊÌâ½â¾ö

ÔÚʹÓÃWindowsÃüÁîÐвÙ×÷MySQLÊý¾Ý¿âµÄʱºò£¬ÒÔutf8¸ñʽ´æ´¢ÔÚMySQLÊý¾Ý¿âÖеÄÊý¾Ý£¬´ÓÃüÁîÐжÁÈ¡³öÀ´×ÜÊÇÂÒÂ룬ÏÔʾȫÊÇÎʺš£»òÕß´ÓÃüÁîÐвåÈëÐÂÊý¾Ý£¬½á¹ûÏà·´£¬ÔÚÃüÁîÐÐÖÐÏÔʾÊÇÕý³£µÄ£¬µ«ÊÇÔÚPHPMyAdminÖÐÈ´ÊÇÂÒÂë¡£
¡¡¡¡¾­¹ýÉÏÍø²éÕÒÑо¿£¬·¢ÏÖmysqlµÄÃüÁîÐпͻ§¶Ë¸ù±¾ÎÞ·¨ÒÔutf-8µÄÐÎʽ·µ»ØÊý¾Ý£¬½â¾öÈçÏ¡£
¡¡¡¡² ......

[ת]mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεȠ      
     
     
//Ö÷¼ü549830479      
     
   alter table tabelname add new_fiel ......

mysqlÃÜÂëÐ޸ķ½·¨

MySQLÃÜÂëÐ޸ķ½·¨
   Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£
      ·½·¨Ò»
¡¡¡¡Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬
¡¡¡¡²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
¡¡¡¡·½·¨¶þ
¡¡ ......

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ