NRTServers Posted October 14, 2008 Share Posted October 14, 2008 Morning: In most software packages out there 2-day, The end user has the ability to optimize and repair any errors in the database. Our Master database is becoming extremely large. Is there a option that can do this in TCAadmin?...or an external program to do the above. Thanks Link to comment Share on other sites More sharing options...
JasonF Posted October 14, 2008 Share Posted October 14, 2008 Do you enable server stats logging? This is usually the culprit and you can read about it here https://esupport.tcadmin.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=34&nav=0,3 Link to comment Share on other sites More sharing options...
NRTServers Posted October 14, 2008 Author Share Posted October 14, 2008 Thanks for the reply Jason, No..we do not run the stats software . But I will read the link you posted. Dave Link to comment Share on other sites More sharing options...
ECF Posted October 14, 2008 Share Posted October 14, 2008 Download MYSql GUI Tool from their website. There is an option in there to optimize and/or repair the DB. Link to comment Share on other sites More sharing options...
nosit1 Posted October 14, 2008 Share Posted October 14, 2008 How bad does stats logging slow down the database? Link to comment Share on other sites More sharing options...
HIS-MOTHER Posted October 14, 2008 Share Posted October 14, 2008 How bad does stats logging slow down the database? an example would be our 200+MB SQL DB 160 of that being the stats stuff. Link to comment Share on other sites More sharing options...
leetservers Posted October 15, 2008 Share Posted October 15, 2008 Same here, Db is big but it seems to run fine. =bobby Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.