Posted by Andy Hassall on 04/08/07 21:09

On Sun, 08 Apr 2007 18:25:41 GMT, Glenn <bagsmode@frontiernet.net> wrote:

>I'm using Apache server, PHP (ver4) driven pages, querying a MySQL DB.
>I'm trying to monitor/tail
>some log files and perform queries to
>1) insert the new data,
>2) verify that the data is within certain constraints.
>
>Each query is taking a full second to perform (is that normal? I have
>about 100k records at the moment).

"Normal" depends on how much work you're doing on the data - just a number of
rows isn't enough to say.

>Plus, having an issue with only able to tail two files...?
>I can open two Internet Explorer windows and tail two files; but as
>soon as I try to open a 3rd, nothing happens until I get out of one of
>the others.
>
>Any idea to why I can only do 2 at a time?

Browsers will only open a limited number of connections to a server at the
same time, to avoid thrashing the server. You're most likely seeing this limit.
How are you handling this - outputting data as it appears in the logfile, but
keeping the same HTTP connection open and flushing? That will hit the
connections limit.

An alternative is to have the browser poll the page for new information, e.g.
with a refresh header (or meta refresh equivalent), or Javascript timer.
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]