Can only run 2 windows at a time?

[Glenn]

Hi,

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).

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?

Thanks
Glenn

[Andy Hassall]

On Sun, 08 Apr 2007 18:25:41 GMT, Glenn <ba******@frontiernet.netwrote:

>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 :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Glenn]

On Sun, 08 Apr 2007 22:09:51 +0100, Andy Hassall <an**@andyh.co.uk>
wrote:

>On Sun, 08 Apr 2007 18:25:41 GMT, Glenn <ba******@frontiernet.netwrote:

>>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.

Yeah, I'll have to say that I have about 5 SUM's in the Select
statement :D prolly helping the slowdown, eh?

>>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.

Yes: "outputting data as it appears in the logfile, but
keeping the same HTTP connection open and flushing? "

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.

Was hoping to do this in the next version.. glad that you mentioned
it, so that I know that I'm going decent direction :)

>Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Thanks
Glenn

[Andy Hassall]

On 11 Apr 2007 10:55:53 GMT, David Gillen <Be****@RedBrick.DCU.IEwrote:

>Andy Hassall said:

>On Sun, 08 Apr 2007 18:25:41 GMT, Glenn <ba******@frontiernet.netwrote:

>>>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.

There is a registry hack which works around this, I can't recall exactly which
key needs changing though.

There is, but it shouldn't be done, as it's somewhat antisocial - the limit is
there for a reason.

HTTP/1.1, sec. 8.1.4, para. 6: "A single-user client SHOULD NOT maintain more
than 2 connections with any server or proxy."

Anyone exceeding this should contribute to the offical fund for wigs for
admins who have torn their hair out due to their server's load suddenly
increasing.
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool