News for hackers. Stuff that matters.
Re:Build Your Own Circular Log with MySQL by btn on Thursday December 02, 2010 @05:57PM (#1964014)
It's a nice solution, but doesn't seem to solve the problem they present at the start of the article. "What we wanted was a way to keep at least 24 hours worth of entries at all times"; but their solution only stores the last MAX_CIRCULAR_LOG_ROWS entries.
Re:Build Your Own Circular Log with MySQL by jekor on Thursday December 02, 2010 @07:43PM (#1964331)
Ah yes, good point. Luckily we have a regular rate of messages and we knew that 2 million would be enough to always have roughly 24 hours worth.