VV_silent Posted November 22, 2019 Report Share Posted November 22, 2019 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) Quote Link to comment Share on other sites More sharing options...
henderson Posted November 11, 2020 Report Share Posted November 11, 2020 Hi! Experiencing same problem, maintenance script locking database, any thoughts? Revive Adserver v5.0.5, DB: MariaDB 10.5 (InnoDB), PHP 7.4.11 Thank you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.