53.4. Sampling Schedules #
53.4.1. Creating a Sampling Schedule #
Before performing this instruction:
To create a sampling schedule:
Go to sampling schedules in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Schedule.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Schedule.
In the top-right corner of the page, click Create task.
Specify parameters of the new sampling schedule (parameters marked with an asterisk are required):
Name.
Set cron-string execution: Allows specifying the interval for taking samples in the crontab format.
If you turn on this toggle, in Execution, enter the string.
Execution: The type of the sampling schedule.
Possible values:
Once: One sample will be created at the specified date and time.
Repeated: Samples will be taken at the specified interval.
For this value, specify the following parameters:
Interval: The unit of measurement of the interval.
Possible values:
Minutes
Hours
Days
Repeat every: The interval for taking samples by minutes or hours.
This parameter is available only if you select Minutes or Hours from Interval.
Execution days: The days when samples will be taken.
Cron total line: The string in the crontab format that specifies the interval for taking samples.
This parameter is available only if you turn off Set cron-string execution.
Time: The date and/or time when samples will be taken.
This parameter is available only if you select Once from Execution or Days from Interval.
Start and Repeat until: The start and end date and time for taking samples.
These parameters are available only if you turn on Set cron-string execution or select Repeated from Execution.
Database: The database for which the sample will be taken.
Server: The profiler server whose directory will be used to store the sample.
skip_sizes: Specifies whether to skip the collection of relation sizes when taking the sample.
Possible values:
true: The collection of relation sizes will be skipped when taking the sample.
false: The collection of relation sizes will not be skipped when taking the sample.
Click Save.
53.4.2. Viewing Sampling Schedules #
Go to sampling schedules in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Schedule.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Schedule.
The table of sampling schedules with the following columns will be displayed:
Task: The unique name of the sampling schedule.
Instance: The instance where the sampling schedule is created.
Database: The database for which samples are taken.
Schedule: The string in the crontab format that specifies the interval for taking samples.
User: The user that created the sampling schedule.
Actions.
For more information about available actions, refer to the corresponding instructions.
53.4.3. Editing a Sampling Schedule #
Go to sampling schedules in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Schedule.
Click
next to the task.
Using the task console section:
In the navigation panel, go to Task console → Schedule.
Click
next to the task of the Creating a statistics snapshot type. To determine the type of the task, refer to the Parameters column.
Edit schedule parameters.
For more information about these parameters, refer to the Section 53.4.1.
When editing a schedule using the task console section, the following additional parameters are displayed:
Type: The type of the task.
Operation • Object: The operation description and the name of the object on which the operation is executed.
To go to the detailed object view, click the name of the object.
Click Save.
53.4.4. Executing a Sampling Schedule #
You can manually execute a sampling schedule to instantly start taking samples.
To execute a sampling schedule:
Go to sampling schedules in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Schedule.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Schedule.
Click
→ Execute next to the sampling schedule.
53.4.5. Activating and Deactivating a Sampling Schedule #
You can deactivate a sampling schedule to temporarily stop taking samples. Sampling schedules are activated by default.
To deactivate or activate a sampling schedule:
Go to sampling schedules in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Schedule.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Schedule.
Click
→ Deactivate or Activate next to the sampling schedule.
53.4.6. Deleting a Sampling Schedule #
Important
Deleted sampling schedules cannot be restored.
When you delete a sampling schedule, the associated samples are not deleted.
To delete a sampling schedule:
Go to sampling schedules in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Schedule.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Schedule.
Click
→ Delete next to the sampling schedule. Click Delete.