Joined: Thu Jun 28, 2012 7:58 am Posts: 4
|
When I goto Invoices > Receipts the resulting mysql query causes the server to go into meltdown. mysql process runs at 100% until something expires. The website never returns anything and usually crashes firefox.
THere are no errors in mysqld.log and nothing out of the ordinary being logged elsewhere. If I restart mysql while the query hangs the page refreshes and comes back with no receipts created so it's defiantly a query thats the issue.
Not sure where to start on this one, any ideas?
UPDATE - On looking at the cc_receipt table I have 67884 records which I think it the issue. I have over 6000 customers generated and it must be regenerating these call summary's once a month. Looking at the receipts is too much for the query
Is there a way to speed it up?
This is running on 64-bit Centos 6.5 A2billing 2.0.7
|
|