Ghan_04
Active member
For some reason, my database has been getting slammed recently by something to do with the xf_job table and scheduled jobs. The cron jobs themselves don't seem to be the source of the problem. What I see is this kind of thing filling up my database process list:
I see queries like this constantly as I refresh the processlist. They don't seem to take long to execute individually, but it's like every page load submits a ton of them at a time. I'm averaging about 2,000 queries per second on the database with only ~250 people online. MariaDB is using up 3.5 of the server's 4 cores and is driving the load above 30. This is with enableListeners=false to disable all addons. Where can I look to pinpoint what's going on here?
Thanks!
I see queries like this constantly as I refresh the processlist. They don't seem to take long to execute individually, but it's like every page load submits a ton of them at a time. I'm averaging about 2,000 queries per second on the database with only ~250 people online. MariaDB is using up 3.5 of the server's 4 cores and is driving the load above 30. This is with enableListeners=false to disable all addons. Where can I look to pinpoint what's going on here?
Thanks!