[Spce-user] Slow queries since upgrade to 5.5.5

[Henk]

Hi all,

I noticed high CPU and load on my system when I look into the call 
history of a subscriber. I found MYSQL was taking it all and the query 
shows up in the slow query file. The EXPLAIN looks like this, showing a 
filesort on 211928 rows:

+------+--------------------+---------------------------------------+--------+----------------------------------------------------------------+---------+---------+------------------------------------+--------+-----------------------------+
| id   | select_type        | table                                 | 
type   | possible_keys | key     | key_len | 
ref                                | rows   | Extra                       |
+------+--------------------+---------------------------------------+--------+----------------------------------------------------------------+---------+---------+------------------------------------+--------+-----------------------------+
|    1 | PRIMARY            | <derived2>                            | 
ALL    | NULL | NULL    | NULL    | NULL                               | 
211928 | Using where; Using filesort |
|    1 | PRIMARY            | source_customer_billing_zones_history | 
eq_ref | PRIMARY | PRIMARY | 4       | 
me.source_customer_billing_zone_id |      1 | Using where                 |
|    2 | DERIVED            | me                                    | 
ref    | suid | suid    | 108     | const                              | 
152242 | Using index condition       |
|    3 | DEPENDENT SUBQUERY | call_list_suppressions                | 
ALL    | cls_domain_direction_pattern_idx,cls_direction_mode_domain_idx 
| NULL    | NULL    | NULL |      1 | Using where                 |
|    4 | UNION              | me                                    | 
ref    | duid | duid    | 108     | const                              | 
59686 | Using index condition       |
|    5 | DEPENDENT SUBQUERY | call_list_suppressions                | 
ALL    | cls_domain_direction_pattern_idx,cls_direction_mode_domain_idx 
| NULL    | NULL    | NULL |      1 | Using where                 |
+------+--------------------+---------------------------------------+--------+----------------------------------------------------------------+---------+---------+------------------------------------+--------+-----------------------------+

Please help as this has a serious impact on system performance.

Best regards,

Henk Plessius

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20180904/eca275a1/attachment.html>