利用logrotate对MySQL日志进行轮转

2

3

4

5

6

7

8

9

10

SHELL=/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin

MAILTO=root

HOME=/

# run-parts

01 * * * * root run-parts /etc/cron.hourly

02 4 * * * root run-parts /etc/cron.daily

22 4 * * 0 root run-parts /etc/cron.weekly

42 4 1 * * root run-parts /etc/cron.monthly

2

3

4

5

6

7

8

#!/bin/sh

/usr/sbin/logrotate /etc/logrotate.conf

EXITVALUE=$?

if [ $EXITVALUE != 0 ]; then

/usr/bin/logger -t logrotate "ALERT exited abnormally with [$EXITVALUE]"

fi

exit 0

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

EXITVALUE=$?

if [ $EXITVALUE != 0 ]; then

/usr/bin/logger -t logrotate "ALERT exited abnormally with [$EXITVALUE]"

fi

exit 0

[root@lx202 /etc/cron.daily ]# cat /etc/logrotate.conf

# see "man logrotate" for details

# rotate log files weekly

weekly

# keep 4 weeks worth of backlogs

rotate 4

# create new (empty) log files after rotating old ones

create

# uncomment this if you want your log files compressed

#compress

# RPM packages drop log rotation information into this directory

include /etc/logrotate.d

# no packages own wtmp -- we'll rotate them here

/var/log/wtmp {

monthly

minsize 1M

create 0664 root utmp

rotate 1

}

/var/log/btmp {

missingok

monthly

minsize 1M

create 0600 root utmp

rotate 1

}

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

# This logname can be set in /etc/my.cnf

# by setting the variable "err-log"

# in the [safe_mysqld] section as follows:

#

# [safe_mysqld]

# err-log=/opt/mysql/data/mysqld.log

#

# If the root user has a password you have to create a

# /root/.my.cnf configuration file with the following

# content:

#

# [mysqladmin]

# password = <secret>

# user= root

#

# where "<secret>" is the password.

#

# ATTENTION: This /root/.my.cnf should be readable ONLY

# for root !

/opt/mysql/data/mysqld.log {

# create 600 mysql mysql

notifempty

daily

rotate 3

missingok

compress

postrotate

# just if mysqld is really running

if test -x /opt/mysql/bin/mysqladmin &&

/opt/mysql/bin/mysqladmin ping &>/dev/null

then

/opt/mysql/bin/mysqladmin flush-logs

fi

endscript

}

2

3

[mysqladmin]

password = ***

user= root

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

/data/mysql/log/slow.log

/data/mysql/log/alert.log {

create 600 mysql mysql

notifempty

daily

rotate 7

missingok

# compress

postrotate

# just if mysqld is really running

if test -x /opt/mysql/bin/mysqladmin &&

/opt/mysql/bin/mysqladmin ping &>/dev/null

then

/opt/mysql/bin/mysqladmin flush-logs

fi

endscript

}