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

mysqlÎóɾ

¸Õ¸ÕʹÓÃmysql£¬ÎóɾÁËtestÊý¾Ý¿â£¬»¹Ã»À´µÃ¼°±¸·Ý£»
ÔõÑù¿ÉÒÔ»Ö¸´£¿
ÓÃÊý¾Ý»Ö¸´ÎļþÊÔÊÔ

Èç¹ûÓжþ½øÖÆÈÕÖÆµÄ»°¿ÉÒԲο¼Õâ¸öÌù×ӵIJÙ×÷»Ö¸´ÄãµÄÊý¾Ý¡£

http://topic.csdn.net/u/20090608/20/e50feb34-0a07-4675-80d4-2eac35973286.html?58720
ʹÓÃmysqlbinlog»Ö¸´Êý¾Ý

²Î¿¼Ò»Ï¶þ樓°É£¬ÓÑÇé幫頂ÁË¡£

°ï¶¥

mysqlbinlog

SQL code:

[b]ÀûÓÃmysqlbinlog¹¤¾ß»Ö¸´MySQLÊý¾Ý¿â[/b]

Èç¹ûMySQL·þÎñÆ÷ÆôÓÃÁ˶þ½øÖÆÈÕÖ¾£¬Äã¿ÉÒÔʹÓÃmysqlbinlog¹¤¾ßÀ´»Ö¸´´ÓÖ¸¶¨µÄʱ¼äµã¿ªÊ¼ (ÀýÈ磬´ÓÄã×îºóÒ»´Î±¸·Ý)Ö±µ½ÏÖÔÚ»òÁíÒ»¸öÖ¸¶¨µÄʱ¼äµãµÄÊý¾Ý¡£¹ØÓÚÆôÓöþ½øÖÆÈÕÖ¾µÄÐÅÏ¢£¬²Î¼û5.11.3½Ú£¬¡°¶þ½øÖÆÈÕÖ¾¡±¡£¶ÔÓÚ mysqlbinlogµÄÏêϸÐÅÏ¢£¬²Î¼ûmysqlÊÖ²á8.6½Ú£¬¡°mysqlbinlog£ºÓÃÓÚ´¦Àí¶þ½øÖÆÈÕÖ¾ÎļþµÄʵÓù¤¾ß¡±¡£ ÒªÏë´Ó¶þ½øÖÆÈÕÖ¾»Ö¸´Êý¾Ý£¬ÄãÐèÒªÖªµÀµ±Ç°¶þ½øÖÆÈÕÖ¾ÎļþµÄ·¾¶ºÍÎļþÃû¡£Ò»°ã¿ÉÒÔ´ÓÑ¡ÏîÎļþ(¼´my.cnf or my.ini£¬È¡¾öÓÚÄãµÄϵͳ)ÖÐÕÒµ½Â·¾¶¡£Èç¹ûδ°üº¬ÔÚÑ¡ÏîÎļþÖУ¬µ±·þÎñÆ÷Æô¶¯Ê±£¬¿ÉÒÔÔÚÃüÁîÐÐÖÐÒÔÑ¡ÏîµÄÐÎʽ¸ø³ö¡£ÆôÓöþ½øÖÆÈÕÖ¾µÄÑ¡ÏîΪ-- log-bin¡£ÒªÏëÈ·¶¨µ±Ç°µÄ¶þ½øÖÆÈÕÖ¾ÎļþµÄÎļþÃû£¬
ÊäÈëÏÂÃæµÄMySQLÓï¾ä£º
SHOW BINLOG EVENTS G
Ä㻹¿ÉÒÔ´ÓÃüÁîÐÐÊäÈëÏÂÃæµÄÄÚÈÝ£º
mysql --user=root -pmy_pwd -e 'SHOW BINLOG EVENTS G'
½«ÃÜÂëmy_pwdÌæ»»Îª·þÎñÆ÷µÄrootÃÜÂë¡£
1. Ö¸¶¨»Ö¸´Ê±¼ä
¶ÔÓÚMySQL 4.1.4£¬¿ÉÒÔÔÚmysqlbinlogÓï¾äÖÐͨ¹ý--start-dateºÍ--stop-dateÑ¡ÏîÖ¸¶¨DATETIME¸ñʽµÄÆðֹʱ¼ä¡£¾ÙÀý˵Ã÷£¬¼ÙÉèÔÚ½ñÌìÉÏÎç10:00(½ñÌìÊ


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

mysqlÉèÖÃÎÊÌâ

żµÄÍøÕ¾Õâô˵```
The page cannot be displayed
There are too many people accessing the Web site at this time.

¿Éʵ¼ÊÉÏ×î¶àÖ»ÓÐ3~4¸öÈËÔÚͬʱµÇ¼°¢
ÇëÎÊÈçºÎ½â¾ö°¢?ÒòΪż°²×°mysqlµÄʱºòËÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ