I have generated a couple of logs across different machines. Each log representing an action performed by user. The log is a text file generated in php by appending using file_put_contents . A line in the log represent action performed by user, time etc. There are many logs like this for each and every user action. Now I want to make a user profile which contain what all actions he did by going through these logs in ascending order of time. How do I do this?
Also I am planning to store these user profile in a MYSQL db. We have a large data of over 50GB of text from which I have to make these profiles. Is this ok?
Is there any tool that let me get business intelligence from these logs. (Suppose if i want to see how many users did a specific action today etc).