Plain Black, makers of WebGUI - Automating database maintenance tasks

Discuss > WebGUI Dev

Automating database maintenance tasks
User	knowmad
Date	5/13/2008 5:58 am
Views	138
Rating	0 Rate [ \| ]

Previous · Next
User	Message
knowmad	Date: 5/13/2008 5:58 am · Subject: Automating database maintenance tasks · Rating: 0 Hey folks, We have a client who had a MySQL table crash (userSession) which resulted in "bad things" in his WebGUI site. He's a skilled sysadmin and maintains a 30,000+ member website running on MySQL (not WebGUI yet) so has some experience in managing databases. He suggested the following steps be taken as part of the Weekly maintenance workflow: * REPAIR all tables in all databases * OPTIMIZE all tables in all databases * investigating FLUSH as well Perhaps you're already doing this. If not, I'd like to hear your thoughts about adding these. William ---- Knowmad Technologies http://www.knowmad.com
Back to Top	Rate [ \| ]

Discuss > WebGUI Dev