> >>>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.
Exactly what I needed to know. Thanks Russ and everybody else. - Grant -- [email protected] mailing list
