Can a apache access log and error log have too many entries?

too many entries access log

[miketheman]

Hi guys,
I started using ajax on my site to update a clock. This updates every second.

Can Access logs get so large that they not only take up space, but also slow the server?

I thought it might because in php fopen a large file will result in a slower script.

Well, thank you anyone for anyone's input. Just curious.

[g1smd]

I'd rotate the logs daily or weekly instead of monthly to keep the individual file sizes down.

[miketheman]

Is it possible to make apache store them in mysql?

[Frank_Rizzo]

Do you really need to log the ajax requests? You can set apache to not log specific locations as well as .js, .css files etc.

Here is an example:

SetEnvIf Request_URI "(\.gif¦\.jpg¦\.png¦\.css¦\.js)$" no_log
SetEnvIf Request_URI "/ajax/" no_log
SetEnvIf Request_URI "/jquery/" no_log
CustomLog /var/log/mysite_access_log "%a %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %T %v \"%{x-forwarded-for}i\"\"%{CLIENT-IP}i\"" env=!no_log

[miketheman]

Ohh wow. i didn't know that. That will be really helpful! I'll be trying it out, later.

Thank you Fran_Rizzo and g1smd for your suggestions and input.

[miketheman]

For everyone who stubbles on this thread...i thought of a simple concept of adding logs into mysql.

My server is a WAMP (more like a WIMP ... miss Linux), I was going to create a bat file that would read the logs every 24 hours and turn them into sql to be injected into my mysql db.

Either that or just delete them after a week. They tend to climb up there in size really fast due to visits and I think the ajax requests.

Any comments?

[miketheman]

Hey guys, is there a way to disable the logs completely? I only use them when I'm testing codes. Would this be a bad idea?