Õýȷɾ³ýMYSQlÈÕÖ¾·½·¨
1.²éÕÒµ±
mysql> show binary logs;
+—————-+———–+
| Log_name | File_size |
+—————-+———–+
| mysql-bin.000001 | 150462942 |
| mysql-bin.000002 | 125 |
| mysql-bin.000003 | 106 |
+—————-+———–+
2.ɾ³ýbin-log(ɾ³ýmysql-bin.000003֮ǰµÄ¶øûÓаüº¬mysql-bin.000003)
mysql> purge binary logs to ‘mysql-bin.000003′;
Query OK, 0 rows affected (0.16 sec)
3. ²éѯ½á¹û(ÏÖÔÚÖ»ÓÐÒ»Ìõ¼Ç¼ÁË.)
mysql> show binlog events\G
*************************** 1. row ***************************
Log_name: mysql-bin.000003
Pos: 4
Event_type: Format_desc
Server_id: 1
End_log_pos: 106
Info: Server ver: 5.1.26-rc-log, Binlog ver: 4
1 row in set (0.01 sec)
(mysql-bin.000001ºÍmysql-bin.000002Òѱ»É¾³ý)
mysql> show binary logs;
+—————-+———–+
| Log_name | File_size |
+—————-+———–+
| mysql-bin.000003 | 106 |
+—————-+———–+
1 row in set (0.00 sec)
(ɾ³ýµÄÆäËü¸ñʽÔËÓÃ!)
¡¡ PURGE {MASTER | BINARY} LOGS TO ‘log_name’
¡¡¡¡PURGE {MASTER | BINARY} LOGS BEFORE ‘date’
¡¡¡¡ÓÃÓÚɾ³ýÁÐÓÚÔÚÖ¸¶¨µÄÈÕÖ¾»òÈÕÆÚ֮ǰµÄÈÕÖ¾Ë÷ÒýÖеÄËùÓжþ½øÖÆÈÕÖ¾¡£ÕâЩÈÕÖ¾Ò²»á´Ó¼Ç¼ÔÚÈÕÖ¾Ë÷ÒýÎļþÖеÄÇåµ¥Öб»É¾³ý£¬ÕâÑù±»¸ø¶¨µÄÈÕÖ¾³ÉΪµÚÒ»¸ö¡£
¡¡¡¡ÀýÈ磺
¡¡¡¡PURGE MASTER LOGS TO ‘mysql-bin.010′;
¡¡¡¡PURGE MASTER LOGS BEFORE ‘2008-06-22 13:00:00′;
Çå³ý3ÌìÇ°µÄ binlog
PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);
¡¡¡¡BEFORE±äÁ¿µÄdate×Ô±äÁ¿¿ÉÒÔΪ’YYYY-MM-DD hh:mm:ss’¸ñʽ¡£MASTERºÍBINARYÊÇͬÒå´Ê¡£
¡¡¡¡Èç¹ûÄúÓÐÒ»¸ö»îÐԵĴÓÊô·þÎñÆ÷£¬¸Ã·þÎñÆ÷µ±Ç°ÕýÔÚ¶ÁÈ¡ÄúÕýÔÚÊÔͼɾ³ýµÄÈÕÖ¾Ö®Ò»£¬Ôò±¾Óï¾ä²»»áÆð×÷Ó㬶øÊÇ»áʧ°Ü£¬²¢°éËæÒ»¸ö´íÎó¡£²»¹ý£¬Èç¹û´ÓÊô·þÎñÆ÷ÊÇÐÝÖ¹µÄ£¬²¢ÇÒÄúÅöÇÉÇåÀíÁËÆäÏëÒª¶ÁÈ¡µÄÈÕÖ¾Ö®Ò»£¬Ôò´ÓÊô·þÎñÆ÷Æô
Ïà¹ØÎĵµ£º
MySQLÃÜÂëÐ޸ķ½·¨
Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£
·½·¨Ò»
¡¡¡¡Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬
¡¡¡¡²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
¡¡¡¡·½·¨¶þ
¡¡ ......
×î½üдÁËÒ»¸ö¼òµ¥µÄMysql²Ù×÷À࣬ÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬»¹Çë¸÷λ¸ßÊÖÖ¸ÕýÒ»ÏÂÎö¹¹º¯ÊýµÄÓ÷¨£º
<?php
/*
* Created on 2010-5-25
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*
* class mysql
* made by S71ENCE
*/
class mysql ......
JAVAµ÷ÓÃMYSQL´æ´¢¹ý³Ì
¹¤³ÌÊÓͼ£º
´úÂëÇåµ¥£º
myconn.java
package org.apache.sh_mysql.test;
import java.sql.*;
public class MyConn {
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost/test?useUnicode=true&characterEn ......
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆ京Òå¼°×÷Óã ......