github.com/dolthub/dolt/go@v0.40.5-0.20240520175717-68db7794bea6/performance/import_benchmarker/testdata/all.yaml (about)

     1  opts:
     2    seed: 0
     3  tests:
     4  - name: "primary key types"
     5    repos: &repos
     6  #  - name: mysql # mysqld --port 3308 --local-infile=1
     7  #    external-server:
     8  #      name: test
     9  #      host: 127.0.0.1
    10  #      user: root
    11  #      password:
    12  #      port: 3308
    13    - name: dolt_cli
    14  #  - name: dolt_server
    15    #    server:
    16  #      port: 3308
    17  #  args: [ "--port", "3308" ]
    18  
    19    tables:
    20    - name: "int"
    21      schema: |
    22        create table xy (
    23          x int primary key,
    24          y varchar(30)
    25        );
    26    - name: "float"
    27      schema: |
    28        create table xy (
    29          x float primary key,
    30          y varchar(30)
    31        );
    32    - name: "varchar"
    33      schema: |
    34        create table xy (
    35          x varchar(20) primary key,
    36          y varchar(30)
    37        );
    38  - name: "config width"
    39    repos: *repos
    40    tables:
    41    - name: "2 cols"
    42      schema: |
    43        create table xy (
    44          x int primary key,
    45          y varchar(30)
    46        );
    47    - name: "4 cols"
    48      schema: |
    49        create table xy (
    50          x int primary key,
    51          y int,
    52          z int,
    53          w int
    54        );
    55    - name: "8 cols"
    56      schema: |
    57        create table xy (
    58          x int primary key,
    59          y int,
    60          z int,
    61          w int,
    62          a int,
    63          b int,
    64          c int,
    65          d int
    66        );
    67  - name: "pk type"
    68    repos: *repos
    69    tables:
    70    - name: "int"
    71      schema: |
    72        create table xy (
    73          x int primary key,
    74          y varchar(30)
    75        );
    76    - name: "float"
    77      schema: |
    78        create table xy (
    79          x float primary key,
    80          y varchar(30)
    81        );
    82    - name: "varchar"
    83      schema: |
    84        create table xy (
    85          x varchar(30) primary key,
    86          y varchar(30)
    87        );
    88  - name: "schema types"
    89    repos: *repos
    90    tables:
    91    - name: "varchar"
    92      schema: |
    93        create table xy (
    94          x int,
    95          y varchar(30)
    96        );
    97  #  - name: "geometry"
    98  #    schema: |
    99  #      create table xy (
   100  #        x int primary key,
   101  #        y geometry
   102  #      );
   103    - name: "datetime"
   104      schema: |
   105        create table xy (
   106          x int primary key,
   107          y date
   108        );
   109  - name: "secondary indexes"
   110    repos: *repos
   111    tables:
   112    - name: "no secondary"
   113      schema: |
   114        create table xy (
   115          x int primary key,
   116          y varchar(30),
   117          z varchar(30),
   118          w varchar(30)
   119        );
   120    - name: "one index"
   121      schema: |
   122        create table xy (
   123          x int primary key,
   124          y varchar(30),
   125          z varchar(30),
   126          w varchar(30),
   127          index x (x)
   128        );
   129    - name: "two index"
   130      schema: |
   131        create table xy (
   132          x int primary key,
   133          y varchar(30),
   134          z varchar(30),
   135          w varchar(30),
   136          index x (x),
   137          index y (y)
   138        );
   139    - name: "four index"
   140      schema: |
   141        create table xy (
   142          x int primary key,
   143          y varchar(30),
   144          z varchar(30),
   145          w varchar(30),
   146          index x (x),
   147          index y (y),
   148          index z (z),
   149          index w (w)
   150        );
   151  - name: "blobs"
   152    repos: *repos
   153    tables:
   154    - name: "no blob"
   155      schema: |
   156        create table xy (
   157          x int primary key,
   158          y varchar(30),
   159          z varchar(30),
   160          w varchar(30)
   161        );
   162    - name: "1 blob"
   163      schema: |
   164        create table xy (
   165          x int primary key,
   166          y blob,
   167          z varchar(30),
   168          w varchar(30)
   169        );
   170    - name: "2 blobs"
   171      schema: |
   172        create table xy (
   173          x int primary key,
   174          y blob,
   175          z blob,
   176          w varchar(30)
   177        );
   178  - name: "row count"
   179    repos: *repos
   180    tables:
   181    - name: "400k"
   182      rows: 400000
   183      schema: |
   184        create table xy (
   185          x int primary key,
   186          y varchar(30)
   187        );
   188    - name: "800k"
   189      rows: 800000
   190      schema: |
   191        create table xy (
   192          x int primary key,
   193          y varchar(30)
   194        );
   195    - name: "1.6mm"
   196      rows: 1600000
   197      schema: |
   198        create table xy (
   199          x int primary key,
   200          y varchar(30)
   201        );
   202    - name: "3.2mm"
   203      rows: 3200000
   204      schema: |
   205        create table xy (
   206          x int primary key,
   207          y varchar(30)
   208        );
   209  - name: "sorting"
   210    repos: *repos
   211    tables:
   212    - name: "shuffled"
   213      shuffle: true
   214      rows: 2000000
   215      schema: |
   216        create table xy (
   217          x int primary key,
   218          y varchar(30)
   219        );
   220    - name: "sorted"
   221      shuffle: false
   222      rows: 2000000
   223      schema: |
   224        create table xy (
   225          x int primary key,
   226          y varchar(30)
   227        );