Is anyone out there using the billing feature with more than 64 bills (customers)?

I could be barking up the wrong tree, but I've done some experimenting by changing the query in bills.inc.php to call specific bills. If I give it 63 bills and call the page, regardless of how many times I do it, it comes up in less than 5 seconds. But if I give it 64 or more, then I am looking of 70+ seconds for the page to be generated. It doesn't matter which bill_ID I use so it doesn't seem to be a problem with a specific ID.

Also, can anyone please tell me what the values at the bottom of the page mean? Below are two examples, one when it returns the page quickly and the other slowly.

MySQL: Cell 60/0.003s Row 387/0.026s Rows 7/0s Column 180/2.239s MySQL: Cell 61/0.004s Row 393/24.614s Rows 7/0.645s Column 183/44.798s

Kind regards,

Mahomed Hussein Senior Operations Engineer Custodian DataCentre tel: +44 (0)1622 230382 email: Mahomed@CustodianDC.com http://www.custodiandc.com/disclaimer.txt

-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Mahomed Hussein Sent: 22 September 2011 10:48 To: Observium Network Observation System Subject: Re: [Observium] Traffic bills page taking over a minute to display

Hi

Thanks for the response. I am not entirely sure which queries to run, but I've run "select * from bills" using the Execute SQL section of WebMin and that returns the results almost immediately. So it doesn't seem to be an issue with that query. If you can point me at which file or queries to run, I can test them further. Thanks.

Kind regards,

Mahomed Hussein Senior Operations Engineer Custodian DataCentre tel: +44 (0)1622 230382 email: Mahomed@CustodianDC.com http://www.custodiandc.com/disclaimer.txt

-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Dirk-Willem van Gulik Sent: 21 September 2011 15:11 To: Observium Network Observation System Subject: Re: [Observium] Traffic bills page taking over a minute to display

On 21 Sep 2011, at 15:08, Mahomed Hussein wrote:

Can anyone please help or provide some tips of where to start checking? It now becoming pretty unusable.

Have you looked at the SQL query ? How long that takes if you do it manually from the mysql cmnd tool ?

That gives you an idea as to where to start looking,

Dw.

Kind regards,

Mahomed Hussein

Senior Operations Engineer

image8c376c.jpg@5c3feea6.0860423b

Tel:

+44 (0)1622 230 382

Email:

Mahomed@CustodianDC.com Web:

www.CustodianDC.com

Status:

status.CustDC.net

imagea72a25.png@94a57a1c.c10e4664 ISO:27001 IS:567248

Click to view our email disclaimer

From: Mahomed Hussein Sent: 31 August 2011 09:52 To: 'observium@observium.org' Subject: Traffic bills page taking over a minute to display

Hi

We've been adding customers to the billing section and after a strange occurrence a few weeks ago (which we attributed to time changes between the VM and the ESX host), the billing page has been very slow to generate. Please could you let me know if there is anything I can do to check/fix the problem?

Below is how long the most recent page display took:

MySQL: Cell 63/0s Row 404/38.23s Rows 8/0.65s Column 189/56.87s Generated in 95.36 seconds.

This is happening in the latest dev release of Google Chrome, Opera 11.50 and IE9 (I haven't tested firefox).

I have already rebooted the server.

Below is the system information.

Observium 0.11.8.2404 Apache 2.2.17 (Ubuntu) PHP 5.3.5-1ubuntu7.2 MySQL 5.1.54-1ubuntu4

Any help will be sincerely appreciated.

Kind regards,

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium This e-mail has been scanned by www.CustodianDC.com for viruses, explicit material and spam

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Thanks. I'll try that and will post back.

Kind regards,

Mahomed Hussein Senior Operations Engineer Custodian DataCentre tel: +44 (0)1622 230382 email: Mahomed@CustodianDC.com http://www.custodiandc.com/disclaimer.txt

-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Dirk-Willem van Gulik Sent: 22 September 2011 14:35 To: Observium Network Observation System Subject: Re: [Observium] Traffic bills page taking over a minute to display

On 22 Sep 2011, at 10:48, Mahomed Hussein wrote:

Thanks for the response. I am not entirely sure which queries to run, but I've run "select * from bills" using the Execute SQL section of WebMin and that returns the results almost immediately. So it doesn't seem to be an issue with that query. If you can point me at which file or queries to run, I can test them further. Thanks.

May be easiest to switch on SQL statement logging

http://dev.mysql.com/doc/refman/5.1/en/query-log.html

and then get things going. And then do exactly that one page operations - and check what the actual query in the log is.

If that returns fast - your next step is diving in to PHP debugging. If that is slow - fixing the query/indexes is next.

Dw

Kind regards,

Mahomed Hussein Senior Operations Engineer Custodian DataCentre tel: +44 (0)1622 230382 email: Mahomed@CustodianDC.com http://www.custodiandc.com/disclaimer.txt

-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Dirk-Willem van Gulik Sent: 21 September 2011 15:11 To: Observium Network Observation System Subject: Re: [Observium] Traffic bills page taking over a minute to display

On 21 Sep 2011, at 15:08, Mahomed Hussein wrote:

...

Can anyone please help or provide some tips of where to start checking? It now becoming pretty unusable.

Have you looked at the SQL query ? How long that takes if you do it manually from the mysql cmnd tool ?

That gives you an idea as to where to start looking,

Dw.

...

Kind regards,

Mahomed Hussein

Senior Operations Engineer

image8c376c.jpg@5c3feea6.0860423b

Tel:

+44 (0)1622 230 382

Email:

Mahomed@CustodianDC.com Web:

www.CustodianDC.com

Status:

status.CustDC.net

imagea72a25.png@94a57a1c.c10e4664 ISO:27001 IS:567248

Click to view our email disclaimer

From: Mahomed Hussein Sent: 31 August 2011 09:52 To: 'observium@observium.org' Subject: Traffic bills page taking over a minute to display

Hi

We've been adding customers to the billing section and after a strange occurrence a few weeks ago (which we attributed to time changes between the VM and the ESX host), the billing page has been very slow to generate. Please could you let me know if there is anything I can do to check/fix the problem?

Below is how long the most recent page display took:

MySQL: Cell 63/0s Row 404/38.23s Rows 8/0.65s Column 189/56.87s Generated in 95.36 seconds.

This is happening in the latest dev release of Google Chrome, Opera 11.50 and IE9 (I haven't tested firefox).

I have already rebooted the server.

Below is the system information.

Observium 0.11.8.2404 Apache 2.2.17 (Ubuntu) PHP 5.3.5-1ubuntu7.2 MySQL 5.1.54-1ubuntu4

Any help will be sincerely appreciated.

Kind regards,

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium This e-mail has been scanned by www.CustodianDC.com for viruses, explicit material and spam

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium