findMissingChunks.sql

# 20 days in minutes / 10 minutes = 2880 chunks
# 1 day in minutes / 10 minutes = 144 chunks

use log;

    set @start = '20151014050000';

 select seq.tenMinuteChunk
   from (select left(date_format(date_add(@start, interval seq*10 minute), '%Y%m%d%H%i'), 11) as tenMinuteChunk
           from seq_0_to_144
        ) seq
            left join
        (select left(timestamp, 11) as tenMinuteChunk
           from <<Pick a few specific tables to check for holes>>
          where timestamp >= @start
          group by tenMinuteChunk
        ) navi          on navi.tenMinuteChunk = seq.tenMinuteChunk
  where navi.tenMinuteChunk is null
;

groupChunksAndPrettyPrint.js

var minutesMissing = [/*paste output of query above here*/];

var last = 0, i, lastGap, newGap, gaps = [];

for (i=0; i < minutesMissing.length; i++) {
    newGap = minutesMissing[i] - last;

    if (newGap > 1 && newGap !== 5) {
        gaps.push({ size: 1, first: minutesMissing[i] });
    } else {
        lastGap = gaps[gaps.length-1];
        lastGap.size = lastGap.size + 1;
    }
    last = minutesMissing[i];
}

var msg = '';
for (i=0; i < gaps.length; i++) {
    msg += gaps[i].first + ' for ' + gaps[i].size * 10 + ' minutes\n';
}
console.log(msg);