MySQL InnoDB Same Select another result

Question

I am using InnoDB on MySQL and I have problem with selecting data from log

when I select

SELECT * FROM `log` 
WHERE `updated` >= '20140110144000' AND `updated` <= '20140110150000' 
ORDER BY `updated` ASC

I will get two different result

in execution at time 15:00 will get 0 rows

in execution at time 16:00 will get over 2.000 rows

how is it possible ? innodb memory cache ?

@SamD That has nothing to do with this question. – jeremycole Jan 15 '14 at 08:25 — jeremycole, Jan 15 '14 at 08:25

score 1 · Answer 1 · edited May 23 '17 at 10:33

1

InnoDB vs. MyISAM are different database engines. Look here for a good detailed explanation.

edited May 23 '17 at 10:33

Community

answered Jan 10 '14 at 18:58

mituw16

score 1 · Answer 2 · answered Jan 10 '14 at 19:02

1

sorry solved

I have corrupted NTP synchronization... and other server and data to log with older datetime

answered Jan 10 '14 at 19:02

user5332

mortymacs · Answer 3 · 2014-01-10T19:00:32.010

0

Check it:

SELECT COUNT(*) FROM `log` 
WHERE TIMESTAMP(`updated`) BETWEEN TIMESTAMP('20140110144000') AND TIMESTAMP('20140110150000') 
ORDER BY `updated` ASC

edited Jan 10 '14 at 19:00

answered Jan 10 '14 at 18:54

mortymacs

3 Answers3