Re: single table for all vhosts?
"Chris Powell" <[email protected]>
| Newsgroups | gmane.comp.apache.mod-log-sql |
|---|---|
| Message-ID | <[email protected]> |
Paul Chvostek said: > Hiya. > > Given the apparant lack of list archives for this list, I'm afraid that > as a new user I may be repeating old questions, but anyway ... Hello, Paul. I apologize for a very tardy reply. There are in fact archives of the list, and I've just updated the message footer to reflect this. They can be found here: http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql > Should I expect problems if I set every virtualhost to record log > entries to the same table, rather than create a new table for each > virtualhost? And is there a way to set that table name *once* rather > than include a "LogSQLTransferLogTable access_log" in every vhost? This is the way I do it, and it is certainly feasible; I like it because it means a single, monolithic, convenient table. (I encourage rebuttal from folks hosting large numbers of virtualhosts...there might be situations where one-table-per-host is more appropriate.) The current functionality of the LogSQLMassVirtualHosting directive is to activate one table per host. If you want to log all your virtual hosts to a single table, simply use LogSQLCreateTables On but skip LogSQLMVH. As to your second note, I'm pleased that this is a feature in the 1.19b1 release that I put out a few days ago. That feature was long coming and is highly appropriate for folks with a setup like yours. I highly encourage you to try the beta and see if it matches your needs. It is beta for non-Linux architectures, but stable for Linux. > Cancellations would shift from "DROP TABLE www_www_example_com" to > "DELETE FROM access_log WHERE virtual_host='www.example.com'". Agreed! Regards, Chris -- Chris Powell [email protected] (206) 783-5104 voice, (815) 461-4456 fax ____________________________________________________________________ Reminder: to unsubscribe, send email to <[email protected]> with the words "unsubscribe mod_log_sql" in the body (w/o quotes). The module homepage is http://www.grubbybaby.com/mod_log_sql/ The list archives are here: http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql