# MEMORY DELETE query takes more than 60 seconds of time with 100% CPU load

**URL:** <https://forums.percona.com/t/memory-delete-query-takes-more-than-60-seconds-of-time-with-100-cpu-load/3671>\
**Category:** Other MySQL® Questions\
**Created:** [August 10, 2014, 5:11am UTC](https://forums.percona.com/t/memory-delete-query-takes-more-than-60-seconds-of-time-with-100-cpu-load/3671 "2014-08-10T05:11:17Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Chavy](https://avatars.discourse-cdn.com/v4/letter/c/919ad9/32.png) [@Chavy](https://forums.percona.com/u/Chavy)\
**Post date:** [August 13, 2014, 10:28am UTC](https://forums.percona.com/t/memory-delete-query-takes-more-than-60-seconds-of-time-with-100-cpu-load/3671/3 "2014-08-13T10:28:18Z")

</div>

[URL][http://rghost.ru/57449917[/URL]](http://rghost.ru/57449917%5B/URL%5D)

Try to execute query

```auto
DELETE FROM `db_test_table_copy` WHERE `bid`=2 AND `regtime`!=1407760802;

```

on this 9.8 Mb memory table. On my server it takes 1 minute and 35 seconds with 100% CPU loading all this time  
Server version: 5.6.19

---

_[View the full topic](https://forums.percona.com/t/memory-delete-query-takes-more-than-60-seconds-of-time-with-100-cpu-load/3671)._
