mysql DB repair being run Daily by CPANEL?

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!

 

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.