Overhead not being cleared in cPanel

Sajawal

Well-Known Member
Sep 10, 2020
48
7
8
Pakistan
cPanel Access Level
Root Administrator
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
 
  • Like
Reactions: cPanelAnthony

cPanelAnthony

Administrator
Staff member
Oct 18, 2021
1,046
111
118
Houston, TX
cPanel Access Level
Root Administrator
Hello! Do you see anything in the MySQL error log when these issues occur?

 

Sajawal

Well-Known Member
Sep 10, 2020
48
7
8
Pakistan
cPanel Access Level
Root Administrator
Hello! Do you see anything in the MySQL error log when these issues occur?

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'