MySQL Forums
Forum List  »  General

Merge Tables
Posted by: matthew crowley
Date: October 28, 2004 09:55AM

I am running a mysql database (4.1.3) on a dedicated single Xeon (1Gb RAM) server. My tables are getting large (~20 tables around 7 million rows) and this is affecting performance. I would like to use merge tables, as most of the queries are run off of the last months worth of data or so. The old data is never changed, as it is logs coming from Cell Sites. My question is this --> How do I go about adding a table to a merge definition? Do I have to drop the old merge table and create a new one? What I would like to do is keep one table with about three months worth of rolling data, and then every night archive the oldest day's data from the 3 month table to the corresponding monthly table as part of a merge table.

Options: ReplyQuote


Subject
Written By
Posted
Merge Tables
October 28, 2004 09:55AM
October 28, 2004 12:17PM


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.