《Mysql入門mysql日志滾動》要點：
本文介紹了Mysql入門mysql日志滾動，希望對您有用。如果有疑問，可以聯系我們。
MYSQL數據庫1,查看log環境
代碼如下:
mysql> show global variables like '%log%';
+---------------------------------+---------------------------------+
| Variable_name?????????????????? | Value?????????????????????????? |
+---------------------------------+---------------------------------+
| back_log??????????????????????? | 50????????????????????????????? |
| binlog_cache_size?????????????? | 32768?????????????????????????? |
| binlog_format?????????????????? | MIXED?????????????????????????? |
| expire_logs_days??????????????? | 0?????????????????????????????? |
| general_log???????????????????? | ON????????????????????????????? |
| general_log_file??????????????? | /usr/local/mysql/mysql.log????? |
| log???????????????????????????? | ON????????????????????????????? |
| log_bin???????????????????????? | ON????????????????????????????? |
| log_bin_trust_function_creators | OFF???????????????????????????? |
| log_bin_trust_routine_creators? | OFF???????????????????????????? |
| log_error?????????????????????? | /var/log/mysqld.log???????????? |
| log_output????????????????????? | FILE??????????????????????????? |
| log_queries_not_using_indexes?? | OFF???????????????????????????? |
| log_slave_updates?????????????? | OFF???????????????????????????? |
| log_slow_queries??????????????? | ON????????????????????????????? |
| log_warnings??????????????????? | 1?????????????????????????????? |
| max_binlog_cache_size?????????? | 4294963200????????????????????? |
| max_binlog_size???????????????? | 1073741824????????????????????? |
| max_relay_log_size????????????? | 0?????????????????????????????? |
| relay_log?????????????????????? |???????????????????????????????? |
| relay_log_index???????????????? |???????????????????????????????? |
| relay_log_info_file???????????? | relay-log.info????????????????? |
| relay_log_purge???????????????? | ON????????????????????????????? |
| relay_log_space_limit?????????? | 0?????????????????????????????? |
| slow_query_log????????????????? | ON????????????????????????????? |
| slow_query_log_file???????????? | /usr/local/mysql/mysql-slow.log |
| sql_log_bin???????????????????? | ON????????????????????????????? |
| sql_log_off???????????????????? | OFF???????????????????????????? |
| sql_log_update????????????????? | ON????????????????????????????? |
| sync_binlog???????????????????? | 0?????????????????????????????? |
+---------------------------------+---------------------------------+
30 rows in set (0.00 sec)
上面主要有三個日志文件,mysql.log,mysqd.log,mysql-slow.log,除了mysqld.log不克不及通過mysqladmin flush-logs來刷新日志外,其他的都可以,mysqld.log是服務器啟動程序mysqld產生的.
MYSQL數據庫2,生成日志刷新用戶
代碼如下:
mysql> GRANT RELOAD ON *.* TO 'log'@'localhost' IDENTIFIED BY 'log';
Query OK, 0 rows affected (0.07 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
用root賬戶登錄進去,添加一個log的用戶.分開清楚一點.
MYSQL數據庫3,日志滾動腳本,只保存一個星期的日志
代碼如下:
[root@linux ~]# vim log.sh?? //添加以下內容
#!/bin/sh
# log refresh
if [ -f $1 ];
then
??? echo "refresh ok" 1>&2
else
??? echo "log file do not exist;"
??? exit 1
fi
LOG=$1
DB_USER="log"
DB_PASS="log"??????????????????????????????????????????????????????????????????????????????????????????????????????
# Others vars
DATE=`date +%w`???????????????????????????????????????
BIN_DIR="/usr/local/mysql/bin"
mv ${LOG} ${LOG}_${DATE}
${BIN_DIR}/mysqladmin? -ulog -plog flush-logs
添加可執行權限chmod +x log.sh
MYSQL數據庫腳本很簡單,不過有一點要解釋一下,便是mv ${LOG} ${LOG}_${DATE},第一周會產生7個文件,第二周會覆蓋上周的,星期一覆蓋星期一,星期二覆蓋星期二,以此內推.
MYSQL數據庫4,日記滾動
代碼以下:
[root@linux ~]# ./log.sh /usr/local/mysql/mysql.log
refresh ok
[root@linux ~]# ls /usr/local/mysql/ |grep mysql
mysql.log
mysql.log_1
歡迎參與《Mysql入門mysql日志滾動》討論，分享您的想法，維易PHP學院為您提供專業教程。
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/8084.html
