Self-managed Server MySQL event scheduler waiting on empty queue since server restarted 10 days ago

[media]

Self-managed Server MySQL event scheduler waiting on empty queue since server restarted 10 days ago

5

event_scheduler

localhost

NULL

Daemon

4103867

Waiting on empty queue

NULL

I see there is fix for this

The event_Scheduler is, as it's name suggests, a way to Schedule Events (in this case queries) to run in MySQL at a given time. It is simply waiting for an event to trigger it and tell it to do something. As you can see you have no events set up, so it will be waiting for a long time.

It is enabled by default, but can be disabled by running:

SET @@global.event_scheduler = 0;

You also want to add:

event_scheduler = OFF

to your my.cnf file to prevent it starting after a reboot.

BUT before I apply that I want to make sure that that does not effect IPB board on my server???

Can someone who has knowledge on this look at this?

Thanks

[teraßyte]

Invision Community doesn't use the event scheduler.

[media]

21 hours ago, teraßyte said:

Invision Community doesn't use the event scheduler.

Thank you.... 🙂 

[media]

FYI anyone moved their server from Centos to Alma 8 be careful Myslq event scheduler (event_scheduler) default value "ON" Somehow that cause overload or lagging on server

I have disabled the service (MySql event_scheduler), and my server load went from 5.6 to 1.2