Hi, I am having problem with this simple MySQL query: select sender as id from message where status=1 and recipient=1 where sender table has multi millions of rows. When I run this on SequelPro, it runs really slow for the first time, ~4 seconds or more, and the next execution it run really fas…

Can you post “SHOW CREATE TABLE message” ?

Here is the “SHOW CREATE TABLE message” 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 `i…

MySQL query sometimes runs slow, sometimes fast

General Questions

MrAwanish July 8, 2016, 12:03am 4

Try using MySql Table Partitioning features.

Topic		Replies	Views
Query slow first time, then fast Other MySQL® Questions	5	4111	February 8, 2008
Query slows down, when repeated Other MySQL® Questions	4	524	March 19, 2007
Query speed Other MySQL® Questions	2	415	January 12, 2007
Highly optimized queries are sometimes taking 20s to perform? Other MySQL® Questions	5	704	January 30, 2009
query cache enhncement Other MySQL® Questions	1	363	January 9, 2007

MySQL query sometimes runs slow, sometimes fast

Related topics