rarebit Posted September 16, 2007 Share Posted September 16, 2007 Hi, so i've got a mysql table (or set of tables) which are used for logging, when it get's full the request starts to lag while it's searched. Therefore periodically I want to back it up. However, say I set a routine which back's it all up to file and then truncates (as so to reset the id) the table, ok. But say whilst this is being done more entries are added and are not backed up. One point is, a certain period of time worth of log's need to be retained for frequency checking. Considerations: - If an entry is added whilst the table is being truncated, what happens. - If only use delete entry, then at what point does the id run into trouble. - Is it crazy to think about using two tables and just rotate them... What's the professional solution? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.