I've started logging each page request made to my site as an entry in a MySQL table. I get about 5000 page requests per day, and I wonder if I'm asking to much of MySQL. Is there a limit on how big a table can be? Other considerations?
Are you serious? We log 4-7 million rows a day here.. I dont think you have any reason to worry.
I'm very glad to hear that. What about performance issues? Will the insert be slower as the table grows? That could be a problem.
- Grant
We have an (InnoDB) table to which we log about 30 million rows per day (and growing).
To keep the inserts responsive we have a rolling script which moves the rows to another table which isn't accessed by the site. InnoDB allows the move script to do its work without locking out the site.
If you don't have some sort of strategy to empty the table daily, weekly or on a rolling basis (like we do) you'll find that your inserts eventually slow to a crawl (I've seen it happen). Making sure you only have the minimum required indexes on the table will also help keep your inserts sprightly.
So in summary:
* Use InnoDB * Empty the table periodically * Index lightly.
Hope this helps.
--
Russ
-- [email protected] mailing list
