¹ØÓÚMySQL¶þ½øÖÆÈÕÖ¾BinlogµÄÈÏʶ
MySQLµÄ¶þ½øÖÆÈÕÖ¾¿ÉÒÔ˵»òÊÇMySQL×îÖØÒªµÄÈÕÖ¾ÁË,Ëü¼Ç¼ÁËËùÓеÄDDLºÍDML(³ýÁËÊý¾Ý²éѯÓï¾ä)Óï¾ä,ÒÔʼþÐÎʽ¼Ç¼,»¹°üº¬Óï¾äËùÖ´ÐеÄÏûºÄµÄʱ¼ä,MySQLµÄ¶þ½øÖÆÈÕÖ¾ÊÇʧÎó°²È«Ð͵Ä.
ÔÚ5.1µÄ°æ±¾Äã¶þ½øÖÆÈÕÖ¾»¹Ìæ´úÁËÔ±¾µÄ¸üÐÂÈÕÖ¾.Ò»°ãÀ´Ëµ¿ªÆô¶þ½øÖÆÈÕÖ¾´ó¸Å»áÓÐ1%µÄÐÔÄÜËðºÄ(²Î¼ûMySQL¹Ù·½ÖÐÎÄÊÖ²á5.1.24°æ).¶þ½øÖÆÓÐÁ½¸ö×îÖØÒªµÄʹÓó¡¾°:
ÆäÒ»ÊÇ:MySQL ReplicationÔÚMaster¶Ë¿ªÆôbinlog,Mster°ÑËüµÄ¶þ½øÖÆÈÕÖ¾´«µÝ¸øslavesÀ´´ïµ½master-slaveÊý¾ÝÒ»Ö±µÄÄ¿µÄ.
Æä¶þ:×ÔÈ»¾ÍÊÇÊý¾Ý»Ö¸´ÁË,ͨ¹ýʹÓÃmysqlbinlog¹¤¾ßÀ´»Ö¸´Êý¾Ý.
binlog²»Ö§³Öselect,showÒ»ÀàÓï¾ä,Èç¹ûÒª¼Ç¼ÕâЩÓï¾ä¿ÉÒÔͨ¹ý´ò¿ªMySQLµÄgeneral logÀ´´óµ½Ä¿µÄ.
¿ÉÒÔÀûÓÃmysqlbinlog¹¤¾ßÀ´²é¿´¶þ½øÖÆÈÕÖ¾,´ò¿ªÒ»¸öÕýÔÚʹÓõÄbinlog
$mysqlbinlog var/mysql-bin.000022
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#091222 18:09:33 server id 2 end_log_pos 106 Start: binlog v 4, server v 5.1.41-debug-log created 091222 18:09:33 at startup
# Warning: this binlog was not closed properly. Most probably mysqld crashed writing it.
ROLLBACK/*!*/;
# at 106
#091222 23:20:35 server id 2 end_log_pos 174 Query thread_id=4 exec_time=1 error_code=0
SET TIMESTAMP=1261495235/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
SET @@session.sql_mode=0/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
BEGIN
/*!*/;
# at 174
#091222 23:20:35 server id 2 end_log_pos 269 Query thread_id=4 exec_time=0 error_code=0
use test/*!*/;
SET TIMESTAMP=1261495235/*!*/;
insert bench values(20,'xiaojj')
/*!*/;
# at 269
#091222 23:20:35 server id 2 end_log_pos 296 Xid = 22
COMMIT/*!*/;
DELIMITER ;
# End of log file
Ïà¹ØÎĵµ£º
nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄÜ¼à¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»ÄÜ¼à¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾֹͣ£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......
TO_DAYS(date) //¸ø¶¨Ò»¸öÈÕÆÚ£¬·µ»Ø´Ó0Ä꿪ʼµÄÌìÊý¡£
from_DAYS(N) //¸ø¶¨Ò»¸öÌìÊý£¬·µ»ØÒ»¸öÈÕÆÚ¡£
È磺
select TO_DAYS('1997-10-7') //·µ»Ø729669
select from_DAYS(729669) //·µ»Ø1997-10-7
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date)
ÈôÎÞ²ÎÊýµ÷Óã¬Ôò·µ ......
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for conn ......
MysqlÖÐlimitµÄÓ÷¨£ºÔÚÎÒÃÇʹÓòéѯÓï¾äµÄʱºò£¬¾³£Òª·µ»ØÇ°¼¸Ìõ»òÕßÖмäij¼¸ÐÐÊý¾Ý£¬Õâ¸öʱºòÔõô°ìÄØ£¿²»Óõ£ÐÄ£¬mysqlÒѾΪÎÒÃÇÌṩÁËÕâÑùÒ»¸ö¹¦ÄÜ¡£
SELECT * from table LIMIT [offset,] rows | rows OFFSET offset
LIMIT ×Ó¾ä¿ÉÒÔ±»ÓÃÓÚÇ¿ÖÆ SELECT Óï¾ä·µ»ØÖ¸¶¨µÄ¼Ç¼Êý¡£LIMIT ½ÓÊÜÒ»¸ö»òÁ½¸öÊý ......