Jump to content

 Waiting for table level lock rv_data_bkt_r

Recommended Posts


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)

Link to post
Share on other sites
  • 11 months later...

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...