Dear All, i'm developing a web application with a lot of event to track in it. I'll install the application in ca. 10 web server and I need to have the tracking event saved in a db in order to be analyzed.
I'll receive 100K events/minutes = 144 millions events a day an event row is (event type, user id, object id, context id, session id, timestamp)
I think about store them in a MyISAM table and then, every day, change the table name according to the date (i.e. log20090826, log20080827 and so on). Have you other/best ideas? I can use, if more performant, other RDBMS.
another question: is there any method to know the timestamp of a row without having it explicitly written (no space used)?