rates option in 1.6.2 causing high mysql cpu
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