I've noticed alot of sites, shut down for 30 min or so each week for maintenence, and unless i'm mistaken, i read websites with alot of traffic that rely heavily on MySQL needs to optimized their MySQL database every so often to make sure it keeps running smoothly.
Can anyone verify this for me, or give me some hints/ideas on what is needed to make sure the MySQL database used for a site with heavy site, stays working smoothly with no problems?
