Re: Archive and Reduce Database Size to Optimize the site
Posted by: Rick James
Date: March 24, 2012 10:36AM

> I would need to reduce the database size to 1year at the time, and save the prior years as Archives on a 2nd database which can be accessed when desired..
This approach does not necessarily help. Let's look at your queries and SHOW CREATE TABLE.

Usually the 'right' solution is to add an appropriate INDEX. Other possibilities are modifying the SELECTs, and maybe PARTITIONing. Another possibility is the cache size. Let's see SHOW VARIABLES LIKE '%buffer%'.

I deal with tables with lots of old data (tens of gigabytes), yet they have been designed so that they continue to work just fine for "recent" data.

Options: ReplyQuote


Subject
Written By
Posted
Re: Archive and Reduce Database Size to Optimize the site
March 24, 2012 10:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.