mysql DB repair being run Daily by CPANEL?

vicos

Well-Known Member
Apr 18, 2003
82
3
158
All of a sudden I wake to find my domains reporting mysql too many connection errors.

I have one very large mysql DB (6GB). Inspection of the system shows that root is running a mysql repair against this database, the backup subsequently starts and tries to dump it, and user connections pile up as mysql is unable to respond to their queries.

Since this just started, I assume this automatic daily mysql repair came with a CPANEL/WHM upgrade.

How can I disable checking/repair of the mysql databases belonging to one or more particular user accounts ?

TIA!
 

MattCurry

Well-Known Member
Aug 18, 2009
275
0
66
Houston, Tx
mySQL Repair

Hello,


I could understand how that would be inconvienent, however cPanel doesn't do a daily repair of databases. If you are still having issues we may need to take a closer look at it, and you can have us do that by putting a ticket in(at bottom of post).

Thank you,
Matthew Curry
 

vicos

Well-Known Member
Apr 18, 2003
82
3
158
I could understand how that would be inconvienent, however cPanel doesn't do a daily repair of databases. If you are still having issues we may need to take a closer look at it, and you can have us do that by putting a ticket in(at bottom of post).

Thank you,
Matthew Curry
Hi Matthew, thanks for the response.

Last night I went into WHM and told backup not to backup the user account which owned the large database. I also told it not to backup the entire mysql databases, just for the individual accounts.

I did not have a problem this am.

Prior to this problem, I did have a cron, running from the user account that owned the large database, which did a repair and optimize on that database. It ran every Sunday early a.m. I figured out that was causing the problem and commented the line out of the crontab and killed the running task.

However, the next several days the problem reoccurred, and this is when I found the mysql repair running as root. When it was running from my cron previously, the task ran as the respective user. This is why I assumed CPANEL was doing it.

I'll have to look closer and report back.
 

thewebhosting

Well-Known Member
May 9, 2008
1,201
1
68
Hi,

cPanel does not run the script of database repair on daily. If you have any issue with such databases then you can set the cron for that and run the database script for that databases.

You can also run this script from SSH when you want to repair all the databases:

mysqlcheck --all-databases -r #repair
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
77
308
cPanel Access Level
Root Administrator
Actually, /scripts/pkgacct repairs the databases of a user before backing up the databases.