asterisk2billing.org http://forum.asterisk2billing.org/ |
|
Receipt section hangs mysql http://forum.asterisk2billing.org/viewtopic.php?f=33&t=10819 |
Page 1 of 1 |
Author: | Sc00by [ Mon May 05, 2014 11:03 am ] |
Post subject: | Receipt section hangs mysql |
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 |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |