This tab is an attempt to quickly isolate issues and causes of cron problems.
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.
The MySQL Non-Sleeping Threads by Node frame shows the MySQL Non-Sleeping threads by node across the selected timeframe.
The SQL Trace count by path frame looks at MySQL trace counts by path, which can help trace SQL statements across a selected timeframe.
The Cron database call frame looks at the number of crons calling to the database across a selected timeframe.
The Cron schedule table locks frame looks at cron schedule table locks across a selected timeframe.
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.
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.
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.
The Datastore Operations Tables looks at database table operations, including
UPDATE across a selected timeframe. This frame shows the database tables with the highest operation frequency against them.