1MK-PURGE-LOGS(1) User Contributed Perl Documentation MK-PURGE-LOGS(1)
2
6 mk-purge-logs - Purge binary logs on a master based on purge rules.
7
9 Usage: mk-purge-logs [OPTION...] DSN
10 mk-purge-logs purges binary logs on a MySQL server, based on purge
12 rules.
13 Print and purge all unused binary logs on master:
15 mk-purge-logs --print --purge h=master
17 Silently purge oldest binary logs on master until their total size is
19 less than 1M:
20 mk-purge-logs --purge-rules total_size --total-size 1M h=master
22 Purge oldest, unused binary logs on master until their total size is
24 less than 500k, print information about work done:
25 mk-purge-logs --purge-rules unused,total_size --total-size 500k \
27 --verbose h=master
28
30 The following section is included to inform users about the potential
31 risks, whether known or unknown, of using this tool. The two main
32 categories of risks are those created by the nature of the tool (e.g.
33 read-only tools vs. read-write tools) and those created by bugs.
34 mk-purge-logs purges (deletes) binary logs on a master based on
36 "--purge-rules" when "--purge" is specified. Specifying the wrong
37 "--purge-rules" could delete binary logs that are still needed.
38 At the time of this release, we know of no bugs that could cause
40 serious harm to users.
41 The authoritative source for updated information is always the online
43 issue tracking system. Issues that affect this tool will be marked as
44 such. You can see a list of such issues at the following URL:
45 <http://www.maatkit.org/bugs/mk-purge-logs>.
46 See also "BUGS" for more information on filing bugs and getting help.
48
50 mk-purge-logs purges binary logs on a master based on "--purge-rules"
51 by executing "PURGE BINARY LOGS TO".
52
54 Specify at least one of "--purge" or "--print".
55 This tool accepts additional command-line arguments. Refer to the
57 "SYNOPSIS" and usage information for details.
58 --ask-pass
60 group: Connection
61 Prompt for a password when connecting to MySQL.
63 --config
65 type: Array
66 Read this comma-separated list of config files; if specified, this
68 must be the first option on the command line.
69 --defaults-file
71 short form: -F; type: string; group: Connection
72 Only read mysql options from the given file. You must give an
74 absolute pathname.
75 --dry-run
77 Print but do not execute the "--purge" statement (disables
78 "--purge").
79 Specifying this option allows you to test what mk-purge-logs would
81 do if "--purge" were specified without "--dry-run". The SQL
82 statement for "--purge" is printed to STDOUT, like:
83 This is a dry-run. The following SQL statement would be executed
85 by specifying --purge without --dry-run:
86 PURGE BINARY LOGS TO ? mysql-bin.000003
87 The first line lets you know that "--dry-run" is in effect and the
89 line after it is the SQL statement that would be executed on the
90 server with the "?" replaced by the binary log file name that
91 follows it.
92 See also "--print".
94 --help
96 Show help and exit.
97 --password
99 short form: -p; type: string; group: Connection
100 Password to use when connecting.
102 --port
104 short form: -P; type: int; group: Connection
105 Port number to use for connection.
107 --print
109 Print which binary logs "--purge" will purge.
110 This option prints each binary log file name and its size to STDOUT
112 that would be purged if all the "--purge-rules" pass and "--purge"
113 is specified. Purging uses the MySQL "PURGE BINARY LOGS TO"
114 command which only specifies the binary log file name to purge to,
115 not the binary logs before it. This option will print the binary
116 logs before the purge to binary log.
117 See also "--dry-run".
119 --purge
121 Purge (delete) binary logs that match all "--purge-rules". The
122 server's master binary logs are purged using "PURGE BINARY LOGS"
123 when this option is specified and all "--purge-rules" pass. Else,
124 no binary logs are purged.
125 Specify "--print" to see which binary logs are purged and their
127 sizes, else all binary logs are purged silently unless there is an
128 error.
129 See also "--dry-run".
131 --purge-rules
133 type: Hash; default: unused
134 Match binary logs that pass all of the specified rules. The rules
136 are mutually inclusive, so only binary logs that pass all rules are
137 purged.
138 Some rules, like "total_size", require an extra option to specify
140 their value.
141 · total_size
143 Purge oldest binary logs until the total size of all binary
145 logs is less than "--total-size". "SHOW BINARY LOGS" lists the
146 size of each binary log. If the total of these sizes is
147 greater than "--total-size", then the oldest binary logs are
148 purged until the total size is less than or equal to
149 "--total-size".
150 · unused
152 Purge binary logs that are no longer being read by any slaves.
154 When this rule is specified, mk-purge-logs will recurse to the
155 server's first-level slaves (i.e. only direct slaves of the
156 server) and "SHOW SLAVE STATUS" to find which master binary
157 logs they are reading. Master binary logs not being read by
158 any slaves are unused and will be purged.
159 --recursion-method
161 type: string
162 Preferred recursion method for discovering slaves.
164 Possible methods are:
166 METHOD USES
168 =========== ================
169 processlist SHOW PROCESSLIST
170 hosts SHOW SLAVE HOSTS
171 The processlist method is preferred because SHOW SLAVE HOSTS is not
173 reliable. However, the hosts method is required if the server uses
174 a non-standard port (not 3306). Usually mk-purge-logs does the
175 right thing and finds the slaves, but you may give a preferred
176 method and it will be used first. If it doesn't find any slaves,
177 the other methods will be tried.
178 --set-vars
180 type: string; default: wait_timeout=10000; group: Connection
181 Set these MySQL variables. Immediately after connecting to MySQL,
183 this string will be appended to SET and executed.
184 --socket
186 short form: -S; type: string; group: Connection
187 Socket file to use for connection.
189 --total-size
191 type: size
192 Purge oldest binary logs until their total size is less than this
194 amount.
195 This option specifies the value for the "--purge-rules"
197 "total_size" value.
198 --user
200 short form: -u; type: string; group: Connection
201 User for login if not current user.
203 --verbose
205 short form: -v; default: 0
206 Print information about binary logs found and purged. By default
208 mk-purge-logs operates silently, except for errors which are
209 printed to STDERR. Specifying this option prints extra information
210 to STDOUT about what the tool is doing.
211 --version
213 Show version and exit.
214
216 These DSN options are used to create a DSN. Each option is given like
217 "option=value". The options are case-sensitive, so P and p are not the
218 same option. There cannot be whitespace before or after the "=" and if
219 the value contains whitespace it must be quoted. DSN options are
220 comma-separated. See the maatkit manpage for full details.
221 · A
223 dsn: charset; copy: yes
225 Default character set.
227 · D
229 dsn: database; copy: yes
231 Default database.
233 · F
235 dsn: mysql_read_default_file; copy: yes
237 Only read default options from the given file
239 · h
241 dsn: host; copy: yes
243 Connect to host.
245 · p
247 dsn: password; copy: yes
249 Password to use when connecting.
251 · P
253 dsn: port; copy: yes
255 Port number to use for connection.
257 · S
259 dsn: mysql_socket; copy: yes
261 Socket file to use for connection.
263 · u
265 dsn: user; copy: yes
267 User for login if not current user.
269
271 You can download Maatkit from Google Code at
272 <http://code.google.com/p/maatkit/>, or you can get any of the tools
273 easily with a command like the following:
274 wget http://www.maatkit.org/get/toolname
276 or
277 wget http://www.maatkit.org/trunk/toolname
278 Where "toolname" can be replaced with the name (or fragment of a name)
280 of any of the Maatkit tools. Once downloaded, they're ready to run; no
281 installation is needed. The first URL gets the latest released version
282 of the tool, and the second gets the latest trunk code from Subversion.
283
285 The environment variable "MKDEBUG" enables verbose debugging output in
286 all of the Maatkit tools:
287 MKDEBUG=1 mk-....
289
291 You need Perl, DBI, DBD::mysql, and some core packages that ought to be
292 installed in any reasonably new version of Perl.
293
295 For a list of known bugs see
296 <http://www.maatkit.org/bugs/mk-purge-logs>.
297 Please use Google Code Issues and Groups to report bugs or request
299 support: <http://code.google.com/p/maatkit/>. You can also join
300 #maatkit on Freenode to discuss Maatkit.
301 Please include the complete command-line used to reproduce the problem
303 you are seeing, the version of all MySQL servers involved, the complete
304 output of the tool when run with "--version", and if possible,
305 debugging output produced by running with the "MKDEBUG=1" environment
306 variable.
307
309 This program is copyright 2010-2011 Percona Inc. Feedback and
310 improvements are welcome.
311 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
313 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
314 MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
315 This program is free software; you can redistribute it and/or modify it
317 under the terms of the GNU General Public License as published by the
318 Free Software Foundation, version 2; OR the Perl Artistic License. On
319 UNIX and similar systems, you can issue `man perlgpl' or `man
320 perlartistic' to read these licenses.
321 You should have received a copy of the GNU General Public License along
323 with this program; if not, write to the Free Software Foundation, Inc.,
324 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
325
327 Daniel Nichter, Baron Schwartz
328
330 This tool is part of Maatkit, a toolkit for power users of MySQL.
331 Maatkit was created by Baron Schwartz; Baron and Daniel Nichter are the
332 primary code contributors. Both are employed by Percona. Financial
333 support for Maatkit development is primarily provided by Percona and
334 its clients.
335
337 This manual page documents Ver 0.9.0 Distrib 7540 $Revision: 7531 $.
338perl v5.28.0 2011-06-08 MK-PURGE-LOGS(1)