Hi everyone -
We recently started logging our apache logs directly into a mysql db. Two questions: 1. The db files are growing fairly rapidly. Will inserts begin to slow the larger the database gets? Is there a recommended method for rotating the database every few gigs (it's all in one table, so we could rotate the table...) Or should we just keep letting it grow and maybe deal with it down the road? After a a few hundred gigs, say.... 2. Does anyone have an already thought out set of SQL queries that will generate useful data given a database full of log files? I know all those database analysis tools do something along those lines, except they parse the log rather than querying a db. (ie Unique visitors for a given time period, exit pages, entry pages, etc) Thanks in advance, Chad Arimura --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
