background:

I have 'inherited' a php webapp in my small company and after years of nagging have finally gotten the go to throw away the spaghetti code and start again.

Biz, örneğin sistemde yapılan her eylem oturum açmak istiyorum:

• kullanıcı X izlendi madde Y
• kullanıcı X güncellenen madde Y
• Şehir Z yeni öğe Y

and later provide graphs on different resolutions ( day, month , year ) of the actions done in the system.

On the previous version we have a table with 20,000,000 of records since 2005 so this would give you an idea of the ammount of data we already have and this is only for one of many statistics.

actual question:

What recomendations you have on building a near to realtime system to create this statistics?

notes:

1. Grafik zaten google görselleştirme API üzerinden kaplıdır
2. Im not adversed of using any NoSql databases or messaging servers, crons or whatever that gets the job done, but would prefer mysql/php solution
3. My current train of thought is automatically create a table for each statistic I want to save, and create several aggregation tables ( by month , by day , by year ) to cache the results.
4. Ben geniş bir soru olduğunu biliyorum ama herhangi bir öneri bekliyoruz