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

Invision Community doesn't use the event scheduler.

21 hours ago, teraßyte said:

Invision Community doesn't use the event scheduler.

Thank you.... 🙂 

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 

 

And more on this.

I don’t know how, but I switched my server’s database MySQL 8 to MariaDB 11.4 my board was running daily load average 1.8 then under MariaDB 11.4 running daily load average 0.9

I do not how, but I am seeing this every day right now

Some info: testing under exact daily hit and usage….

New DB tested about 10 days so far…

What are your thoughts about this? MariaDB really better or am I just daydreaming?

Edited yesterday at 12:35 AM1 day by media

Was the MySQL 8 configuration the same as MariaDB? If the configuration values are different, it’s possible that MySQL 8 was simply using non-optimized values.

I know some of my clients switched from MariaDB to MySQL and their sites were faster overall. However, their configuration was also tuned by expert server administrators. 🤷‍♂️

I have MariaDB 10.6.19 on my Classic instance of Invision Community and haven’t noticed any issues with speed or performance. My community does not have high traffic or large amounts of data yet so that may be the biggest difference here.

May I ask how large and/or active your community is?

50 minutes ago, teraßyte said:

Was the MySQL 8 configuration the same as MariaDB? If the configuration values are different, it’s possible that MySQL 8 was simply using non-optimized values.

I know some of my clients switched from MariaDB to MySQL and their sites were faster overall. However, their configuration was also tuned by expert server administrators. 🤷‍♂️

Exact same configuration… Server Admin tuned both… same way

44 minutes ago, Gary said:

I have MariaDB 10.6.19 on my Classic instance of Invision Community and haven’t noticed any issues with speed or performance. My community does not have high traffic or large amounts of data yet so that may be the biggest difference here.

May I ask how large and/or active your community is?

1.1 million post 96 thousand members

Speaking of MariaDB only, I know a client updated from 10.3 to 10.6 and saw noticeable improvements.

4 minutes ago, teraßyte said:

Speaking of MariaDB only, I know a client updated from 10.3 to 10.6 and saw noticeable improvements.

Keeping my fingers crossed….