Data base cache errors slow forum and high use of database resoucres

[Eng.mohd.badawi]

Yes i enabled memchace for the cpanel and i forget to configure the system, now i did it and waiting for results,

in addition i discovered that I have one product displaying copywrites in...

[Eng.mohd.badawi]

I believe it is still in defult since i didnt change it

Please see attached screen shots for the config file showing the cache configeration

[Eng.mohd.badawi]

Still im reciving many errors, it seems enabling memchashed didn’t stop it

[Eng.mohd.badawi]

@Wayne Luke

I noticed once the size became big the errors start to come, when I truncated the tables the errors stopped until the size became big, for today only until now I received 20 errors...

[Eng.mohd.badawi]

In 12 hours from trancating the cache table the data bace size reached 14 GB

see attached large tables size...

[Eng.mohd.badawi]

Yes except the tables mentioned above
language, Phrase, userfiel

[Eng.mohd.badawi]

Mysql server restarted and tables truncated as requested , the isse disappeared for few days ... then again cameback aggressively every day 5 or 6 errors ... data base size reached 6 GB couse of cache,...

[Eng.mohd.badawi]

Dears,

please note that the errors issue raised up after upgrade to 5.4.5 , there was no issue with 5.4.2

After upgrade to 5.4.5 I start receiving database errors below some,...

[Eng.mohd.badawi]

hi

I'm receiving this errors weekly 2 or three times, please help in providing solutions.

Database error in vBulletin 5.4.1:

           Invalid SQL:
INSERT 

...

[Eng.mohd.badawi]

email Already sent and support ticket open notification received

[Eng.mohd.badawi]

first I'm working on the current data base mixed between latin1 and UTF8 ..... not on the copy mentioned earlier


if I understand correctly you mean in vBulletin under Languages &...

[Eng.mohd.badawi]

thanks Wayne your link was really helped me to understand this ...

On data base copy I followed the instructions and changed the tables on e by one / data base to UTF8MB4 character set and...

[Eng.mohd.badawi]

Screenshot of data base...

[Eng.mohd.badawi]

yes the data base is mixed now between latin1 and UTF8 characters.

since I carried out the update from 3.8.0 directly to 5.4.1 with enabling the the Latin1 from the config file.
...

[Eng.mohd.badawi]

Search function in not working correctly when searching Arabic language the search word comes in strange form and not giving results please see below
search word


search result...

[Eng.mohd.badawi]

thanks alot, I already changed the hosting and I will follow your recommendation hopfully I will get better results

[Eng.mohd.badawi]

Attachments , avatares and templates moved befour,

I appriciate if you can give me your recommendation for the hosting...

[Eng.mohd.badawi]

Thanks wayne,

could you recomend for me a hosting can take my data base which reaching 2.5 GB once search is fully indexed, running grand setting and Cache in place.

or in general...

[Eng.mohd.badawi]

Hi every body

i have an issue with data base size increase after upgrade directly from 3.8.0 to 5.4.1.

i tryied to reduce by shifting photos, avatares and attachments from data...