Nick Baker wrote: > > 1. Size. Is a practical size one should limit the DB to.
Depends on hardware. > 2. Calculating or projecting future size. > > There are 9 tables in my DB. Seven tables contain static info. Using > MyPHPAdmin, I have been monitoring the two dynamic tables to get some idea > how much space is required. The results are shown below. I see a very > strange pattern. One note: Each day the oldest 95% of Table 1 is deleted, > using <CFQUERY "DELETE" function. I am wondering it the "DELETE" function > may be leaving a lot of trash in the DB? http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html For size calculations read chapter 14 and 15 of the manual. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
