5.2.4 The rotate log Command

Press CTRL+C to copy
 
rotate log [{--hosts=|-h }host_list] [site_name]

host_list:
    host[,host[,...]]

Rotate mcmd logs for the connected MySQL Cluster Manager agent, for agents running on certain hosts, or for agents on all hosts in a management site.

For example, to rotate logs for the agent to which the client session is connected:

Press CTRL+C to copy
 
mcm> rotate log;
+--------------------------+
| Command result           |
+--------------------------+
| Log rotated successfully |
+--------------------------+
1 row in set (0.03 sec)

A new log file, with an underscore and then a timestamp inserted into its file name before the file extension, is created as a result:

Press CTRL+C to copy
 
-rw-r-----   1 mcmd cluster    74265 Jul 15 22:45 mcmd.log
-rw-r-----   1 mcmd cluster  1197573 Jul 15 22:45 mcmd_2021-07-15T22-45-28.log

To rotate logs for agents on specific hosts like nanna12 and nanna13, use the --hosts option (or its short form -h):

Press CTRL+C to copy
 
mcm> rotate log --hosts=nanna12,nanna13 mysite;

To rotate logs on all agents in the management site mysite:

Press CTRL+C to copy
 
mcm> rotate log mysite;