# MySQL query sometimes runs slow, sometimes fast

**URL:** <https://forums.percona.com/t/mysql-query-sometimes-runs-slow-sometimes-fast/4769>\
**Category:** General Questions\
**Created:** [March 11, 2016, 2:46am UTC](https://forums.percona.com/t/mysql-query-sometimes-runs-slow-sometimes-fast/4769 "2016-03-11T02:46:19Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![zangetsKid](https://avatars.discourse-cdn.com/v4/letter/z/54ee81/32.png) [@zangetsKid](https://forums.percona.com/u/zangetsKid)\
**Post date:** [March 13, 2016, 8:50pm UTC](https://forums.percona.com/t/mysql-query-sometimes-runs-slow-sometimes-fast/4769/3 "2016-03-13T20:50:38Z")

</div>

Here is the “SHOW CREATE TABLE message”

```auto
CREATE TABLE `message` ( `id` int(20) NOT NULL AUTO_INCREMENT, `sender` bigint(20) NOT NULL, `recipient` bigint(20) NOT NULL, `status` int(5) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `id` (`id`), KEY `recipient` (`recipient`), KEY `sender` (`sender`), KEY `date` (`date`), KEY `status` (`status`), KEY `sent` (`status`,`recipient`) ) ENGINE=InnoDB AUTO_INCREMENT=90224500 DEFAULT CHARSET=latin1; 

```

Any idea what’s wrong?

---

_[View the full topic](https://forums.percona.com/t/mysql-query-sometimes-runs-slow-sometimes-fast/4769)._