| asterisk2billing.org http://forum.asterisk2billing.org/ |
|
| rates option in 1.6.2 causing high mysql cpu http://forum.asterisk2billing.org/viewtopic.php?f=33&t=7442 |
Page 1 of 1 |
| Author: | taffey01 [ Thu Apr 08, 2010 11:51 am ] |
| Post subject: | rates option in 1.6.2 causing high mysql cpu |
Works fine in ver 1.4.1 but since moving to 1.6.2 i can no longer see any of the rates. I've run all the mysql update files manually but made no difference. Would love to fix this issue. When cpu spikes i see this in mysql processlist whilst its showing high cpu. | 10 | a2billinguser | localhost | mya2billing | Query | 18 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS cc_prefix.destination, cc_ratecard.dialprefix, cc_ratecard.buyrate, cc_ra | Anything i run in the logs or something to try and find this? I get the same issue on my test server as well running the same DB. If i build a new server with new DB it works fine. Is there a way to import customer call records to a new server with different DB? |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|