We have a database that supports our customers and runs pretty much 24/7/365. Obviously we need to keep this database healthy and optimized. I've read the official documentation and third party books on MySQL and they all are very good at explaining what should be done and how to do it but none that I can find explain the impact of running mysqlcheck commands on the other applications or user issuing reads and writes to the database at the same time.
Is it prudent to set up a script that runs mysqlcheck on the whole database at a set time each week? Will users and applications be prevented from accessing tables for reads and writes while the mysqlcheck process is running or will they simply suffer a performance hit? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]