When you have very large tables, performing a Truncate will be much quicker. If you are concerned about archive data, you can choose either Inline, which will freeze your browser for the period of this upgrade, or background, which will create a background process to bring your old syslog data from a backup table to the new syslog format. Again this process can take several hours.

Inline Upgrade

In MySQL 5.1.6 and above, you have the option to make this a partitioned table by days. Prior to this release, you only have the traditional table structure available.

In MySQL 5.1.6 and above, you have the option to make this a partitioned table by days. In MySQL 5.5 and above, you can create multiple partitions per day. Prior to MySQL 5.1.6, you only have the traditional table structure available.

Partitioned Table

Retention Policy

Partitions per Day

Select the number of partitions per day that you wish to create.

Syslog %s Advisor

The upgrade of the 'main' syslog table can be a very time consuming process. As such, it is recommended that you either reduce the size of your syslog table prior to upgrading, or choose the background option</p> <p>If you choose the background option, your legacy syslog table will be renamed, and a new syslog table will be created. Then, an upgrade process will be launched in the background. Again, this background process can quite a bit of time to complete. However, your data will be preserved</p> <p>Regardless of your choice, all existing removal and alert rules will be maintained during the upgrade process.</p> <p>Press <b>'Upgrade'</b> to proceed with the upgrade, or <b>'Cancel'</b> to return to the Plugins menu.

You can also select the retention duration. Please keep in mind that if you have several hosts logging to syslog, this table can become quite large. So, if not using partitioning, you might want to keep the size smaller.

There were %s Device records removed from the Syslog database

Facilities to filter on

Removal Handling

Click 'Continue' to Export the following Syslog Alert Rule(s).

Export Syslog Alert Rule(s)

For recording Re-Alert Cycles, should the Alert be tracked at the System or Device level.

Define how to Alert on the syslog messages.

For the 'Threshold' method, If the number seen is above this value an Alert will be triggered.

Define how you would like this string matched. If using the SQL Expression type you may use any valid SQL expression to generate the alarm. Available fields include 'message', 'facility', 'priority', and 'host'.