offset_test.rb

require 'mysql2'
require 'faker'

# create table offset_test (
#   id bigint primary key auto_increment,
#   date datetime not null,
#   index(date)
# )

con = Mysql2::Client.new(host: "localhost", database: "test")
st = con.prepare('insert into offset_test (date) values (?)')
1.upto(200000).each {
  st.execute Faker::Time.backward(1000)
}