Is it possible to do something with this query ?
Waiting for table level lock | INSERT INTO rv_data_bkt_r
(interval_start, creative_id, zone_id, count)
VALUES ('2019-11-22 14:50:00', '0', '45', '1')
ON DUPLICATE KEY UPDATE count = count + 1
BTW is it ok to drop old data from this table ? because I have almost 600k row there, for 1 year already.
mysql> select count(*) from rv_data_bkt_r;
+----------+
| count(*) |
+----------+
| 549006 |
+----------+
1 row in set (0.32 sec)
mysql> select count(*) from rv_data_bkt_m;
+----------+
| count(*) |
+----------+
| 145879 |
+----------+
1 row in set (0.00 sec)