[Spce-user] rateomat problem

[Alex Lutay]

Dear Mykola,

I believe it tries to select amount of not-yet rated CDRs.

So, probably you have a lot of records in accounting.cdr because:
 - rate-o-mat was stopped for a long time
AND/OR
 - default CDR cleanup settings is too big for you
(keep CDRs for 6 month), so you have to decrease amount of CDRs to keep
in accounting.cdr table.
AND/OR
 - MySQL is slow for you, slow server, slow IO, not enough RAM for
InnoDB bufferpool?
OR
 - MySQL indexes 'rstatus' is missed on your DB for some reason.

I would check all of them from up to down.

On 08/31/2015 02:45 PM, Mykola Zaika wrote:
> I have problem with my server.  What does rateomat stand for?
> 
> # Time: 150831 15:40:23
> # User at Host: rateomat[rateomat] @ localhost []
> # *Query_time: 1717.441911 * Lock_time: 0.000072 Rows_sent: 100
> Rows_examined: 15906956
> SET timestamp=1441024823;
> SELECT * FROM accounting.cdr WHERE rating_status = 'unrated' ORDER BY
> start_time ASC LIMIT 100;
> 
> 
> | 20518 | rateomat   | localhost | accounting   | Query   |  794 | Sending
> data | SELECT * FROM accounting.cdr WHERE rating_status = 'unrated' ORDER
> BY start_time ASC LIMIT 100


-- 
Alexander Lutay
Head of Quality Assurance
Sipwise GmbH, Campus 21/Europaring F15
AT-2345 Brunn am Gebirge

Office: +43(0)13012036
Email: alutay at sipwise.com
Website: http://www.sipwise.com