Re: query to find gaps in sequential indexes causes CPU spikes

[Rick James]

You have:

select  column0
    from  CustomerData as cd
    where  column1 = 10
      and  column0 >= 50
      AND  
      ( SELECT  count(*)
            from  CustomerData
            where  column1 = 10
              and  column0 = cd.column0 + 1) = 0
    order by  column0
    limit  1

Competing products sometimes to a better job of optimizing queries.

This is virtually the same, and might be better optimized by MySQL:

select  column0
    from  CustomerData as cd
    where  column1 = 10
      and  column0 >= 50
      AND  
      NOT EXISTS ( SELECT  *
            from  CustomerData
            where  column1 = 10
              and  column0 = cd.column0 + 1)
    order by  column0
    limit  1

To further assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

Do you have a compound index on (column1, column0)

In particular, have you tuned the caches? --
http://mysql.rjweb.org/doc.php/memory