Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
is automating mysqlcheck safe?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
mikegpitt
Advocate
Advocate


Joined: 22 May 2004
Posts: 3224

PostPosted: Wed Jan 16, 2013 6:10 pm    Post subject: is automating mysqlcheck safe? Reply with quote

I have a database that receives frequent inserts and deletes each day. I'm thinking about tuning the performance by automating mysqlcheck each evening. I've seen some blogs suggest running the following via a cron each night `mysqlcheck --auto-repair --optimize -u root -p <database_name>`.

Is it safe to let mysqlcheck do this each evening? Can the optimize or auto-repair flags ever cause the database to enter a locked state or cause data corruption?

I do run nightly backups of the database, but it would be a bad morning to find that everything broke as I slept. :wink:
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum