Sonata Stats failed_jobs.ibd size

For some reason, the sonata_stats failed_jobs.ibd is quite big in our system, currently 20.2GB in size.

Any particular reason for this? What exactly are the failed_jobs withing sonata stats?

1 Like

Hello Sir,

The failed_jobs table stores information about jobs that have failed to process.

We will improve this in a future version.

For now to flush this table, inside /usr/share/sonata/queues-stats/backend you can execute the command: php artisan queue:flush

This command will flush all records in the failed_jobs table.