MySQL Forums
Forum List  »  Optimizer & Parser

Re: Large database
Posted by: Sean Allin
Date: February 15, 2007 05:13PM

Review the types of queries you need to support.

I've a db logging syslog data with over 4 million records. However, 99% of the queries are for troubleshooting and I normally only need access to the current month's data. So at the beginning of each month, I archive the previous month's data into it's own table, keeping current month's table under 1 million records. I then use a mrg_myisam table definition to link all the archived tables together for the few times I need to query all the records.

Options: ReplyQuote


Subject
Views
Written By
Posted
3350
January 12, 2007 07:45AM
2103
February 09, 2007 01:42AM
1939
February 14, 2007 06:55AM
2159
February 14, 2007 06:47PM
2053
February 15, 2007 05:35AM
Re: Large database
2167
February 15, 2007 05:13PM


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.