Overhead not being cleared in cPanel

[Sajawal]

Hi,

I'm facing an issue with cPanel PHPMyAdmin, when I'm trying to optimize the database table the overhead is not being cleared out, and also my website's works slowed until I restart the MySQL service.

Please let me know the solution to this error.

Mysql: Server version: 8
CloudLinux v8
cPanel version v100.0.4

Regards,
Sajawal

 

[cPanelAnthony]

Hello! Do you see anything in the MySQL error log when these issues occur?

The cPanel & WHM Log Files | cPanel & WHM Documentation

This document describes the location of all of the log files in cPanel & WHM, Webmail, and MySQL®. This document also provides examples of each log file.

docs.cpanel.net

 

[Sajawal]

Hello! Do you see anything in the MySQL error log when these issues occur?

The cPanel & WHM Log Files | cPanel & WHM Documentation

This document describes the location of all of the log files in cPanel & WHM, Webmail, and MySQL®. This document also provides examples of each log file.

docs.cpanel.net

Hi, sorry for the delay.

Logs of /var/log/mysqld.log are mentioned below:

2021-12-01T06:00:13.080453Z 1039010 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:00:13.804164Z 1039015 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:00:38.509171Z 1039337 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:00:39.155703Z 1039347 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:01:03.491072Z 1039645 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:01:27.213929Z 1039927 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:02:34.544578Z 1040821 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T06:30:35.461533Z 1052148 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T07:00:40.177508Z 1064314 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2021-12-01T07:30:40.775804Z 1076311 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

 

[cPanelAnthony]

Would it be possible for you to open a ticket for us to investigate using the link in my signature? Please provide me with the ticket ID once done.

 

[weelow]

I am having the same problem and I am using the same

Mysql: Server version: 8
CloudLinux v8
cPanel version v100.0.7

Could you please share how you solved this problem?

 

[cPRex]

@weelow - I don't see that the OP opened a ticket with us, so I don't have a resolution to post. If you're seeing the same thing, could you open a ticket with our team so we can look into that on our end?

 

[sahostking]

Hi - we have one server showing the same signs as this. Any solution we can try?

We are going to open a ticket aswell soon.