The Cron tab

This tab is an attempt to quickly isolate issues and causes of cron problems.

Cron transaction duration in seconds

The Cron transaction duration in seconds frame displays crons transaction duration in seconds. This will display transactions that have long runtimes. A deeper dive into APM will show more details on what query the transaction/operation may be running.

MySQL Non-Sleeping Threads by Node

The MySQL Non-Sleeping Threads by Node frame shows the MySQL Non-Sleeping threads by node across the selected timeframe.

SQL Trace count by path

The SQL Trace count by path frame looks at MySQL trace counts by path, which can help trace SQL statements across a selected timeframe.

Cron database call

The Cron database call frame looks at the number of crons calling to the database across a selected timeframe.

Cron schedule table locks

The Cron schedule table locks frame looks at cron schedule table locks across a selected timeframe.

Cron schedule clean cron fired

The Cron schedule clean cron fired frame looks at the number of crons cleaned up across a selected timeframe. If no data is displayed in this frame, it could indicate a problem with crons running correctly. If the cron job schedule is not cleaned, crons will not run optimally and may take longer to run.

Cron schedule clean records details table

The Cron schedule clean records details table table provides details on the job to clean records from the cron_schedule table across a selected timeframe.

cron_schedule table updates

The cron_schedule table updates frame looks at the number of cron scheduled table updates across a selected timeframe. High activity on the delete or updating of this table may indicate an issue with crons. Also, crons update this table when they run and complete, so if there is no activity on this table and there are crons configured, there could be a problem with crons.

Datastore Operations Tables

The Datastore Operations Tables looks at database table operations, including SELECT, DELETE, and UPDATE across a selected timeframe. This frame shows the database tables with the highest operation frequency against them.