github.com/square/finch@v0.0.0-20240412205204-6530c03e2b96/benchmarks/jcole-bug-97001/setup.yaml (about)

     1  # https://bugs.mysql.com/bug.php?id=97001
     2  # https://blog.jcole.us/2019/09/30/reconsidering-access-paths-for-index-ordering-a-dangerous-optimization-and-a-fix/
     3  # https://hackmysql.com/post/infamous-order-by-limit-query-optimizer-bug/
     4  
     5  stage:
     6    trx:
     7      - file: schema.sql
     8      - file: insert-rows.sql
     9        data:
    10          n:
    11            generator: auto-inc
    12            scope: client-group
    13    workload:
    14      - trx: [schema.sql]
    15      - trx: [insert-rows.sql] # 5k rows/insert 
    16        iter-clients: 200      # x 200 inserts = 1,000,000 rows
    17        clients: 4