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
Âý²éѯ£¬Õâ¸öÒ»¶à¾ÍÒªÓÅ»¯ÁË
Ïà¹ØÎĵµ£º
ÉùÃ÷£º²¿ÊðDedeCMS£¬ÔÚÍøÉÏËÑÁ˺ܶà×ÊÁÏ£¬°üÀ¨Õâ¸öÂÛ̳£¬¼¸ºõûÓз¢ÏÖÔÚlinuxϲ¿ÊðµÄÏÖ³É×ÊÁÏ¿ÉÒԲο¼¡£
Ë죬×Ô¼º°ÑÕû¸ö²¿Êð¹ý³ÌÖÐÒ»Ð©ÖØÒªµÄµã¼Ç¼ÏÂÀ´£¬Ò»ÊÇËã×ö×Ô¼ºµÄÀͶ¯³É¹û£¬Í¬Ê±£¬ÆÚÍû¶ÔÔø¾ºÍÎÒÒ»ÑùÃÔ㣬²»ÖªÈçºÎ²¿Êð   ......
¹ØÓÚMySqlµÄµ¼Èëµ¼³öÎÊÌâ
ÔÚÖÕ¶ËÖУ¬½øÈëmysqlµÄ·¾¶ÏµÄbinÖУ¬ÔÚÕâ¸ö·¾¶Ï¿ÉÒÔÖ´ÐÐmysql£¬mysqldumpµÈÃüÁî¡£
»òÕßÌí¼Ó»·¾³±äÁ¿ ÉèÖû·¾³±äÁ¿path "...(mysqlµÄ°²×°Â·¾¶ÏµÄbinĿ¼)"£¬ÕâÑù¾Í²»±ØÃ¿´Î¶¼½øÈëÉÏÃæËù˵µÄ·¾¶Ï²Ù×÷¡£
µ¼³öÒ»¸ö¿â£º
mysqldump ......
1.¶Ô²éѯ½øÐÐÓÅ»¯£¬Ó¦¾¡Á¿±ÜÃâÈ«±íɨÃ裬Ê×ÏÈÓ¦¿¼ÂÇÔÚ where ¼° order by Éæ¼°µÄÁÐÉϽ¨Á¢Ë÷Òý¡£
2.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ
·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺
select id from t where num is null
¿ÉÒÔÔÚnumÉÏÉèÖÃ
ĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâ
Ñù²éѯ£º
sel ......
mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
MYSQLµÄÓÅ»¯ÊǷdz£ÖØÒªµÄ¡£ÆäËû×î³£ÓÃÒ²×îÐèÒªÓÅ»¯µÄ¾ÍÊÇlimit¡£mysqlµÄlimit¸ø·ÖÒ³´øÀ´Á˼«´óµÄ·½±ã£¬µ«Êý¾ÝÁ¿Ò»´óµÄʱºò£¬limitµÄÐÔÄܾͼ±¾çϽµ¡£
ͬÑùÊÇÈ¡10ÌõÊý¾Ý
select * from yanxue8_visit limit 10000,10 ºÍ
select * from yanxue8_visit limit 0,10
¾Í²»ÊÇÒ»¸öÊýÁ¿¼¶±ðµ ......