Hello,
For the following query:
select unix_timestamp(beginTime) as bTime,myTable.* from myTable Where
nodeID=2 AND flavor In('sim','ofl') AND (deactive= 0 OR
deactive>=1176682388) AND unix_timestamp(entryTime)<=1176682388 AND
beginTime<=from_unixtime(1546300816) AND elementID In
(491507,491508,491509,491510,491511,491512,491513,491514,491515,491516,491517,491518,491519,491520)
Order by beginTime desc limit 14
EXPLAIN shows
+----+-------------+---------------+------+---------------+---------+---------+-------+--------+-------------+
| id | select_type | table | type | possible_keys | key |
key_len | ref | rows | Extra |
+----+-------------+---------------+------+---------------+---------+---------+-------+--------+-------------+
| 1 | SIMPLE | myTable | ref | PRIMARY | PRIMARY | 4 |
const | 403782 | Using where |
+----+-------------+---------------+------+---------------+---------+---------+-------+--------+-------------+
Show processlist reveals that the query state sits in sending data for a
very very long time.
Perhaps I need a tunning parameter adjusted. Does anyone know which one,
or have any other ideas?
Thanks,
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
