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