MySQL hammering my server after update to 5.6.3

[imager]

Changing the date range appears to have solved the problem. I don't actually know why the date range was zero in some of these modules but I am just so glad that it's all working again. Thank you for...

[imager]

It's been half an hour since I edited the date ranges and reset the MySQL server and so far, touch wood, the server load has remained in what we regards as the normal range!...

[imager]

Is it the search JSON like this? {"date":{"from":"0"},"sort":

EDIT - I have worked it out; there were a few modules with '0' and have changed them...

[imager]

Wayne Luke "Finally, edit all search modules on your site and make sure they have a valid date range. Even if it is 365 (or more) days. Default should be 30 days but older installs might have empty...

[imager]

The support ticket is [SID-2327129]

[imager]

I have updated my support ticket mentioning you requested the mysql-slow.log file and I have sent it to contact AT vbulletin dot com via WeTranfer

Also I don't know if this is useful?...

[imager]

PHP is now set to 128MB.

I'm not sure what you mean by run query describe node...

[imager]

Would it be helpful to upgrade from PHP 7.3 to 7.4 and to a more recent version of MariaDB?

[imager]

I should have the MySQL log shortly. Where should I send this?

[imager]

Maybe it's too difficult to switch from MariaDB to MySQL8, from my hosting company:

After looking into this it looks like you have existing databases on the server. Unfortunately since this...

[imager]

Can you help me identify what to look for?...

[imager]

Unfortunately, the server load remains too high and is creeping back towards a level that will stall vBulletin on that domain.

The next step is for the hosting company to replace MariaDB...

[imager]

That's interesting but I will explore that later. The issue here is a sudden out of control issue with table requests.

[imager]

We're still on MariaDB for now, but I have run the InnoDB conversion script and that appears to have worked as planned. I have restarted the MySQL server service and server load has dropped. Let's see...

[imager]

OK, I'm just going to check that the work to change from MariaDB isn't in progress and then I will run the script....

[imager]

In Omnibus Yes I have asked the hosting company to switch to MySQL 8. I will hopefully be done in a few hours.

[imager]

This beyond my skills - how is the choice of table engine determined?

I will enquire about Apache 2.4.

Edit, server status is: Server Version: Apache/2.4.46 (cPanel) OpenSSL/1.1.1g...

[imager]

The PHP/MySQL details are:


The Table Status lists a mixture of InnoDB and MyISAM and Memory, here is a clip of the list: ...

[imager]

I updated two of my forums to 5.6.3 last night but my busier forum is causing the server to overload. The hosting support techs reported back:

So far I have been able to narrow down the source...

[imager]

Is vBulletin caching needed if you run a CDN?...